> ## Documentation Index
> Fetch the complete documentation index at: https://wabis.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

> Link Google Sheets to the platform and sync contacts, messages, orders, and flow submissions into them.

## What is this?

**Google Sheets** lets you link spreadsheets to your workspace and keep them up to date with your data — contacts, every message, order events, and WhatsApp Flow submissions. It's the **Google Sheets** page under **Google** in the sidebar (also reachable from **Channels → Google**).

![The Sheets tab showing registered sheets with the Add Existing Sheet and Create New Sheet buttons](https://mintcdn.com/wabis/WS9kn1_MGeoTtoMA/images/google-integration-sheets-list.png?fit=max\&auto=format\&n=WS9kn1_MGeoTtoMA\&q=85\&s=a905e11d3ccba2ff3b8fdf2861e344f4)

> [!NOTE]
>
> Connect your Google account first — see [Google](https://wabis.mintlify.site/workspace/google/overview.md). The Google integration needs a plan that includes Google, and your platform administrator must have set up Google OAuth first. Permissions control what you can do: `google:view` to see it, `google:create` to connect an account, `google:edit` to change sync settings, and `google:delete` to remove sheets or disconnect.

## What can I do here?

* **Add Existing Sheet** by pasting a spreadsheet ID or Google Sheet link, or **Create New Sheet** from the platform
* See all linked sheets under **Registered sheets for this Google account**, and **Open** any of them in Google
* Sync **contacts**, **messages**, **orders**, and **flow submissions** to a sheet and tab of your choice
* Run a **Bulk Sync** to send everything that already exists
* Unlink a sheet without touching the file in Google

## How to use it

The page shows four tiles — **Linked sheets**, **Active syncs** (for example *2 of 4* switched on), **Rows synced** and **Last sync** — above these tabs: **Sheets**, **Contacts**, **Messages**, **Orders**, **Flows** and **Add-on**.

### Link a spreadsheet

1. Click **Add Existing Sheet** and paste a spreadsheet ID or the full Google Sheet link, then click the link button. Or click **Create New Sheet**, enter a **Sheet name**, and create it.
2. Linked sheets are listed under **Registered sheets for this Google account**. Click **Open** to view one in Google.
3. To remove a sheet from the list, use its remove action and confirm **Unlink Google Sheet?**. This only removes it from the platform — the original file in Google is unchanged.

### Set up syncing

Open the **Contacts**, **Messages**, **Orders** or **Flows** tab. Each shows what it writes and its columns, an **On / Off** switch, the **Sheet** and **Tab** to write to, and its Bulk Sync button.

Each sync type has an **Enable** toggle, a **Sheet** to write to, and a **Tab** within it. The default tab is **Sheet1**. After a sync is on, use its **Bulk Sync** button to send everything that already exists.

| Sync | What it writes | Columns / notes |
| - | - | - |
| **Contact Sync to Sheet** | Contacts as rows | Name, Phone, Email, Status, Labels, Source, Created At, Custom Fields. Shows **Rows synced**. Use **Bulk Sync All Contacts**. |
| **Message Sync to Sheet** | Every incoming and outgoing message, one new row each | Use **Bulk Sync Messages**. |
| **Order Sync to Sheet** | Every order lifecycle event | Use **Bulk Sync Orders**. |
| **Flow Sync to Sheet** | Every WhatsApp Flow form submission | Flow ID, Flow Name, Submitted At, Name, Phone, Raw Response, Custom Field Map. Use **Bulk Sync Flows**. |

![The Sheets tab showing the Contact, Message, Order, and Flow sync cards with their toggles, sheet and tab selectors, and Bulk Sync buttons](https://mintcdn.com/wabis/WS9kn1_MGeoTtoMA/images/google-integration-sheets-sync.png?fit=max\&auto=format\&n=WS9kn1_MGeoTtoMA\&q=85\&s=ae18663d0b51668a3f4d6f4b7c7985ea)

### Sheet per Flow

Under the **Flow Sync to Sheet** card, **Sheet per Flow** lets you send each WhatsApp Flow's submissions to its own sheet instead of one shared sheet. Flows that don't have a sheet of their own use the default Flow sheet you chose above.

1. Find the Flow in the **Sheet per Flow** list. If the channel has no Flows yet, it says "No Flows found for this channel."
2. Choose a **Sheet** and a **Tab** for that Flow, or pick **Use default sheet** to go back to the shared one ("Using the default Flow sheet").
3. To copy submissions that already exist, click **Sync existing submissions** — you'll see "Flow sync started". The Flow then shows **Last synced** and **Rows synced** while it works ("Syncing…").

Each Flow sheet has the columns **Submitted At**, **Name**, **Phone**, then one column per form field. If you add a field to the form later, it is added as a new column.

### Default sheet for Flows

On the **Flows** tab, turn on the **Default sheet**, pick its sheet and tab, and use **Sync existing to default** to copy past submissions. Under **Where each Flow sends its answers**, choose per Flow:

| Choice | What happens |
| - | - |
| **Default sheet** | Answers go to the default sheet (*Goes to \[sheet] › \[tab]*). If the default is off or not chosen yet, nothing is sent and the Flow says so |
| **Own sheet** | The Flow gets its own sheet with one column per question (*Own sheet · n rows synced*) |
| **Don't send** | Its answers are kept out of Sheets |

Drafts are hidden until the Flow is published.

### Add-on: trigger automations from a sheet

The **Add-on** tab links to the **Google Sheets add-on** on the Google Workspace Marketplace (shown when your platform administrator has added the link in Integration Settings). With it installed, a change in your sheet can trigger WhatsApp automations. To install: click **Get the add-on** (the Marketplace opens in a new tab), click **Install** then **Continue**, choose your Google account and allow the permissions, open a Google Sheet, click **Extensions** and pick the add-on, then follow the setup in its side panel.

### Use sheets in automations

The **Google Sheets** step in the [Automation](https://wabis.mintlify.site/workspace/automation/overview.md) builder can add, update, or fetch rows in a linked sheet.

## Troubleshooting / Technical Notes

* **"Link Failed" when adding a sheet.** Check that you pasted a valid spreadsheet ID or link, and that the connected Google account has access to that sheet.
* **Nothing is syncing.** Make sure the sync's **Enable** toggle is on and a **Sheet** and **Tab** are selected. Then use **Bulk Sync** for data that already existed.
* **Where do new rows appear?** In the tab you selected. The default tab is **Sheet1**.
* **Unlinking a sheet doesn't delete the file.** It only removes the link from the platform.
* **"Could not update Flow sheet sync."** The change to a Flow's sheet didn't save. Check the connected Google account can open that sheet and try again.
* **You can't change sync settings.** You need `google:edit`, and `google:delete` to remove a sheet.

## Related docs

* [Google](https://wabis.mintlify.site/workspace/google/overview.md)
* [Google Contacts](https://wabis.mintlify.site/workspace/google/contacts.md)
* [Automation Overview](https://wabis.mintlify.site/workspace/automation/overview.md)
* [WhatsApp Flows](https://wabis.mintlify.site/workspace/whatsapp/flow.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.