Connect Excel file from OneDrive or Sharepoint to Smartsheet

lschek1
lschek1 ✭✭
edited 06/14/22 in Add Ons and Integrations

Hello, I would like to know if there is a way to automatically copy the data from an excel file located at a specific folder in OneDrive or Sharepoint to Smartsheet.

I have tried to use Power Automate and Zapier with no luck. The specific issues I have encountered is that in Power Automate, I can only bring metadata from the Excel files but not the content or data itself within Excel. In Zapier (OneDrive to Smartsheet), something similar happens. All the 'Actions' available in both softwares do not appear to copy this data.

I'm a beginner in these integrations and I would like to execute this query everytime a new file has been created.

Thanks and best regards!

Best Answer

Answers