I know we can post data “to” a Google Sheet, but is there an action (or a way) to read data “from” a google sheet other than moving it to the knowledgebase? I am currently posting information to a sheet from one pickaxe, but I want to be able to read that data from another pickaxe if at all possible. Is there any action that would help with this?
Hi there! We don’t currently have an easy way to do this. You might be able to accomplish it with a customized action (that would require some backend coding)
Hi @gex_gpt,
You can do this with actions.
The problem with Google actions is that you need to log into cloud console, create authorisation tokens, add scopes. If not familiar with it oculd be a bit overwhelming.
If possible would be better to use a database like Airtable instead Sheets.
Let me know if you have any questions
1 Like
Thanks, @ab2308 - Can you say more about this? Possible to use Supabase, MySQL, etc.?, running a query using the user’s email address?
Are there MCP servers for some of these platforms?
@kenlyle yes there is an MCP server for pretty much anything these days. Here is the one for Supabase Supabase MCP Server. You can definitely run a query with the user’s email address.
Thanks, @ab2308 - Where can I learn how to configure that? There’s nothing in the Resource Directory at least top level, and MCP seems to deserve top-level these days.
The JSON config for the Supabase Smithery Action includes /token, but when I replace token with an API Key, I get an error, Invalid JSON.