ActiveCampaign and Google Sheets, ready to switch on

New subscribers land as rows with the list and the date, tag changes rewrite the same row, and opens and clicks go to a second tab, so you can pivot a campaign without exporting anything. You paste your API key and a link to your sheet, and we switch it on for you.

No setup fee, cancel any month, and a person on live chat if a key doesn't work.

More with these apps: all ActiveCampaign integrations · all Google Sheets integrations

What moves, and when

The details you would normally get after a sales call. Here they are up front.

WhatDirectionWhenRule
New subscriber as a rowActiveCampaign to Google SheetsWithin secondsEmail, name, the list they joined and the date
Tag and field changesActiveCampaign to Google SheetsWithin secondsThe same row is rewritten in place, so the sheet shows the state, not the story
Opens and clicksActiveCampaign to Google SheetsWith every campaignOne row per event on a second sheet, with the contact, the campaign and the link
Rows back into ActiveCampaignGoogle Sheets to ActiveCampaignEvery few minutesA row you add with an email joins the list you name, so a list built in a sheet actually gets used
Your columns stay yoursIn Google SheetsAlwaysWe write the columns we set up; what you add to the right, your formulas and your filters are left alone
Duplicate checkBoth waysEvery contactMatched by email; a known address updates its row instead of adding one

How to set up ActiveCampaign and Google Sheets

A few minutes of your time, then it's ours.

  1. Choose ActiveCampaign and Google Sheets
    Press Connect. This pair is already selected on the checkout page at $39 a month, and there's nothing else to pick.
  2. Pay and open your account
    Card or invoice, about two minutes. The account opens with this integration waiting for its two keys.
  3. Paste the ActiveCampaign API key and the Google Sheets link
    • ActiveCampaign API key: in ActiveCampaign open Settings in the left menu, then Developer. Full ActiveCampaign guide
    • Google Sheets link: create or open the spreadsheet, share it with the address our engineer sends you or with anyone who has the link, and paste the link from the address bar. Full Google Sheets guide
    Each screen carries the full guide with the exact menu names, about four minutes for both.
  4. We check both keys
    Each key is checked against ActiveCampaign's and Google Sheets's own API the moment you paste it. If one doesn't pass, the screen says what to fix, and a person joins the chat if that isn't enough.
  5. Add one test subscriber, then we switch it on
    A minute or two. Add a subscriber in ActiveCampaign and watch the row appear, then change a tag and watch the same row update. A person checks the setup and switches it on, within a working day.

When ActiveCampaign or Google Sheets changes its API, we fix it within a working day. You don't get a ticket to solve.

$39a month
  • Everything in the table above, with monitoring on.
  • Fixes when either app changes its API.
  • A person on live chat, weekdays 10:00 to 19:00 EET.
  • Custom logic beyond the table is priced separately.
Ask us to connect it

What it will cost once you can switch it on yourself. While we're in beta we connect it by hand and don't charge for it.

Ways to connect ActiveCampaign and Google Sheets

Two ways people connect these two, and what each one asks of you.

Zapier or MakeDovetly
Who sets it upYou, one step at a time in the scenario editorAlready built. You paste two keys and we switch it on.
Who fixes it when it breaksYou: the scenario is yours, so the fix is tooWe do, within a working day, and we watch it
What you need to knowTriggers, actions, filters and how the fields of ActiveCampaign and Google Sheets mapWhere the two keys are. The guide shows it.
PriceSet by the builder's plan, counted in tasks or operations$39 a month, flat, whatever the volume

Before you decide

Can I load an old list this way?

You can. Think about consent first: we add what you put in the sheet, and whether those people agreed is yours to answer.

Why do rows go back on a schedule?

Google Sheets doesn't announce cell changes, so we look every few minutes. Out of ActiveCampaign it's within seconds.

Can the sheet start an automation?

Yes. A row with a tag column joins the list and gets the tag, and whatever automation watches that tag starts on its own. It's the cheapest way to run a campaign from a list somebody typed up.

Anything to know about ActiveCampaign?

The API key belongs to the user who made it, so the integration acts with that user's permissions and shows up in the account as that user.

Anything to know about Google Sheets?

Google Sheets doesn't tell anyone when a cell changes, so anything we read back out of a sheet is picked up on a short schedule rather than the moment you type it.

What if mine is a bit different?

Tell us what should go where in plain words. Small changes to the rules above are usually free; bigger ones we price within a working day and build into the same account.