Microsoft Excel + Microsoft Office 365

Create draft emails in Microsoft Office 365 for new rows in Microsoft Excel

Streamline the process of drafting emails based on new data in Microsoft Excel. This workflow springs into action whenever a new row appears in your spreadsheet, generating a draft email in Microsoft Office 365. It's a smart way to ensure key data changes don't slip through the cracks but get acknowledged in a timely manner. No more digging through rows or missing critical information, leave the manual checkups behind and let this automation handle it for you.

When this happens...
New Row
Triggers when a new row is added to a worksheet 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
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Column IndexRequired
- Apply To
- Header Preservation
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write
- Shared Inbox
- 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
- Parent Folder
- Child Folder
Trigger
Polling
Try It
- EventRequired
- Merge with existing attendees?
- AttendeesRequired
Action
Write
- Distribution ListRequired
- User EmailRequired
Action
Write
- Calendar
- SubjectRequired
- Start Date & TimeRequired
- End Date & TimeRequired
- All Day Event?
- Description
- Show me as Free or Busy
- Attendees
- Categories
- Location
Action
Write
- To Email(s)Required
- CC Email(s)
- BCC Email(s)
- SubjectRequired
- Body FormatRequired
- BodyRequired
- Attachment
- Action for Files Larger Than 150MB
Action
Write
- Shared Mailbox
- Folder NameRequired
- Parent Folder
Action
Write
- Shared Mailbox
- Email IDRequired
Action
Write
- Shared Mailbox
- Email IDRequired
- Flag ActionRequired
Action
Write
- Email IDRequired
- Mark asRequired
- Mailbox
Action
Write
- Shared Mailbox
- Categories to RemoveRequired
- Email IDRequired
Action
Write
- Draft Email IDRequired
- Send From
Action
Write
- Shared Mailbox
- Email IDRequired
- ImportanceRequired
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
- Contact Folder
- First Name
- Last Name
- Email
Action
Search
- Folder Info
- FolderRequired
- Search terms
- From address
- Start date
- End date
Action
Search
- Calendar
- Start date and timeRequired
- End date and timeRequired
Action
Search

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- New NameRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- No Match Copy
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write
- Calendar
- Time BeforeRequired
- Time Before (Unit)Required
Trigger
Polling
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
- Email IDRequired
- CategoriesRequired
- Mark as Read
Action
Write
- Shared Mailbox
- Email IDRequired
- Destination FolderRequired
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
- Contact to DeleteRequired
Action
Write
- EventRequired
Action
Write
- Email IDRequired
- To Email(s)Required
- Comment
Action
Write
- Email IDRequired
- Destination FolderRequired
Action
Write
- Email IDRequired
- Comment
Action
Write
- From Email
- To Email(s)Required
- CC Email(s)
- BCC Email(s)
- SubjectRequired
- Body FormatRequired
- BodyRequired
- Attachments
- Action for Files Larger Than 150MB
Action
Write
- EventRequired
- 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
- Calendar
- Search TermRequired
- Start Date & Time
- End Date & Time
Action
Search
- Search Info
- Search valueRequired
Action
Search
- Shared Mailbox
- Email IDRequired
- Attachment IDRequired
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

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

Related categories

Similar apps

About Microsoft Office 365

Microsoft Office 365 Business is a complete office suite in the cloud. It provides all the standard office products like Excel, Outlook, Word, SharePoint and more, but available from any internet enabled computer! Zapier does not currently support Outlook.com addresses or Home 365 accounts, only business or Enterprise.

Learn more

Microsoft Excel + Microsoft Office 365

Create draft emails in Microsoft Office 365 for new rows in Microsoft Excel

New Row

New Worksheet

Add Row

Add Row to Table

Clear Column by Index

Create Workbook

Delete Worksheet

Update Row

Find Row

Get Cells in Range

Get Worksheet by ID

Find or Create Worksheet

New Attachment

New Contact

New Email Matching Search

New Message in Folder

Add Attendees to Calendar Event

Add User to Distribution List

Create Event

Create Draft Email

Create Folder

Delete Email

Flag / Unflag Email

Mark Email as Read/Unread

Remove Category From Email

Send Draft Email

Set Email Importance

Update Contact

Find a Contact

Find Emails in Specific Folder

Get Calendar Events in Date Range

New Row in Table

Updated Row

Add Row(s)

Clear Cells by Range

Clear Row by ID

Create Worksheet

Rename Worksheet

API Request (Beta)

Find Worksheet(s)

Get Row by ID

Find or Create Row

Calendar Event Start

New Calendar Event

New Email

New Flagged Email

Updated Calendar Event

Set Categories on an Email

Copy Email

Create Contact

Create Draft Reply

Delete Contact

Delete Event

Forward Email

Move Email to Folder

Reply to Email

Send Email

Update Calendar Event

Find Calendar Event

Find Emails

Get Attachment by ID

Find or Create Contact

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

About Microsoft Office 365

Related categories

Similar apps

Email by Zapier

Google Docs

Gmail

Related Zap Templates

Related Zap Templates