Send info from Won Sale/Opportunity to Google Sheet

I would like to send some specific information related to the Sale/Opportunity and the related quote to a Google sheet after the deal is won. I know how to setup the workflow rules on when to trigger the action to be taken but I don't have enough experience yet on how to write the code to send the data I want to the specific Google Sheet.

I assume I would do this in a custom function inside CRM. I would need to authenticate with my google sheet then add a row with the desired data. I just need the data to be added to the sheet on the next row. Once it is in the sheet we will update and change things as needed for our implementation process.

Does anyone have any experience or knowledge they want to share on how I can do this?