Python: Fetch data from Google Sheet

fetch_google_sheet.py

import gspread
import pandas as pd
from oauth2client.service_account import ServiceAccountCredentials

creds = ServiceAccountCredentials.from_json_keyfile_name(
    filename="credentials.json",
    scopes=["https://www.googleapis.com/auth/drive"]
)

# Initialize client
client = gspread.authorize(creds)

# Fetch name of first spreadsheet file
spreadsheet_file = client.list_spreadsheet_files()[0]["name"]

# Open spreadsheet
sh = client.open(spreadsheet_file)

# Get all values from first worksheet
data = sh.worksheets()[0].get_all_values()

# Use first row as column names and all subsequent rows as data
df = pd.DataFrame(data[1:], columns=data[0])