Step by step guide to interact with Google Sheets using Python

Google Configuration


pip install gspread
pip install --upgrade oauth2client
import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope = ['',
credentials = ServiceAccountCredentials.from_json_keyfile_name('credentials.json', scope)client = gspread.authorize(credentials)work_sheet ='python-test').sheet1

Tech consultant ( | Avid learner | Composer | Proudly believing less is more, except for love and knowledge

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store