Gmail + Google Sheets
Clear Google Sheets rows when new matching emails are found in Gmail
Streamline your workflow between Gmail and Google Sheets with this automation. When a new email arrives in your Gmail that matches a designated search criteria, the related content in Google Sheets is directly updated. This way, your spreadsheets stay current with every incoming relevant email, making data management more efficient and time-effective.
Streamline your workflow between Gmail and Google Sheets with this automation. When a new email arrives in your Gmail that matches a designated search criteria, the related content in Google Sheets is directly updated. This way, your spreadsheets stay current with every incoming relevant email, making data management more efficient and time-effective.
- When this happens...
New Email Matching SearchTriggers when you receive a new email that matches a search string you provide.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Clear Spreadsheet Row(s)Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Label or mailbox
Search keywords
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Starred Email
Triggers when you receive a new email and star it within two days.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planLabelRequired
MessageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email message to be DeletedRequired
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
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To
Send message to Google Contacts Group/Label
Cc
Bcc
From
From Name
Reply To
SubjectRequired
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ThreadRequired
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 ZapPollingZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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 ZapPollingZapier checks for new data every 15 min on the Free planMessageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient Instructions
To
Cc
Bcc
SubjectRequired
From
From Name
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name of labelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MessageRequired
Label(s) to removeRequired
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
Subject
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search StringRequired
To
Send message to Google Contacts Group/Label
Cc
Bcc
From
From Name
Reply To
SubjectRequired
Body type
BodyRequired
Add signature default
Label or 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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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 Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Search from last row
Row count
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
Search from last row
Row count
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.
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
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 emails in Gmail to Google Sheets rows
- Add new labeled Gmail emails to rows in Google Sheets
- Add new Gmail emails matching searches to Google Sheets rows
- Create Trello cards and Google Sheets rows for new starred emails on Gmail
- 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 a Gmail email and add a spreadsheet row to Google Sheets for new leads in Facebook Lead Ads
- Extract key information from labeled emails and use ChatGPT to categorize important information and add to a Google Sheet
- 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
- Create drafts on Gmail for new rows on Google Sheets
- Store new incoming Gmail addresses in Google Sheets
- Track new survey responses and alert a team via email
- Share Google Sheets rows via Gmail messages
- Send new Gmail emails from new or updated Google Sheets rows in Team Drive
- Update Google Sheets rows with new Gmails matching a search
- Extract data with Bitskout from new Gmail invoice attachments and generate Google Sheets rows
- Create multiple Google Sheets rows for new starred emails in Gmail
- Create Gmail drafts for new or updated Google Sheets rows
- Convert, split, and extract data from new Gmail attachments with PDF-app and add Google Sheets rows
- Copy new starred Gmail emails to Google Sheets worksheets
- Send Gmail emails with ScreenshotOne website screenshots from new or updated Google Sheets rows
- Reformat new emails in Gmail before logging it in Google Sheets
- Send Gmail emails for new Google Sheets spreadsheet rows on team drive
- 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
- Look up Google Sheet rows, then find and edit boxes in Streak from new Gmail threads
- Add new Google Sheets rows for detailed CandidateZip parsed Gmail resume attachments
- 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
- Send email in Gmail with new or updated Google Sheets rows in Team Drive
- Create Gmail drafts from new Google Sheets rows
- Add rows in Google Sheets with new stared emails in Gmail
- Create Gmail drafts for new or updated rows in a Google Sheet (team Drive)
- Create Gmail drafts for new Google Sheet rows (team Drive)
- Send Gmail emails for new Google Sheets
- Send Gmail emails for new Google Sheet worksheets
- Create Google Sheets worksheets from new emails in Gmail
- Post Gmail emails with Gerar Certificado certificates generated from new Google Sheets rows
- Send Gmail emails and generate SimplyDocs documents for new Google Sheets spreadsheet rows
- 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 a daily DALL-E image and send it via Gmail
- 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
- 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
- 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
- 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
- Write email replies with Chatsonic
- Analyze incoming emails with Chatbase and add to Google Sheets
- Update Google Sheets rows when new emails arrive in Gmail
- Create worksheets in Google Sheets from new labeled emails in Gmail
- Create multiple Google Sheets rows from new labeled Gmail emails
- Create labels in Gmail for new or updated rows in Google Sheets
- Copy new Gmail attachments to Google Sheets worksheets
- Update Google Sheets rows with new matching search emails from Gmail
- Create spreadsheet columns in Google Sheets for new emails matching search in Gmail
- Reply to emails in Gmail when new or updated rows are detected in Google Sheets (team drive)
- Copy new matching Gmail emails to Google Sheets worksheets
- Create new Google Sheets columns from new Gmail emails
- "update Google Sheets rows with new Gmail emails"
- Create Google Sheets spreadsheets from new Gmail emails matching search
- Create new Google Sheets spreadsheets from new labeled Gmail emails
- Create new Google Sheets rows for each new Gmail label
- Update Google Sheets rows with new Gmail attachments
- Update Google Sheets rows when new labeled emails arrive in Gmail
- Create new Google Sheets worksheets for Gmail emails matching search criteria
- Create Google Sheets columns for new labeled Gmail emails
- Copy worksheets in Google Sheets for new labeled emails in Gmail
- Update Google Sheets rows for every new labeled email in Gmail
- Create spreadsheets in Google Sheets from new attachments in Gmail
- Copy worksheets in Google Sheets for each new email in Gmail
- Create worksheets in Google Sheets for new attachments in Gmail
Related Zap Templates
- Save new Gmail emails matching certain traits to a Google Spreadsheet
- Add new labeled Gmail emails to rows in Google Sheets
- Send Gmail emails for new Google Sheet spreadsheet rows
- Extract key information from labeled emails and use ChatGPT to categorize important information and add to a Google Sheet
- Prepare draft emails for updated rows on Google Sheets
- Track new survey responses and alert a team via email
- Update Google Sheets rows with new Gmails matching a search
- Create Gmail drafts for new or updated Google Sheets rows
- Send Gmail emails with ScreenshotOne website screenshots from new or updated Google Sheets rows
- Add Google Sheets rows for new CandidateZip-parsed resume attachments in Gmail
- Add new Google Sheets rows for detailed CandidateZip parsed Gmail resume attachments
- Send email in Gmail with new Google Sheets rows in Team Drive
- Add rows in Google Sheets with new stared emails in Gmail
- Send Gmail emails for new Google Sheets
- Post Gmail emails with Gerar Certificado certificates generated from new Google Sheets 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
- Reply to emails with new Google Sheets rows in Gmail
- Create Gmail drafts from new Google Sheets worksheets
- Add labels to Gmail emails based on new or updated Google Sheets rows in team drive
- 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
- Write email replies with Chatsonic
- Create worksheets in Google Sheets from new labeled emails in Gmail
- Copy new Gmail attachments to Google Sheets worksheets
- Reply to emails in Gmail when new or updated rows are detected in Google Sheets (team drive)
- "update Google Sheets rows with new Gmail emails"
- Create new Google Sheets rows for each new Gmail label
- Create new Google Sheets worksheets for Gmail emails matching search criteria
- Update Google Sheets rows for every new labeled email in Gmail
- Create worksheets in Google Sheets for new attachments in Gmail
- Send emails via Gmail when Google Sheets rows are updated
- Add new Gmail emails matching searches to Google Sheets rows
- Take new Gmail emails from a specific sender and add them to a Google Sheets spreadsheet
- Create Google Sheets rows and send emails in Gmail with new caught webhooks
- Create drafts on Gmail for new rows on Google Sheets
- Share Google Sheets rows via Gmail messages
- Extract data with Bitskout from new Gmail invoice attachments and generate Google Sheets rows
- Convert, split, and extract data from new Gmail attachments with PDF-app and add Google Sheets rows
- Reformat new emails in Gmail before logging it in Google Sheets
- 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.
- Send email in Gmail with new or updated Google Sheets rows in Team Drive
- Create Gmail drafts for new or updated rows in a Google Sheet (team Drive)
- Send Gmail emails for new Google Sheet worksheets
- Send Gmail emails and generate SimplyDocs documents for new Google Sheets spreadsheet rows
- 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 a daily DALL-E image and send it via Gmail
- Post new sms messages to Slack private channels
- Create Gmail labels for new Google Sheets spreadsheet rows
- Add labels to Gmail emails for new Google Sheets rows
- Add labels to emails in Gmail for new spreadsheet rows (team drive) in Google Sheets
- Create Google Sheets rows with data extracted from purchase orders in new Gmail attachments with Bitskout
- Analyze incoming emails with Chatbase and add to Google Sheets
- Create multiple Google Sheets rows from new labeled Gmail emails
- Update Google Sheets rows with new matching search emails from Gmail
- Copy new matching Gmail emails to Google Sheets worksheets
- Create Google Sheets spreadsheets from new Gmail emails matching search
- Update Google Sheets rows with new Gmail attachments
- Create Google Sheets columns for new labeled Gmail emails
- Create spreadsheets in Google Sheets from new attachments in Gmail
- Add new emails in Gmail to Google Sheets rows
- Create Trello cards and Google Sheets rows for new starred emails on Gmail
- Send a Gmail email and add a spreadsheet row to Google Sheets for new leads in Facebook Lead Ads
- Add rows on Google Sheets when new Gmail threads start
- Store new incoming Gmail addresses in Google Sheets
- Send new Gmail emails from new or updated Google Sheets rows in Team Drive
- Create multiple Google Sheets rows for new starred emails in Gmail
- Copy new starred Gmail emails to Google Sheets worksheets
- Send Gmail emails for new Google Sheets spreadsheet rows on team drive
- Look up Google Sheet rows, then find and edit boxes in Streak from new Gmail threads
- Create and email new Veem contacts with Google Sheets and Gmail
- Create Gmail drafts from new Google Sheets rows
- Create Gmail drafts for new Google Sheet rows (team Drive)
- Create Google Sheets worksheets from 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
- 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
- Create Gmail drafts from new Google Sheets rows
- Reply to emails in Gmail for new or updated Google Sheets rows
- Track email information in Google Sheets with Hugging Face
- Add labels to emails in Gmail when new or updated rows occur in Google Sheets
- Create Gmail labels for new Google Sheets worksheets
- Extract data from new labeled Gmail attachments with Knowstory and export to Google Sheets
- Update Google Sheets rows when new emails arrive in Gmail
- Create labels in Gmail for new or updated rows in Google Sheets
- Create spreadsheet columns in Google Sheets for new emails matching search in Gmail
- Create new Google Sheets columns from new Gmail emails
- Create new Google Sheets spreadsheets from new labeled Gmail emails
- Update Google Sheets rows when new labeled emails arrive in Gmail
- Copy worksheets in Google Sheets for new labeled emails in Gmail
- Copy worksheets in Google Sheets for each new email in Gmail