Loading

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 herearrow pointing down
Start herearrow pointing down
Choose an Action
Get Started for Free
  • Free forever for core features
  • 14 day trial for premium features & apps

Trusted at companies large and small

  • Update rows in Google Sheets with new inbound emails

    • Email by Zapier logo
    • Google Sheets logo
    Email by Zapier + Google Sheets
  • Send voicemails from Voicemail Realm and follow-up emails with new Google Sheets rows

    • Google Sheets logo
    • Email by Zapier logo
    Google Sheets + Delay by Zapier + 1 more
  • Create Google Sheets spreadsheet rows and send emails for new tasks completed in Trail

    • Trail logo
    • Email by Zapier logo
    • Google Sheets logo
    Trail + Email by Zapier + Google Sheets
  • Create invoices in cloudlayer.io from new Google Sheets rows and send outbound emails

    • Google Sheets logo
    • cloudlayer.io logo
    • Email by Zapier logo
    Google Sheets + cloudlayer.io + Email by Zapier
  • Create bar charts in QuickChart from new Google Sheets rows and send outbound emails

    • Google Sheets logo
    • QuickChart logo
    • Email by Zapier logo
    Google Sheets + QuickChart + Email by Zapier
  • Create Packfleet shipments from new Google Sheets rows and send outbound emails

    • Google Sheets logo
    • Email by Zapier logo
    Google Sheets + Packfleet + Email by Zapier
  • Lookup Google Sheets rows and create Microsoft Dynamics 365 CRM contacts for new DisputeFox leads

    Premium
    Details
    • DisputeFox logo
    • Email by Zapier logo
    DisputeFox + Filter by Zapier + Google Sheets + 3 more
  • Create and send emails for new Google Sheets worksheets with Email by Zapier

    • Google Sheets logo
    • Email by Zapier logo
    Google Sheets + Email by Zapier
  • Add new Email by Zapier read receipts to Google Sheets as rows

    • Email by Zapier logo
    • Google Sheets logo
    Email by Zapier + Google Sheets
  • Update Google Sheets rows when new read receipts arrive in Email by Zapier

    • Email by Zapier logo
    • Google Sheets logo
    Email by Zapier + Google Sheets
  • Add new inbound emails in Email by Zapier to multiple Google Sheets rows

    • Email by Zapier logo
    • Google Sheets logo
    Email by Zapier + Google Sheets

Update rows in Google Sheets with new inbound emails

  • Email by Zapier logo
  • Google Sheets logo
Email by Zapier + Google Sheets

Send voicemails from Voicemail Realm and follow-up emails with new Google Sheets rows

  • Google Sheets logo
  • Email by Zapier logo
Google Sheets + Delay by Zapier + 1 more

Create Google Sheets spreadsheet rows and send emails for new tasks completed in Trail

  • Trail logo
  • Email by Zapier logo
  • Google Sheets logo
Trail + Email by Zapier + Google Sheets

Create invoices in cloudlayer.io from new Google Sheets rows and send outbound emails

  • Google Sheets logo
  • cloudlayer.io logo
  • Email by Zapier logo
Google Sheets + cloudlayer.io + Email by Zapier

Create bar charts in QuickChart from new Google Sheets rows and send outbound emails

  • Google Sheets logo
  • QuickChart logo
  • Email by Zapier logo
Google Sheets + QuickChart + Email by Zapier

Create Packfleet shipments from new Google Sheets rows and send outbound emails

  • Google Sheets logo
  • Email by Zapier logo
Google Sheets + Packfleet + Email by Zapier

Lookup Google Sheets rows and create Microsoft Dynamics 365 CRM contacts for new DisputeFox leads

Premium
Details
  • DisputeFox logo
  • Email by Zapier logo
DisputeFox + Filter by Zapier + Google Sheets + 3 more

Create and send emails for new Google Sheets worksheets with Email by Zapier

  • Google Sheets logo
  • Email by Zapier logo
Google Sheets + Email by Zapier

Add new Email by Zapier read receipts to Google Sheets as rows

  • Email by Zapier logo
  • Google Sheets logo
Email by Zapier + Google Sheets

Update Google Sheets rows when new read receipts arrive in Email by Zapier

  • Email by Zapier logo
  • Google Sheets logo
Email by Zapier + Google Sheets

Add new inbound emails in Email by Zapier to multiple Google Sheets rows

  • Email by Zapier logo
  • Google Sheets logo
Email by Zapier + Google Sheets

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.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.

Email by Zapier logo
Google Sheets logo

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

    Premium
    Send Printfection gift URL to new contact from a Google Sheet
    • Email by Zapier logo
    • Google Sheets logo
    • Printfection logo
    Email by Zapier + Google Sheets + Printfection
  • Zapier users love adding Langzy Translate to their workflows

Supported triggers and actions

What does this mean?
    • 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.

    Trigger
    Instant
    Try It
    • ToRequired

      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 True and set up a Zap using the New Read Receipt trigger.

    Action
    Write
    • 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

    Trigger
    Instant
    Try It
    • 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

    • 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.

    Trigger
    Scheduled
    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.

    Trigger
    Instant
    Try It
    • 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

    Trigger
    Scheduled
    Try It
    • 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.

    Trigger
    Scheduled
    Try It
    • 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

    • 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.

    Trigger
    Instant
    Try It

How to connect Email by Zapier + Google Sheets

  1. Step 1: Authenticate Email by Zapier and Google Sheets.
    30 seconds
  2. Step 2: Pick one of the apps as a trigger, which will kick off your automation.
    15 seconds
  3. Step 3: Choose a resulting action from the other app.
    15 seconds
  4. Step 4: Select the data you want to send from one app to the other.
    2 minutes
  5. That’s it! More time to work on other things.

Email by Zapier Tutorials

Google Sheets Tutorials

email logo

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

  • Email
  • Zapier
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

Related categories

Similar apps

Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
Quip integrationsQuip integrations

Quip

Documents

Get started for free

You can't add more hours to the day. Zapier is the next best thing.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.