How to Connect Trello to Google Sheets

Trello's CSV export is a paid feature, so on free and Standard workspaces the API is not a power-user option, it is the only practical route to a spreadsheet. The good news is that it is one of the simpler APIs here. The one thing to plan for is that cards reference lists and members by ID, so a raw export is full of opaque strings unless you fetch the board's lists and members and translate them.

The paid option: CSV export

On Premium or Enterprise, open the board menu and choose Print, export and share → Export as CSV, then import into Sheets. On free and Standard workspaces only JSON export is offered, which is a raw dump rather than a table and needs processing before it is useful in a spreadsheet.

Trello to Google Sheets for free (Apps Script + API)

Get an API key from trello.com/app-key and generate a token from the manual authorisation link on that page. Both are passed as query parameters. The board ID is in the board URL, or you can call the boards endpoint to list them.

The approach that keeps this fast: fetch lists and members once per board, build lookup maps, then fetch all cards in a single call. Trello returns every card on a board in one response, so per-card requests are rarely necessary and are the main way people hit rate limits.

1function importTrelloBoard() {2  const KEY   = "YOUR_API_KEY";3  const TOKEN = "YOUR_TOKEN";4  const BOARD = "YOUR_BOARD_ID";5 6  const auth = "key=" + KEY + "&token=" + TOKEN;7  const base = "https://api.trello.com/1/boards/" + BOARD;8 9  const get = (path, extra) =>10    JSON.parse(UrlFetchApp.fetch(11      base + path + "?" + auth + (extra ? "&" + extra : ""),12      { muteHttpExceptions: true }13    ).getContentText());14 15  // Cards reference lists and members by ID, so build lookups first.16  const listNames = {};17  get("/lists").forEach((l) => { listNames[l.id] = l.name; });18 19  const memberNames = {};20  get("/members").forEach((m) => { memberNames[m.id] = m.fullName || m.username; });21 22  // Custom fields need customFieldItems=true, and their definitions live23  // separately because cards only carry field and option IDs.24  const fieldNames = {}, optionNames = {};25  get("/customFields").forEach((f) => {26    fieldNames[f.id] = f.name;27    (f.options || []).forEach((o) => { optionNames[o.id] = o.value.text; });28  });29 30  // One call returns every card on the board.31  const cards = get("/cards", "customFieldItems=true");32 33  const rows = cards.map((c) => {34    const custom = (c.customFieldItems || []).map((item) => {35      const name = fieldNames[item.idCustomField] || "field";36      const value = item.idValue37        ? optionNames[item.idValue]38        : item.value && (item.value.text || item.value.number || item.value.date);39      return name + ": " + (value || "");40    }).join("; ");41 42    return [43      c.name,44      listNames[c.idList] || c.idList,45      (c.idMembers || []).map((id) => memberNames[id] || id).join(", "),46      (c.labels || []).map((l) => l.name || l.color).join(", "),47      c.due || "",48      c.dueComplete,49      c.dateLastActivity,50      custom,51      c.shortUrl,52    ];53  });54 55  const header = ["Card","List","Members","Labels","Due","Done",56                  "Last activity","Custom fields","URL"];57  const ss = SpreadsheetApp.getActiveSpreadsheet();58  const sheet = ss.getSheetByName("Trello") || ss.insertSheet("Trello");59  sheet.clearContents();60  sheet.getRange(1, 1, 1, header.length).setValues([header]);61  if (rows.length) {62    sheet.getRange(2, 1, rows.length, header.length).setValues(rows);63  }64}

Run once to authorise, then add a time-driven trigger. Note that the cards endpoint returns open cards by default; archived ones need filter=all, which matters when you are measuring completed throughput rather than current state.

Limits: around 300 requests per 10 seconds per key and 100 per token, which board-level calls stay well inside. Very large boards return large responses, so request only the fields you need with the fields parameter if responses get unwieldy.

The Brooked method

Brooked resolves list, member, label and custom-field IDs to names automatically, so cards arrive as a readable table rather than a grid of identifiers. It works the same on free workspaces as paid ones, since it uses the API rather than the CSV export, and several boards can import into one spreadsheet on a single schedule.

Step 1: Install Brooked

Install Brooked from the Google Workspace Marketplace. Free tier includes 100 imports per month, no credit card required.

Step 2: Connect Trello

Choose Trello in Brooked and authorise your account. Pick the boards you want, choose whether to include archived cards, and import.

Step 3: Schedule the refresh

Set the import to re-run daily or weekly. Because Trello itself keeps no history of how a board looked last week, a scheduled snapshot is the simplest way to build trend data on throughput and cycle time.

Brooked AI, Trello

Live

Ask anything about your Trello data…

Method comparison

Common use cases

• Board snapshots: count cards per list over time to see whether work is piling up
• Cycle time: track how long cards sit in each stage using scheduled snapshots
• Workload: cards per member across several boards in one table
• Client reporting: share a filtered view of a board without giving board access
• Cross-board portfolio: combine multiple team boards into one status report

Troubleshooting common issues

Related Articles

• How to Connect Monday.com to Google Sheets
• How to Connect Clockify to Google Sheets
• How to Connect ClickUp to Google Sheets

Frequently asked questions