Loading

Google Sheets + Gmail Integrations

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.

Choose a Trigger
Start herearrow pointing down
Start herearrow pointing down
Choose an Action
Connect Apps
  • Free forever for core features
  • 14 day trial for premium features & apps

  • Create Google Sheets rows and send emails in Gmail with new caught webhooks

    Premium
    Details
    • Webhooks by Zapier logo
    • Google Sheets logo
    • Gmail logo
    Webhooks by Zapier + Google Sheets + Gmail
  • Create Trello cards and Google Sheets rows for new starred emails on Gmail

    • Gmail logo
    • Trello logo
    • Google Sheets logo
    Gmail + Trello + Google Sheets
  • Create drafts on Gmail for new rows on Google Sheets

    • Google Sheets logo
    • Gmail logo
    Google Sheets + Gmail
  • Track new survey responses and alert a team via email

    • Google Sheets logo
    • Airtable logo
    • Gmail logo
    Google Sheets + Airtable + Gmail
  • Send Gmail emails for new Trello cards that are also in Google Sheets

    • Trello logo
    • Google Sheets logo
    • Gmail logo
    Trello + Google Sheets + Gmail
  • Share Google Sheets rows via Gmail messages

    • Google Sheets logo
    • Gmail logo
    Google Sheets + Gmail
  • Prepare draft emails for updated rows on Google Sheets

    • Google Sheets logo
    • Gmail logo
    Google Sheets + Gmail
  • Add Google Sheets rows for new CandidateZip-parsed resume attachments in Gmail

    • Gmail logo
    • CandidateZip Resume/Job Parser logo
    • Google Sheets logo
    Gmail + CandidateZip Resume/Job Parser + Google Sheets
  • Get more info about senders of starred Gmail emails with Lead Score by Zapier and log it in Google Sheets

    • Gmail logo
    • Lead Score by Zapier logo
    • Google Sheets logo
    Gmail + Lead Score by Zapier + Google Sheets
  • Look up Google Sheet rows, then find and edit boxes in Streak from new Gmail threads

    • Gmail logo
    • Streak logo
    Gmail + Google Sheets + Streak
  • Add new Google Sheets rows for detailed CandidateZip parsed Gmail resume attachments

    • Gmail logo
    • CandidateZip Resume/Job Parser logo
    • Google Sheets logo
    Gmail + CandidateZip Resume/Job Parser + Google Sheets
  • Analyze the Voice of the Employee in the emails received related to your employees' performance reviews.

    • Gmail logo
    • MeaningCloud logo
    • Google Sheets logo
    Gmail + MeaningCloud + Google Sheets
  • Create and email new Veem contacts with Google Sheets and Gmail

    • Google Sheets logo
    • Veem logo
    • Gmail logo
    Google Sheets + Veem + Gmail
  • Send email in Gmail with new Google Sheets rows in Team Drive

    • Google Sheets logo
    • Gmail logo
    Google Sheets + Gmail
  • Send email in Gmail with new or updated Google Sheets rows in Team Drive

    • Google Sheets logo
    • Gmail logo
    Google Sheets + Gmail
  • Create Gmail drafts from new Google Sheets rows

    • Google Sheets logo
    • Gmail logo
    Google Sheets + Gmail
  • Create Gmail drafts for new or updated Google Sheets rows

    • Google Sheets logo
    • Gmail logo
    Google Sheets + Gmail
  • Update Google Sheets rows with new Gmails matching a search

    • Gmail logo
    • Google Sheets logo
    Gmail + Google Sheets
  • Send new Gmail emails from new or updated Google Sheets rows in Team Drive

    • Google Sheets logo
    • Gmail logo
    Google Sheets + Gmail
  • Translate new emails matching Gmail searches with Langzy Translate and add them to Google Sheets

    • Gmail logo
    •  logo
    • Google Sheets logo
    Gmail + Google Sheets
  • Add rows in Google Sheets with new stared emails in Gmail

    • Gmail logo
    • Google Sheets logo
    Gmail + Google Sheets
  • Create Gmail drafts for new or updated rows in a Google Sheet (team Drive)

    • Google Sheets logo
    • Gmail logo
    Google Sheets + Gmail
  • Create Gmail drafts for new Google Sheet rows (team Drive)

    • Google Sheets logo
    • Gmail logo
    Google Sheets + Gmail
  • Send Gmail emails for new Google Sheets

    • Google Sheets logo
    • Gmail logo
    Google Sheets + Gmail

Create Google Sheets rows and send emails in Gmail with new caught webhooks

Premium
Details
  • Webhooks by Zapier logo
  • Google Sheets logo
  • Gmail logo
Webhooks by Zapier + Google Sheets + Gmail

Create Trello cards and Google Sheets rows for new starred emails on Gmail

  • Gmail logo
  • Trello logo
  • Google Sheets logo
Gmail + Trello + Google Sheets

Create drafts on Gmail for new rows on Google Sheets

  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Track new survey responses and alert a team via email

  • Google Sheets logo
  • Airtable logo
  • Gmail logo
Google Sheets + Airtable + Gmail

Send Gmail emails for new Trello cards that are also in Google Sheets

  • Trello logo
  • Google Sheets logo
  • Gmail logo
Trello + Google Sheets + Gmail

Share Google Sheets rows via Gmail messages

  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Prepare draft emails for updated rows on Google Sheets

  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Add Google Sheets rows for new CandidateZip-parsed resume attachments in Gmail

  • Gmail logo
  • CandidateZip Resume/Job Parser logo
  • Google Sheets logo
Gmail + CandidateZip Resume/Job Parser + Google Sheets

Get more info about senders of starred Gmail emails with Lead Score by Zapier and log it in Google Sheets

  • Gmail logo
  • Lead Score by Zapier logo
  • Google Sheets logo
Gmail + Lead Score by Zapier + Google Sheets

Look up Google Sheet rows, then find and edit boxes in Streak from new Gmail threads

  • Gmail logo
  • Streak logo
Gmail + Google Sheets + Streak

Add new Google Sheets rows for detailed CandidateZip parsed Gmail resume attachments

  • Gmail logo
  • CandidateZip Resume/Job Parser logo
  • Google Sheets logo
Gmail + CandidateZip Resume/Job Parser + Google Sheets

Analyze the Voice of the Employee in the emails received related to your employees' performance reviews.

  • Gmail logo
  • MeaningCloud logo
  • Google Sheets logo
Gmail + MeaningCloud + Google Sheets

Create and email new Veem contacts with Google Sheets and Gmail

  • Google Sheets logo
  • Veem logo
  • Gmail logo
Google Sheets + Veem + Gmail

Send email in Gmail with new Google Sheets rows in Team Drive

  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Send email in Gmail with new or updated Google Sheets rows in Team Drive

  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Create Gmail drafts from new Google Sheets rows

  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Create Gmail drafts for new or updated Google Sheets rows

  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Update Google Sheets rows with new Gmails matching a search

  • Gmail logo
  • Google Sheets logo
Gmail + Google Sheets

Send new Gmail emails from new or updated Google Sheets rows in Team Drive

  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Translate new emails matching Gmail searches with Langzy Translate and add them to Google Sheets

  • Gmail logo
  •  logo
  • Google Sheets logo
Gmail + Google Sheets

Add rows in Google Sheets with new stared emails in Gmail

  • Gmail logo
  • Google Sheets logo
Gmail + Google Sheets

Create Gmail drafts for new or updated rows in a Google Sheet (team Drive)

  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Create Gmail drafts for new Google Sheet rows (team Drive)

  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Send Gmail emails for new Google Sheets

  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

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.


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.

Google Sheets logo
Gmail logo

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

    Premium
    Create Google Sheets rows and send emails in Gmail with new caught webhooks
    • Gmail logo
    • Google Sheets logo
    • Webhooks by Zapier logo
    Gmail + Google Sheets + Webhooks by Zapier
  • Zapier users love adding Trello to their workflows

    Create Trello cards and Google Sheets rows for new starred emails on Gmail

    Premium
    Create Trello cards and Google Sheets rows for new starred emails on Gmail
    • Gmail logo
    • Google Sheets logo
    • Trello logo
    Gmail + Google Sheets + Trello

Supported triggers and actions

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

    • Column NameRequired

    • Index

      The column position (zero-based) to insert. If not set, append to the right by default.

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

    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.

    • SpreadsheetRequired

    • WorksheetRequired

    Action
    Write