jatindera/iot-google-sheets-data-analysis-on-jupyter-notebook

IoT - Google Sheets Data Analysis on Jupyter Notebook

1. Open https://console.developers.google.com/

2. Login using your gmail account

3. Click on drop down as shown in following image

4. A pop up will open. On the top right of pop up, click on "New Project"

5. Give a project name as shown in the image and click "Create"

6. Browser will automatically take you back to the next screen. Choose your project from the drop down at the top. And click on "Enable APIS and Services".

7. Search for "Google Sheets API" and click on it. Browser will take you to next screen.

8. Click on "Enable API"

9. Browser will take you back to the next screen. Click on "Credentials" from the left menu.

10. On the next screen, Click on "Create Credentials" from the top menu and then "Service Account".

11. Give a name to the "Service Account". Click "Create".

12. Click "Select a role" -> "Service accounts" -> "Service account user".

13. Click "Continue".

14. Click "Done".

15. Note down the "Email" value and then "Click" on the email value. We will use the email value later. Don't worry if you don't note it. you can always copy it later.

16. Click "Add Key" -> "Create new key".

17. Create a json key for your Service Account.

18. A private key is downloaded to your computer. Upload it to your Jupyter Environment/ save it in the same folder where your notebook is.

19. Click on Save at the bottom. Then click on "Back" button at the top.

20. Go to and make a spreadsheet. Create 2 columns, "Temperature" and "Humidity". Fill your data.

21. Get your spread sheet id

22. Click on "File" -> "Share" and share it with your service account email

23. Make following changes in your code and execute your code.

Hope you enjoyed this project !

As an optional steps, you can do following to update your Google Sheet data regularly using Raspberry Pi / ESP82266 and DHT22 Sensor