Planned · on the roadmap

Live spreadsheets for Trello

Sheets is coming to Trello: your tasks, issues and time as live tables that formulas, pivot tables and charts read directly, without exports.

  • Spreadsheet formulas
  • Pivot tables and charts
  • Scheduled e-mail reports
Planned reports

What you will build on Trello

Each is one formula on live data. These are examples of the syntax: the column names will follow Trello's own fields once the integration ships.

=data.issues.count(id, assignee, A2, status, "<>Done")
Workload by person. Open items and estimated hours per assignee.
=data.issues.count(id, project, A2, due, "<"&TODAY())
Cross-project status. One table of every project with its open, overdue and done counts.
=data.issues.avg(cycle_days, project, A2)
Cycle time. Average days from start to done, per project or type.
The data

Tables from Trello

Issues or tasks · Projects · Sprints · Assignees · Worklogs

How it will run

Your data stays in Trello

Sheets will open inside Trello, as an app in its own interface, and read your data through Trello's API with your permission. We plan to list it in the Trello Power-Ups Directory.

Want it?

Vote for Sheets for Trello

A thumbs up moves Trello up the roadmap. Leave your e-mail address too and we write once, when it ships.

We use your details only to answer you. Privacy policy

FAQ

Questions

Is Sheets for Trello available?

Not yet. Trello is on the Sheets roadmap. Give it a thumbs up and leave your e-mail address on this page: we tell you when it is ready, and the votes decide what we build next.

What will Sheets read from Trello?

Your tasks, issues and time, as tables: Issues or tasks, Projects, Sprints, Assignees, and Worklogs. Each table becomes a data source that formulas, pivot tables and charts read live.

Will Sheets change anything in Trello?

It is planned read-only: Sheets reads your Trello data and does not change it.

What works today?

Sheets works today with QuickBooks Online, Xero, Shopify, WooCommerce, BigCommerce, HubSpot, FreshBooks, monday.com, and Asana.

Want Sheets for Trello?

Requests decide what we build next. We write once, when it is ready.

85 tools on the integrations page