Script to send a fixed value to Google Spreadsheet by button click -- 2

Job ID: 32452967

Budget: £20 – £250 GBP

I already have a script which allows me to pull text data and display it on my web page from my Google Spreadsheet depending on the email address that is logged into Firebase.

I want to send a fixed value e.g 2 to a specific column in Google Sheets e.g. Column Z and then still using my query function for emailaddress/ firebase logged in email address find the relevant cell and populate it with the fixed value (2). This needs to be submitted to the Google spreadsheet when the user clicks a button with a specific ID.

//
Related categories: JavaScript HTML5 HTML Google Sheets Google APIs