Microsoft Excel + Microsoft Outlook

Create draft emails in Microsoft Outlook for new rows in a Microsoft Excel table

Keep your email drafts organized whenever you add new data to your Microsoft Excel table. With this workflow, each time a new row is added to your Excel table, a draft email will be created in Microsoft Outlook, allowing you to quickly review and send emails based on the latest information in your spreadsheet. Streamline your communication process and ensure you stay up-to-date with the latest data using this automation.

When this happens...
New Row in Table
Triggers when a new row is added to a table in a spreadsheet.
TriggerPolling
automatically do this!
Create Draft Email
Creates a draft of an email that can then be reviewed and sent out.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Calendar
- Time BeforeRequired
- Time Before (Unit)Required
Trigger
Polling
Try It

- Parent FolderRequired
- Child Folder
Trigger
Polling
Try It
- Contact Folder
Trigger
Polling
Try It
- Parent Folder
- Child Folder
- Search termsRequired
- Note
Trigger
Polling
Try It
- Shared Inbox
- Parent Folder
- Child Folder
Trigger
Polling
Try It
- Event
- Merge with existing attendees?
- Attendees
Action
Write
- Contact 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
Action
Write
- Email IDRequired
- To Email(s)
- CC Email(s)
- BCC Email(s)
- Reply-To Email
- Subject
- Body
- Attachment
- Action for Files Larger Than 150MB
- Reply to All
Action
Write
- Email IDRequired
- Comment
Action
Write
- 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
- Merge with existing attendees?
- Attendees
- Categories
- Location
Action
Write
- Api Docs Info
- Apply standard error handling?Required
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Additional Request Headers
- Body
Action
Write
- Contact Folder
- First Name
- Last Name
- Email
Action
Search
- Contact 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
Action
Search or write

- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write
Cancelled Calendar Event
Triggers when an event is cancelled.
Trigger
Instant
Try It
- Calendar
Trigger
Polling
Try It
- Shared Inbox
Trigger
Polling
Try It
New Flagged Email
Triggers when a new email is flagged.
Trigger
Polling
Try It
- Calendar
Trigger
Polling
Try It
- Calendar
- SubjectRequired
- Start Date & TimeRequired
- End Date & TimeRequired
- Location Name
- Sensitivity
- Attendees
- Is this an All Day Event?
- Description
- Show me as Free or Busy
- Is this an Online Meeting?
Action
Write
- To Email(s)Required
- CC Email(s)
- BCC Email(s)
- Reply-To Email
- SubjectRequired
- Body FormatRequired
- BodyRequired
- Attachment
- Action for Files Larger Than 150MB
Action
Write
- EventRequired
Action
Write
- 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
Action
Write
- 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
Action
Write
- Calendar
- Search TermRequired
- Start Date & Time
- End Date & Time
Action
Search
- Search Info
- Search ValueRequired
Action
Search

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more