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

# Google Sheets

> Link Google Sheets to AdsEra and use a sheet as the audience of a campaign.

Link your Google spreadsheets to AdsEra and use a sheet's rows as the recipients of a campaign.

> [!NOTE]
>
> AdsEra only uses Google's `drive.file` permission. It can open **only the spreadsheets you pick**, not the rest of your Google Drive.

***

## Adding the integration

**1. Connect your Google account**

Open **Marketplace → Google Sheets** and click **Connect Google Account**. Sign in with Google and allow access.

**2. Add a spreadsheet**

Click **Add Spreadsheet**. Google's file picker opens. Choose the spreadsheet. It appears under **Linked Spreadsheets**.

**3. Map the columns**

For each sheet, choose the **Mobile Number Column (For WhatsApp)**, the **Email Column (For Email Campaigns)** and the **Attribute Mapping** from columns to contact attributes.

Changed the sheet's columns or added tabs? Click the sync icon (**Sync all tabs and fetch latest structure**).

***

## Using the integration

### Send a campaign to a sheet

1. Create a campaign and, under the audience, switch on **Use Google Sheet Audience**.
2. Choose the **Google Account**, **Spreadsheet** and **Tab**.
3. Under **Automation Rules**, choose how rows are used:
   * **Run on Existing Rows**: the sheet is processed once when the campaign starts.
   * **Automated**: new and updated rows are processed as they come in. This needs the AdsEra webhook script installed in the spreadsheet. Contact support to set it up.
4. Optionally, add a condition (a column **Equals** or **Not Equals** a value) to send only to matching rows.

### Ask AI

The **Used by agents** section sets what Ask AI may do with your linked sheets.

### Troubleshooting

> [accordion] The spreadsheet isn't listed
>
> AdsEra only sees spreadsheets you picked. Click **Add Spreadsheet** and choose it.

> [accordion] New columns don't show up
>
> Click the sync icon on the spreadsheet to fetch the latest structure.

***

## Removing the integration

* **Remove one spreadsheet:** click **Remove Sheet** on it and confirm.
* **Disconnect the Google account:** choose the account and disconnect it, then confirm. Every spreadsheet linked through it is removed.

Campaigns that used a removed sheet can't fetch its rows again. Contacts already created stay in AdsEra. You can also remove AdsEra's access from your Google account at [myaccount.google.com/permissions](https://myaccount.google.com/permissions).


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