This is a pre-production deployment of Warehouse, however changes made here WILL affect the production instance of PyPI.
Latest Version Dependencies status unknown Test status unknown Test coverage unknown
Project Description
1) Create client_secret.json in Google APIs Console:
- Create new project in Google APIs Console(;
- Open the Credentials page ( and create new credentials Add credentials > OAuth 2.0 client ID;
- In 'Type of application' select 'Other types' and enter the name of client(for example 'Spreedsheet client') and press 'Create';
- Select your created client and download it like a JSON file;
- Rename json file to 'client_secret.json' and put it to your project dir
- Activate Google Drive API and Google Sheets API in Google Dev. Console (

2) Create an instance of an object:
- Import SpreadsheetWorker and PERMISSION_TYPES to your project
- Сreate an instance of the class SpreadsheetWorker and pass to him a path to your client_secret.json file as first argument. Then you can pass title spreadsheet, that will be created

!!!REMARK!!!: when you run creating of spreadsheet for the first time and accept agreement in your browser, may happen, that your spreadsheet will not created. To solve this problem, just run script again. This problem is connected with the creation of .credentials directory.

3) Import package:
from PythonGoogleSpreadsheet.PythonGoogleSpreadsheet import SpreadsheetWorker, PERMISSION_TYPES

Methods of python-google-spreadsheet:
- spreadsheet_constructor(output_data):
Create new Google Spreadsheet
If output_data not define, spreadsheet generator create new empty spreadsheet with access permission only for user, who allowed using his data for app (in browser). Else create new spreadsheet with access permission only for user, who allowed using his data for app (in browser) and data from output_data

:param output_data(non-requirement): <list> - data for recording to Spreadsheet (if not specified, spreadsheet will be create empty)
output_data = [
['Iron Man', 'Tony Stark'],
[43, 1.75, 80],
['Just like his costume;-]']
:return: new spreadsheet id

- record_data(output_data, spreadsheet_id):
Record data to spreadsheet

:param output_data: <list> - data for recording to Spreadsheet
:param spreadsheet_id: <str> - id of modifying spreadsheet
:return: <dict> - response from Google

- get_spreadsheet_data(spreadsheet_id, sheet_name, sheet_range):
Get data from spreadsheet by sheet name and sheet range
!!!REMARK!!!: sheet_name must be consist of letters of the Latin alphabet

:param spreadsheet_id: <str> - id of modifying spreadsheet
:param sheet_name: <str> - name of sheet from which the data will be taken
:param sheet_range: <str> - range of columns(Example - 'A3:B10').
:return: <list> - array of values from selected sheet in spreadsheet

- add_permission(spreadsheet_id, permission_type, user_email):
Add new permission to spreadsheet with id spreadsheet_id

:param spreadsheet_id: <str> - spreadsheet id
:param permission_type: <str> - type of permission, that apply to the spreadsheet
:param user_email(non-requirement): <str> - email of user, to which is added permission
:return: response or None

- show_permissions(spreadsheet_id):
Show all permissions of selected spreadsheet (with id spreadsheet_id)

:param spreadsheet_id: <str> - spreadsheet id
:return: <dict> - permissions

- remove_permission(spreadsheet_id, permission_id):
Remove permission by id of permission

:param spreadsheet_id: <str> - spreadsheet id
:param permission_id: <str> - id of permission to delete(can get in from response of show_permission-method)
:return: ''
Release History

Release History


This version

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

Download Files

Download Files

TODO: Brief introduction on what you do with files - including link to relevant help section.

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
spreadsheet_maker-1.0.tar.gz (5.7 kB) Copy SHA256 Checksum SHA256 Source Sep 27, 2016

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting