competitor_monitor_gsheet.py

import gspread
from oauth2client.service_account import ServiceAccountCredentials
import pandas as pd
import requests
from bs4 import BeautifulSoup 

# Access credentials for google sheet and access the google sheet
scope = ['https://spreadsheets.google.com/feeds',
         'https://www.googleapis.com/auth/drive']

# Copy your path to your credential JSON file.
PATH_TO_CREDENTIAL = '/Users/bla/credential/data science-4936da0d6b1f.json'

# Initiate your credential
credentials = ServiceAccountCredentials.from_json_keyfile_name(PATH_TO_CREDENTIAL, scope)

# Authorize your connection to your google sheet
gc = gspread.authorize(credentials)

# Access google sheet
sht1 = gc.open_by_key('11DU3qbPoXlbUXJ-o_zerndJdqQ8pNBMsAZpeBfbwyc0')