Weekly Google Tasks archive to Sheets

Build a deterministic code-based workflow that archives my completed Google Tasks into a Google Sheet every week and then clears them, so my task lists stay clean. No reasoning steps, no LLM calls. Every node is a discrete API action with a fixed flow.

Trigger: cron, every Friday at 5pm in my local timezone.

Inputs I should be able to configure on the workflow: (1) the Google Sheets spreadsheet ID, (2) the name of the archive tab inside that spreadsheet, and (3) the timezone used to compute the week window. Default the week window to the last 7 days ending at the trigger fire time.

Flow:

1. Call Google Tasks → List Task Lists to enumerate every task list on my account. Paginate until done.

2. For each task list returned, call Google Tasks → List Tasks with showCompleted=true, showHidden=false, and the completedMin / completedMax parameters set to the start and end of the current week window in RFC 3339. Paginate. Keep only tasks where status is completed.

3. For each completed task, build a row with these columns in this order: completion date (YYYY-MM-DD), task title, list name, original due date (YYYY-MM-DD or blank), notes, task ID. If the list returned zero completed tasks, skip steps 4 and 5 for that list.

4. Call Google Sheets → Append Values once per list, writing all rows for that list into the configured archive tab. Use valueInputOption=USER_ENTERED so dates render nicely. The append should land after the last existing row of the table on that tab.

5. After the append for a list succeeds, call Google Tasks → Clear Completed Tasks on that same list to hide the completed items. Do NOT clear a list if its append failed.

Error handling: if List Task Lists or List Tasks fails, abort the run and surface the error. If Append Values fails for a specific list, log the error, skip the clear step for that list, and continue with the remaining lists. The next run will pick up anything that was not archived because nothing got cleared.

The archive tab should already exist; do not create or rename it. Assume the first row is a header row and the workflow only appends data rows underneath.