Google Sheets API in Python: Create a Service Instance

In this tutorial, we will be learning how to create Google Spreadsheets Service instance in Python. This will be the beginning to the Google Sheets API tutorial series.

Your support is what makes better tutorial materials.

About Google Sheets:
Google Sheets is a cloud spreadsheet application created by Google. Similar to Microsoft Excel, Google sheets provides a rich selection of features and functions. Unlike Excel, Google Sheets is completely free, changes are automatically saved, seamlessly collaboration with your colleagues and friends. You can also export Google Sheets file to different file format (Excel, Csv, Text, Html, etc).

Python script used in this video:

Part 1: Create a New Project

Part 2:

Google Sheets API Documentation

More tutorial videos on my website

#GoogleSheetsAPI

[AlexLunnar]

What a great tutorial, realy thank you for do this, it´s saving me

[anthonysimonyan]

Hey there Jenn great video tho I have a question I reached a problem at the very start I just copy pasted the code to see if it works and it says that SCOPE is not a defined variable but I don't understand why

[ritvikmahajan]

run-local-server method creates service for local computer, what about when going into production

[humbertotorres]

Hi Jie! Thank you for the video.
Still, i get this message error.
Can you help me out?


Traceback (most recent call last):
File "/Users/Name/Documents/Python/tryspreadsheetsapi.py", line 31, in <module>
flow = InstalledAppFlow.from_client_secrets_file(CLIENT_SECRET_FILE, SCOPES)
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/google_auth_oauthlib/flow.py", line 199, in from_client_secrets_file
return cls.from_client_config(client_config, scopes=scopes, **kwargs)
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/google_auth_oauthlib/flow.py", line 158, in from_client_config
raise ValueError(
ValueError: Client secrets must be for a web or installed app.

[howardfx]

Hi Jenn,
Thanks for the tutorial. I've followed all the instructions given in the video and is getting the following traceback.

Traceback (most recent call last):
  File "/Users/Howard/Desktop/LineOfficialAccount/ATeamLineBot/linebot/GService.py", line 4, in <module>
    from google_auth_oauthlib.flow import Flow, InstalledAppFlow
ImportError: No module named google_auth_oauthlib.flow