Reading Data from Google Sheets

Once you have your API set up, reading data is surprisingly easy, especially with libraries like gspread.

First, install the library:

pip install gspread

Then, use this Python code to grab your data:

import gspread

# Connect using your credentials
gc = gspread.service_account(filename='credentials.json')

# Open the sheet by its name
sh = gc.open("My Cool Spreadsheet")

# Select the first worksheet (tab)
worksheet = sh.sheet1

# Get all values as a list of lists
data = worksheet.get_all_values()

print(data)

Output:

[
    ['Name', 'Age', 'City'],
    ['Alice', '25', 'New York'],
    ['Bob', '30', 'Paris']
]

You can even convert this directly into a Pandas DataFrame to start analyzing it immediately!

I show you how to build powerful apps using this data in my Full Stack Google Sheets course.