Loading

Gmail + Google Sheets Integrations

How to connect Gmail + Google Sheets

Zapier lets you send info between Gmail 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
Connect Apps
  • Free forever for core features
  • 14 day trial for premium features & apps

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.

Gmail logo
Google Sheets logo

Do Even More with Gmail + 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 Gmail + Google Sheets workflows do more for them.

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

Supported triggers and actions

What does this mean?
    • Label/Mailbox

    • Search String

      This works the same as the search bar you see in Gmail. For example: from:amy OR from:david or subject:dinner label:my-family. Learn more.

    Trigger
    Scheduled
    Try It
    • Search StringRequired

      By default this search will trigger on emails in all folders, including Sent emails, which most people don't want. To limit results, like to your inbox, include in:inbox.

      This works the same as the search bar you see in Gmail. For example: from:amy OR from:david or in:inbox subject:dinner label:my-family. Learn more.

    Trigger
    Scheduled
    Try It
  • Gmail triggers, actions, and search

    New Label

    Triggers when you add a new label.

    Trigger
    Scheduled
    Try It
    • Label/Mailbox

      (Note: If no Label/Mailbox is selected, this Zap will trigger on all e-mails, including Drafts.)

    Trigger
    Scheduled
    Try It
  • Gmail triggers, actions, and search

    New Starred Email

    Triggers when you receive a new email and star it within two days.

    Trigger
    Scheduled
    Try It
    • Label(s) to Add

    • Message to be LabeledRequired

    Action
    Write

How Gmail + Google Sheets Integrations Work

  1. Step 1: Authenticate Gmail 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.

Gmail Tutorials

Google Sheets Tutorials

gmail logo
gmail logo

About Gmail

One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.
Learn more

Related categories

  • Email
  • Google

Similar apps

IMAP by Zapier integrationsIMAP by Zapier integrations

IMAP by Zapier

Email, Zapier
SMTP by Zapier integrationsSMTP by Zapier integrations

SMTP by Zapier

Email, Zapier
Microsoft Office 365 integrationsMicrosoft Office 365 integrations

Microsoft Office 365

Email, Microsoft
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.