All tutorials

Google Sheets guide

How to sync Trello to Google Sheets

Keep selected Trello cards in a Google worksheet, with room for your own formulas and notes.

Board Export+ writes updates from Trello to Google Sheets. Editing a spreadsheet cell does not change Trello. Use sync for recurring reporting; choose a CSV export and manual import when you only need a one-time copy.

Before you start

Install Board Export+, open a board you can access and select Google Sheets. You need a Google account with permission to edit the destination spreadsheet, plus an active Pro trial or Pro license.

Connect your board and worksheet

1. Select Connect Google account and complete Google authorization. Return to Board Export+ to check the connection.
2. Choose Create new and name a spreadsheet, or use Select existing to choose a file in Google Picker.
3. Select a worksheet or create a new one. Start with an empty worksheet so the managed columns have the expected headers.
4. Choose the Trello fields to sync. Use the optional list and label filters to limit the active cards included.
5. Review the destination, fields and filters, confirm the review, then start the sync.
6. Wait for the initial run to complete and inspect its history. Use Sync now for another update; pause or resume automatic updates from the sync controls.

What appears in your spreadsheet

Column A holds the Trello Card ID. Columns B–I hold Card, List, Due, Done, Labels, Members, Card URL and Description. These positions stay fixed; fields you leave unchecked have empty cells. Done records the card’s due-complete flag, independently of its list name.

Download the exact sample rows as JSON. For the same board as a readable document, open the sample PDF.

Keep your formulas and notes safe

Reserve A:I for Board Export+. Put your own formulas and notes in J onward. Sync matches existing rows by Trello Card ID, updates matching cards and appends new ones. Do not change the managed headers or delete or duplicate card IDs.

Rows for cards that were deleted, archived or excluded by a filter remain in the sheet. Sync does not delete those old rows, so the worksheet is not an exact live count of the board. Pause the sync before restructuring its worksheet.

Fix common sync problems

Google asks me to reconnect

Use Connect Google account again and select the account that can edit the file. If authorization is blocked or the feature is unavailable for your account, contact support@nikaj.dev; use CSV import for an immediate one-time copy.

The worksheet headers or card IDs conflict

Restore the A:I headers and unique IDs, or choose a new empty worksheet. The sync stops when it finds conflicting IDs or headers rather than clearing your data.

A card is missing or an old row remains

Check list and label filters, card archive status and the latest completed run. Archived cards are excluded from managed rows; old rows are retained when cards stop matching.

Can I stop updates or disconnect Google?

Pause stops automatic updates. Disconnect removes stored Google credentials and pauses your syncs. Spreadsheet data already written stays in Google Sheets.

For reports you can send directly to a client, see export Trello to PDF.