MS Project & Smartsheet

Jeremy Ng

Hi everyone,

I'm looking for advice on setting up an automatic sync between MS Project and Smartsheet. Specifically, I want to create a schedule in MS Project and have it automatically populate a Smartsheet spreadsheet when published.

Has anyone successfully implemented this kind of integration? If so, could you share your approach and any tools or methods you used? I'm particularly interested in any solutions involving Power Automate or other automation tools.

Thanks in advance for your help!

Isaac A.

Hi @Jeremy Ng!

I haven’t personally set up this type of integration, but I’ve seen multiple cases where DataShuttle is used for syncing MS Project data with Smartsheet. You might find this related thread helpful: MS Project Import Question. You can also check out this help article about DataShuttle to get started.

Regarding Power Automate, have you checked out Microsoft's official documentation for connecting Smartsheet? Additionally, these discussions might be useful:

• Power Automate & Smartsheet
• How do I use Smartsheet connector in Power Apps?

You can also explore the Smartsheet Power Automate integration page. If you’d like more details on using the integration, you can also reach out to your Customer Success Manager or Sales team here.

Hope this helps!

Cheers,
Isaac.