Integrations
Google Sheets
Append a row, read a range, find a row, or update a range.
What this guide covers
- A Google account through the Google authorization flow with access to the intended spreadsheet.
- 4 supported workflow actions.
- The connection acts with the authorized Google account's access. Share only the spreadsheets needed by the workflow.
- Concurrent updates can overwrite or reorder data if the workflow assumes a stable row.
What Google Sheets connects
A Google account through the Google authorization flow with access to the intended spreadsheet.
Append a row, read a range, find a row, or update a range.
Prerequisites and permissions
- Google account permission to the spreadsheet
- Spreadsheet identifier
- Valid A1-style range or column/range inputs required by the action
The connection acts with the authorized Google account's access. Share only the spreadsheets needed by the workflow.
Connect and configure
- Open the intended Agent Project → Integrations.
- Find Google Sheets and select Connect.
- Complete authorization with the correct external identity.
- Confirm the returned connection status is active.
- In the workflow builder, add App Action.
- Select Google Sheets, choose one supported action, select the connection, and complete the fields Yanola displays.
- Save and test with controlled data before activation.
Supported actions
| Action ID | What it does |
|---|---|
append_row | Add a row to a sheet. |
read_range | Read values from a sheet range. |
find_row | Find the first row containing a value in a column. |
update_range | Overwrite values in a sheet range. |
Example workflow
Append a qualified lead's name, phone, category, and timestamp to a shared sheet.
Workflow Trigger → Validate inputs → App Action (Google Sheets) → Condition → Notify or End FlowReconnection and token expiration
- Open Integrations when a workflow reports a missing, expired, revoked, or error connection.
- Select Reconnect for Google Sheets.
- Authorize the intended identity again.
- Validate access to the exact resource used by the workflow.
- Retest every dependent App Action.
Troubleshooting
| Symptom | What to check |
|---|---|
Connection is expired, revoked, or error | Reconnect from Integrations and complete provider consent. |
Action cannot find a resource | Grant the connected identity access and use the exact provider ID. |
Action input is rejected | Match the action-specific fields and data types shown in the node. |
Test and live behavior differ | Check provider environment, current permissions, external rate limits, and live data. |
Limitations and security
Concurrent updates can overwrite or reorder data if the workflow assumes a stable row.
Yanola does not expose spreadsheet formulas, charts, or workbook administration as separate actions.
Never place provider access tokens or secrets in workflow text, logs, screenshots, or AI prompts. Remove unused connections and reconnect only through Yanola.