{ "info": { "author": "InCountry", "author_email": "developers@incountry.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Programming Language :: Python", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: Implementation :: CPython", "Programming Language :: Python :: Implementation :: PyPy" ], "description": "# Google Env\n\nA simple utility which pulls development-time values from a Google spreadsheet. This\nallows you to share dev secrets in a semi-secure way.\n\n## Usage\n\n1. You need an Oauth credentials JSON file. One person needs to register an\nOauth app in the Google Console and then download the credentials JSON file.\nPlace this file in `$HOME/google_env_creds.json`.\n\n2. Now create a `.env` file in your code project. Reference the spreadsheet\nwhich contains your secrets at the top of the file:\n\n`.env`:\n\n # GOOGLE_ENV: https://docs.google.com/spreadsheets/d/17fcDBp5tez9JFtRwucDW5-wq3jgmzq8s-oWcnUljyR0!Sheet1\n\nNote that the sheet name should be after the '!' at the end.\n\n3. Install the `google_env` package:\n\n `pip install google_env`\n\n4. Now run the `google_env` script directory containing your .env file\n\n `$ google_env`\n\nThe first time you run it you will be sent through the Google Oauth flow in the browser.\nYour access key to the spreadsheet will then be cached in a local file in\n`~/.google_env_token`.\n\nNow the contents of your spreadsheet are downloaded and inserted into the `.env`\nfile. Your spreadsheet should have 2 columns, the key and the value, with no header.\n\nSo if your sheet looks like this:\n\n| | A | B |\n|---|------------|--------------|\n| 1 | key1 | mysecretkey1 |\n| 2 | AWS_ACCESS | foobar |\n---------------------------------\n\nThen the resulting .env file will be rewritten as:\n\n # GOOGLE_ENV: https://docs.google.com/spreadsheets/d/17fcDBp5tez9JFtRwucDW5-wq3jgmzq8s-oWcnUljyR0\n key1=mysecretkey1\n AWS_ACCESS=foobar\n # END_GOOGLE_ENV\n\nNote that you should leave the closing comment line. This will allow you to\nre-run `google_env` any time to update keys from the spreadsheet.\n\nIf you need to override any values, simply add a second assignment for that\nkey lower down in your `.env` file.\n\n## Doing other things with Google Sheets\n\nThis package can be used to easily retrieve information from any Google Sheet.\n\n > import google_env\n > for row in google_env.read_sheet(sheet_id, sheet_range):\n # row will be an array of column values for each row in the sheet\n print(row)\n\nWhere `sheet_id` is like `1mhs7mW7dBK_lhNYB4hZFwdF1QXWSEzl6ITsY50DGx9M` and\n`sheet_range` is a Sheets range like `!` like\n`Sheet1!A1:G20`.\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/incountry/google_env", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "google-env", "package_url": "https://pypi.org/project/google-env/", "platform": "", "project_url": "https://pypi.org/project/google-env/", "project_urls": { "Homepage": "https://github.com/incountry/google_env" }, "release_url": "https://pypi.org/project/google-env/0.4.0/", "requires_dist": [ "google-api-python-client", "google-auth-httplib2", "google-auth-oauthlib" ], "requires_python": ">=2.7.0", "summary": "Script to populate .env file from a Google Sheet", "version": "0.4.0" }, "last_serial": 5689810, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "205b24cea67910e5906a88a55909a5ff", "sha256": "49a7e49a5702266145e17715cb38528011e17bc689a721cdf09b28ed001b8357" }, "downloads": -1, "filename": "google_env-0.1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "205b24cea67910e5906a88a55909a5ff", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7.0", "size": 4324, "upload_time": "2019-08-16T21:52:59", "url": "https://files.pythonhosted.org/packages/97/c1/2655df7c23f0d99e6d3c2f75ea000bdedd5239e806075a2f6d2ec142caab/google_env-0.1.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7ca57664528b7fda6cf075ef63cd5f93", "sha256": "0dfa25e9b3bc5b12d00f1a8d3f5b1f7424e83e938e3bcab7c6182725ba0bb1a7" }, "downloads": -1, "filename": "google_env-0.1.0.tar.gz", "has_sig": false, "md5_digest": "7ca57664528b7fda6cf075ef63cd5f93", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7.0", "size": 5281, "upload_time": "2019-08-16T21:53:01", "url": "https://files.pythonhosted.org/packages/59/21/3a26a7014c09d58eec07209a022980084cdcdff185f464d4febbf6a2f226/google_env-0.1.0.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "801493f9bd4c3406aed6c13ba006290b", "sha256": "a11f43c8916d5683294ac0f26c586e8fe88cef42546b72a94e1291c4391c2128" }, "downloads": -1, "filename": "google_env-0.2.0.tar.gz", "has_sig": false, "md5_digest": "801493f9bd4c3406aed6c13ba006290b", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7.0", "size": 5288, "upload_time": "2019-08-16T21:55:42", "url": "https://files.pythonhosted.org/packages/e2/b8/117d19784215a460790b176a8890841d452f999d0d34a1e385e1d9805cf4/google_env-0.2.0.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "4200f78d7c6fa994697bf5b40a63321e", "sha256": "d3064cdcee2680c7d3197f5320a1e0a74fdddd783c6607e28ad53150748cbba9" }, "downloads": -1, "filename": "google_env-0.3.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "4200f78d7c6fa994697bf5b40a63321e", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7.0", "size": 4583, "upload_time": "2019-08-16T22:01:05", "url": "https://files.pythonhosted.org/packages/32/a8/e5e6c89b8784f0450d35b2fd1ac46055bbd78987fa9efdab5c902c9dc611/google_env-0.3.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "3d8f6a7c92340135281a37e25d0fa853", "sha256": "613e8d9d150825ae48433e459bef93b23a3f2adf5631b8876505278d7197f6e0" }, "downloads": -1, "filename": "google_env-0.3.0.tar.gz", "has_sig": false, "md5_digest": "3d8f6a7c92340135281a37e25d0fa853", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7.0", "size": 5341, "upload_time": "2019-08-16T22:01:06", "url": "https://files.pythonhosted.org/packages/b7/93/b68998610ebd669b906aead7ab641790ea7c8832edc17304b575231bcdf7/google_env-0.3.0.tar.gz" } ], "0.4.0": [ { "comment_text": "", "digests": { "md5": "c55d70360d4ba4c58d07c5b647e6bbd9", "sha256": "c3dbc379d2bb0d3039a81cd2b4702d28d698201dedbce7998ccb97139d52553a" }, "downloads": -1, "filename": "google_env-0.4.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "c55d70360d4ba4c58d07c5b647e6bbd9", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7.0", "size": 4654, "upload_time": "2019-08-16T22:19:51", "url": "https://files.pythonhosted.org/packages/3f/a9/8de81115bb3bc9c21c0ba35edf80987fd3ea3d2bb50a746ac66e23a082af/google_env-0.4.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7de417bbe1024fe0364dced6fa40b05b", "sha256": "b0286b249866745ebbfccef80d6afbccc05869670b44e85488400dd922f1564a" }, "downloads": -1, "filename": "google_env-0.4.0.tar.gz", "has_sig": false, "md5_digest": "7de417bbe1024fe0364dced6fa40b05b", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7.0", "size": 5407, "upload_time": "2019-08-16T22:19:53", "url": "https://files.pythonhosted.org/packages/3b/7e/16d4cb6b2ce7b3f4f2ad06b8267555abef1f84f11bedbc6e5b1b0219f2f3/google_env-0.4.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "c55d70360d4ba4c58d07c5b647e6bbd9", "sha256": "c3dbc379d2bb0d3039a81cd2b4702d28d698201dedbce7998ccb97139d52553a" }, "downloads": -1, "filename": "google_env-0.4.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "c55d70360d4ba4c58d07c5b647e6bbd9", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7.0", "size": 4654, "upload_time": "2019-08-16T22:19:51", "url": "https://files.pythonhosted.org/packages/3f/a9/8de81115bb3bc9c21c0ba35edf80987fd3ea3d2bb50a746ac66e23a082af/google_env-0.4.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7de417bbe1024fe0364dced6fa40b05b", "sha256": "b0286b249866745ebbfccef80d6afbccc05869670b44e85488400dd922f1564a" }, "downloads": -1, "filename": "google_env-0.4.0.tar.gz", "has_sig": false, "md5_digest": "7de417bbe1024fe0364dced6fa40b05b", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7.0", "size": 5407, "upload_time": "2019-08-16T22:19:53", "url": "https://files.pythonhosted.org/packages/3b/7e/16d4cb6b2ce7b3f4f2ad06b8267555abef1f84f11bedbc6e5b1b0219f2f3/google_env-0.4.0.tar.gz" } ] }