Skip to main content
Link your Google spreadsheets to AdsEra and use a sheet’s rows as the recipients of a campaign.
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

AdsEra only sees spreadsheets you picked. Click Add Spreadsheet and choose it.
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.