Update SMARTSHEET using Power Automate
Hello,
I have an updated Excel file, and I would like to transfer new rows of data using Power Automate. I see the ability to go from SMARTSHEET to Excel, is there a way to go from Excel to SMARTSHEET?
Thanks,
Shahara
Best Answers
-
Based on Microsoft's list of automations using Smartsheet (here), no, it doesn't look like there's an integration that flows from Excel to Smartsheet using Power Automate.
You may want to look into Smartsheet's Data Shuttle (see here) to sync content from Excel.
Cheers!
Genevieve
-
-
There aren't any templates available but you could build a flow yourself to solve your problem.
Smartsheet connector allows you to insert rows into a sheet.
Here is a video that shows you how to import data from excel to SharePoint.
https://www.youtube.com/watch?v=F2leKcMPAtw
Just replace the SharePoint Create Item action with Smartsheet's Insert Row action
Answers
-
Based on Microsoft's list of automations using Smartsheet (here), no, it doesn't look like there's an integration that flows from Excel to Smartsheet using Power Automate.
You may want to look into Smartsheet's Data Shuttle (see here) to sync content from Excel.
Cheers!
Genevieve
-
-
There aren't any templates available but you could build a flow yourself to solve your problem.
Smartsheet connector allows you to insert rows into a sheet.
Here is a video that shows you how to import data from excel to SharePoint.
https://www.youtube.com/watch?v=F2leKcMPAtw
Just replace the SharePoint Create Item action with Smartsheet's Insert Row action
-
Thank you @atif_hafeez ! It worked perfectly. Do you know how to get it to update the sheet without duplicating the data?
Thanks,
Shahara
-
I have the same question- did you figure out how to update the sheet without duplicating data? @Shahara Anderson
