Hello, I've already worked on a project that on some point used to export some sheets to drive as csv and print pdf invoices from sheet to drive too, so i already did script sth like that.
some of my previous projects:
-multiple projects that manipulated sheet data in different ways then added or modified a live firestore database depending on data.
-an elimination brackets tournament project that will go live soon using apps script and google sheets.
-campagain builders in gs and apps script
-amazon fba organic ranking
-used google places api with a project too
would be nice if you send me a message to discuss your requirements and start working afterwards, you only need to pay me on 100% project completion or on set milestones completion no upfront payment of any kind, thank you.