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.
- Supported fields
- How to use the Power-Up
- Connect the Power-Up to Unito
- Get the Google Sheets Add-On
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
- 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.
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 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.