Every 10 minutes
Run automatically on the configured schedule.
Workflow template
See overdue and upcoming tasks from several Trello boards in one Google Sheets report. Each daily refresh replaces the previous snapshot, so completed tasks disappear and rows do not accumulate.
How it works
Run automatically on the configured schedule.
Paste 1–20 Trello board links, separated by commas. The prepared Code step validates and deduplicates them, then sets a rolling seven-day window. Change Upcoming days to any whole number from 1 to 31.
Read each selected board sequentially, then collect the saved responses after the loop completes. Stop on an error so an inaccessible board cannot silently disappear from a supposedly complete report.
Use the connected Trello account to read board names, lists and open-card deadline fields. This action reads Trello without changing cards or boards.
Keep unfinished cards that are overdue or due within the next seven times 24 hours. Exclude archived lists, completed cards and missing deadlines, remove repeated card IDs, and sort by due time.
Create one dedicated spreadsheet with eight prepared headers, then reuse that same file on subsequent runs. You do not need to prepare a destination file.
Look up the report worksheet by its saved name so the refresh targets its current numeric worksheet ID.
Prepare typed cells for the complete report. Task names stay literal text, including names beginning with an equals sign. Extend the worksheet if the report needs more rows.
Apply one atomic Google Sheets batch to replace A:H and clear leftover rows. Completed or rescheduled tasks disappear on the next refresh. An empty report gets a dated No matching tasks row.
The result
| Status | Board | List | Task | Due at (UTC) | Days overdue | Card URL | Snapshot at (UTC) |
|---|---|---|---|---|---|---|---|
| Overdue | Client launch | In progress | Review landing page | 2026-11-15T09:00:00.000Z | 1 | https://trello.com/c/Example1 | 2026-11-16T09:00:00.000Z |
| Upcoming | Operations | To do | Prepare workshop materials | 2026-11-19T14:00:00.000Z | 0 | https://trello.com/c/Example2 | 2026-11-16T09:00:00.000Z |
Days overdue rounds elapsed 24-hour periods upward. Due exactly at the snapshot time counts as Upcoming. The rolling window includes its final instant; it is not a calendar-week view.
Before activation
Use a Trello account that can read every selected board. Connect the Google account that should own the report spreadsheet. Assign it to each Google Sheets action if the editor does not select it automatically.
Open Choose boards and reporting window. In Input Data, replace the empty Board links value with the normal Trello board URLs, separated by commas. Board short links and full board IDs also work. Keep Upcoming days at 7 or choose a whole number from 1 to 31.
The prepared daily schedule is 09:00 UTC. Change its time and timezone if needed. The template creates Trello cross-board deadlines with a Deadlines worksheet once; choose your preferred names before the first run.
Test using boards you control with an overdue card, an upcoming card and a completed card. Open the spreadsheet link returned by Create or reuse the report spreadsheet. After completing or rescheduling a card, run again and verify the old row disappears without a second spreadsheet or duplicate rows.
The report owns A:H. Every refresh replaces values in columns A:H of the dedicated worksheet, including its headers and any manual notes in that range. Formatting is retained. Keep personal notes outside those columns or in another worksheet. This is a current snapshot, not an append-only history.
Small and medium board sets. Choose at most 20 boards, each with fewer than 1,000 open cards, and at most 1,000 matching cards in the combined report. Provider response and aggregate size limits also apply. An archived board, malformed response, failed read or exceeded limit stops the run before updating the report; the previous snapshot remains available.
All matching tasks, with UTC dates. The report includes matching cards across the chosen boards, regardless of assignee. It excludes archived cards and lists, completed due dates and cards without deadlines. Due times and snapshot times use UTC. The default upcoming window is seven rolling 24-hour periods.
Review who can read the spreadsheet. The sheet contains task names, board and list names, deadlines and card links. Descriptions, comments, attachments and members are not copied. The workflow does not change sharing settings; opening a card link still requires Trello access.
No. The template creates one dedicated spreadsheet and its header row on the first successful run, then reuses it. Set the spreadsheet and worksheet names before the first run. The output includes a link to the file.
The report replaces the previous contents of A:H rather than appending rows. Cards that no longer match are removed on the next successful refresh, and an empty result is shown explicitly with its snapshot time. This also replaces manual values you add in that range.
The loop stops and the report is not refreshed with a partial selection. The previous spreadsheet snapshot remains. Restore access or fix the selected board link, then run the workflow again.
No. It is a scheduled Google Sheets snapshot of all matching unfinished tasks on the selected boards. It does not change Trello, filter by assignee, or provide a Gantt chart. The default upcoming window is the next seven times 24 hours, and all copied dates are UTC.
Every 10 minutes, append the scheduled time and these readings to the worksheet you choose at installation: Account time zone, Reporting currency, Account locale.
View template →Every 10 minutes, append the scheduled time and these readings to the worksheet you choose at installation: Profiles in selected list.
View template →Every 10 minutes, append the scheduled time and these readings to the worksheet you choose at installation: Leading event ID, Trading volume over the last 24 hours, Liquidity.
View template →Every 10 minutes, append the scheduled time and these readings to the worksheet you choose at installation: Upload space used this month, Monthly upload allowance.
View template →Every 10 minutes, append the scheduled time and these readings to the worksheet you choose at installation: Registered users.
View template →Every 10 minutes, append the scheduled time and these readings to the worksheet you choose at installation: Rolling seven-day requests, Delivered, Hard bounces.
View template →