Google Sheets + Microsoft Outlook
Create draft emails in Microsoft Outlook from Google Sheets rows
Simplify your email drafting process by setting up this workflow to generate draft emails in Microsoft Outlook directly from new rows in your Google Sheets. Whenever you add a new row containing email content, this automation will instantly create a new draft email in Outlook, saving you time and effort when managing your emails.
Simplify your email drafting process by setting up this workflow to generate draft emails in Microsoft Outlook directly from new rows in your Google Sheets. Whenever you add a new row containing email content, this automation will instantly create a new draft email in Outlook, saving you time and effort when managing your emails.
- When this happens...
New Spreadsheet Row (Team Drive)Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Draft EmailCreates a draft of an email that can then be reviewed and sent out.
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 foundParent FolderRequired
Child Folder
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planParent Folder
Child Folder
Search termsRequired
Note
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCalendar
SubjectRequired
Start Date & TimeRequired
End Date & TimeRequired
All Day Event?
Description
Show me as Free or Busy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To Email(s)Required
CC Email(s)
BCC Email(s)
SubjectRequired
Body FormatRequired
BodyRequired
Attachment
Action for Files Larger Than 150MB
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.From Email
To Email(s)Required
CC Email(s)
BCC Email(s)
SubjectRequired
Body FormatRequired
BodyRequired
Attachments
Action for Files Larger Than 150MB
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact Folder
ContactRequired
First Name
Last Name
Email Addresses
Business Phones
Home Phones
Mobile Phone
Job Title
Company Name
Department
Business Website URL
Personal Notes
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Calendar
Search TermRequired
Start Date & Time
End Date & Time
ActionThis is an event a Zap performs.SearchFind existing data in your appContact Folder
First NameRequired
Last Name
Email
Business Phones
Home Phones
Mobile Phone
Job Title
Company Name
Department
Business Website URL
File As
Personal Notes
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
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 foundCalendar
Time BeforeRequired
Time Before (Unit)Required
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New Flagged Email
Triggers when a new email is flagged.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planContact Folder
First NameRequired
Last Name
Email Addresses
Business Phones
Home Phones
Mobile Phone
Job Title
Company Name
Department
Business Website URL
File As
Personal Notes
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EventRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event
Subject
Start Date & Time
End Date & Time
All Day Event?
Is Online Meeting?
Hide attendees list?
Description
Show me as Free or Busy
The importance of the event
Attendees
Categories
Location
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.Contact Folder
First Name
Last Name
Email
ActionThis is an event a Zap performs.SearchFind existing data in your app
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
SpreadsheetsAbout Microsoft Outlook
Microsoft Outlook is a web-based suite of webmail, contacts, tasks, and calendaring services.
Similar apps
Gmail
Email, Google
Zoho Mail
Email, ZohoRelated Zap Templates
- Send Microsoft Outlook emails with newly-updated rows in Google Sheets
- Add rows to Google Sheets with new Microsoft Outlook emails
- Send Microsoft Outlook emails from new rows in Google Sheets
- Create Microsoft Outlook events from new Google Sheets rows
- Create Google Sheets rows for new Microsoft Outlook calendar events
- Send Microsoft Outlook emails for new or updated spreadsheet rows in Google Sheets
- Verify emails from new Google Sheets rows with QuickEmailVerification and send Microsoft Outlook emails
- Parse resumes from Outlook attachments using CandidateZip and store the info in Google Sheets
- Create draft emails in Microsoft Outlook for new spreadsheet rows in Google Sheets
- Create draft emails in Microsoft Outlook for new or updated rows in Google Sheets
- Create Microsoft Outlook events for new or updated Google Sheets rows
- Create multiple Google Sheets rows from new Microsoft Outlook emails for seamless organization
- Create emails in Microsoft Outlook from new spreadsheet rows in Google Sheets team drive
- Create Microsoft Outlook contacts from new Google Sheets rows
- Add new Microsoft Outlook events to Google Sheets as rows
- Create Microsoft Outlook contacts from new or updated Google Sheets rows
- Create multiple Google Sheets rows for new Microsoft Outlook calendar events
- Update Google Sheets rows with new Microsoft Outlook calendar events
- Update Google Sheets rows when new Microsoft Outlook calendar events start
- Create Microsoft Outlook events from new or updated Google Sheets spreadsheet rows in team drive
- Add new Microsoft Outlook contacts to Google Sheets as rows
- Create Microsoft Outlook events from new or updated Google Sheets spreadsheet rows in team drive
- Update Microsoft Outlook contacts from new or updated Google Sheets rows
- Update Google Sheets rows with new Microsoft Outlook emails
- Create spreadsheets in Google Sheets from new emails in Microsoft Outlook
- Create spreadsheet columns in Google Sheets for new emails in Microsoft Outlook
- Create multiple rows in Google Sheets for new contacts in Microsoft Outlook
- Send emails in Microsoft Outlook when new or updated rows appear in Google Sheets (team drive)
- Start new Google Sheets spreadsheets when Microsoft Outlook calendar events begin
- Update Google Sheets with multiple rows for every updated event in Microsoft Outlook
- Create Google Sheets columns for new Microsoft Outlook contacts
- Create Google Sheets spreadsheets for new Microsoft Outlook calendar events
- Create Google Sheets rows for updated Microsoft Outlook calendar events
- Create new Microsoft Outlook emails when new Google Sheets worksheets are added
- Update Microsoft Outlook events when new rows are added in Google Sheets
- Update Microsoft Outlook contacts with new or updated rows in Google Sheets team drive
- Create spreadsheet rows in Google Sheets for new messages in Microsoft Outlook folders
- Create multiple rows in Google Sheets for new messages in Microsoft Outlook folders
- Update Google Sheets rows with new Microsoft Outlook folder messages
- Create rows in Google Sheets for new flagged emails in Microsoft Outlook
- Create spreadsheet rows in Google Sheets for new emails matching search in Microsoft Outlook
- Update Google Sheets rows with updated Microsoft Outlook calendar events
- Create custom actions in Microsoft Outlook for each new row in Google Sheets
- Create new Google Sheets spreadsheets for matching emails found in Microsoft Outlook
- Manage new Microsoft Outlook attachments by creating custom actions in Google Sheets
- Create Google Sheets spreadsheets from new Microsoft Outlook attachments
- Organize new Microsoft Outlook messages in a folder into Google Sheets spreadsheets
- Create Microsoft Outlook contacts from new or updated rows in Google Sheets team drive
- Create multiple spreadsheet rows in Google Sheets for new flagged emails in Microsoft Outlook
- Update Google Sheets rows with new Microsoft Outlook emails matching search criteria
Related Zap Templates
- Send Microsoft Outlook emails with newly-updated rows in Google Sheets
- Create Microsoft Outlook events from new Google Sheets rows
- Verify emails from new Google Sheets rows with QuickEmailVerification and send Microsoft Outlook emails
- Create draft emails in Microsoft Outlook for new or updated rows in Google Sheets
- Create emails in Microsoft Outlook from new spreadsheet rows in Google Sheets team drive
- Create Microsoft Outlook contacts from new or updated Google Sheets rows
- Update Google Sheets rows when new Microsoft Outlook calendar events start
- Create Microsoft Outlook events from new or updated Google Sheets spreadsheet rows in team drive
- Create spreadsheets in Google Sheets from new emails in Microsoft Outlook
- Send emails in Microsoft Outlook when new or updated rows appear in Google Sheets (team drive)
- Create Google Sheets columns for new Microsoft Outlook contacts
- Create new Microsoft Outlook emails when new Google Sheets worksheets are added
- Create spreadsheet rows in Google Sheets for new messages in Microsoft Outlook folders
- Create rows in Google Sheets for new flagged emails in Microsoft Outlook
- Create custom actions in Microsoft Outlook for each new row in Google Sheets
- Create Google Sheets spreadsheets from new Microsoft Outlook attachments
- Create multiple spreadsheet rows in Google Sheets for new flagged emails in Microsoft Outlook
- Add rows to Google Sheets with new Microsoft Outlook emails
- Create Google Sheets rows for new Microsoft Outlook calendar events
- Parse resumes from Outlook attachments using CandidateZip and store the info in Google Sheets
- Create Microsoft Outlook events for new or updated Google Sheets rows
- Create Microsoft Outlook contacts from new Google Sheets rows
- Create multiple Google Sheets rows for new Microsoft Outlook calendar events
- Create Microsoft Outlook events from new or updated Google Sheets spreadsheet rows in team drive
- Update Microsoft Outlook contacts from new or updated Google Sheets rows
- Create spreadsheet columns in Google Sheets for new emails in Microsoft Outlook
- Start new Google Sheets spreadsheets when Microsoft Outlook calendar events begin
- Create Google Sheets spreadsheets for new Microsoft Outlook calendar events
- Update Microsoft Outlook events when new rows are added in Google Sheets
- Create multiple rows in Google Sheets for new messages in Microsoft Outlook folders
- Create spreadsheet rows in Google Sheets for new emails matching search in Microsoft Outlook
- Create new Google Sheets spreadsheets for matching emails found in Microsoft Outlook
- Organize new Microsoft Outlook messages in a folder into Google Sheets spreadsheets
- Update Google Sheets rows with new Microsoft Outlook emails matching search criteria
- Send Microsoft Outlook emails from new rows in Google Sheets
- Send Microsoft Outlook emails for new or updated spreadsheet rows in Google Sheets
- Create draft emails in Microsoft Outlook for new spreadsheet rows in Google Sheets
- Create multiple Google Sheets rows from new Microsoft Outlook emails for seamless organization
- Add new Microsoft Outlook events to Google Sheets as rows
- Update Google Sheets rows with new Microsoft Outlook calendar events
- Add new Microsoft Outlook contacts to Google Sheets as rows
- Update Google Sheets rows with new Microsoft Outlook emails
- Create multiple rows in Google Sheets for new contacts in Microsoft Outlook
- Update Google Sheets with multiple rows for every updated event in Microsoft Outlook
- Create Google Sheets rows for updated Microsoft Outlook calendar events
- Update Microsoft Outlook contacts with new or updated rows in Google Sheets team drive
- Update Google Sheets rows with new Microsoft Outlook folder messages
- Update Google Sheets rows with updated Microsoft Outlook calendar events
- Manage new Microsoft Outlook attachments by creating custom actions in Google Sheets
- Create Microsoft Outlook contacts from new or updated rows in Google Sheets team drive