Reading google sheet file using function: File_Url= "https://docs.google.com/spreadsheets/d/458qrjGFH9CD050rRwEHfayWVd4x9VheVAiZkGsj4lIo/export?format=tsv" def getGoogle(google): import pandas as pd import numpy as np import sys if sys.version_info.major == 3: import ssl ssl._create_default_https_context = ssl._create_unverified_context try: df = pd.read_csv(google, delimiter='\t').rename(columns=lambda x: x.strip()) except Exception as e: import requests, io x = requests.get(url=google).content df = pd.read_csv(io.StringIO(x.decode('utf8')), delimiter='\t').rename(columns=lambda x: x.strip()) df = df.replace({np.nan: None}) return df.to_dict('records') googleSheetRecord=getGoogle(File_Url) ...