Connect Act-On and Google Sheets

Act-On holds your marketing programs and lists, while sales, events and compliance teams often work from a shared spreadsheet. FlowMattic writes Act-On form submissions, opt-outs, bounces, spam complaints and program activity into Google Sheets from your WordPress site, so each team sees the part of the marketing record it needs.

Try FlowMattic free See example workflows

22 triggers 19 actions 7 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Act-On16 triggers

Do this in Google Sheets19 actions

1. TriggerForm Submitted

2. ActionAdd New Row

When Act-On fires Form Submitted, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Act-On and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Log Act-On form submissions in Google Sheets

Every Act-On form submission becomes a row, so sales or event staff can follow up from the sheet without an Act-On login.

Form SubmittedAdd New Row

View the template

Keep a suppression list of global opt-outs

When a contact opts out of all email, they are added to a suppression sheet that other teams check before importing lists into their own tools.

Contact Opt Global OutAdd New Row

Mark hard-bounced addresses in the lead sheet

A hard bounce finds the contact's row by email and marks the address as bad, so reps phone the lead instead of emailing an address that does not exist.

Contact Bounce HardLookup Row DataUpdate Row

Record spam complaints with the date

Each spam complaint is logged with the contact and date, giving the marketing lead evidence to review which sends or lists cause complaints.

Contact Marked Email as SpamDate/Time FormatterAdd New Row

Track opt-outs by subscription category

Category opt-outs are logged with the category name, so you can see which newsletters or offer types people drop and adjust what you send.

Subscription Category Opt OutAdd New Row

Keep an audit log of automated programs

A row is added each time an automated program starts, which helps a team with several marketers see who switched on which program and when.

Automated Program StartedAdd New Row

Share the email send calendar with the wider team

Scheduled messages are added to a calendar sheet with send date and subject, so sales and support know which campaigns are about to reach customers.

Email Message ScheduledAdd New Row

Set up: form submissions into a sheet

At the end, each Act-On form submission is added to your Google Sheet as one row.

Prepare the sheet
Add a header row with the fields your Act-On form collects, such as Name, Email, Company and Form.
Connect Google Sheets
Under Connects in FlowMattic, add Google Sheets with an account that can edit the spreadsheet.
Start with Form Submitted
Create a workflow with the Act-On Form Submitted trigger, follow its instructions to send Act-On events to the workflow and submit a test entry.
Add New Row
Add Google Sheets Add New Row, map each form field to its column, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Act-On	To Google Sheets
First name	Name
Email address	Email
Company	Company
Form name	Form
Submitted date	Date

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

These workflows log Act-On events in the sheet; opting contacts back in and starting programs stay in Act-On. Information flows from Act-On to Google Sheets only.
Form fields come from your Act-On form, so the mapping above is an example. Submit a test entry after any form change and remap new fields.
Opt-out and complaint sheets hold personal data. Limit sharing to the people who need them and keep the tab protected from edits.

Act-On

Integration page

Triggers (16)

Automated Program StartedTriggers when an Automated Program is started.
Automated Program StoppedTriggers when an Automated Program is stopped.
Contact Bounce HardTriggers when a contact is added to the hard bounce list.
Contact Bounce SoftTriggers when a contact is added to the soft bounce list.
Contact Marked Email as SpamTriggers when a contact marks an email as spam.
Contact Opt Global InTriggers when a contact opts in for all email communication.
Contact Opt Global OutTriggers when a contact opts out from all email communication.
CRM ConnectedTriggers when a user connects to a CRM.
CRM DisconnectedTriggers when a user disconnects from a CRM.
Email Message ScheduledTriggers when a message is scheduled.
Form SubmittedTriggers when a Form is submitted.
Subscription Category AddedTriggers when a contact adds a new subscription category.
Subscription Category DeletedTriggers when a contact deletes a subscription category.
Subscription Category Opt InTriggers when a contact opts into a subscription category.
Subscription Category Opt OutTriggers when a contact opts out from a subscription category.
Subscription Category UpdatedTriggers when a contact updates a subscription category.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Act-On and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Compliance has its own record

Opt-outs, bounces and complaints are logged with dates in a sheet that can be shared without giving everyone Act-On access.

Sales works from current leads

Form submissions and bad addresses reach the lead sheet as they happen, so reps contact the right people the right way.

Marketing events at a flat cost

FlowMattic runs on your own WordPress site with unlimited runs, so a large send that brings hundreds of bounces costs no more.

Common questions

How do I send Act-On form submissions to Google Sheets?

Add a Google Sheets connection, create a workflow with the Act-On Form Submitted trigger and send Act-On events to it. Add Add New Row, map the form fields to columns, test and switch on.

Can I keep a list of everyone who unsubscribes?

Yes. Use Contact Opt Global Out for people leaving all email and Subscription Category Opt Out for single categories. Each can write to its own tab with the email and date.

Can the sheet tell me which forms bring the most leads?

Yes. Map the form name to a column in the Form Submitted workflow, then use a pivot table or COUNTIF in Google Sheets to count rows per form.

Can edits in the sheet update Act-On?

Not with these workflows. They only copy Act-On events into the sheet, so changes in the sheet stay there. Keep Act-On as the place where contact preferences are changed.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Act-On and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Act-On integration 1.0.0, Google Sheets integration 2.2.4.