How to send an email in Gmail when a new row is added in Google Sheets

Relay.app is an automation tool that lets you automate actions across Gmail, Google Sheets, and many other apps. In this guide, we'll show you how to automatically send email in Gmail for each row added in Google Sheets using Relay.app.
Google Sheets logoGoogle Sheets > Gmail
Trigger
Last triggered
Google Sheets logoRow added
Gmail logoSend email
1

Add the Google Sheets trigger

Every playbook starts with a trigger. The trigger detects changes in your connected apps and runs your playbook in response.

Click "Add trigger" and select "Row added to sheet" under Google Sheets. Then, select the sheet. If this is your first time using a Google Sheets integration in Relay, you'll be prompted to connect your Google Sheets account.

Now, every time a new row is added to a sheet in Google Sheets, your playbook will run automatically.

2

Add the Gmail Send Email automation

Now you can send emails automatically through your Gmail account. Add a new step and select "Send email" from the list of Gmail automations.

Connect Gmail to Relay if you haven't already, then fill out the details like the sender, recipients, subject, and body. You can reference fields from Google Sheets to automatically pass along the right data.

3

Turn on the playbook

When you are done with the playbook, it's time to turn it on.

The playbook will now run automatically whenever a new row is added to a sheet in Google Sheets. You can also click "Check now" to do a manual check whenever you'd like.

See all blog posts ➔

More how-to guides featuring Gmail and Google Sheets

See all how-to guides ➔

What will you automate?

Sign up and get started with your first Relay.app workflow today.
Background imageBackground image