Weekly Google Tasks Archive to Google Sheets (Auto Cleanup)

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.

Additional information

What does this prompt do?

Runs automatically every Friday at 5pm and walks every one of your Google Tasks lists.
Pulls each task that was completed during the past week, including its title, list name, completion date, original due date, and notes.
Appends a new row for every completed task into a dedicated archive tab in your Google Sheet, grouped by list.
Clears the completed tasks from each list once the rows are safely written, so you start the next week with a clean slate.

What do I need to use this?

A Google account with Google Tasks (the same one you use day to day).
A Google Sheet you want to use as the archive, with a tab ready for the rows.
A few minutes to connect your Google account when you first save the workflow.

How can I customize it?

Change the schedule. Run it daily at end of day, monthly on the last Friday, or any other cadence.
Add or remove columns in the archive. Common additions include the task ID, parent task, or a link back to the task.
Limit which lists get archived, for example only personal lists or only a specific work list.

Frequently asked questions

Will my completed tasks be deleted forever?

No. Each task is written into your Google Sheet first, then cleared from the list. Cleared tasks are hidden in the Google Tasks UI but the rows in your sheet are your permanent record.

What if I have several task lists?

The workflow handles every list you have. It loops through each one, archives that list's completed items, and then clears that list before moving on.

Can I send the archive somewhere other than Google Sheets?

Yes. After you generate the workflow you can swap the Google Sheets step for Notion, Airtable, or a CSV email instead. The Google Tasks side stays the same.

What happens if no tasks were completed this week?

The workflow finishes cleanly with nothing written and nothing cleared. You will not get empty rows or duplicate archives.

Does this work with shared task lists?

Yes, as long as the Google account you connect can see the list. The workflow uses the same access you have inside Google Tasks.