Gmail + Google Sheets
Prepare draft emails for updated rows on Google Sheets
Spreadsheets make excellent repositories when you're gathering information for your outreach. Once you're happy with what you've put together, use this Google Sheets-Gmail integration to kick off your workflow: change a column on your sheet to signify you're ready, and the Zap will trigger. It will then create a draft email for you on Gmail, complete with custom copy and values from your spreadsheet so everything is ready for a final scan and to be sent off.
Spreadsheets make excellent repositories when you're gathering information for your outreach. Once you're happy with what you've put together, use this Google Sheets-Gmail integration to kick off your workflow: change a column on your sheet to signify you're ready, and the Zap will trigger. It will then create a draft email for you on Gmail, complete with custom copy and values from your spreadsheet so everything is ready for a final scan and to be sent off.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create DraftCreate a draft email message.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
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.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
Search from last row
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
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
MessageRequired
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.Search StringRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
No 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 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
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
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
ColumnsRequired
Row CountRequired
First Row
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 foundLabel or mailbox
Search keywords
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planEmail 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
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.Trigger Instructions
ThreadRequired
To
Cc
Bcc
From
From Name
Reply To
Body type
BodyRequired
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
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 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
- Create Trello cards and Google Sheets rows for new starred emails on Gmail
- Add new Gmail emails matching searches to Google Sheets rows
- 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
- Create Google Sheets rows and send emails in Gmail with new caught webhooks
- 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
- Add rows on Google Sheets when new Gmail threads start
- Update Google Sheets rows with new Gmails matching a search
- Send Gmail emails for new Trello cards that are also in Google Sheets
- Create drafts on Gmail for new rows on Google Sheets
- Share Google Sheets rows via Gmail messages
- Create Gmail drafts for new or updated Google Sheets rows
- Track new survey responses and alert a team via email
- Extract data from new labeled Gmail attachments with Knowstory and export to Google Sheets
- Add new Google Sheets rows for detailed CandidateZip parsed Gmail resume attachments
- Send new Gmail emails from new or updated Google Sheets rows in Team Drive
- Store new incoming Gmail addresses in Google Sheets
- Add rows in Google Sheets with new stared emails in Gmail
- Extract data with Bitskout from new Gmail invoice attachments and generate Google Sheets rows
- Create a daily DALL-E image and send it via Gmail
- Reply to emails with new Google Sheets rows in Gmail
- Reformat new emails in Gmail before logging it in Google Sheets
- 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
- 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
- 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
- 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 Gmail drafts from new Google Sheets rows
- 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
- 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
- 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
- Update Google Sheets rows when new starred emails arrive in Gmail
- Create multiple spreadsheet rows in Google Sheets for every new thread in Gmail
- Create multiple rows in Google Sheets for new Gmail labels
- Create labels in Gmail for new spreadsheets in Google Sheets
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
- Send a Gmail email and add a spreadsheet row to Google Sheets for new leads in Facebook Lead Ads
- Update Google Sheets rows with new Gmails matching a search
- Share Google Sheets rows via Gmail messages
- Extract data from new labeled Gmail attachments with Knowstory and export to Google Sheets
- Store new incoming Gmail addresses in Google Sheets
- Create a daily DALL-E image and send it via Gmail
- Add Google Sheets rows for new CandidateZip-parsed resume attachments in Gmail
- 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 Google Sheet rows (team Drive)
- Create Google Sheets worksheets from new emails in Gmail
- 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 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
- Create Google Sheets rows with data extracted from purchase orders in new Gmail attachments with Bitskout
- 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
- Create multiple spreadsheet rows in Google Sheets for every new thread in Gmail
- Send emails via Gmail when Google Sheets rows are updated
- Create Trello cards and Google Sheets rows for new starred emails on Gmail
- Take new Gmail emails from a specific sender and add them to a Google Sheets spreadsheet
- Extract key information from labeled emails and use ChatGPT to categorize important information and add to a Google Sheet
- Send Gmail emails for new Trello cards that are also in Google Sheets
- Create Gmail drafts for new or updated Google Sheets rows
- Add new Google Sheets rows for detailed CandidateZip parsed Gmail resume attachments
- Add rows in Google Sheets with new stared emails in Gmail
- Reply to emails with new Google Sheets rows in Gmail
- Get more info about senders of starred Gmail emails with Lead Score by Zapier and log it in Google Sheets
- Create and email new Veem contacts with Google Sheets and Gmail
- Create Gmail drafts from new Google Sheets rows
- Send Gmail emails for new Google Sheets
- 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 Gmail drafts from new Google Sheets rows
- 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
- Create multiple rows in Google Sheets for new Gmail labels
- Add new emails in Gmail to Google Sheets rows
- Add new Gmail emails matching searches 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
- Create drafts on Gmail for new rows on Google Sheets
- Track new survey responses and alert a team via email
- Send new Gmail emails from new or updated Google Sheets rows in Team Drive
- Extract data with Bitskout from new Gmail invoice attachments and generate Google Sheets rows
- 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
- Send email in Gmail with new 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
- 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
- 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
- Send Gmail emails with ScreenshotOne website screenshots from new or updated Google Sheets rows
- 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
- Update Google Sheets rows when new starred emails arrive in Gmail
- Create labels in Gmail for new spreadsheets in Google Sheets