I am trying to connect a Power Queried excel table to a Google sheet for Data Studio. I know if I need too I can use sheetgo but I want to save my organization money since we are a nonprofit and use Power Automate since they already purchased it for me. Any suggestion?
Hey, I know this is an aged post at this point, but if you’re able to get the Excel table saved to a standard file location as a csv, I can get you a PowerShell script to upload it to a Google Drive folder and then a Google Apps Script to import the file - overwriting the existing content (so that your data studio references remain intact). PowerShell can be set to run at a certain time with Windows Task Scheduler and Google Apps Script can be set to run at a certain time as well with the triggers setting.
All of it kind of hinges on the data being CSV and in a stable location each day at the designated time.