Automated Python solution to backup Google Sheets from your Google Drive and save them directly to a mapped network drive on Windows.

• 🔐 Secure authentication with Google Drive API (OAuth2)
• 🔍 Filter and list all Google Sheets files
• ⬇️ Download as Excel (.xlsx) or CSV formats
• 💾 Save backups to mapped network drives (e.g., Z:\Backups\GoogleSheets)
• 🕒 Automate using Windows Task Scheduler

git clone https://github.com/PBreno/backup_google_sheets.git
cd backup_google_sheets

python -m venv venv
venv\Scripts\activate

pip install -r requirements.txt

1. Visit the Google Cloud Console.
2. Enable the Google Drive API.
3. Create OAuth 2.0 credentials (Desktop app).
4. Download the credentials.json file. On the first run, token.json will be generated after you authenticate. `

python src\public\main.py

Feel free to fork the repo, submit issues, or create pull requests!
All contributions are welcome!

Maintained by @PBreno
For any questions, please open an issue.