Connect GMass and Google Sheets

GMass sends mail merge campaigns from Gmail and reports sends, opens, clicks, replies, bounces and unsubscribes. Many GMass users keep their prospect list in Google Sheets. FlowMattic writes each GMass event into a sheet from your own WordPress site, so the outreach list itself shows who replied, who bounced and who asked to stop.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in GMass6 triggers

Do this in Google Sheets19 actions

1. TriggerEmail Sent

2. ActionAdd New Row

When GMass fires Email Sent, 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

GMass 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 GMass email sent to a sheet

Each campaign send adds a row with the recipient, subject and campaign, giving a dated record of who was contacted and when.

Email SentAdd New Row

View the template

Mark replies on your prospect list

Email Replied finds the prospect's row by email and sets a Replied column, so whoever owns the list can see which conversations are open without searching Gmail.

Email RepliedLookup Row DataUpdate Row

Collect bounced addresses on a cleanup tab

Each bounce goes onto a Bounced tab with the address and campaign, so you can remove bad addresses from the source list before the next send.

Email BouncedAdd New Row

Flag unsubscribes so they are not emailed again

Email Unsubscribed looks up the address and writes Do not contact in its row, which keeps the next mail merge from that sheet clear of people who opted out.

Email UnsubscribedLookup Row DataUpdate Row

Record which links each prospect clicked

Email Clicked adds the recipient and the clicked URL to a Clicks tab, so you can see who looked at pricing or a case study before you call.

Email ClickedAdd New Row

Write a last-opened date next to each prospect

Rather than a row per open, Email Opened updates one dated column per person, formatted by Date/Time Formatter, so a sort shows the warmest prospects first.

Email OpenedLookup Row DataDate/Time FormatterUpdate Row

Set up: log each email sent

At the end, every email GMass sends as part of a campaign is recorded as a row in your sheet.

Create a Sends tab
Add headers such as Recipient, Campaign, Subject and Sent at. Keep it separate from the prospect list GMass sends from.
Connect GMass and Google
Under Connects, add your GMass account and the Google account that owns the spreadsheet.
Trigger on Email Sent
Start a workflow with the GMass Email Sent trigger and send a small test campaign to yourself so the fields are captured.
Write the row
Add Google Sheets Add New Row, map the recipient and campaign fields, test the step and switch the workflow on.

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

GMass app icon — Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

From GMass	To Google Sheets
Email address	Recipient
Campaign ID	Campaign
Subject	Subject
Event time	Sent at

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

Email Sent is for campaign emails, not single transactional messages, so one-off emails you send from Gmail will not appear.
If your campaign was sent from a Google Sheet, write results to extra columns or a separate tab rather than the merge columns GMass reads.
Lookups match on the exact email address. Keep addresses in lowercase in the sheet so replies and unsubscribes find their row.

GMass

Integration page

Triggers (6)

Email SentTriggers when an individual email is sent as part of a campaign. This is not the trigger for transactional emails.
Email OpenedTriggers when an email is opened.
Email RepliedTriggers when an email that is sent as part of a campaign receives a reply.
Email UnsubscribedTriggers when an email address is unsubscribed.
Email ClickedTriggers when a link is clicked in an email.
Email BouncedTriggers when an email bounces.

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

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

Results on the list you send from

Replies, bounces and opt-outs land next to each prospect, so the next campaign starts from a list that is already cleaned.

Large campaigns, same price

Runs are unlimited, so logging every send and open from a campaign of thousands costs nothing extra on FlowMattic.

Prospect data on your own server

Engagement data passes through your WordPress site into your own sheet, rather than another automation company's account.

Common questions

Can I see GMass replies in my Google Sheet?

Yes. Start a workflow on Email Replied, look up the prospect's row by email with Lookup Row Data, and set a Replied column with Update Row.

How do I stop emailing people who unsubscribed?

Use Email Unsubscribed to write Do not contact in the person's row, then filter those rows out of the sheet before your next mail merge.

Should I log every open?

On large campaigns, a row per open grows the sheet quickly. Updating a last-opened date on each prospect's row gives the useful part with fewer rows.

Can bounces go to a separate cleanup list?

Yes. Email Bounced can add each address to a Bounced tab with the campaign it came from, ready for you to remove from the source list.

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

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