A Guide to the Export & Sync Power-Up for Trello

Export & Sync can export an entire Trello board to Google Sheets and keep data up-to-date in both apps. Here's how it works.

Jump to:

What does the Export & Sync Power-Up for Trello do?

Unito's Export & Sync Power-Up for Trello is designed to help you get the most out of your Trello reports as quickly and efficiently as possible.

Get the Export & Sync Power-Up for Trello. If you're a Trello user, it's already included in your Unito plan!

You can use it to export Trello data into Google Sheets directly and then build automated reports that always show the latest Trello updates in real-time. That's because this Power-Up is more than just an export tool; it keeps everything in sync, too.

Here are the Trello fields you can export to Google Sheets:

  • Link to card

  • Title

  • Description

  • Board name

  • Start date

  • Updated at

  • Due date

  • Label

  • List

  • Status

  • All custom fields, including Date, Text, Dropdown, Numbers, and Checkbox.

Got feedback? Submit a Unito feature request to let us know what you'd like to see in the next update to Export & Sync!

How do I use the Export & Sync Power-Up?

Step 1: Get the Power-Up

The first thing you need to do is find Unito's Export & Sync Power-Up on Trello's Power-Up Marketplace and add it to the Trello board you want to export.

Frame 12

Once you've added the Power-Up, you'll see an Export & Sync button on your Trello board. Click on it to start your first export.

Frame 11

Step 2: Connect Trello and Google Sheets

When you first hit that button, you'll be taken to this screen.

Frame 22

From here, you'll pick the Trello board you want to export and connect your Google account. Export & Sync will automatically create a new Google Sheet for your export.

After adding your Google account, you'll be asked to give permission to Unito for Google Sheets to change data in your Google Sheets. This is essential for your export to work properly.

Frame 23

After connecting your tools, the Export & Sync Power-Up will start exporting your Trello board.

Frame 26

Step 3: Add the Unito for Google Sheets add-on

This is the last step to finish your export! Go to the Unito-add on for Google Sheets — which will keep your data updated as changes happen in Trello — and install it.

Unito add on

Once it's installed, go back to the Power-Up and hit Go to your Sheet.

export and sync ready

After hitting that button, you'll be taken to the spreadsheet where your Trello data will be exported. Click on Extensions to activate the Unito add-on.

export and sync extension

Then hit the blue Complete your export button.


And you're done!

Step 4: Use your new data!

Now all your Trello data is in Google Sheets! Your new spreadsheet will be created at the root of your Google Drive, and will be kept updated in real time by the Power-Up.

What does that mean?

Any time a new Trello card is created on your board, it'll be synced over to Google Sheets, where a new row will be created too. Update a field in Trello and it'll be updated in Google Sheets, too. But while you can edit rows in Google Sheets and see those changes reflected in Trello, new Trello cards won't be created when you create a new row in Google Sheets. That way, you don't have to worry about stakeholders and other collaborators accidentally creating duplicate cards from your reports.

And since all your Trello data is in Google Sheets, you can use all the Google Sheets features you're used to for data visualization and analysis. You can use pivot tables, sparklines, and charts to create beautiful reports that will always be up to date.

Limitations of this Power-Up (and other things to keep in mind)

While this Power-Up is the best way to export Trello data to Google Sheets and keep it all in sync, there are a few things you can't do with it (yet!):

What happens if I stop the export halfway?

If you leave the Power-Up while creating your export, you won't be able to come back to it later unless you use the standalone Unito app.

Updating cells in header rows

If you need to update the cells in your header row, you'll have to update the field mappings in Unito to match. Otherwise, your flow will stop syncing any cells in a column with an updated header.

Can I edit an export?

You won't be able to make changes to an export in the Power-Up after creating it. But if you go to the standalone Unito app, you'll find a Unito flow corresponding to your export, which can be edited. Here's how that works.

Got feedback? Submit a Unito feature request to let us know what you'd like to see in the next update to Export & Sync.