shillelagh_sqlalchemy_query_google_sheets_with_sql.py

1from sqlalchemy import create_engine
2
3# Replace with your actual Google Sheet URL
4sheet_url = "https://docs.google.com/spreadsheets/d/1_rN3SuGYLLuLhQG_n96vn877Yoj3u6uE6Z06N1Z3yYc/edit#gid=0"
5
6# Create a SQLAlchemy engine using the shillelagh dialect
7engine = create_engine("shillelagh://")
8
9# Execute a SQL query directly against the Google Sheet
10connection = engine.connect()
11query = f'SELECT * FROM "{sheet_url}"'
12results = connection.execute(query)
13
14for row in results:
15    print(row)