Google Sheets API - Action

I havnt tried importing a spreadsheet as a knowledge base in Pickaxe yet… But I have seen that some people are/were having trouble with it because LLMs dont seem to like rows and columns too much…

What about if we could build an action that connects to the native Goggle Sheets API? It takes a tiny bit of setup over on the GSheets side, but this could be a game changer.

The API could be called very specifically with the JSON/Python Actions, instead of asking and praying and hoping via the natural language method.

This seems alot more reliable this way, especially if GSheets is being used as a database.

What are your thoughts?

PS: I know that this can be achieved with Zapier/Make/ActivePieces, but I thought about cutting out the middle man for simplicity and less surface area of potential failure.

Thanks

I’m not 100% confident in my skills… but will try to build it myself next week :cowboy_hat_face:

Facing exactly the same challenge. A lot of my data is on spreadsheets. Cant get Pickaxe to connect to it. Having GSheets integration would be a game-changer for small businesses indeed.