How to connect Google Sheets + Gmail
Zapier lets you send info between Google Sheets and Gmail automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Quickly automate Google Sheets and Gmail workflows with Zapier's templates
Get more info about senders of starred Gmail emails with Lead Score by Zapier and log it in Google Sheets
Analyze the Voice of the Employee in the emails received related to your employees' performance reviews.
Translate new emails matching Gmail searches with Langzy Translate and add them to Google Sheets
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.


Do Even More with Google Sheets + Gmail
With Zapier, you can do more than just connect 2 apps—you can automate entire processes from beginning to end! Here are some popular ways users make their Google Sheets + Gmail workflows do more for them.
Zapier users love adding Webhooks by Zapier to their workflows
Create Google Sheets rows and send emails in Gmail with new caught webhooks
Create Google Sheets rows and send emails in Gmail with new caught webhooksPremiumZapier users love adding Trello to their workflows
Create Trello cards and Google Sheets rows for new starred emails on Gmail
Create Trello cards and Google Sheets rows for new starred emails on GmailPremium
Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Try ItNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
The column position (zero-based) to insert. If not set, append to the right by default.
No Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
Try ItDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired