[Integration] Map & test Google Sheets integration #41

New issue

Open

opened 2026-03-23 09:38:03 -07:00 by pyr0ball · 0 comments

pyr0ball commented

2026-03-23 09:38:03 -07:00

Owner

Goal

Fully map, document, and verify the Google Sheets integration.

Checklist

Read scripts/integrations/google_sheets.py end-to-end; note every field, credential, and config key it touches
Document required credentials and how to obtain them (Google account with Sheets API enabled)
Write a short setup guide (README or inline docstring)
Verify connect() / test() roundtrip with a real account
Verify sync() produces correct output
Add/update integration test in tests/integrations/
Confirm Settings → Integrations UI saves/loads credentials correctly
Handle and surface auth errors gracefully

Library / API

Google Sheets API v4 / gspread

Notes

Part of the integration audit — ensure every integration in scripts/integrations/ is documented, tested, and works end-to-end before Paid Tier GA.

## Goal Fully map, document, and verify the **Google Sheets** integration. ## Checklist - [ ] Read `scripts/integrations/google_sheets.py` end-to-end; note every field, credential, and config key it touches - [ ] Document required credentials and how to obtain them (Google account with Sheets API enabled) - [ ] Write a short setup guide (README or inline docstring) - [ ] Verify `connect()` / `test()` roundtrip with a real account - [ ] Verify `sync()` produces correct output - [ ] Add/update integration test in `tests/integrations/` - [ ] Confirm Settings → Integrations UI saves/loads credentials correctly - [ ] Handle and surface auth errors gracefully ## Library / API Google Sheets API v4 / gspread ## Notes Part of the integration audit — ensure every integration in `scripts/integrations/` is documented, tested, and works end-to-end before Paid Tier GA.