Add Google Sheets Row
Append one row to a connected Google Sheet — the cheapest way to hand data from a conversation to a team that lives in a spreadsheet.
Quick start
- Go to Automate → Workflows and open a workflow. Click + and pick Add Google Sheets Row.
- Connect Google under Settings → Integrations, and share the spreadsheet with that account with edit access.
- Paste the spreadsheet's link, click Load, then pick the Tab if there is more than one.
- Fill in Row to add, one value per box, text or
{{…}}placeholders. - Set Status to Published in the top toolbar, Save, confirm Publish. Agents: ask an owner or admin.
Watch out
- It publishes even with nothing connected — a step left that way fails every time it runs, until Google Sheets is connected.
- Values go into your sheet by position (first box = cell A, second = B…). Moving fields around in your sheet later does not update this step.



Details
Getting here
Automate → Workflows, open a workflow, click + on the canvas, then pick Add Google Sheets Row under Add Steps.
Before you start
- An owner, admin or agent can add this step and save the workflow. Publishing that workflow — the thing that makes it run on live conversations — is an owner or admin action.
- Building and running workflows depends on your plan; see pricing.
- A Google account connected in Settings → Integrations, and the target spreadsheet shared with that account with edit access. Until connected, the drawer shows a connect card instead of the fields.
- The connection is per workspace, not per sheet. Anyone who can build a workflow here can point this step at any spreadsheet the connected Google account can edit — not only the one it was set up for.
Set up
- Open the workflow and click + where the row belongs.
- Pick Add Google Sheets Row.
- Paste the spreadsheet's link and click Load — this reads its tabs and headers, which only label the boxes below.
- Pick the Tab if there is more than one.
- Fill in Row to add, one value per box, with text or
{{…}}placeholders. - Save the step. To publish: set Status to Published in the toolbar at the top of the editor, click Save, then confirm with Publish. The dropdown on its own changes nothing until you save.
Fields
- Spreadsheet link
- The sheet's own URL. Load fetches its tabs and headers.
- Tab
- Which sheet tab to append the row to.
- Limits: Only shown once Load has run.
- Row to add
- One value per box, labelled from the sheet's header row when known. Each box takes plain text, or click in and use the
{{…}}picker for a variable like{{contact.first_name}}or the customer's last answer. - Limits: The values are positional — the first always lands in cell A of the new row, the second in cell B, and so on, whether or not a header was ever loaded.
- When this contact already has a row
- Add a new row every time appends, as before. Pick Update the row with the same … and a heading — usually Phone — to update the row that already holds the same value under that heading instead, and add one only when none does.
- Limits: The value in that box must not come out empty when the step runs, or the step fails rather than guess.
How it works
- What leaves Inchat, and when: the instant the step runs, one call to the Google Sheets API appends a single row to the named tab, using this workspace's connected Google account.
- The values sent are exactly what you configured, with every
{{…}}placeholder already resolved. - With Add a new row every time, the row is appended after whatever the sheet already has — it never overwrites or inserts in the middle.
- With Update the row with the same …, the step reads the values under that heading, finds the first row with the same value, and writes your values into that row's cells. A box you left empty leaves its cell as it was, so notes the team typed elsewhere in the row survive. Phone numbers match as whole numbers however they were typed, so
012-345 6789and+60 12-345 6789are the same contact. No match: the row is appended. - A value that starts with
=is written as a formula, exactly as if it had been typed into the sheet by hand. - So a customer's reply that happens to start with “=” becomes a formula in your sheet, not plain text — Google treats it the same way a person typing into a cell would.
- The values are positional on the wire: the header row shown in the drawer only labels which box maps to which position at the time you loaded it.
- If the sheet's headers change position afterwards (say, “Phone” moves from B to C), the step keeps writing to the same position, not the same header.
When it fails
- Google Sheets is not connected for this workspace: the step fails with Google Sheets is not connected — connect it in Settings › Integrations., before any request is sent.
- The connected account no longer has edit access to the sheet — never shared, or removed. Google answers 403 and the step fails with “That Google account cannot edit this spreadsheet — share the sheet with it, with edit access.”
- The spreadsheet id is wrong, deleted, or the connected account cannot see it: Google answers 404 and the step fails with That spreadsheet does not exist, or the connected account cannot see it.
- Google sometimes refuses a request even though Settings still shows Connected — Google already revoked the saved access token before its stored expiry. The step fails with Google rejected the connection — reconnect Google Sheets in Settings., and reconnecting there is on you; this failure does not flip Settings to Disconnected.
- Separately, the saved connection is sometimes due for its routine refresh. If Google refuses that refresh — access revoked for good — Settings itself updates to show Disconnected, and the step fails with Google Sheets is not connected — connect it in Settings › Integrations.
- Google is rate-limiting this workspace: the step fails with Google Sheets is rate limiting this workspace — try again shortly.
- A failed row does not stop the run: the step shows as failed in the run's Activity tab and the flow moves straight to the next one, and nothing is written to the sheet.
Limits
- It publishes even with nothing connected. The connection card blocks editing the fields in the drawer, but not saving or publishing the workflow.
- A step left this way fails, once per run, every time it runs, until Google Sheets is connected.
- It can append or update one row; it cannot delete a row or read a value back into the conversation.
- Updating matches the first row with that value. Two rows with the same phone number: only the higher one is updated.
- Two runs for the same new contact at the same moment can both find no row and both append one. Delete the extra row; later runs update the higher one.
- The mapping is by position, not by header name — see How it works. Moving a header to another position without editing this step silently misfiles the row.
- A row is capped at 50 values, each up to 4,000 characters.
- The connection is per workspace, not per sheet. Anyone who can build a workflow here can point this step at any spreadsheet the connected Google account can edit — not only the one it was set up for.
Use cases
- Log every completed order to a shared spreadsheet the fulfilment team already works from, right after Move Deal to Stage marks a deal won.
- Append a row for every lead that answers an Ask a Question step, so sales can work the list without opening Inchat.
- Keep one row per customer, matched on phone: each new order or address updates their row instead of adding a duplicate.
- Let the AI Agent keep the sheet current without a workflow: AI Agents → Actions → Sync to Google Sheets / Notion uses this same step.
Reading this with an AI assistant? Plain Markdown version.