CODEWITHSUNDEEP
pythongoogle-apigoogle-sheets
user1427661
user1427661

Reputation: 11794

Accessing a Spreadsheet in Google Drive

I have a Spreadsheet stored a few directories into my Google Drive that I'd like to access and read with the Google Spreadsheet API using Python. What is the best way to do this? It seems like all of the examples on the Google API website involve documents that are in Google Docs, not Google Drive, and it seems like none of the examples for the Google Drive API involve reading spreadsheets.

Upvotes: 3

Views: 2489

Answers (2)

Bell Frajer
Bell Frajer

Reputation: 13

link = https://docs.google.com/spreadsheets/d/...source = StringIO.StringIO(requests.get(link).content)) data = pd.read_csv(source)

Upvotes: 0

Claudio Cherubino
Claudio Cherubino

Reputation: 15024

You can either use the Spreadsheets API or Apps Script to programmatically access spreadsheets stored on your Drive account.

Upvotes: 2

Related Questions