Google sheets integration with Drip CRM

Project Requirement We want to automate the delivery of an individual code from a spreadsheet into an email sent from our ECRM platform Drip when triggered by either a form submission from our website or purchase of sunglasses from our online store. Data from the ECRM platform then needs to be populated back against the issued code in the spreadsheet. Programs Google Sheets Drip ECRM Tasks Create code that enables read/write functionality between a spreadsheet (most likely a Google Sheet doc as it needs to be shared between numerous parties) and DRIP ECRM platform. When a Childe For Life form is submitted or a purchase for sunglasses has been made, Drip would then need to import the next available code from the code spreadsheet and have it populate into an email template that is sent out to the customer. Data from the Form or purchase then needs to be exported from Drip and allocated against the relevant code. Such data would include customer name, date of purchase, Sku Description, Address, Purchased From. There is an API for Drip which can be coded using JavaScript