Email by Zapier + Google Sheets Integrations
Zapier lets you send info between Email by Zapier and Google Sheets automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
Choose a Trigger
Start here
Start here
Choose an Action
- Free forever for core features
- 14 day trial for premium features & apps
Trusted at companies large and small
Quickly automate Email by Zapier and Google Sheets workflows with Zapier's templates
Our most popular Zap!
Lookup Google Sheets rows and create Microsoft Dynamics 365 CRM contacts for new DisputeFox leads
PremiumDetails
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 Email by Zapier + Google Sheets
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 Email by Zapier + Google Sheets workflows do more for them.
Zapier users love adding Printfection to their workflows
Send Printfection gift URL to new contact from a Google Sheet
Send Printfection gift URL to new contact from a Google SheetPremiumZapier users love adding Langzy Translate to their workflows
Send Langzy Translate - translated new rows in Google Sheets via email
Send Langzy Translate - translated new rows in Google Sheets via emailPremium
Email AddressRequired
Customize the private email address associated with your mailbox. Be sure to use lowercase and numbers only. Just forward emails to this address to trigger this Zap. Want to receive to your own email address? Try Mailgun, IMAP, Mandrill, or Gmail instead.
Try ItToRequired
Can be a comma separated list of emails. Limited to 5.
SubjectRequired
Body (HTML or Plain)Required
You can place HTML in here and we will send it as is. If this is plain text, we will try to convert it to some very basic HTML for greater client compatibility.
Attachment
A file object to be attached to the email. Plain text content will converted into a txt file and attached. Please note, if the file is over ~10mb or so, you should explore using other email sending techniques (like Gmail or SMTP).
From Name
This will be your "display name" when sending. Want to send from your own email address? Try Mailgun, IMAP, Mandrill or Gmail apps instead.
Reply To
Specify a reply address other than your own.
Cc
Can be a comma separated list of emails. Limited to 5.
Bcc
Can be a comma separated list of emails. Limited to 5.
Force Linebreaks?
Set this to "yes" if your emails are received without line breaks or spacing.
Enable read receipts?
Want to be notified when this email is opened? Set this to to
Trueand set up a Zap using theNew Read Receipttrigger.
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 It
Setup Directions
In order to trigger when emails are opened, this must be paired with a separate Zap using the Send Outbound Email action, with the Enable Read Receipts? field set to
True.To test with a live email, send an email to yourself using your Send Outbound Email action (with read receipts enabled) and open it, then test this trigger immediately for samples. If you don't need to test with live data, click Skip Test to use static test data.
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
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 It
How to connect Email by Zapier + Google Sheets
- Step 1: Authenticate Email by Zapier and Google Sheets.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Email by Zapier Tutorials
Google Sheets Tutorials
About Email by Zapier
Send and receive email via a custom Zapier email address at "zapiermail.com". This is great for triggering off of emails and sending custom emails. (Max of 10 email sends per hour.)
Have direct access to your own email servers? Check out our IMAP and SMTP services!
Related categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
DocumentsGet started for free
You can't add more hours to the day. Zapier is the next best thing.