Schedule logo
Trello logo
Google Sheets logo

Workflow template

Refresh a cross-board Trello deadline report in Google Sheets

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

From selected Trello boards to one current deadline report

1 Trigger · 3 Transformations · 1 Loop · 4 Actions
Schedule1 · Trigger

Every 10 minutes

Run automatically on the configured schedule.

FastHook2 · Transformation

Choose boards and reporting window

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.

FastHook3 · Loop

For each selected board

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.

Trello4 · Action

Read open cards and lists

Use the connected Trello account to read board names, lists and open-card deadline fields. This action reads Trello without changing cards or boards.

FastHook5 · Transformation

Build the current deadline report

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.

Google Sheets6 · Action

Create or reuse the report spreadsheet

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.

Google Sheets7 · Action

Find the dedicated report worksheet

Look up the report worksheet by its saved name so the refresh targets its current numeric worksheet ID.

FastHook8 · Transformation

Prepare one complete refresh

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.

Google Sheets9 · Action

Replace the deadline report

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

One deadline list across several boards

Fictional snapshot taken on November 16 at 09:00 UTC. The same worksheet is refreshed rather than appended to.
StatusBoardListTaskDue at (UTC)Days overdueCard URLSnapshot at (UTC)
OverdueClient launchIn progressReview landing page2026-11-15T09:00:00.000Z1https://trello.com/c/Example12026-11-16T09:00:00.000Z
UpcomingOperationsTo doPrepare workshop materials2026-11-19T14:00:00.000Z0https://trello.com/c/Example22026-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

Set up your workflow

  1. Connect Trello and Google Sheets

    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.

  2. Paste the board links

    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.

  3. Review the schedule and report settings

    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.

  4. Run and compare with Trello

    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.

Details and limitations
  • 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.

Questions about this template

Do I need an existing spreadsheet?

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.

Will repeated runs create duplicate rows?

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.

What happens if one board cannot be read?

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.

Is this an interactive Trello dashboard or a two-way sync?

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.