How to automatically Add New Rows to a Google Sheet When You Receive an Email in Gmail

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 run the “add row to sheet” action in Google Sheets for each email received in Gmail using Relay.app.
Gmail logoGmail > Google Sheets
Trigger
Last triggered
Gmail logoEmail received
Google Sheets logoAdd row to sheet
1

Add the Gmail 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 "Email received" under Gmail. Then, select filters such as sender, message content, or labels. If this is your first time using a Gmail integration in Relay, you'll be prompted to connect your Gmail account.

2

Add the Google Sheets Add row automation

Now, you can create the automation to "Add a Row" in Google Sheets.

You can reference fields from Gmail to automatically pass along the right data, and even use AI extract to pull out certain information.

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 you receive an email in Gmail that matches your criteria. You can also click "Check now" to do a manual check whenever you'd like.

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