Connect Benchmark Email and Google Sheets

Benchmark Email manages your newsletter list, but sales, events and partners often need the same list in a spreadsheet. FlowMattic keeps that sheet current from your WordPress site: new subscribers are added, unsubscribes and cleaned addresses are marked, and changed emails and profiles are updated on the existing row.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Benchmark Email5 triggers

Do this in Google Sheets19 actions

1. TriggerSubscriber Added

2. ActionAdd New Row

When Benchmark Email fires Subscriber Added, 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

Benchmark Email 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

Add new Benchmark Email subscribers to Google Sheets

Each new subscriber becomes a row with email, name and list, so the team sees who joined without exporting from Benchmark Email.

Subscriber AddedAdd New Row

View the template

Mark unsubscribed people on their row

An unsubscribe finds the person's row by email and sets the status to unsubscribed with the date, so nobody adds them to a manual mailing later.

UnsubscribeLookup Row DataUpdate Row

Replace the old address when a subscriber changes email

When someone changes their email, the row with the old address gets the new one, so the sheet and the list stay matched person for person.

Existing Email ChangedLookup Row DataUpdate Row

Keep a list of cleaned addresses to fix

Addresses Benchmark Email cleans from the list are logged in their own tab, so sales can phone those contacts and ask for a working email.

Email CleanedAdd New Row

Update names and fields when a profile changes

Profile edits such as a new company or city are written to the subscriber's row, which keeps segments built in the sheet accurate.

Profile Changed.Lookup Row DataUpdate Row

Count sign-ups per month in their own tab

Date/Time Formatter turns the sign-up date into a month name used as the tab, so list growth per month is visible at a glance.

Subscriber AddedDate/Time FormatterAdd New Row

Set up: new subscribers into a sheet

At the end, every new Benchmark Email subscriber is added to your Google Sheet as a row.

Prepare the sheet
Add a header row such as Email, First name, Last name, List, Status and Joined.
Connect Google Sheets
Under Connects in FlowMattic, add Google Sheets with an account that can edit the spreadsheet.
Start with Subscriber Added
Create a workflow with the Benchmark Email Subscriber Added trigger, follow its instructions to send list events to the workflow and add a test subscriber.
Add New Row
Add Google Sheets Add New Row, map the subscriber fields, set Status to subscribed, test and switch the workflow on.

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

From Benchmark Email	To Google Sheets
Email	Email
First name	First name
Last name	Last name
List name	List
Date added	Joined

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 send Benchmark Email events into the sheet; editing a row does not change the list. Change subscriber details in Benchmark Email and let the sheet follow.
The unsubscribe, email change and profile workflows find rows by email, so keep one row per address and do not reformat the Email column.
For Existing Email Changed, search the sheet with the old address and write the new one, otherwise the lookup finds nothing to update.

Benchmark Email

Integration page

Triggers (5)

Subscriber AddedTriggers when a new subscriber is added.
UnsubscribeTriggers when an email is unsubscribed.
Existing Email ChangedTriggers when an existing email changes.
Email CleanedTriggers when an email is cleaned.
Profile Changed.Triggers when a profile is updated.

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

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

A list other teams can use

Sales and event staff work from an up-to-date sheet without logins to Benchmark Email or manual exports.

Bad addresses become a task

Cleaned and unsubscribed addresses are flagged on the row, so nobody emails them by hand and sales can ask for a new address.

Subscriber data stays on your server

FlowMattic runs on your WordPress site with unlimited runs, so list events pass through your own server on the way to the sheet.

Common questions

How do I export Benchmark Email subscribers to Google Sheets automatically?

Create a FlowMattic workflow with the Benchmark Email Subscriber Added trigger, connect Google Sheets and add Add New Row mapped to your columns. New subscribers are written to the sheet from then on.

Can the sheet show who unsubscribed?

Yes. A second workflow with the Unsubscribe trigger looks up the email with Lookup Row Data and uses Update Row to set the status and date.

What does Email Cleaned mean for the sheet?

It fires when Benchmark Email removes an address it treats as undeliverable. Logging those rows gives you a list of contacts to reach another way.

Will current subscribers be added?

No. The triggers only see new events. Export your list from Benchmark Email once and paste it into the sheet, then let the workflows keep it current.

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

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