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.2.tar.gz
(13.6 kB
view hashes)
Built Distribution
snapsheets-0.6.2-py3-none-any.whl
(14.7 kB
view hashes)
Close
Hashes for snapsheets-0.6.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9d297263c619f302a1ba711022026bc0f652bf945c4e9ae423bf04d1644c9038 |
|
MD5 | 675def31383d57f987dd1f1e11cd7f78 |
|
BLAKE2b-256 | 62e8af08b3e5b4d8fa16caf22e458b03fc932d83904b8680f26f4c6cd1882ef8 |