Gmail + Google Sheets
Add new Gmail emails matching searches to Google Sheets rows
Emails can get lost in your inbox easily. If you need to keep a record of specific emails, though, this integration is just the ticket. After you set it up, each new email matching a specified search in your Gmail account will be automatically added to a row in a specified Google Sheets spreadsheet.
Emails can get lost in your inbox easily. If you need to keep a record of specific emails, though, this integration is just the ticket. After you set it up, each new email matching a specified search in your Gmail account will be automatically added to a row in a specified Google Sheets spreadsheet.
- When this happens...
New Email Matching SearchTriggers when you receive a new email that matches a search string you provide.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
SubjectRequired
To
Cc
Bcc
From
From Name
Body Type
BodyRequired
Signature
Label/Mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Message to Remove Label(s) FromRequired
Label(s) to RemoveRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search StringRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Welcome
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Label
Triggers when you add a new label.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Starred Email
Triggers when you receive a new email and star it within two days.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planLabel(s) to Add
Message to be LabeledRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Trigger Instructions
ThreadRequired
To
Cc
Bcc
From
From Name
Body Type
BodyRequired
Signature
Label/Mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To
Cc
Bcc
From
From Name
Reply To
SubjectRequired
Body Type
BodyRequired
Signature
Label/Mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Trigger Instructions
ThreadRequired
To
Cc
Bcc
From
From Name
Reply To
Body Type
BodyRequired
Label/Mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search StringRequired
To
Cc
Bcc
From
From Name
Reply To
SubjectRequired
Body Type
BodyRequired
Signature
Label/Mailbox
Attachments
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
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.
Similar apps
IMAP by Zapier
Email, Zapier
SMTP by Zapier
Email, Zapier
Microsoft Office 365
Email, Microsoft
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
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.
Related Zap Templates
- Save new Gmail emails matching certain traits to a Google Spreadsheet
- Send emails via Gmail when Google Sheets rows are updated
- Add new labeled Gmail emails to rows in Google Sheets
- Add new emails in Gmail to Google Sheets rows
- Send Gmail emails for new Google Sheet spreadsheet rows
- Create Trello cards and Google Sheets rows for new starred emails on Gmail
- Create Google Sheets rows and send emails in Gmail with new caught webhooks
- Take new Gmail emails from a specific sender and add them to a Google Sheets spreadsheet
- Create drafts on Gmail for new rows on Google Sheets
- Add rows on Google Sheets when new Gmail threads start
- Send Gmail emails for new Trello cards that are also in Google Sheets
- Create a daily DALL-E image and send it via Gmail
- Prepare draft emails for updated rows on Google Sheets
- Send email in Gmail with new or updated Google Sheets rows in Team Drive
- Add rows in Google Sheets with new stared emails in Gmail
- Send new Gmail emails from new or updated Google Sheets rows in Team Drive
- Track new survey responses and alert a team via email
- Share Google Sheets rows via Gmail messages
- Store new incoming Gmail addresses in Google Sheets
- Update Google Sheets rows with new Gmails matching a search
- Create Gmail drafts for new or updated rows in a Google Sheet (team Drive)
- Send Gmail emails for new Google Sheets
- Reformat new emails in Gmail before logging it in Google Sheets
- Look up Google Sheet rows, then find and edit boxes in Streak from new Gmail threads
- Create Gmail drafts from new Google Sheets rows
- Add new Google Sheets rows for detailed CandidateZip parsed Gmail resume attachments
- Send Gmail emails for new Google Sheet worksheets
- Add Google Sheets rows for new CandidateZip-parsed resume attachments in Gmail
- 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.
- Create and email new Veem contacts with Google Sheets and Gmail
- Send email in Gmail with new Google Sheets rows in Team Drive
- Create Gmail drafts for new or updated Google Sheets rows
- Translate new emails matching Gmail searches with Langzy Translate and add them to Google Sheets
- Create Gmail drafts for new Google Sheet rows (team Drive)
- Create Google Sheets worksheets from new emails in Gmail
- Post Gmail emails with Gerar certificado certificates generated from new Google Sheets rows
- Detect new Gmail emails from potential investors or clients using Peltarion classifiers
- Send Gmail emails and generate SimplyDocs documents for new Google Sheets spreadsheet rows
- Create Google Sheets spreadsheets for new Crossbeam overlaps with new emails in Gmail
- When a new email lands in your Gmail inbox, scan its contents for sensitive data using Nightfall DLP, and log any findings in Google Sheets
- Send emails via Gmail for new Google Sheets worksheets
- Send Gmail emails for new Google Sheets spreadsheets
- Create Maroo invoices from new Google Sheets rows and send Gmail emails
- Send Gmail emails and get Digit.ink credential metadata from new Google Sheets rows
- Send Gmail emails with Digit.ink issuer profiles from new Google Sheets rows
- Verify emails from new Google Sheets rows with QuickEmailVerification and send emails via Gmail
- Convert HTML to PDFs in converts.online from new Google Sheets rows and send Gmail emails
- Send projects in Tilkee via Gmail with new rows added to Google Sheets (Team Drive)
- Send emails in Gmail for projects in Tilkee created from new rows in Google Sheets (Team Drive)
- Enrich consumer data in new Google Sheets rows using Online Audience Append in Versium REACH and validate email addresses in ZeroBounce
- Send template outputs in Brain Pod AI via Gmail from new rows in Google Sheets
- Extract data from new attachments in Gmail emails with Eden AI and add to Google Sheets rows
- Extract data with Bitskout from new attachments in Gmail and add to Google Sheets rows
- Create Gmail drafts from new Google Sheets rows
- Reply to emails with new Google Sheets rows in Gmail
- Post new sms messages to Slack private channels
- Reply to emails in Gmail for new or updated Google Sheets rows
- Create Gmail drafts from new Google Sheets worksheets
- Extract data with Bitskout from new Gmail invoice attachments and generate Google Sheets rows
- Create Gmail labels for new Google Sheets spreadsheet rows
- Track email information in Google Sheets with Hugging Face
- Add labels to Gmail emails based on new or updated Google Sheets rows in team drive
- Add labels to Gmail emails for new Google Sheets rows
- Extract key information from labeled emails and use ChatGPT to categorize important information and add to a Google Sheet
- Add labels to emails in Gmail when new or updated rows occur in Google Sheets
- Create draft replies in Gmail for new spreadsheet rows in Google Sheets
- Add labels to emails in Gmail for new spreadsheet rows (team drive) in Google Sheets
- Create Gmail labels for new Google Sheets worksheets
- Build content outlines with Jasper and send to your team as an email
- Send Gmail emails with ScreenshotOne website screenshots from new or updated Google Sheets rows
- Create Google Sheets rows with data extracted from purchase orders in new Gmail attachments with Bitskout
- Extract data from new labeled Gmail attachments with Knowstory and export to Google Sheets
- Send a Gmail email and add a spreadsheet row to Google Sheets for new leads in Facebook Lead Ads
- Write email replies with Chatsonic
Related Zap Templates
- Save new Gmail emails matching certain traits to a Google Spreadsheet
- Add new emails in Gmail to Google Sheets rows
- Create Google Sheets rows and send emails in Gmail with new caught webhooks
- Add rows on Google Sheets when new Gmail threads start
- Prepare draft emails for updated rows on Google Sheets
- Send new Gmail emails from new or updated Google Sheets rows in Team Drive
- Store new incoming Gmail addresses in Google Sheets
- Send Gmail emails for new Google Sheets
- Create Gmail drafts from new Google Sheets rows
- Add Google Sheets rows for new CandidateZip-parsed resume attachments in Gmail
- Create and email new Veem contacts with Google Sheets and Gmail
- Translate new emails matching Gmail searches with Langzy Translate and add them to Google Sheets
- Post Gmail emails with Gerar certificado certificates generated from new Google Sheets rows
- Create Google Sheets spreadsheets for new Crossbeam overlaps with new emails in Gmail
- Send Gmail emails for new Google Sheets spreadsheets
- Send Gmail emails with Digit.ink issuer profiles from new Google Sheets rows
- Send projects in Tilkee via Gmail with new rows added to Google Sheets (Team Drive)
- Send template outputs in Brain Pod AI via Gmail from new rows in Google Sheets
- Create Gmail drafts from new Google Sheets rows
- Reply to emails in Gmail for new or updated Google Sheets rows
- Create Gmail labels for new Google Sheets spreadsheet rows
- Add labels to Gmail emails for new Google Sheets rows
- Create draft replies in Gmail for new spreadsheet rows in Google Sheets
- Build content outlines with Jasper and send to your team as an email
- Extract data from new labeled Gmail attachments with Knowstory and export to Google Sheets
- Send emails via Gmail when Google Sheets rows are updated
- Send Gmail emails for new Google Sheet spreadsheet rows
- Take new Gmail emails from a specific sender and add them to a Google Sheets spreadsheet
- Send Gmail emails for new Trello cards that are also in Google Sheets
- Send email in Gmail with new or updated Google Sheets rows in Team Drive
- Track new survey responses and alert a team via email
- Update Google Sheets rows with new Gmails matching a search
- Reformat new emails in Gmail before logging it in Google Sheets
- Add new Google Sheets rows for detailed CandidateZip parsed Gmail resume attachments
- Get more info about senders of starred Gmail emails with Lead Score by Zapier and log it in Google Sheets
- Send email in Gmail with new Google Sheets rows in Team Drive
- Create Gmail drafts for new Google Sheet rows (team Drive)
- Detect new Gmail emails from potential investors or clients using Peltarion classifiers
- When a new email lands in your Gmail inbox, scan its contents for sensitive data using Nightfall DLP, and log any findings in Google Sheets
- Create Maroo invoices from new Google Sheets rows and send Gmail emails
- Verify emails from new Google Sheets rows with QuickEmailVerification and send emails via Gmail
- Send emails in Gmail for projects in Tilkee created from new rows in Google Sheets (Team Drive)
- Extract data from new attachments in Gmail emails with Eden AI and add to Google Sheets rows
- Reply to emails with new Google Sheets rows in Gmail
- Create Gmail drafts from new Google Sheets worksheets
- Track email information in Google Sheets with Hugging Face
- Extract key information from labeled emails and use ChatGPT to categorize important information and add to a Google Sheet
- Add labels to emails in Gmail for new spreadsheet rows (team drive) in Google Sheets
- Send Gmail emails with ScreenshotOne website screenshots from new or updated Google Sheets rows
- Send a Gmail email and add a spreadsheet row to Google Sheets for new leads in Facebook Lead Ads
- Add new labeled Gmail emails to rows in Google Sheets
- Create Trello cards and Google Sheets rows for new starred emails on Gmail
- Create drafts on Gmail for new rows on Google Sheets
- Create a daily DALL-E image and send it via Gmail
- Add rows in Google Sheets with new stared emails in Gmail
- Share Google Sheets rows via Gmail messages
- Create Gmail drafts for new or updated rows in a Google Sheet (team Drive)
- Look up Google Sheet rows, then find and edit boxes in Streak from new Gmail threads
- Send Gmail emails for new Google Sheet worksheets
- Analyze the Voice of the Employee in the emails received related to your employees' performance reviews.
- Create Gmail drafts for new or updated Google Sheets rows
- Create Google Sheets worksheets from new emails in Gmail
- Send Gmail emails and generate SimplyDocs documents for new Google Sheets spreadsheet rows
- Send emails via Gmail for new Google Sheets worksheets
- Send Gmail emails and get Digit.ink credential metadata from new Google Sheets rows
- Convert HTML to PDFs in converts.online from new Google Sheets rows and send Gmail emails
- Enrich consumer data in new Google Sheets rows using Online Audience Append in Versium REACH and validate email addresses in ZeroBounce
- Extract data with Bitskout from new attachments in Gmail and add to Google Sheets rows
- Post new sms messages to Slack private channels
- Extract data with Bitskout from new Gmail invoice attachments and generate Google Sheets rows
- Add labels to Gmail emails based on new or updated Google Sheets rows in team drive
- Add labels to emails in Gmail when new or updated rows occur in Google Sheets
- Create Gmail labels for new Google Sheets worksheets
- Create Google Sheets rows with data extracted from purchase orders in new Gmail attachments with Bitskout
- Write email replies with Chatsonic