Node: Append Row to Google Sheets
How to use the Append Row to Google Sheets node to export board or conversation data to a spreadsheet.
The Append Row to Google Sheets node automatically adds a row to a Google Sheets spreadsheet from a workflow. It's the simplest way to send Omnifox data (board tasks, conversation data, AI classifier results, etc.) to an external spreadsheet without writing any code.
Requirements
- The workspace must have a connected and active Google Sheets integration (set up under Integrations). Without it, the node skips with the message "No Google Sheets integration is connected in this workspace".
When to use it
- Logging to a spreadsheet every time a board task moves to "Done".
- Exporting leads captured by a WhatsApp or Webchat workflow to a sheet shared with the team.
- Keeping an external log of workflow events (e.g. every time a deal is created).
Configuration
- Spreadsheet ID: optional on the node if the integration already has a default spreadsheet configured; if set here, it takes priority.
- Sheet/tab name: optional; if not set, uses the integration's default tab or "Sheet1".
- Values: the row to append. Accepts three shapes:
- A simple list of cells.
- A list of
{value: "..."}objects (what the visual editor builds). - Text separated by line breaks or by "|" (e.g.
{{trigger.item_title}} | {{trigger.contact_name}} | Done). Each cell supports variables, resolved right before writing.
Example
A board workflow fires when a card moves to the "Done" group. You add Append Row to Google Sheets with Values = {{trigger.item_title}} | {{trigger.assigned_user_name}} | {{trigger.completed_at}}. Every completed task gets logged as a new row in the team's spreadsheet.
Tips
- Try the pipe-separated text format first if you don't want to build the values list by hand — it's the fastest to write.
- The node automatically updates the integration's last-sync timestamp, handy to confirm in the Integrations panel that it's still working.
Troubleshooting
- "No Google Sheets integration is connected": connect or reconnect the integration under Integrations before using this node.
- "The row to append is empty": check that the Values field isn't empty after variables are resolved.
- The write fails but the workflow keeps going: this node never stops the workflow on a Google API error; check the error detail in the workflow's execution history.
Related articles
-
Build your first workflow
Omnifox workflows automate your operation: a trigger starts the automation and action nodes do the work. Build a welcome message in minutes.
-
Workflow triggers catalog
Learn which events can start a workflow automatically in Omnifox.
-
Action nodes available in workflows
Discover the actions a workflow can run automatically.
-
Conditions and branching (if/then) in a workflow
Make your flows take decisions and follow different paths based on each contact data.
-
Ready-to-use workflow templates
Start your automations in minutes from prebuilt flows you can customize.