Accessing Spreadsheet in python using Google API

Question

How to access a spreadsheet document in python from Google Sheets using Sheets API ? I was trying to access a document in my google account. So Will API key be sufficient or should we go with Oauth2client?

ReyAnthonyRenacia · Accepted Answer · 2016-11-10 08:45:03Z

1

You can just use the OAuth2 flow. The credentials will be stored in your client_secret.json. This procedure is detailed in the Python Quickstart Sheets API guide.

Step 1: Turn on the Google Sheets API

Step 2: Install the Google Client Library

Step 3: Set up the sample

answered Nov 10, 2016 at 8:45

ReyAnthonyRenacia

17.7k6 gold badges42 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

arulmr · Accepted Answer · 2016-11-10 08:50:14Z

1

You can try using the library Gspread for accessing google spreadsheets. You can install gspread using the command

pip install gspread

or

pip install https://github.com/burnash/gspread/archive/master.zip

I have written a detailed blog on how to access google sheets in python using gspread. This might help you.

answered Nov 10, 2016 at 8:50

arulmr

8,8649 gold badges56 silver badges70 bronze badges

Collectives™ on Stack Overflow

Accessing Spreadsheet in python using Google API

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related