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
