Gmail + Google Sheets
Create drafts on Gmail for new rows on Google Sheets
If you're using a spreadsheet to track all those leads, set up this Google Sheets-Gmail integration to automate the outreach process. It will then trigger whenever you add a new row on Google Sheets, automatically preparing a new draft email for you on Gmail. From there you can make sure the dynamic content was added to your template as you needed, and hit send!
If you're using a spreadsheet to track all those leads, set up this Google Sheets-Gmail integration to automate the outreach process. It will then trigger whenever you add a new row on Google Sheets, automatically preparing a new draft email for you on Gmail. From there you can make sure the dynamic content was added to your template as you needed, and hit send!
- When this happens...
New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create DraftCreate (but do not send) a new 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.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
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 found
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 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.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 foundSubjectRequired
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 app
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
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsRelated 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
- 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
- Create Google Sheets rows and send emails in Gmail with new caught webhooks
- Add rows on Google Sheets when new Gmail threads start
- Extract key information from labeled emails and use ChatGPT to categorize important information and add to a Google Sheet
- Send a Gmail email and add a spreadsheet row to Google Sheets for new leads in Facebook Lead Ads
- Send Gmail emails for new Trello cards that are also in Google Sheets
- Add rows in Google Sheets with new stared emails in Gmail
- Store new incoming Gmail addresses in Google Sheets
- Share Google Sheets rows via Gmail messages
- Create a daily DALL-E image and send it via Gmail
- Extract data from new attachments in Gmail emails with Eden AI and add to Google Sheets rows
- Prepare draft emails for updated rows on Google Sheets
- Update Google Sheets rows with new Gmails matching a search
- Reformat new emails in Gmail before logging it in 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
- 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
- Create Gmail drafts for new or updated Google Sheets rows
- Extract data from new labeled Gmail attachments with Knowstory and export to Google Sheets
- Add Google Sheets rows for new CandidateZip-parsed resume attachments in Gmail
- Reply to emails in Gmail for new or updated Google Sheets rows
- Analyze incoming emails with Chatbase and add to Google Sheets
- Create Gmail drafts for new or updated rows in a Google Sheet (team Drive)
- Extract data with Bitskout from new Gmail invoice attachments and generate Google Sheets rows
- 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
- 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)
- 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
- 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 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
- 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
- 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 emails in Gmail to Google Sheets rows
- Send Gmail emails for new Google Sheet spreadsheet rows
- Add rows on Google Sheets when new Gmail threads start
- Send Gmail emails for new Trello cards that are also in Google Sheets
- Share Google Sheets rows via Gmail messages
- Prepare draft emails for updated rows on Google Sheets
- Track new survey responses and alert a team via email
- Get more info about senders of starred Gmail emails with Lead Score by Zapier and log it in Google Sheets
- Add Google Sheets rows for new CandidateZip-parsed resume attachments in Gmail
- Create Gmail drafts for new or updated rows in a Google Sheet (team Drive)
- 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 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
- 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 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
- 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
- Extract key information from labeled emails and use ChatGPT to categorize important information and add to a Google Sheet
- Add rows in Google Sheets with new stared emails in Gmail
- Create a daily DALL-E image and send it via Gmail
- Update Google Sheets rows with new Gmails matching a search
- Send new Gmail emails from new or updated Google Sheets rows in Team Drive
- Create Gmail drafts for new or updated Google Sheets rows
- Reply to emails in Gmail for new or updated Google Sheets rows
- Extract data with Bitskout from new Gmail invoice attachments and generate Google Sheets rows
- 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
- 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
- Reply to emails with new Google Sheets rows in Gmail
- 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
- 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
- Add new labeled Gmail emails to rows in Google Sheets
- 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
- Send a Gmail email and add a spreadsheet row to Google Sheets for new leads in Facebook Lead Ads
- Store new incoming Gmail addresses in Google Sheets
- Extract data from new attachments in Gmail emails with Eden AI and add to Google Sheets rows
- Reformat new emails in Gmail before logging it in Google Sheets
- Add new Google Sheets rows for detailed CandidateZip parsed Gmail resume attachments
- Extract data from new labeled Gmail attachments with Knowstory and export to Google Sheets
- Analyze incoming emails with Chatbase and add to 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
- Translate new emails matching Gmail searches with Langzy Translate and add them to Google Sheets
- Send Gmail emails for new Google Sheet worksheets
- 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 with Bitskout from new attachments in Gmail and add to Google Sheets rows
- Post new sms messages to Slack private channels
- 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
- 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