Help with Google Sheets API

The specific reason I was using this was so that the user entered text into a box on the Wix site, then when they clicked a button it sent that text into a box in a google sheet that then ran a query on the rest of the database in the google sheet. It was hosted in an iFrame to show the result. I ended up just using the CSV export so I could have my exact google sheet in the wix database, then used queries etc. in wix code instead