Google Sheets + Microsoft Outlook
Create draft emails in Microsoft Outlook for new or updated rows in Google Sheets
Keep your email drafts organized by effortlessly maintaining updated Google Sheets entries with this efficient automation. With each new or updated row in your Google Sheets, this workflow instantly creates a draft email in Microsoft Outlook, ensuring you consistently have the right information on hand when it's time to send out emails. Streamline your correspondence process and save time with this seamless integration.
Keep your email drafts organized by effortlessly maintaining updated Google Sheets entries with this efficient automation. With each new or updated row in your Google Sheets, this workflow instantly creates a draft email in Microsoft Outlook, ensuring you consistently have the right information on hand when it's time to send out emails. Streamline your correspondence process and save time with this seamless integration.
- When this happens...
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - 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
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
Cancelled Calendar Event
Triggers when an event is cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.From Email
To Email(s)Required
CC Email(s)
BCC Email(s)
Reply-To Email
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 Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
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
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
Headers
Overwrite existing worksheets
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 planParent 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
Location Name
Sensitivity
Attendees
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)
Reply-To Email
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.Email IDRequired
Comment
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.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
About Microsoft Outlook
Microsoft Outlook is a web-based suite of webmail, contacts, tasks, and calendaring services.
Similar apps
Related 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
- Create draft emails in Microsoft Outlook from Google Sheets rows
- Parse resumes from Outlook attachments using CandidateZip and store the info in Google Sheets
- 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
- Create draft emails in Microsoft Outlook for new spreadsheet 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
- Create multiple rows in Google Sheets for new emails matching search in Microsoft Outlook
- Find emails with EmailListVerify and send Microsoft Outlook emails for new Google Sheets rows
- Update Google Sheets rows each time new contacts are created in Microsoft Outlook
- Update Google Sheets rows with new matching emails from Microsoft Outlook
- Update Google Sheets rows with new Microsoft Outlook emails
- Create new Microsoft Outlook events from new Google Sheets rows
- Create Microsoft Outlook events from new or updated Google Sheets rows
- Create draft emails in Microsoft Outlook from new spreadsheets in Google Sheets
- Create Google Sheets rows for new Microsoft Outlook calendar events
- Create Google Sheets entries for new Microsoft Outlook emails matching a specific search
- Update Microsoft Outlook events when new rows are added in Google Sheets
- Create HubSpot contacts when new customers are added in Sharpei
- Create draft emails in Microsoft Outlook from new worksheets in Google Sheets
- Create spreadsheet rows in Google Sheets for new emails matching search in Microsoft Outlook
- Create events in Microsoft Outlook from new spreadsheets in Google Sheets
- Create new Google Sheets worksheets for each new Microsoft Outlook email
- Copy new Microsoft Outlook emails to Google Sheets worksheets
Related Zap Templates
- Send Microsoft Outlook emails with newly-updated rows in Google Sheets
- Create Microsoft Outlook events from new Google Sheets rows
- 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 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
- Find emails with EmailListVerify and send Microsoft Outlook emails for new Google Sheets rows
- Update Google Sheets rows with new Microsoft Outlook emails
- Create draft emails in Microsoft Outlook from new spreadsheets in Google Sheets
- Update Microsoft Outlook events when new rows are added in Google Sheets
- Create spreadsheet rows in Google Sheets for new emails matching search in Microsoft Outlook
- Copy new Microsoft Outlook emails to Google Sheets worksheets
- Add rows to Google Sheets with new Microsoft Outlook emails
- Create Google Sheets rows for new Microsoft Outlook calendar events
- Send Microsoft Outlook emails for new or updated spreadsheet rows 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
- Update Google Sheets rows each time new contacts are created in Microsoft Outlook
- Create new Microsoft Outlook events from new Google Sheets rows
- Create Google Sheets rows for new Microsoft Outlook calendar events
- Create HubSpot contacts when new customers are added in Sharpei
- Create events in Microsoft Outlook from new spreadsheets in Google Sheets
- Send Microsoft Outlook emails from new rows in Google Sheets
- Create draft emails in Microsoft Outlook from Google Sheets rows
- Verify emails from new Google Sheets rows with QuickEmailVerification and send Microsoft Outlook emails
- 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
- Create multiple rows in Google Sheets for new emails matching search in Microsoft Outlook
- Update Google Sheets rows with new matching emails from Microsoft Outlook
- Create Microsoft Outlook events from new or updated Google Sheets rows
- Create Google Sheets entries for new Microsoft Outlook emails matching a specific search
- Create draft emails in Microsoft Outlook from new worksheets in Google Sheets
- Create new Google Sheets worksheets for each new Microsoft Outlook email