To be able to programmatically update Google Sheets, we need to enable the APIs and Service in Google Cloud Platform.
Create a new Google Cloud project
- Log into the Google Cloud Console at https://console.cloud.google.com
- Click the down arrow of the project list
- On the Select a project pop-up click the NEW PROJECT button
Enable the Google Sheet API
- In the upper left corner click the “hamburger” menu icon and select APIs & Services
- On the APIs & Services page click the + ENABLE APIS AND SERVICES button
- Enter google sheet api into the search box and select the Google Sheets API tile
- Click the Enable button