Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works
Zapier makes it easy to integrate Microsoft SharePoint with Smartsheet - no code necessary. See how you can get setup in minutes.
100%
Help
Microsoft SharePoint
Microsoft SharePoint
1. Choose trigger event
Smartsheet
Smartsheet
2. Choose action
1. Select the event
Setup
Test
Microsoft SharePoint
Choose a trigger event
Choose a trigger
A trigger is the event that starts your Zap—like a "New File in Folder" from Microsoft SharePoint.
Add your action
An action happens after the trigger—such as "Create Workspace" in Smartsheet.
You’re connected!
Zapier seamlessly connects Microsoft SharePoint 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.
Create a new record or update an existing record in your app.
Choose a Sheet
Required
Row
Required
Title
Required
Comment
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Source Workspace
Source Folder
Required
Destination Workspace
Destination Folder
Required
New Folder Name
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Workspace
Required
New Name
Required
What to Include?
Skip Remap
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Choose Source Sheet
Required
Choose a Destination Sheet
Required
Choose Row
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Destination
Required
Template
Required
Copy Cells?
Required
Copy Attachments?
Required
Copy Discussions?
Required
Sheet Name
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Choose a Sheet
Required
Email Address(es)
Required
Choose Row
Required
Email Subject
Message
CC Me?
Include Attachments ?
Include Discussions ?
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Choose a Sheet
Required
Email Address(es) to Share To
Required
Access Level
Required
Notify via Email?
Required
Email Subject
Message
CC Me?
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Api_docs_info
Stop on error
Required
HTTP Method
Required
URL
Required
Query string parameters
Additional request headers
Body
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Sheet ID
Required
Row ID
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
For AI agents & developers
Use Microsoft SharePoint and Smartsheet with AI agents and code
Beyond Zap workflows. Call Microsoft SharePoint and Smartsheet actions directly from your AI client or your codebase, using the same 9,000+ app integrations Zapier already runs.
No code
Connect via Zapier MCP
Expose Microsoft SharePoint and Smartsheet actions as tools in any MCP client. Authenticate once, then call them in natural language.
Example actions on this page
Copy File or Folder
Create Workspace
Works with
Claude · ChatGPT · Cursor · any MCP-compatible client
There is no Python package yet. SDK is TypeScript-only (@zapier/zapier-sdk). The MCP server URL is personal to your account; get it at zapier.com/mcp.
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
Practical ways you can use Microsoft SharePoint and Smartsheet
Monitor new leads or opportunities.
When a new list item is added in Microsoft SharePoint, Zapier will create a new row in Smartsheet. This helps business owners track leads, opportunities, or any other key data in real-time without manual entry, ensuring better organization and faster decision-making.
When a new list is created in Microsoft SharePoint, Zapier will automatically create a new row in a Smartsheet sheet. This allows engineers to seamlessly track new project resources or tasks, streamlining collaboration and ensuring no critical details are overlooked.
When a file is uploaded or updated in Microsoft SharePoint, Zapier will automatically add a new row or update an existing row in a Smartsheet project sheet. This ensures that team members always have up-to-date information about the latest changes, reducing errors and delays in communication.
Learn how to automate Smartsheet on the Zapier blog
Make work flow with AI
Level up your Microsoft SharePoint to Smartsheet integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.
Frequently Asked Questions about Microsoft SharePoint + Smartsheet integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Microsoft SharePoint and Smartsheet
How can I start a workflow in Smartsheet when a new file is added in SharePoint?
We support triggers that listen for new files in SharePoint. You can set up a trigger so that every time a new file is added to your SharePoint folder, an action is initiated to start a defined workflow in Smartsheet.
Can I update a SharePoint list when a row is modified in Smartsheet?
Yes, our integration allows you to set up an action to update items in a SharePoint list whenever a row is modified in Smartsheet. This ensures your data remains consistent across both platforms.
Is it possible to create documents in SharePoint from new rows added in Smartsheet?
Absolutely. By using our integration, you can automate the creation of documents or files within SharePoint whenever new rows are added to your Smartsheet, making data transfer seamless.
How do I handle permissions for actions taken via the integration?
Permissions are managed according to the respective platform's security settings. Ensure that both your Smartsheet and SharePoint accounts have the necessary permissions for creating or updating items as required by your specific automated actions.
Can alerts be sent out if an error occurs during the automation between Microsoft SharePoint and Smartsheet?
Yes, alerts can be configured so that notifications are sent out whenever there's an error within the automation process, providing transparency and immediate awareness for troubleshooting purposes.
Do changes made via the integration show up real-time?
While some updates may appear almost instantaneously, there might occasionally be slight delays due to server communication times between Microsoft SharePoint and Smartsheet. We strive for near real-time updates wherever technically feasible.
What happens if my credentials expire for one of the integrations?
If credentials expire or get revoked, automated tasks will not perform successfully until reauthorization is complete. It's crucial to maintain active credentials to prevent disruptions in your automations.
About Microsoft SharePoint
Microsoft SharePoint is a service that helps organizations share content to quickly find information and seamlessly collaborate.
Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.
