- How to automatically Add New Rows to a Google Sheet When You Receive an Email in Gmail
- 1. Add the Gmail trigger
- 2. Add the Google Sheets Add row automation
- 3. Turn on the playbook
- Learn more about integrating with Gmail and Google Sheets
- Related blog posts
- More how-to guides featuring Gmail and Google Sheets
How to automatically Add New Rows to a Google Sheet When You Receive an Email in Gmail
Gmail > Google SheetsEmail received
Add row to sheetAdd 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.
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.
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.
What will you automate?
