snapsheets 1.0.0

Quick and Easy Downloader for Public Google Spreadsheets

Snapsheets

Effortlessly download public Google Spreadsheets in bulk!

Tired of downloading Google Spreadsheets one by one through your browser? Snapsheets is here to save you time and effort! With this tool, you can quickly grab multiple Google Spreadsheets straight from your terminal --- all you need is a public link to the sheets.

No more repetitive clicking. No more hassle. No auth needed. Just fast and easy spreadsheet downloading!

---

Install

$ pip3 install snapsheets

$ pipx install snapsheets

$ uv tool install snapsheets

Usage

$ snapsheets --url="copy_and_paste_url_here"
2022-06-09T08:09:31 | SUCCESS  | 🤖 Downloaded snapd/snapsheet.xlsx
2022-06-09T08:09:31 | SUCCESS  | 🚀 Renamed to snapd/20220609T080931_snapsheet.xlsx

Docs and Repository

• GitLab Pages : https://qumasan.gitlab.io/snapsheets/
• GitLab Repos : https://gitlab.com/qumasan/snapsheets/
• PyPI package : https://pypi.org/project/snapsheets/

Help

$ 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.

Examples

Book-mode: with --config argument

$ snapsheets --config="config/"
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

Sheet-mode: with --url argument

$ snapsheets --url="https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0"
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.

• Make ./config/ directory and place your TOML files.

  • If ./config/ does not exist, it will search from . (current directory).

• Downloaded files are saved to ./snapd/ directory

  • If ./snapd/ does not exit, it will be saved in . (current directory).

As module: import snapsheets

from snapsheets.sheet 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)