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:
- Supported fields
- How to use the Power-Up
- Connect the Power-Up to Unito
- Get the Google Sheets Add-On
- Limitations
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. 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
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.
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.
Step 2: Connect Trello and Google Sheets
When you first hit that button, you'll be taken to this screen.
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.
After connecting your tools, the Export & Sync Power-Up will start exporting your Trello board.
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.
Once it's installed, go back to the Power-Up and hit Go to your Sheet.
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.
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 doesn't this Power-Up support?
Currently, this Power-Up isn't able to export or sync data from custom fields like Date, Text, Dropdown, Numbers, or Checkbox. This Power-Up will export your entire Trello board at once, syncing only default Trello fields. It's an easy way to get Trello data into Google Sheets. Once this export is complete, you can use the standalone Unito app to add custom field support, filter out some data, and more.
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.
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.