Google sheets template interface with Shopify

I am looking for assistance to create a custom Google Sheets template to interface with Shopify. The key functionalities I need are order management, sales reporting, creating a custom invoice. I would like the template to periodically update information from Google sheets order form spreadsheet into Shopify, so I can print invoices, packing slips, track customer order providing me with the insight to make informed decisions, yet isn't a strain on my system or take away from its performance. I have some experience with Google Sheets and Shopify, however I would need guidance with the implementation of the spreadsheet, and creating the necessary connections that allow it to interact with Shopify.