Connect Microsoft Office 365 and Smartsheet to unlock the power of automation
- No credit card required
- Free forever for core features
- 14-day trial for premium features and apps
Set up your first integration
Quickly connect Microsoft Office 365 to Smartsheet with a Zapier template.
Our most popular template
How Zapier works
Zapier makes it easy to integrate Microsoft Office 365 with Smartsheet - no code necessary. See how you can get setup in minutes.
Choose a trigger
A trigger is the event that starts your Zap—like a "Calendar Event Start" from Microsoft Office 365.
Add your action
An action happens after the trigger—such as "Create Workspace" in Smartsheet.
You’re connected!
Zapier seamlessly connects Microsoft Office 365 and Smartsheet, automating your workflow.
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
- Calendar
- Time BeforeRequired
- Time Before (Unit)Required
Try ItTriggerPolling- Calendar
Try ItTriggerPolling- Shared Inbox
Try ItTriggerPolling- New Flagged Email
Triggers when a new email is flagged.
Try ItTriggerPolling
- Parent FolderRequired
- Child Folder
Try ItTriggerPolling- Contact Folder
Try ItTriggerPolling- Parent Folder
- Child Folder
- Search termsRequired
- Note
Try ItTriggerPolling- Parent Folder
- Child Folder
Try ItTriggerPolling
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Connect Microsoft Office 365 and Smartsheet to integrate crucial parts of your business
With Zapier, you can integrate everything from basic data entry to end-to-end processes. Here are some of the business-critical workflows that people automate with Zapier.
Automate your lead management and improve conversions
Create more impactful campaigns with automation
Provide world-class support with a little help from automation
Automate your way to actionable, up-to-date data
Resolve incidents faster with automation
Learn how to automate Microsoft Office 365 on the Zapier blog
Learn how to automate Smartsheet on the Zapier blog
Frequently Asked Questions about Microsoft Office 365 + Smartsheet integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Microsoft Office 365 and Smartsheet
What are the available triggers when integrating Microsoft Office 365 with Smartsheet?
When integrating Microsoft Office 365 with Smartsheet, the available triggers include actions such as emails received in Outlook or calendar events created in your Office 365 account. These triggers can initiate processes such as creating new rows or updating existing ones in Smartsheet.
Can Smartsheet be set to automatically update from changes in Microsoft Office 365?
Yes, our integration allows automatic updates in Smartsheet based on specific triggers within Microsoft Office 365, such as modifications in Excel files or updates to SharePoint lists.
Is it possible to create a two-way sync between Microsoft Office 365 and Smartsheet?
Currently, only one-way synchronization is supported. This means you can set up triggers in Microsoft Office 365 that result in actions within Smartsheet, but not vice versa.
How do actions work when integrating with Smartsheet?
Actions define the tasks executed within Smartsheet once a trigger from Office 365 is detected. Examples include adding rows to a sheet, updating cell data, and creating new sheets based on pre-set templates.
Is there support for conditional workflows between these two platforms?
Yes, we offer support for creating conditional workflows where specific conditions must be met within a trigger from Microsoft Office 365 before an action is executed in Smartsheet.
Are there any limitations to the data that can be transferred from Office 365 to Smartsheet?
While most data types like text and numbers can be transferred seamlessly, there may be limitations regarding complex data structures or unsupported file types that cannot directly integrate into Smartsheet.
Can I integrate multiple accounts of Office 365 with a single Smartsheet account?
Integration of multiple Microsoft Office 365 accounts with one Smartsheet account is supported. Each connection will need its own configuration to manage differing triggers and actions appropriately.
