The URL structure to download a Google sheet to a csv is https://spreadsheets.google.com/feeds/download/spreadsheets/Export?key=yourDocId&exportFormat=csv&sheet=1
The URL structure to view a Google shet is https://docs.google.com/spreadsheets/d/yourDocId
import pandas as pd
mk_gsheets_url = lambda doc_id: f"https://spreadsheets.google.com/feeds/download/spreadsheets/Export?key={doc_id}&exportFormat=csv"
df = pd.read_csv(mk_gsheets_url("1sVvfAGxBdr2R2aiCkG4_STAvIJLBwH3HTADElsagey4"))
# connect to database
import sqlite3
db_name = "lynch"
conn = sqlite3.connect(f"{db_name}.db")
# push the dataframe to sql
df.to_sql(name=db_name, con=conn, if_exists="replace")
# display contents of table
conn.execute(f"SELECT * FROM '{db_name}';").fetchall()To write several DFs to a db, see the following solution: https://stackoverflow.com/q/68705428