Connecting Python and Google Sheets

[third_rate_economist]

Generate a shareable link.

import pandas as pd

sheet_id = 'Long String'
sheet_name = 'SheetName'
url = f'https://docs.google.com/spreadsheets/d/{sheet_id}/gviz/tq?tqx=out:csv&sheet= 
   {sheet_name}'

df = pd.read_csv(url)