Installation and instantiation of google sheet gspread dependencies

gsheet.py

import gspread
import pandas as pd
from oauth2client.service_account import ServiceAccountCredentials
from collections import OrderedDict

# define scope
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']

# add credentials to the account
creds = ServiceAccountCredentials.from_json_keyfile_name('add_json_file_here.json', scope)

# authorize the clientsheet
client = gspread.authorize(creds)