Access to google spreadsheet content.
###Dependent module:
(Maybe needs sudo)
- Google APIs Client Library => pip install --upgrade google-api-python-client
(The version of google-api-python-client above 1.4.0 will install fail in Mac OSX.
Please downgrade install => pip install -I google-api-python-client==1.3.2
reference:http://stackoverflow.com/questions/29190604/attribute-error-trying-to-run-gmail-api-quickstart-in-python) - Httplib2 => pip install httplib2
###Execute steps:
- Change [client_secret], [client_email] and [client_id] to proper value in "client_secrets.json" file that get from Google Console
(Reference:https://github.com/jay0lee/GAM/wiki/Creating-client_secrets.json-and-oauth2service.json) - python googleDriveAccess.py
- Copy Google Sheet File_ID and paste to console.
- Copy Access Token from browser and paste to console.
- Got exported file.
###Settings:
- Open googleDriveAccess.py
- Modify
FILE_NAME: file name for save
SAVE_PATH: the path for save file
FILE_ID: Google spreadsheet file_id got from page address
###NOTIFICATION:
-
If got AttributeError: 'Module_six_moves_urllib_parse' in Mac OS. Execute following command
=> easy_install --upgrade six
It cause by the module version of "six" doesn't synchronized in different Python package.We can check the version by following steps:
a. pip show six
b. $ pytho
>> import six; six._version_