{"repo":"nithinmurali/pygsheets","free":true,"listed":false,"github":"https://github.com/nithinmurali/pygsheets","clone":"git clone https://github.com/nithinmurali/pygsheets.git","description":"Google Sheets Python API v4","language":"Python","stars":1544,"topics":["google-sheets","google-sheets-api","python","python-lib","google-sheets-api-v4","google-sheets-library","spreadsheet"],"license":null,"category":"dev-tools","readme_excerpt":"pygsheets - Google Spreadsheets Python API v4 A simple, intuitive library for google sheets which gets your work done. Features: Open, create, delete and share spreadsheets using title or key Intuitive models - spreadsheet, worksheet, cell, datarange Control permissions of spreadsheets. Set cell format, text format, color, write notes Named and Protected Ranges Support Work with range of cells easily with DataRange and Gridrange Data validation support. checkboxes, drop-downs etc. Conditional formatting support get multiple ranges with get values batch and update wit update values batch Updates version 2.0.5 released Installation From PyPi (Stable) If you are installing from pypi please see the docs here. From GitHub (Recommended) If you are installing from github please see the docs here. Basic Usage Basic features are shown here, for complete set of features see the full documentation here. 1. Obtain OAuth2 credentials from Google Developers Console for google spreadsheet api and drive api and save the file as client secret.json in same directory as project. read more here. 2. Start using pygsheets: Sample scenario : you want to share a numpy array with your remote friend Sample Scenario: you want to fill height values of students More Examples Opening a Spreadsheet Operations on Spreadsheet doc show code Selecting a Worksheet show code Operations on Worksheet doc show code Pandas integration If you work with pandas, you can directly use the dataframes Cell Object doc Each ","default_branch":null,"files":null,"tree":[],"storefront":"/r/nithinmurali","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/nithinmurali/pygsheets/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}