{
    "info": {
        "author": "Yoav Aviram",
        "author_email": "support@cleverblocks.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Environment :: Console",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: BSD License",
            "Natural Language :: English",
            "Operating System :: OS Independent",
            "Programming Language :: Python",
            "Topic :: Internet :: WWW/HTTP :: Dynamic Content :: CGI Tools/Libraries",
            "Topic :: Software Development :: Libraries :: Python Modules",
            "Topic :: Utilities"
        ],
        "description": "Google Spreadsheets API\r\n========================\r\nA simple Python wrapper for the Google Spreadsheeta API.\r\n[![Build Status](https://secure.travis-ci.org/yoavaviram/python-google-spreadsheet.png?branch=master)](http://travis-ci.org/yoavaviram/python-google-spreadsheet)\r\n\r\n\r\n\r\nFeatures\r\n--------\r\n\r\n* An object oriented interface for Worksheets\r\n* Supports List Feed view of spreadsheet rows, represented as dictionaries\r\n* Compatible with Google App Engine\r\n\r\n\r\nRequirements\r\n--------------\r\nBefore you get started, make sure you have:\r\n\r\n* Installed [Gdata](http://code.google.com/p/gdata-python-client/) (pip install gdata)\r\n\r\nUsage\r\n-----\r\n\r\nList Spreadsheets and Worksheets:\r\n\r\n     >>> from google_spreadsheet.api import SpreadsheetAPI\r\n     >>> api = SpreadsheetAPI(GOOGLE_SPREADSHEET_USER, \r\n            GOOGLE_SPREADSHEET_PASSWORD, GOOGLE_SPREADSHEET_SOURCE)\r\n     >>> spreadsheets = api.list_spreadsheets()\r\n     >>> spreadsheets\r\n     [('MyFirstSpreadsheet', 'tkZQWzwHEjKTWFFCAgw'), ('MySecondSpreadsheet', 't5I-ZPGdXjTrjMefHcg'), \r\n     ('MyThirdSpreadsheet', 't0heCWhzCmm9Y-GTTM_Q')]\r\n     >>> worksheets = api.list_worksheets(spreadsheets[0][1])\r\n     >>> worksheets\r\n     [('MyFirstWorksheet', 'od7'), ('MySecondWorksheet', 'od6'), ('MyThirdWorksheet', 'od4')]\r\n\r\nPlease note that in order to work with a Google Spreadsheet it must be accessible\r\nto the user who's login credentials are provided. The `GOOGLE_SPREADSHEET_SOURCE`\r\nargument is used by Google to identify your application and track API calls.\r\n\r\nWorking with a Worksheet:\r\n\r\n    >>> sheet = spreadsheet.get_worksheet('tkZQWzwHEjKTWFFCAgw', 'od7')\r\n    >>> rows = sheet.get_rows()\r\n    >>> len(rows)\r\n    18\r\n    >>> row_to_update = rows[0]\r\n    >>> row_to_update['name'] = 'New Name'\r\n    >>> sheet.update_row(row_to_update)\r\n    {'name': 'New Name'...}\r\n    >>> row_to_insert = rows[0]\r\n    >>> row_to_insert['name'] = 'Another Name'\r\n    >>> row = sheet.insert_row(row_to_insert)\r\n    {'name': 'Another Name'...}\r\n    >>> sheet.delete_row(row)\r\n    >>> sheet.delete_all_rows()\r\n\r\nAdvanced Queries:\r\n\r\n    >>> sheet = spreadsheet.get_worksheet('tkZQWzwHEjKTWFFCAgw', 'od7')\r\n    >>> rows = sheet.get_rows(query='name = \"Joe\" and height < 175')\r\n\r\nOr filter in memory:\r\n\r\n    >>> sheet = spreadsheet.get_worksheet('tkZQWzwHEjKTWFFCAgw', 'od7')\r\n    >>> filtered_rows = sheet.get_rows(\r\n            filter_func=lambda row: row['status'] == \"READY\")\r\n\r\nSort:\r\n\r\n    >>> sheet = spreadsheet.get_worksheet('tkZQWzwHEjKTWFFCAgw', 'od7')\r\n    >>> rows = sheet.get_rows(order_by='column:age', reverse='true')\r\n\r\nThat's it.\r\n\r\nFor more information about these calls, please consult the [Google Spreadsheets\r\nAPI Developer Guide](https://developers.google.com/google-apps/spreadsheets/).\r\n\r\nTests\r\n------\r\nTo run the test suite please follow these steps:\r\n\r\n* Make sure [Nose](http://readthedocs.org/docs/nose/en/latest/) is installed: (`pip install nose`)\r\n* Create a local file named: `test_settings.py` with the following variables set to the relevant values: `GOOGLE_SPREADSHEET_USER`, `GOOGLE_SPREADSHEET_PASSWORD`, `GOOGLE_SPREADSHEET_SOURCE`, `GOOGLE_SPREADSHEET_KEY`, `GOOGLE_WORKSHEET_KEY`, `COLUMN_NAME`, `COLUMN_UNIQUE_VALUE`\r\n* Run `nosetests`\r\n\r\nLicense\r\n-------\r\n\r\nCopyright &copy; 2012 Yoav Aviram\r\n\r\nSee LICENSE for details.",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "UNKNOWN",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/yoavaviram/python-google-spreadsheet",
        "keywords": "google,docs,spreadsheets,api",
        "license": "BSD",
        "maintainer": "",
        "maintainer_email": "",
        "name": "python-google-spreadsheet",
        "package_url": "https://pypi.org/project/python-google-spreadsheet/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/python-google-spreadsheet/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "https://github.com/yoavaviram/python-google-spreadsheet"
        },
        "release_url": "https://pypi.org/project/python-google-spreadsheet/2.0.0/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "A simple Python wrapper for the Google Spreadsheets API",
        "version": "2.0.0"
    },
    "last_serial": 797950,
    "releases": {
        "1.0.0": [],
        "1.0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "65e0b0e232bd0d427231d2fbe386dfc9",
                    "sha256": "a426e9e56d57f9d9406f8cb141da0d6de838a6861be422eaff0cc697514c08c8"
                },
                "downloads": -1,
                "filename": "python_google_spreadsheet-1.0.2-py2.7.egg",
                "has_sig": false,
                "md5_digest": "65e0b0e232bd0d427231d2fbe386dfc9",
                "packagetype": "bdist_egg",
                "python_version": "2.7",
                "requires_python": null,
                "size": 5429,
                "upload_time": "2012-06-05T14:37:06",
                "url": "https://files.pythonhosted.org/packages/11/c5/4ad2e0fdf3a08fde656b67aafcd64b074f8e2301c92103f1f0c2870d6f5f/python_google_spreadsheet-1.0.2-py2.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "04368eff1b93dfe36eb904641f4fa19a",
                    "sha256": "e27552e10c3061cbbd2feb23e06027aba5643f96ceca2d4a5d7bce660aa4dccc"
                },
                "downloads": -1,
                "filename": "python-google-spreadsheet-1.0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "04368eff1b93dfe36eb904641f4fa19a",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2567,
                "upload_time": "2012-06-05T14:35:08",
                "url": "https://files.pythonhosted.org/packages/14/12/f0949f11452878021b2c46769506759a753e550bf8fd9b9f302de8674fbf/python-google-spreadsheet-1.0.2.tar.gz"
            }
        ],
        "1.0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3c563f36181deacdf053ec6a864dc1bc",
                    "sha256": "ed7e55529eb0d7e9f7b8dafa2b87e74a0f3e73fa1d149f0a53405c24e7544a8d"
                },
                "downloads": -1,
                "filename": "python-google-spreadsheet-1.0.3.tar.gz",
                "has_sig": false,
                "md5_digest": "3c563f36181deacdf053ec6a864dc1bc",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3164,
                "upload_time": "2012-06-16T12:32:54",
                "url": "https://files.pythonhosted.org/packages/72/a4/100e526e63f2184ea99d0716cb7b53c648a1d0e9aaddefddb9e98efccca9/python-google-spreadsheet-1.0.3.tar.gz"
            }
        ],
        "1.0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6dbcc96434c0717c7eeb0213de1d7d9d",
                    "sha256": "0c774cd623888fdcedc2088ccf0edc18d952fe0e88d227d01bf16fc47edf1116"
                },
                "downloads": -1,
                "filename": "python-google-spreadsheet-1.0.4.tar.gz",
                "has_sig": false,
                "md5_digest": "6dbcc96434c0717c7eeb0213de1d7d9d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3318,
                "upload_time": "2012-06-20T13:47:30",
                "url": "https://files.pythonhosted.org/packages/bd/14/b325a35ac2d66e435d7040cea8843d92e7d8f87ced481f65efa6c0bcf3c8/python-google-spreadsheet-1.0.4.tar.gz"
            }
        ],
        "2.0.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "03fffb8ab6ccf4b83bdd34bd57818da7",
                    "sha256": "ab0ba21efc79d731db7cd0269080fe8caaa64cfd0d31328d4b739b2e074350a8"
                },
                "downloads": -1,
                "filename": "python-google-spreadsheet-2.0.0.tar.gz",
                "has_sig": false,
                "md5_digest": "03fffb8ab6ccf4b83bdd34bd57818da7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4221,
                "upload_time": "2012-09-06T15:21:08",
                "url": "https://files.pythonhosted.org/packages/64/d1/5d2f81f82cc2a98135b5a58a1518c6b700c010140a79c6c749bd44be6671/python-google-spreadsheet-2.0.0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "03fffb8ab6ccf4b83bdd34bd57818da7",
                "sha256": "ab0ba21efc79d731db7cd0269080fe8caaa64cfd0d31328d4b739b2e074350a8"
            },
            "downloads": -1,
            "filename": "python-google-spreadsheet-2.0.0.tar.gz",
            "has_sig": false,
            "md5_digest": "03fffb8ab6ccf4b83bdd34bd57818da7",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 4221,
            "upload_time": "2012-09-06T15:21:08",
            "url": "https://files.pythonhosted.org/packages/64/d1/5d2f81f82cc2a98135b5a58a1518c6b700c010140a79c6c749bd44be6671/python-google-spreadsheet-2.0.0.tar.gz"
        }
    ]
}