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
