Please Follow the Video for Proper Instruction and for Code Input Check Below :
import pandas as pd
import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope=['https://spreadsheets.google.com/feeds']
creds=ServiceAccountCredentials.from_json_keyfile_name('cs.json',scope)
client=gspread.authorize(creds)
sheet=client.open('BB').sheet1
Analysed=sheet.get_all_records()
Analysed=pd.DataFrame(Analysed)
print(Analysed)
--End of Code Input--
Have any Doubt Regarding this Please Feel Free to Comment and Please do Share us on Various Social Media Platform.