Update SMARTSHEET using Power Automate

Shahara Anderson

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

Genevieve P.

Hi @Shahara Anderson

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

Shahara Anderson

@Genevieve P Thank you

Best,

Shahara

atif_hafeez

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

Genevieve P.

Hi @Shahara Anderson

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

Shahara Anderson

@Genevieve P Thank you

Best,

Shahara

atif_hafeez

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

Shahara Anderson

https://community.smartsheet.com/discussion/comment/322286#Comment_322286

Thank you @atif_hafeez ! It worked perfectly. Do you know how to get it to update the sheet without duplicating the data?

Thanks,

Shahara