Conversion of Google App Sheet to Microsoft PowerAutomate

---

---

Hello, I have some automations set up to collect data via Google Apps Script and I'd like to transfer these automations to Microsoft Power Automate. I've got several restaurants that fill out daily reports and payroll reports. Currently, within Google, they fill out a Google Sheet after they have input the correct data, and they hit a "submit" button that copies the data to a google drive folder, and resets the sheet for its next use. There are 2 reports I want to automate. The first being a daily report that's filled out EOD every day. It is a sheest file. It includes manager notes, sales, the cash deposit etc. After the submit button is hit, the google script complies each locations data in a Drive folder and goes into one google sheet with separate tabs for each location for that one day. Then once that data has been aggregated to one sheet, a email is sent the next morning with a link to the sheet for the owners to have a birds eye view of what's going on in the company each day. The second report is a payroll report that is filled out every 2 weeks. There are multiple tabs of data on this sheet. When the report is submitted, it goes to a Drive folder named "Payroll Period 'date' to 'date'" and is titled "Payroll Period 'date' to 'date' 'store name' 'store number'". Then the CFO goes to said folder to find the data for that pay period. I've got myself into a mess where I have some users on Google, others on Microsoft 365, and its becoming a headache. I'm not sure if the same functionality is even possible. To anyone interested, I'd like to set up a call so that I can share my screen and show the functionalities of both reports as they are now. Then we can investigate if this can be done in Power Automate. Thanks!

Keyword: Software Development

Price: $50.0

Microsoft Power Automate Google Apps Script Automation Data Extraction Google Workspace Microsoft Excel