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.
| What | Direction | When | Rule |
|---|---|---|---|
| New subscriber as a row | ActiveCampaign to Google Sheets | Within seconds | Email, name, the list they joined and the date |
| Tag and field changes | ActiveCampaign to Google Sheets | Within seconds | The same row is rewritten in place, so the sheet shows the state, not the story |
| Opens and clicks | ActiveCampaign to Google Sheets | With every campaign | One row per event on a second sheet, with the contact, the campaign and the link |
| Rows back into ActiveCampaign | Google Sheets to ActiveCampaign | Every few minutes | A row you add with an email joins the list you name, so a list built in a sheet actually gets used |
| Your columns stay yours | In Google Sheets | Always | We write the columns we set up; what you add to the right, your formulas and your filters are left alone |
| Duplicate check | Both ways | Every contact | Matched 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.
- Choose ActiveCampaign and Google SheetsPress Connect. This pair is already selected on the checkout page at $39 a month, and there's nothing else to pick.
- Pay and open your accountCard or invoice, about two minutes. The account opens with this integration waiting for its two keys.
- 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. - We check both keysEach 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.
- Add one test subscriber, then we switch it onA 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.
- 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.
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.
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.