Pull data from Excel into a blank sheet
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
Best Answer
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives