For AI assistants: this page as plain markdown is at https://docs.voicelogica.ai/raw/workflow-nodes/manage-google-sheet.md, and https://docs.voicelogica.ai/llms.txt lists the docs by topic, one file each, small enough to read whole. Read those rather than this HTML page.
Manage Google Sheet
Manage Google Sheet reads or writes a tab in Drive. Authorize Google first or the picker is empty and the runtime fails.
Why this node
Section titled “Why this node”A leads tab, a simple store of SKUs, append a row after the call. A real CRM is still HubSpot or Connect To External Service.
Grant Use spreadsheets (and Drive to browse) on Google authorizations. Calendar / Gmail send are different scopes.
What you configure
Section titled “What you configure”{{call.phone_number}}).Ports: Sheet updated, Sheet error, No wait. Downstream fields come from the row you fetched.
First setup — append the caller after hang-up
Section titled “First setup — append the caller after hang-up”-
A sheet with a
phonecolumn. Google Scopes granted. -
On Call End → Manage Google Sheet. Append Row. Pick the file and tab.
phone= Call Parameters. -
Save & go live, attach, hang up a test call. Refresh the sheet.
Get Row + AI Response is the mid-call path (order status by phone). Keep that GET fast.
What “broken” looks like
Section titled “What “broken” looks like”- Needs setup — no file, no tab, or no operation.
- Picker empty / 403 — scopes not granted on this company.
- Update hits the wrong row — Match Value does not equal the cell (spaces, missing
+).
Troubleshooting
Section titled “Troubleshooting”What is the difference between Get Data and Get Row in the Manage Google Sheet node?
Get Data reads the whole tab. Get Row returns the one row that matches. Use Get Row when the next node needs a single record, for example an order status looked up by phone number.
