Export google spreadsheet to csv, you can filter data with SQL statement.
Project description
googlesheets2csv
Export google spreadsheet to csv, you can filter data with SQL statement.
Installation
pip install googlesheets2csv
Development
git clone https://github.com/YuChunTsao/googlesheets2csv.git
cd googlesheets2csv
pip install -e .
How to get credential json?
- Create Google Cloud project.
- Enable "Google Sheets API" and "Google Drive API".
- Go to "APIs & Services > Credentials" and choose "CREATE CREDENTIALS > Service account".
- Fill out the form and click "Create" and "Done".
- Go to "IAM & Admin > Service Accounts > Keys" and click "ADD KEY > Create new key".
- Select JSON key type and press "Create". (The file will be downloaded automatically.)
CLI usage
usage: googlesheets2csv [-h] [-v] -c -sn -wn [-sql] output
Export google spreadsheet to csv, you can filter data with SQL statement.
positional arguments:
output Output csv file path
options:
-h, --help show this help message and exit
-v, --version show program's version number and exit
-c, --credential_file
Google Cloud service account JSON file with credentials
-sn, --spreadsheet_name
spreadsheet name which you want to access
-wn, --worksheet_name
worksheet name which you want to access
-sql You can filter data with SQL statement. (default "SELECT * FROM your_worksheet_name")
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
googlesheets2csv-0.1.0.tar.gz
(4.2 kB
view hashes)
Built Distribution
Close
Hashes for googlesheets2csv-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fce8845e028fc9224d07d33eddfbcb3455f580105732699f214b19dfa2e46efa |
|
MD5 | 0f0d06d05aad0a0626237d285a1d32bc |
|
BLAKE2b-256 | b3ae0f711844ef6e0e202ff559fabe1803a93cb3e80025b50392e2b4f2d9c12d |