💡 New script: tasks-to-sheets (Google Tasks sync to Sheets)

[github-actions[bot]]

Summary

Syncs Google Tasks into a Google Sheet, keeping rows up to date on changes and completions. Mirrors the proven calendar-to-sheets pattern: each task becomes a row with columns for task list, title, due date, status, completion date, and notes. Enables searching, filtering, and reporting on tasks that Google Tasks itself doesn't support.

Market Signal

Google Tasks is built into Gmail and Calendar but has zero reporting, export, or history capabilities. Zapier templates for Tasks-to-Sheets exist but require paid subscriptions ($29.99/mo minimum). No open-source GAS tool syncs Tasks to Sheets with browser deployment. The calendar-to-sheets script already in this project's catalog validates that "sync X to Sheets" is a strong, proven pattern users value.

User Signal

The project's catalog follows a clear progression: take a Google Workspace service, sync its data somewhere useful, configure via browser. Calendar → Sheets exists. Gmail → Drive/Docs exists. Calendar → Email exists. Tasks → Sheets is the natural next entry that completes coverage of core Workspace services. Google Tasks has a massive but silent user base — it's integrated into Gmail and Calendar by default for every Google account.

Technical Opportunity

The Google Tasks API is available as an advanced service in Apps Script. The implementation mirrors calendar-to-sheets almost exactly: fetch task lists, convert to rows, upsert into sheet. Can reuse sanitizeValue() and rowsEqual() from calendar-to-sheets/src/index.js. Config shape: [{taskListId, spreadsheetId, sheetName}]. The deploy page needs a task list dropdown — similar to the existing calendar dropdown, fetched via the Tasks API after OAuth sign-in.

Assessment

Dimension	Score	Rationale
Feasibility	high	Mirrors calendar-to-sheets exactly; Tasks API is a standard GAS advanced service
Impact	med	Fills a gap for Tasks users; extends the "sync to Sheets" pattern; lower ceiling than email/Drive
Urgency	med	Steady demand; no competitive pressure; natural catalog expansion

Adversarial Review

Strongest objection: Google Tasks has limited adoption compared to dedicated task managers (Todoist, Asana, Things). The market may be too small to justify a new script.

Rebuttal: Tasks is pre-installed for every Gmail and Calendar user — its user base is massive, just underserved and quiet. These are exactly the users this project targets: non-technical people who use Google's built-in tools and want more out of them without paying for Zapier or learning a new task management app. The effort-to-value ratio is excellent because the implementation reuses proven patterns with minimal new code.

Suggested Next Step

Add Google Tasks API as an advanced service scope in the manifest, implement task fetching and Sheets sync in src/tasks-to-sheets/src/index.js, and add a task list dropdown to the deploy page config UI following the calendar dropdown pattern.