GetSheet
Anyone used Get Sheet integration? How do you make it work? Any tutorials?
3 Replies
Hey! Voiceflow doesn’t currently ship a pre-made “GetSheet” (or Google Sheets) block, so most builders wire Sheets in one of two ways:
1. API Step
• Turn on the Google Sheets API in your Google Cloud project and create a service-account key.
• Share the target spreadsheet with that service-account email so it can read/write.
• In Voiceflow drop an API step, set the request to GET
• Map the JSON response into Voiceflow variables for later use.
• For writes, switch the method to PUT/PATCH and pass the values array in the body. 2. Custom Function (JS) • Create a Function and use
• Return the data in
• Function step – lets you write JS, use
• Share the target spreadsheet with that service-account email so it can read/write.
• In Voiceflow drop an API step, set the request to GET
https://sheets.googleapis.com/v4/spreadsheets/{SPREADSHEET_ID}/values/{RANGE} (or any other Sheets endpoint) and add the header Authorization: Bearer {access_token}.• Map the JSON response into Voiceflow variables for later use.
• For writes, switch the method to PUT/PATCH and pass the values array in the body. 2. Custom Function (JS) • Create a Function and use
fetch() inside main() to hit the same Sheets API (or an Apps-Script you’ve published as a web-app).• Return the data in
outputVars, or even craft a Trace if you want to show it as text/a card right away.
3. No-code routers (Zapier/Make/n8n)
• Trigger the zap/flow from Voiceflow (API step or Function) and let the automation platform do the Sheet work, then send a response back to Voiceflow if needed.
Docs that may help:
• API step & calling external services (see “How Voiceflow fits in your tech stack”, Sending and Receiving Data section).• Function step – lets you write JS, use
fetch, and return traces/variables.
If you’re looking for a ready-made Recipe, check the Voiceflow Marketplace – search “Sheets” or “Spreadsheet”; community functions pop up there from time to time.
Hope that clarifies how to connect Sheets! Let me know if you need a concrete request example or guidance on auth setup.@Lucius_Aurelius we're going to put out a tutorial for this
Yea I hope so I paid a plan with voiceFlow but really not any tutorials on how to use get sheet function