Connect OptiMonk and Google Sheets

OptiMonk popups collect email addresses on your store or blog. FlowMattic adds each new subscriber to a Google Sheet along with the campaign that caught them, so you can compare popups side by side, hand out codes from a list, and keep a copy of every signup on your own terms.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in OptiMonk1 trigger

Do this in Google Sheets19 actions

1. TriggerSubscriber and Campaign Data

2. ActionAdd New Row

When OptiMonk fires Subscriber and Campaign Data, 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

OptiMonk 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 each OptiMonk subscriber with the campaign name

Every signup becomes a row with the popup that produced it, so marketers can see which campaign brings in the most addresses without exporting from OptiMonk.

Subscriber and Campaign DataAdd New Row

View the template

Give every popup campaign its own tab

A Router reads the campaign name and writes to a matching tab, which keeps an exit-intent popup and a spin-to-win wheel from mixing in one list.

Subscriber and Campaign DataRouterAdd New Row

Add the campaign to an existing subscriber instead of a new row

People often sign up through more than one popup. Look the email up and update the row with the latest campaign, so each person is counted once.

Subscriber and Campaign DataLookup Row DataRouterUpdate Row

Give each subscriber a unique coupon code from a sheet

Keep unused codes in a tab. The workflow finds the next free code, marks it as given to this email, and sends it with Email (SMTP).

Subscriber and Campaign DataLookup Row DataUpdate RowEmail (SMTP)

Keep your own team's test signups out of the list

A Filter stops entries from your company domain or a test address, so the sheet holds only real visitors while you try new popups.

Subscriber and Campaign DataFilterAdd New Row

Keep a running signup total in a dashboard cell

Counter adds one for each subscriber and Update Cell Data writes the number into a summary cell that a chart on the sheet reads.

Subscriber and Campaign DataCounterUpdate Cell Data

Set up: subscribers with their campaign

At the end, each new OptiMonk subscriber is written to your sheet with the campaign it came from.

Add the columns
Start a sheet with headers such as Email, Name, Campaign, Page and Signed up.
Connect Google Sheets
In FlowMattic Connects, add the Google account that can edit this spreadsheet.
Pick the OptiMonk trigger
Create a workflow with Subscriber and Campaign Data and follow the trigger step's instructions to send OptiMonk data to it.
Sign up once yourself
Submit a popup on your site so FlowMattic captures a real subscriber and the campaign fields.
Map and switch on
Add Google Sheets Add New Row, map the fields to your columns, test the step and turn the workflow on.

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

From OptiMonk	To Google Sheets
Email	Email
Name	Name
Campaign name	Campaign
Page URL	Page
Date	Signed up

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

Which fields arrive depends on the inputs in each popup, so the mapping is an example. A popup that asks only for email sends no name.
The coupon workflow needs one row per code with an empty Given to column. Look up the first row where that column is blank.
These workflows all start from new OptiMonk data. Changing a row in the sheet does not edit the subscriber in OptiMonk.

OptiMonk

Integration page

Triggers (1)

Subscriber and Campaign DataTriggers when new subscriber or campaign data is added.

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

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

Your subscriber list, your copy

Signups pass through your own WordPress server to the sheet, so the list exists outside OptiMonk without another service in the middle.

Popular popups cost nothing extra

Runs are unlimited, so a campaign that suddenly converts well does not use up a monthly task allowance.

Compare campaigns in a sheet

Tabs and counts per campaign let you judge popups with the formulas and charts you already know.

Common questions

How do I connect OptiMonk to Google Sheets?

Create a FlowMattic workflow with the OptiMonk Subscriber and Campaign Data trigger, send a test signup, then add Google Sheets Add New Row and map email, name and campaign to columns.

Can I tell which popup each subscriber came from?

Yes. The campaign name comes with the subscriber data, so map it to its own column, or use a Router to write each campaign to its own tab.

Can I send a discount code from my own list?

Yes. Keep the codes in a tab, find the next unused one with Lookup Row Data, mark it with Update Row and email it with the Email (SMTP) step.

Will someone who signs up twice get two rows?

Only if you add rows without checking. Search the email column first and update the existing row when the address is already there.

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

Start automating OptiMonk 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. OptiMonk integration 1.0.0, Google Sheets integration 2.2.4.