Getting tired of downloading Google Spreadsheets one by one from the browser ?
Project description
Snapsheets
Getting tired of downloading Google Spreadsheets one by one from the browser ?
This package enables to wget Google Spreadsheets without login. (Spreadsheets should be shared with public link)
Where to get it
$ pip3 install snapsheets
Usage
$ snapsheets -h
usage: snapsheets [-h] [--config CONFIG] [--url URL] [--debug] [--version]
options:
-h, --help show this help message and exit
--config CONFIG set config directory (default: ./config/)
--url URL copy and paste an URL of the Google spreadsheet
--debug show more messages
--version show program's version number and exit
- Use
--url
option to download single spreadsheet. - Use
--config
option to download multiple spreadsheets.- create a directory for config files.
- create a config file in TOML format.
Documents
Examples
with --url
option
$ snapsheets --url="https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0"
2022-06-09T08:09:30 | WARNING | Directory varlogs not found. Switch to current directory.
2022-06-09T08:09:31 | SUCCESS | 🤖 Downloaded snapd/snapsheet.xlsx
2022-06-09T08:09:31 | SUCCESS | 🚀 Renamed to snapd/20220609T080931_snapsheet.xlsx
- Downloaded file is temporarily named as
snapsheet.xlsx
, then renamed with current-time based prefix.
with --config
option
$ snapsheets --config="config/"
2022-06-09T08:05:47 | WARNING | Directory varlogs not found. Switch to current directory.
2022-06-09T08:05:48 | SUCCESS | 🤖 Downloaded snapd/snapsheet.xlsx
2022-06-09T08:05:48 | SUCCESS | 🚀 Renamed to snapd/2022_toml_sample1.xlsx
2022-06-09T08:05:49 | SUCCESS | 🤖 Downloaded snapd/snapsheet.xlsx
2022-06-09T08:05:49 | SUCCESS | 🚀 Renamed to snapd/20220609_toml_sample3.csv
- Make
./config/
directory and place your TOML files.- If
./config/
does not exist, it will search from. (current directory)
.
- If
- Downloaded files are saved to
./snapd/
directory- If
./snapd/
does not exit, it will be saved in. (current directory)
.
- If
with module import
>>> from snapsheets import Sheet
>>> url = "https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0"
>>> sheet = Sheet(url=url, desc="Get Sample Sheet")
>>> sheet.snapshot()
📣 Get Sample Sheet
🤖 Downloaded snapd/snapsheet.xlsx
🚀 Renamed to snapd/20220602T225044_snapsheet.xlsx
Other requirements
- Install
wget
if your system doesn't have them - Make your spreadsheet available with shared link (OK with read-only)
PyPI package
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
snapsheets-0.6.1.tar.gz
(13.4 kB
view hashes)
Built Distribution
snapsheets-0.6.1-py3-none-any.whl
(14.6 kB
view hashes)
Close
Hashes for snapsheets-0.6.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b4a0eec0e095dbb3cecd0cc5ff24ed6f71befbe70c9dd2c31414696df8fdc86c |
|
MD5 | 5c67e33e5b5c64dd9ff20bbf1fd96a41 |
|
BLAKE2b-256 | c4f58bfdf03883c24e9622204a48f97f073efe8385520bc7d4497d23def8e603 |