{ "info": { "author": "V\u00edctor P\u00e9rez Berruezo", "author_email": "victor.perez.berruezo@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "License :: Public Domain", "Programming Language :: Python :: 3" ], "description": "# google-api-support\n\nSome functions to make Google APIs more usable. \n\n## Functions avaliable\n\n* Sheets\n * Get pandas.dataframe from Sheets\n * Upload pandas.dataframe to Sheets\n * Retrieve sheet names\n* Slides\n * Create presentation\n * Get presentation info\n * Get presentation slides\n * Get slide notes\n * Replace text\n * Replace shape with image\n * Replace image\n * Get slide notes\n * Batch replace text\n * Batch replace shapes with images\n * Insert image\n * Duplicate object\n * Delete object\n * Batch delete object\n * Delete text\n * Batch delete text\n * Delete presentation notes\n * Transform object\n* Drive\n * Get file name\n * Move file\n * Delete file\n * Copy file\n * Upload image\n * Create folder\n * List folders in folder\n * Get folder id by name\n * Get folder id by path\n * Download file\n\n\n## Install\n\n'''pip install google-api-support'''\n\nYou might need to install manually:\n\n'''pip install google-api-python-client httplib2 oauth2client pandas'''\n\n## Steps to use google Sheets API\n\nIn order to use Google APIs you will need to authenticate, this steps guide you through the process:\n\n0. Create a project in console.developers.google.com\n\nhttps://console.developers.google.com\n\n0. Create google service account.\n 0. Go to https://console.developers.google.com/projectselector/apis/credentials and create a new project.\n ![Create a developers project](Documentation/img/create_project.PNG)\n\n 0. Create credentials.\n ![](Documentation/img/choose_credentials.PNG)\n * In this first version, i will explain how to deal with Services accounts, so select \"Service account key\".\n\n 0. Create a service account.\n ![](Documentation/img/create_service_account.PNG)\n * Download the .json file and KEEP IT SAFE.\n\n 0. Now you have your service account created inside your new project.\n ![](Documentation/img/create_service_account.PNG)\n\n 0. Copy your \"user id\" in \"Manage service accounts\" to use it later.\n * It looks like this one: \"first-service-account@example-id-175820.iam.gserviceaccount.com\"\n\n 0. Go to your dashboard screen and go to \"ENABLE APIS AND SERVICES\" to \"unlock\" the desired API calls.\n In our example, we will just enable \"Google sheets API\".\n ![](Documentation/img/enable_apis.PNG)\n ![](Documentation/img/activate_sheets.PNG)\n\n\n## Save credentials file inside the project:\n\nCreate a folder named `.Credentials` and store newly downloaded credentials renaming them with `service_credentials.json`\n\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/vperezb/google-api-support", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "google-api-support", "package_url": "https://pypi.org/project/google-api-support/", "platform": "", "project_url": "https://pypi.org/project/google-api-support/", "project_urls": { "Homepage": "https://github.com/vperezb/google-api-support" }, "release_url": "https://pypi.org/project/google-api-support/0.0.3/", "requires_dist": [ "google-api-python-client", "httplib2", "oauth2client", "pandas" ], "requires_python": "", "summary": "In this package you will find functions to deal with google apis. Sheets, Drive and Slides", "version": "0.0.3" }, "last_serial": 5687677, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "8a9003f2114c6e31be8861dd781f5cc0", "sha256": "4a4dd8e692bb2702e44b3ce71df5208a6f0d955d8e9bc4ab42ef6c3707bbbd85" }, "downloads": -1, "filename": "google_api_support-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "8a9003f2114c6e31be8861dd781f5cc0", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8634, "upload_time": "2019-06-30T10:34:31", "url": "https://files.pythonhosted.org/packages/c3/5e/ee7162177289e4ecebdc6251474b73442a768739ed1fffd3fa439bfd1d7b/google_api_support-0.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d511d6b173f0d04b6208f61bf8cbe5e8", "sha256": "72cbdf553d97189ef0eecb46c324f214b6800642d57a41f991a04b4e1eca575c" }, "downloads": -1, "filename": "google-api-support-0.0.1.tar.gz", "has_sig": false, "md5_digest": "d511d6b173f0d04b6208f61bf8cbe5e8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6556, "upload_time": "2019-06-30T10:34:33", "url": "https://files.pythonhosted.org/packages/0f/a4/e6c58242cb92874db970a54df7c24c39492fb4ff8aa85facd05b88e8c5c3/google-api-support-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "8cac110c2409722cac9af63869065e2f", "sha256": "cb7fbbf3c618e82524a686e2a75551fccd78d4c60d3f1ed410d8fd386cc94fa7" }, "downloads": -1, "filename": "google_api_support-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "8cac110c2409722cac9af63869065e2f", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8815, "upload_time": "2019-07-13T10:33:46", "url": "https://files.pythonhosted.org/packages/54/11/ef87cda486076d9d84e3b921316ce5fbe173b135da6f101ffd418d835a84/google_api_support-0.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7f3ede625ad4ca3cb1e8800f4041742c", "sha256": "6e7e1709251981e25c9c95768fa8446143d7177d2958e5f695ed3e63295a8da4" }, "downloads": -1, "filename": "google-api-support-0.0.2.tar.gz", "has_sig": false, "md5_digest": "7f3ede625ad4ca3cb1e8800f4041742c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6726, "upload_time": "2019-07-13T10:33:48", "url": "https://files.pythonhosted.org/packages/da/d3/093ed568934c65e980952efb85f5b7f137e61c1fc54dcb829bd7577f680f/google-api-support-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "cf3adcf146cf8abd11340d89810081f6", "sha256": "71a59617f61fb94c1ed23749d443303e5b8c62906a12fa0704a19f68fad7fa1a" }, "downloads": -1, "filename": "google_api_support-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "cf3adcf146cf8abd11340d89810081f6", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 9026, "upload_time": "2019-08-16T13:29:45", "url": "https://files.pythonhosted.org/packages/c8/17/5bd7cb8237b640631124021962bdc932a7a3264fbd396266c713e522fb24/google_api_support-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7e7c94620a969b324796f4f3a1efe598", "sha256": "1356a7cb0fafc1b520d0eb84f831d0be6615f5d5e0003d3c22d401d64fec3e23" }, "downloads": -1, "filename": "google-api-support-0.0.3.tar.gz", "has_sig": false, "md5_digest": "7e7c94620a969b324796f4f3a1efe598", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6933, "upload_time": "2019-08-16T13:29:48", "url": "https://files.pythonhosted.org/packages/19/c0/50b463f247ac9026d56f7b7dca5cde3f54301c872450fe513be4654a3acd/google-api-support-0.0.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "cf3adcf146cf8abd11340d89810081f6", "sha256": "71a59617f61fb94c1ed23749d443303e5b8c62906a12fa0704a19f68fad7fa1a" }, "downloads": -1, "filename": "google_api_support-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "cf3adcf146cf8abd11340d89810081f6", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 9026, "upload_time": "2019-08-16T13:29:45", "url": "https://files.pythonhosted.org/packages/c8/17/5bd7cb8237b640631124021962bdc932a7a3264fbd396266c713e522fb24/google_api_support-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7e7c94620a969b324796f4f3a1efe598", "sha256": "1356a7cb0fafc1b520d0eb84f831d0be6615f5d5e0003d3c22d401d64fec3e23" }, "downloads": -1, "filename": "google-api-support-0.0.3.tar.gz", "has_sig": false, "md5_digest": "7e7c94620a969b324796f4f3a1efe598", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6933, "upload_time": "2019-08-16T13:29:48", "url": "https://files.pythonhosted.org/packages/19/c0/50b463f247ac9026d56f7b7dca5cde3f54301c872450fe513be4654a3acd/google-api-support-0.0.3.tar.gz" } ] }