Connect Poptin and Google Sheets

Poptin turns visitors into leads with exit-intent popups and embedded forms. FlowMattic writes each of those leads to Google Sheets, sorted by popup, without duplicate rows and with clean dates, so sales or the shop owner works from one list. It suits store owners and marketers who test several popups and want to compare what each one brings in.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Poptin1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Lead

2. ActionAdd New Row

When Poptin fires New Lead, 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

Poptin 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 every new Poptin lead in a Google Sheet

Each email or phone number a popup captures becomes a row with the page and popup it came from, ready for follow-up or a mailing import.

New LeadAdd New Row

View the template

Give each popup its own tab to compare results

A Router writes leads from the discount popup, the exit-intent popup and the newsletter bar to separate tabs, so you can see which one earns its place.

New LeadRouterAdd New Row

Update the row of a visitor who signs up again

The same visitor often fills in two popups. Lookup Row Data finds their email and Update Row records the latest popup instead of adding a duplicate.

New LeadLookup Row DataRouterUpdate Row

Write each lead's time in your own time zone

Date/Time Formatter turns the capture time into your local date and hour, so you can see which times of day the popup works best.

New LeadDate/Time FormatterAdd New Row

Add a short note on what each lead wants

When a popup asks a free-text question, an AI Agent sums up the answer in a few words for a Notes column, which makes a long list quicker to sort.

New LeadAI AgentAdd New Row

Set up: every lead as a row

At the end, each lead your Poptin popups capture adds a row to your Google Sheet.

Prepare the sheet
Add a header row with Email, Name, Phone, Popup, Page and Date columns.
Connect Google Sheets
In FlowMattic, open Connects and add a Google account that can edit the sheet.
Start with New Lead
Create a workflow, choose Poptin and New Lead, connect it to your popup and submit a test lead.
Add New Row
Add Google Sheets with Add New Row, map the lead fields to the columns, test the step and switch the workflow on.

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

From Poptin	To Google Sheets
Email	Email
Name	Name
Phone	Phone
Popup name	Popup
Page URL	Page

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

Every workflow here starts with a new Poptin lead. Google Sheets triggers cannot change anything in Poptin.
The fields you receive depend on what each popup's form asks for. Send a test lead from each popup before mapping, and leave columns empty where a popup does not ask.
Poptin's New Lead fires for every conversion, so the same visitor can arrive twice. Use the lookup example if one row per person matters.

Poptin

Integration page

Triggers (1)

New LeadTriggers when a new lead is captured through a Poptin conversion.

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

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

Compare popups on real leads

With each popup's leads on its own tab, you can see which offer brings the most usable contacts, not just the most views.

Leads pass through your site

FlowMattic runs on your own WordPress server, so lead details reach the sheet without going through another automation account.

Unlimited runs during sales

A busy holiday sale can bring in many more leads, and FlowMattic charges nothing per run.

Common questions

How do I send Poptin leads to Google Sheets?

Create a workflow with Poptin's New Lead trigger and add Google Sheets Add New Row. Map the email, name and popup fields to columns, test with one lead and switch the workflow on.

Can leads from different popups go to different sheets?

Yes. Add a Router after the trigger with a condition on the popup name, and give each path its own Add New Row step pointing at a tab or a spreadsheet.

Can I also alert my team about each lead?

Yes. Add an Email (SMTP) step after the row is written, or add a step for the chat app your team uses, in the same workflow.

Will leads collected before the workflow appear?

No. The trigger handles leads from the moment it is switched on. Export earlier leads from Poptin and paste them into the sheet once.

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

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