Send Gmail Emails When a New Google Sheets Row is Added

4 min setup

No coding required

Runs automatically

Streamline your email communication by automating messages directly from Google Sheets. This MESA workflow template triggers an email via Gmail every time a new row is added to your Google Sheets document, ensuring accurate and timely outreach. Ideal for managing notifications, confirmations, or updates, this workflow saves time and keeps communication consistent.

New Google Sheets Row

Filter: Complete Rows Only

How it works

3 steps to send emails automatically whenever someone adds a row to your Google Sheets

New Google Sheets Row

App connector: [Google Sheets](/content/apps/googlesheets/integrate "View Google Sheets integration page"/index.html)• Time to complete: 2 minutes

Why this matters: This trigger monitors your Google Sheets spreadsheet and kicks off the entire workflow whenever a new row gets added, ensuring no email requests get missed.

This step watches your spreadsheet for new rows and captures the data from three key columns: "Recipient Email Address," "Subject," and "Email Body." You'll configure which specific spreadsheet and worksheet to monitor during setup. Once activated, MESA checks your sheet hourly for new entries and automatically starts the email process when it finds them. The data from each new row gets passed to the next step for validation.

Filter: Complete Rows Only

App connector: [Filter](/content/apps/filter/integrate "View Filter integration page"/index.html)• Time to complete: 0 minutes (Auto-configured)

Why this matters: This validation step prevents broken emails by ensuring all three required fields contain data before attempting to send, avoiding failures from incomplete rows.

The filter automatically checks that the recipient email address, subject line, and email body fields all contain content before proceeding. If any field is empty, the workflow stops here and won't send a potentially broken email. This step runs automatically using the data captured from the new spreadsheet row. Only complete rows with all three fields populated will pass through to trigger the actual email sending.

Send Gmail Email

App connector: [Gmail](/content/apps/gmail/integrate "View Gmail integration page"/index.html)• Time to complete: 1 minute

Why this matters: This action delivers the actual Gmail email using the validated data from your spreadsheet row, completing the automated email process.

This step takes the recipient email, subject, and message content from your spreadsheet row and sends it through Gmail. You'll need to specify your "from" email address during setup - this should be the Gmail account you want emails to appear from. The step automatically formats and sends the email using Gmail's API, with the subject line and body text exactly as written in your spreadsheet. Once sent, the workflow completes and waits for the next new row to process.

Frequently asked questions

What happens if someone adds a row but leaves one of the required fields blank?

The Filter step will catch incomplete rows and stop the workflow, preventing broken emails from being sent. The workflow simply waits for the next complete row to process.

Can I use this to send emails from a different Gmail account than the one connected to MESA?

No, the emails will send from whichever Gmail account you've connected to MESA. You'll need to connect the specific Gmail account you want to send from during the initial setup.

How often does MESA check my spreadsheet for new rows?

MESA checks your Google Sheets every hour for new additions. If you need faster processing, you can manually trigger the workflow or consider upgrading to a plan with more frequent polling.

Make this template your own!

Customize this workflow even further:

• Send follow-up sequences
• Log email activity
• Customize with conditions
• Add rich formatting

You're in good company

Avg. App Store rating 4.9/5

Merchant reviews 157

Avg. time saved per week 3.5 hrs

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

Rothy's