Email the person on each new row
When a booking, applicant or new client is added to the sheet, Gmail sends them a welcome or confirmation built from the row's columns.
New Spreadsheet RowSend Email
Connect Google Sheets and Gmail
A sheet of names and a Gmail inbox are enough to run a lot of small-business email, from welcome notes to follow-ups. FlowMattic joins them without code: rows can send emails or prepare drafts, a status change can notify a customer, and matching emails can be logged back into the sheet. Everything runs from your WordPress site.
6 triggers 37 actions 6 example workflows 11 ready-made templates Unlimited runs
Try a pairing
When this happens in Google Sheets6 triggers
Do this in Gmail18 actions
1. TriggerNew Spreadsheet Row2. ActionSend EmailWhen Google Sheets fires New Spreadsheet Row, FlowMattic runs Send Email in Gmail with the data from that event.
You build this in the FlowMattic workflow builder on your own site. See the setup steps
Google Sheets and Gmail 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 templateNotify the team by Gmail when a row is added or changed
A shared tracker sends an email to the people responsible whenever a line is added or edited, so changes reach those who never open the sheet.
New Or Updated Spreadsheet RowSend Email
View the template Prepare Gmail drafts from rows for a human check
Outreach rows become Gmail drafts rather than sent emails, so you can read, tweak and send each one yourself from Gmail.
New Spreadsheet RowCreate Draft
Log matching emails into a sheet and label them
Every hour, find emails that match a search such as invoices from a supplier, add each as a row, then label it so the next run skips it.
ScheduleFind Multiple EmailsIteratorAdd New RowAdd Label to Email
Send follow-ups on the date written in the sheet
A daily run reads the sheet, keeps rows whose follow-up date is today, emails each contact and marks the row as sent.
ScheduleGet Row DataIteratorFilterSend EmailUpdate Row
Reply to a thread by filling in a reply column
Store the thread ID next to each logged email. When someone writes an answer in the Reply column, Gmail sends it in that thread.
Update Specific Column ValueReply to Email
More ready-made templates with both apps
- When a new Gradeazy user is created, add them to a Google Sheets roster and send a Gmail welcome email
- When a SupportCandy ticket is closed, update the row in Google Sheets and email the customer via Gmail
- When a SmartSurvey response is completed, save it to Google Sheets and email the team via Gmail
- When a 2Checkout recurring installment fails, log it to Google Sheets and email the customer via Gmail
- When a Classplus purchase happens, log it in Google Sheets and send the student a welcome email via Gmail
- When a new form response is submitted in SuprForms, add a new row in Google Sheets, then send a confirmation email via Gmail
Set up: an email for each new row
By the end, each row added to your sheet sends one Gmail message to the address in that row.
Connect both Google apps
In FlowMattic, add a Google Sheets connection and a Gmail connection under Connects. They can use the same Google account.
Watch the sheet
Create a workflow with New Spreadsheet Row, choose the spreadsheet and tab, and add a test row with your own email.
Write the email
Add Gmail Send Email, map the Email column to the recipient, and build the subject and body from the other columns.
Send a test
Test the Gmail step, check the email in your inbox and switch the workflow on.
1. Trigger in Google Sheets
New Spreadsheet Row
-
2. Action in Gmail
Send Email
Fields mapped from the earlier steps (a typical setup)
From Google Sheets To Gmail Email column To First name column Greeting in the body Service or product column Subject line Date column Body text
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
- Gmail has no triggers in FlowMattic. To work with incoming mail, run Find Multiple Emails on a Schedule and label what you have processed.
- Emails go out from the Gmail account you connect, so use the address your recipients expect to hear from.
- A row added with an empty email cell will fail at the Gmail step. Put a Filter before it that checks the column is filled.
- Writing back to the sheet you watch with New Or Updated Spreadsheet Row can start the workflow again, so watch a single column when you plan to update rows.
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
Actions (18)
- Send EmailSend an email to the recipient
- Send Template EmailSend an email using the FlowMattic email template
- Find EmailFind an email in Gmail
- Find Multiple EmailsFind multiple emails in Gmail
- Mark Email as ReadMarks the email as read by the thread ID
- Get Email DetailsGet the details of specific email from Gmail
- Reply to EmailReply to the email
- Create DraftCreate a draft of the email
- Send DraftSend the draft of the email
- Delete DraftDelete the draft of the email
- Create Draft ReplyCreate a draft reply of the email
- Send Draft ReplySend the draft reply of the email
- Delete Draft ReplyDelete the draft reply of the email
- List All LabelsList all labels in Gmail
- Create LabelCreate a label in Gmail
- Delete LabelDelete a label in Gmail
- Add Label to EmailAdd a label to the email
- Remove Label from EmailRemove a label from the email
Why run this pair with FlowMattic
Google Sheets and Gmail connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.
No code and no scripts to maintain
You build the workflow by picking columns on a visual builder, instead of writing and fixing script code inside the spreadsheet.
Both Google accounts, one place
Connections are added once and reused, and the data passes through your own WordPress site.
Long sheets cost the same
FlowMattic runs are unlimited, so a daily follow-up run over a long sheet costs no more than a short one.
Common questions
Do I need code for a Gmail and Google Sheets integration?
No. FlowMattic connects both accounts and you pick a Google Sheets trigger, such as New Spreadsheet Row, and a Gmail action, such as Send Email. Columns are mapped into the email on a visual builder, with no script code.
Can I review emails before they are sent?
Yes. Use Create Draft instead of Send Email. The drafts wait in Gmail, and you can send them yourself or later with Send Draft.
Can incoming emails start a workflow?
Gmail has no triggers here, so schedule Find Multiple Emails with a search, loop over the results and label each one so it is only handled once.
Can each email have different text?
Yes. Every column can be placed in the subject or body, and a Router can pick a different template based on a column such as language or plan.
Can I attach labels to emails I log?
Yes. Add Label to Email takes the message from Find Multiple Emails. Create Label sets up the label first if it does not exist yet.
Did not find your answer? You can browse the help center or ask us directly.
Google Sheets with other apps
Google Sheets and Slack149 shared templates
Google Sheets and AI Agents26 shared templates
Google Sheets and Fluent Forms23 shared templates
Google Sheets and WooCommerce21 shared templates
Google Sheets and FluentCRM20 shared templates
Google Sheets and WPForms14 shared templates
Google Sheets and WordPress11 shared templates
Google Sheets and ActiveCampaign11 shared templates
Start automating Google Sheets and Gmail
Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.
30-day money-back guarantee Unlimited workflows and runs Self-hosted
Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Google Sheets integration 2.2.4, Gmail integration 1.2.0.