Using Microsoft Flow to update an excel sheet when a Smartsheet is updated

edited 12/09/19 in Smartsheet Basics

I have been searching and trying out with Microsoft Flow to update an excel sheet in SharePoint, when triggered by "When a sheet is updated - Smartsheet".

However, no matter how I try, I am not able to get the specific row data values. I could only retrieve information of that sheet, for example modified date or name of sheet. 

Is there any way I can access the data in the smartsheet using Microsoft flow?

I tried using Power Query to update the excel, however, it seems like sharepoint does not allow external connection to files outside of sharepoint.