Anyone of you can help me to get the Data from Google Sheets into the Pickaxe bot via action? It would be great solution for many automations. I know there is an action to write something in the GS but other way around?
1 Like
This could be a great question to work with a Pickaxe expert on, you could contact one from the info here: Pickaxe Experts
If you are using google workspace then you can set it up like this: Use the connected sheets option in workspace to sync your google sheet with bigquery and then connect the pickaxe to bigquery via make.com or directly using bigquery api. In your prompt, you’ll need to ask pickaxe to create and execute an sql query against the user query. Youll need to give the table schema and use the pickaxe option of ‘training dialogue’ to provide some example 'natural language and corresponding sql queries so that the system understands how to formulate queries.
This works for simple to moderate complexity queries. However, if you have dozens of sheets then this may not work. Even i am trying to figure out how to execute queries by combining different tables and stuff like that.
1 Like
Great answer @zerodot !
1 Like