L&D series: Google Sheets API

https://i.ytimg.com/vi/BxqfwfQi0jk/maxresdefault.jpg

Learning and Development chapter 19.

Need to record some data to Google Spreadsheet? Here’s the steps.

• Open https://console.developers.google.com/ and Select a project.

• Create new project.

• Click ENABLE APIS AND SERVICES

• Search forGoogle Sheets API then enable.

• Choose Credentials and Create credentials.

• Choose Service account.

• Input name then click DONE.

After add service account, then we will edit to generate the client key.

• Choose KEYS tab and click ADD KEY to create the new key.

• Generate key in JSON format.

It will downloaded a file in .json format. The key will have a content like this.

Now, we will add the key as an editor to our Google Spreadsheet.

• Copy the value of client_email in client_secret.json file.
• Open our GSheet that we want to integrate. Then choose to share.

• Paste the value of client_email and choose the access as an Editor.

Now you can choose the programming language to start the input to GSheet.

Happy coding !!!

https://cdn.analyticsvidhya.com/wp-content/uploads/2020/07/Screenshot-from-2020-07-22-18-25-32.png

What do you want to save with your Google Sheet? — MperMperPisang

Reference

• https://robocorp.com/docs/development-guide/google-sheets/interacting-with-google-sheets