Connect MailPoet and Google Sheets

MailPoet keeps your newsletter list inside WordPress, but contact lists from events, partners and sales often live in Google Sheets. FlowMattic moves people both ways: MailPoet form signups are written to a sheet, and rows you add or change in the sheet create MailPoet subscribers or move them between lists. It suits site owners who run their newsletter from WordPress.

Try FlowMattic free See example workflows

7 triggers 23 actions 6 example workflows 1 ready-made template Unlimited runs

Try a pairing

When this happens in MailPoet1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Form Subscription

2. ActionAdd New Row

When MailPoet fires New Form Subscription, 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

MailPoet 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.

Log each MailPoet form signup in Google Sheets

Every new subscriber from a MailPoet form gets a row with email, name and date, which a partner or client can see without access to wp-admin.

New Form SubscriptionAdd New Row

Add the subscriber's lists and status to the row

Get Subscriber Details returns the lists and status MailPoet holds, so the sheet shows who confirmed and which newsletter they chose.

New Form SubscriptionGet Subscriber DetailsAdd New Row

Create MailPoet subscribers from new sheet rows

Contacts collected at a stand or a webinar are typed into a sheet, and each new row becomes a MailPoet subscriber on the list you choose.

New Spreadsheet RowCreate New Subscriber

Move a subscriber to another list when the sheet says so

Change the List column for a person and the workflow adds them to the new MailPoet list and removes them from the old one.

Update Specific Column ValueAdd Subscriber to List(s)Remove Subscriber From List(s)

Take people off a list when their row is deleted

When a contact is removed from the master sheet, Remove Subscriber From List(s) takes them off the matching MailPoet list too.

Deleted Spreadsheet RowRemove Subscriber From List(s)

Skip rows for people who are already subscribed

Get Subscriber Details checks the email first, and a Router adds them to a list if they exist or creates them if they do not, so re-imports stay tidy.

New Spreadsheet RowGet Subscriber DetailsRouterCreate New Subscriber

Set up: signups logged in a sheet

At the end, every subscription through a MailPoet form adds a row to your Google Sheet.

Connect Google Sheets
In FlowMattic, open Connects and add a Google account that can edit the spreadsheet.
Start with New Form Subscription
Create a workflow, choose MailPoet and New Form Subscription, then sign up through your form with a test email.
Add New Row
Add Google Sheets with Add New Row, choose the sheet and map email, first name, last name and date.
Switch on
Test the step, check the row, then switch the workflow on.

From MailPoet	To Google Sheets
Email	Email
First name	First name
Last name	Last name
Form name	Source
Subscribed at	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

New Form Subscription fires for MailPoet's own subscription forms. People added in other ways, such as an import inside MailPoet, do not start the workflow.
Remove Subscriber From List(s) and Add Subscriber to List(s) work on existing subscribers, so keep the email in the sheet exactly as it is stored in MailPoet.
Only add people from a sheet if they agreed to get your emails, and keep the source of each row in a column.

MailPoet

Integration page

Triggers (1)

New Form SubscriptionTriggers when new form subscription received

Actions (4)

Create New SubscriberCreate a new subscriber
Get Subscriber DetailsGet an existing subscriber details
Add Subscriber to List(s)Add an existing subscriber to list or multiple lists
Remove Subscriber From List(s)Remove an existing subscriber from list or multiple lists

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

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

Your list stays in WordPress

MailPoet and FlowMattic both run on your site, so subscribers are read and written there and only the columns you map go to Google.

Sheets become a way in

Contacts gathered outside your site join the right MailPoet list from a row, without CSV imports.

No count on subscribers

Runs are unlimited, so a big signup day or a long import costs nothing extra.

Common questions

Can I export MailPoet subscribers to Google Sheets automatically?

New form signups are added as they happen with New Form Subscription and Add New Row. For subscribers you already have, export them once from MailPoet and paste them into the sheet.

Can a Google Sheet add subscribers to MailPoet?

Yes. New Spreadsheet Row runs Create New Subscriber with the email and name in the row, and Add Subscriber to List(s) puts existing subscribers on more lists.

Will new subscribers from the sheet get a confirmation email?

That follows your MailPoet sign-up confirmation settings. Test with your own email to see what a subscriber added from the sheet receives.

Can I record which form someone used?

Yes. The New Form Subscription data includes the form, so map it to a Source column and filter the sheet by it later.

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

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