Hello, I have carefully read your requirements and I ensure you that I can automate any of your google sheet task using Formulas & Advanced scripts.
You will only need to pay if you are satisfied with the project after testing everything.
I have more than 5 years of experience working with G-suite applications and successfully completed 400+ projects with G-sheet, Gmail, Google Docs and Google apps script.
We can discuss project details over a chat/call.
Hope to hear from you soon !!
Thanks,
Kishan
Complex Macros/Script Projects:
--> Amazon API,Sheets API, Gmail API,ParseHub API, IGMS API, Facebook API, Zoho API,Formstack , Trello API
--> Zendesk API, Zapier API, Mindbody API,Brid API, Twilio API and Many more .
--> Hospital Managment, Payroll Management, Online Shop, Task Automations.
-- > Email Automation , SMS Automation , Workflow Management
Data Visualization
--> Google Data Studio/Google Sheets/Klipfolio