Hello -
I am a benefits consultant who uses a synced Google Drive on my Windows Explorer. I have a client that uploads Google Sheets to the folder, which I then save as Excel Spreadsheets.
I have a Master Template Excel Spreadsheet that has Power Query to perform data cleanup and functions / formulas that I then send to the client.
I would like to use Power Automate to do the following:
- Automate saving Google Sheets to Excel files with the same name.
- Active / Start Power Query on the Master Template file & save.
- Send me either a Text message or email once all above has been completed.
I have both Power Automate Desktop and Power Automate app; however, I am still new to Power Automate and I am trying to digest all information available.
Thank-you for your help!!
Warren Anderson

Report
All responses (
Answers (