Pull data from Excel into a blank sheet

Tom220599 · 05/26/21

Hi everyone,

I am trying to pull data from an Excel document into a blank canvas smartsheet. I have tried using power automate to do this however i cant see any triggers/actions that would give me the ability to do this. is this achievable through power automate. i have seen that alot of people use that application Zappier for alot of automation. As abit of a side question is this a better application than Power automate when it comes to intergration with smartsheet?.

Kind regards,

Tom

Genevieve P. · 05/27/21

Hi @Tom220599

The choice between Power Automate and Zapier will depend on the type of automations/actions you're looking to do and what apps you're looking to connect.

Based on the Power Automate templates that relate to Smartsheet, it looks like these workflows are built to pull information out of Smartsheet versus put information into Smartsheet. (See: Power Automate and Smartsheet actions.)

If you have an excel document that you're looking to connect with a Smartsheet sheet, have you looked into Data Shuttle? (See: About Data Shuttle & Data Shuttle introduction.)

Cheers,

Genevieve

Genevieve P. · 05/27/21