2.0.5 Import from Google Sheet

# set your google sheet to 
# Click "Share" and then change the sheet from 'Restricted' to "Anyone with the link"

import pandas as pd

sheet_name = "your_sheet_name"  # The name of the sheet that you want to read in
sheet_id = "1jeq-ThereWillBeALongStringOfRandomCharactersAndNumbers_h5w_h3Kp6deRK"  # the part in the URL after this "https://docs.google.com/spreadsheets/d/"  But before this /edit#gid=1500097446  
url = f'''https://docs.google.com/spreadsheets/d/{sheet_id}/gviz/tq?tqx=out:csv&sheet={sheet_name}'''
DF_GoogleSheet= pd.read_csv(url)