Fill a specific cell of a Google Sheet

Questions
3

Alright, here we go:

In the example, I am using this method from the Google Sheets API to update the value of a cell.

Things you would need to adjust on your end are:

  1. Replace 1hlRU37P03VoPkneyfhuPqaUPCB2fkbSzC_jDwUam0pg in the request URL with the ID of your Google Sheet. You can get this ID from the URL of your Google Sheet:
    image
    image1171×646 66.5 KB
  2. Adjust the Sheet1!B3 range accordingly if your spreadsheet has a different name or you want to write into a different cell. It has to specified twice, once at the end of the URL and once as a body parameter.

Hope this helps!

3 Likes