Download a spreadsheet from Google Drive / Workspace using Python

by

The https://github.com/burnash/gspread library is a newer, simpler way to interact with Google Spreadsheets, rather than the old answers to this that suggest the gdata library which is not only too low-level, but is also overly-complicated.

You will also need to create and download (in JSON format) a Service Account key: https://console.developers.google.com/apis/credentials/serviceaccountkey

Here’s an example of how to use it:

import csv
import gspread
from oauth2client.service_account import ServiceAccountCredentials

scope = ['https://spreadsheets.google.com/feeds']
credentials = ServiceAccountCredentials.from_json_keyfile_name('credentials.json', scope)

docid = "0zjVQXjJixf-SdGpLKnJtcmQhNjVUTk1hNTRpc0x5b9c"

client = gspread.authorize(credentials)
spreadsheet = client.open_by_key(docid)
for i, worksheet in enumerate(spreadsheet.worksheets()):
    filename = docid + '-worksheet' + str(i) + '.csv'
    with open(filename, 'wb') as f:
        writer = csv.writer(f)
        writer.writerows(worksheet.get_all_values())

More Related Contents:

  1. gspread authentication throwing insufficient permission
  2. Python: download files from google drive using url
  3. Creating anchored comments programmatically in Google Docs
  4. Automating pydrive verification process
  5. How to download a file from Google Drive using Python and the Drive API v3
  6. How do I access (read, write) Google Sheets spreadsheets with Python?
  7. Getting Google Spreadsheet CSV into A Pandas Dataframe
  8. Refresh Google drive access__token
  9. Google Docs viewer returning 204 responses, no longer working, alternatives?
  10. Fanny’s Occurences
  11. Converting integer to binary in python
  12. What is the use of join() in Python threading?
  13. Removing item from list causes the list to become NoneType
  14. Pandas DataFrame: replace all values in a column, based on condition
  15. What’s the difference between “pip install” and “python -m pip install”?
  16. What is the most efficient way to get first and last line of a text file?
  17. How to start and stop a thread
  18. ImproperlyConfigured: You must either define the environment variable DJANGO_SETTINGS_MODULE or call settings.configure() before accessing settings
  19. How do I sort a dictionary by key?
  20. Removing prefix from column names in Pandas
  21. Calculating the area under a curve given a set of coordinates, without knowing the function
  22. Catch exception and continue try block in Python
  23. Python 3 replacement for deprecated compiler.ast flatten function
  24. Why does numpy.zeros takes up little space
  25. exec() and variable scope [duplicate]
  26. python, sort descending dataframe with pandas
  27. Pythonically add header to a csv file
  28. Python in-memory zip library
  29. Find path to currently running file [duplicate]
  30. Overlap between mask and fired beams in Pygame [AI car model vision]

Leave a Comment