**Author**: `Pahaz Blinov`_
**Repo**: https://github.com/pahaz/google-spreadsheets-api/
Simple create/append google spreadsheet api helper.
Requirements
-------------
* `oauth2client`_
* `googleapiclient`_
Installation
============
`google_spreadsheet`_ is on PyPI, so simply run:
::
pip install google_spreadsheet
or ::
easy_install google_spreadsheet
to have it installed in your environment.
For installing from source, clone the
`repo <https://github.com/pahaz/google-spreadsheets-api>`_ and run::
python setup.py install
Usage scenarios
===============
Two typical usecases where ``google_spreadsheet`` is helpful there are:
1. create new spreadsheet with restricted acccess rules,
2. append data to existing spreadsheet.
You can use it for export your user data to the google spreadsheet.
And sharing this data to all around the world or sharing to specific users.
Usage examples
--------------
Example 1: create spreadsheet
=============================
.. code-block:: py
from google_spreadsheet import get_credentials, Spreadsheets
def create_example():
credentials = get_credentials('auth.json', [
'https://www.googleapis.com/auth/drive',
'https://www.googleapis.com/auth/spreadsheets'])
api = Spreadsheets(credentials=credentials)
sheet = api.create('test1', writers=['pahaz.blinov@gmail.com'])
print(sheet)
if __name__ == '__main__':
create_example()
Example 2: append row to existing spreadsheet
=============================================
.. code-block:: py
from google_spreadsheet import get_credentials, Spreadsheets
def append_data_example():
credentials = get_credentials('auth.json', [
'https://www.googleapis.com/auth/drive',
'https://www.googleapis.com/auth/spreadsheets'])
api = Spreadsheets(credentials=credentials)
sheet = api.get('1jSHsmPTOOiPXdYQlrVBwbo3MO1vp64lmi5R_Ld_duKo')
sheet.append([[1, 2], [3, 4]])
if __name__ == '__main__':
append_data_example()
.. _Pahaz Blinov: https://github.com/pahaz/
.. _oauth2client: https://github.com/google/oauth2client/
.. _googleapiclient: https://github.com/google/google-api-python-client/
.. _google_spreadsheet: https://pypi.python.org/pypi/google_spreadsheet/
Raw data
{
"_id": null,
"home_page": "https://github.com/pahaz/google-spreadsheets-api",
"name": "google_spreadsheet",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "google spreadsheet api util helper",
"author": "Pahaz Blinov",
"author_email": "pahaz.blinov@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/c1/28/3ce1c64b6ef8cb7af944cc96c59e6b941075bdc47db3ec905f3570fcbd18/google_spreadsheet-0.0.6.tar.gz",
"platform": "unix,macos,windows",
"description": "**Author**: `Pahaz Blinov`_\n\n**Repo**: https://github.com/pahaz/google-spreadsheets-api/\n\nSimple create/append google spreadsheet api helper.\n\nRequirements\n-------------\n\n* `oauth2client`_\n* `googleapiclient`_\n\nInstallation\n============\n\n`google_spreadsheet`_ is on PyPI, so simply run:\n\n::\n\n pip install google_spreadsheet\n\nor ::\n\n easy_install google_spreadsheet\n\nto have it installed in your environment.\n\nFor installing from source, clone the\n`repo <https://github.com/pahaz/google-spreadsheets-api>`_ and run::\n\n python setup.py install\n\nUsage scenarios\n===============\n\nTwo typical usecases where ``google_spreadsheet`` is helpful there are:\n1. create new spreadsheet with restricted acccess rules,\n2. append data to existing spreadsheet.\n\nYou can use it for export your user data to the google spreadsheet. \nAnd sharing this data to all around the world or sharing to specific users.\n\nUsage examples\n--------------\n\nExample 1: create spreadsheet\n=============================\n\n.. code-block:: py\n\n from google_spreadsheet import get_credentials, Spreadsheets\n\n\n def create_example():\n credentials = get_credentials('auth.json', [\n 'https://www.googleapis.com/auth/drive',\n 'https://www.googleapis.com/auth/spreadsheets'])\n api = Spreadsheets(credentials=credentials)\n sheet = api.create('test1', writers=['pahaz.blinov@gmail.com'])\n print(sheet)\n\n if __name__ == '__main__':\n create_example()\n\n\nExample 2: append row to existing spreadsheet\n=============================================\n\n.. code-block:: py\n\n from google_spreadsheet import get_credentials, Spreadsheets\n\n\n def append_data_example():\n credentials = get_credentials('auth.json', [\n 'https://www.googleapis.com/auth/drive',\n 'https://www.googleapis.com/auth/spreadsheets'])\n api = Spreadsheets(credentials=credentials)\n sheet = api.get('1jSHsmPTOOiPXdYQlrVBwbo3MO1vp64lmi5R_Ld_duKo')\n sheet.append([[1, 2], [3, 4]])\n\n\n if __name__ == '__main__':\n append_data_example()\n\n\n.. _Pahaz Blinov: https://github.com/pahaz/\n.. _oauth2client: https://github.com/google/oauth2client/\n.. _googleapiclient: https://github.com/google/google-api-python-client/\n.. _google_spreadsheet: https://pypi.python.org/pypi/google_spreadsheet/",
"bugtrack_url": null,
"license": "MIT",
"summary": "Google spreadsheet create/update util",
"version": "0.0.6",
"split_keywords": [
"google",
"spreadsheet",
"api",
"util",
"helper"
],
"urls": [
{
"comment_text": "",
"digests": {
"md5": "294b38afc11a9c831ec733b81331c4be",
"sha256": "b695350b069f9be51a11594b9e685da663c27ac1685733f16101d528e81e987e"
},
"downloads": -1,
"filename": "google_spreadsheet-0.0.6.tar.gz",
"has_sig": false,
"md5_digest": "294b38afc11a9c831ec733b81331c4be",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 6076,
"upload_time": "2016-07-18T13:30:31",
"upload_time_iso_8601": "2016-07-18T13:30:31.854709Z",
"url": "https://files.pythonhosted.org/packages/c1/28/3ce1c64b6ef8cb7af944cc96c59e6b941075bdc47db3ec905f3570fcbd18/google_spreadsheet-0.0.6.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2016-07-18 13:30:31",
"github": true,
"gitlab": false,
"bitbucket": false,
"github_user": "pahaz",
"github_project": "google-spreadsheets-api",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"circle": true,
"lcname": "google_spreadsheet"
}
JSON
