Anyone set up connection to Google Sheets?

Hey all!

My company is recently using Veeqo and need to use Google Sheets to collect order data for various visualisations as a stop gap before the database is built.

Has anyone connected to Google Sheets to automatically send order information before? If so, are you happy to share the script? I have only recently began using scripts so any tips and pointers would be useful.