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
import sqlite3
# pip install "pandas[excel]"