Featured image illustrating a step-by-step guide on syncing Trello to Google Sheets through Unito, depicted by the connected logos through circles and dotted lines.
How To Quickly Export Trello Cards to Google Sheets With 2-Way Updates
Featured image illustrating a step-by-step guide on syncing Trello to Google Sheets through Unito, depicted by the connected logos through circles and dotted lines.

How To Quickly Export Trello Cards to Google Sheets With 2-Way Updates

These step-by-step instructions will show you how to connect Trello with Google Sheets through Unito in order to sync cards to spreadsheet rows. This simple 2-way integration will help you streamline project management, reporting, and data tracking by aligning key information from your Trello board(s) to a spreadsheet.

Whether you’re trying to sync new or historical (existing) Trello cards, you’ll learn how to automatically translate them into organized data in Google Sheets.

Note: If you’re looking for information about Unito’s Export & Sync Power-Up, visit this article instead.

How do Trello cards become rows in Google Sheets?

You’ll tell Unito which Trello fields to sync to Google Sheets and associate them with columns. That means you need to set up a table header (the first row) in Google Sheets with names for each column to pair with your Trello fields.

The names don’t have to be the same, you just need to know which columns you want to match with fields in Trello (e.g., title, description, member etc.)

When you sync Trello to Google Sheets with Unito, your rows will represent Trello cards and your columns will represent fields (e.g., card title, member, labels, etc.).

Before we export Trello cards to Google Sheets rows:

Add Unito to your Trello Board (optional)

This step is for users who wish to add Unito as a Power-Up to an existing Trello board. You can skip this process if you’ve already installed Unito or you’ve logged in directly to our app.

Otherwise, click here if you need help adding Unito as a Trello Power-Up. Just don’t forget to come back to this guide!

Add a row header to your spreadsheet

Your Trello card fields (attachment, description, due date, etc.) will be linked to Google Sheets columns through the row header.

How to autopopulate your spreadsheet’s header row:

Auto-populate your header row and fields with Unito

Unito Spreadsheet Sync now allows you to automatically populate a header row in a blank spreadsheet by selecting import from Unito Spreadsheet Sync.

After you insert two columns into a blank sheet, click Create Flow from within Unito Spreadsheet Sync and Import data from the tool of your choice. When you create a flow this way, you’ll be given an option to auto-populate your row header.

Autopopulate

So, before syncing, you can either name each cell in the first row manually, or have Unito auto-populate your spreadsheet header row.

A table header or header row in Google Sheets. The first row tells Unito how to identify fields from Trello
Each cell in the first row represents a field for Unito. 

If you haven’t figured out what kind of data you want to sync to your spreadsheet, we created this Google Sheets template you can use to get started.

Install the Unito Spreadsheet Sync Extension

From the Google Workspace Marketplace you can install Unito Spreadsheet Sync, a necessary Google Sheets add-on, in order to sync your spreadsheets with Trello.

If you need help setting it up, follow these instructions:

How to install Unito Spreadsheet Sync in your Google Workspace

Install Unito Spreadsheet Sync in order to connect your spreadsheet to Trello.

You can find more detailed steps on this process here.

When you’re ready, select the Unito add-on, then Open Unito, and Insert the two columns in this sheet.

Whether you do this automatically or manually, the first and last rows in your spreadsheet must be titled: “UnitoID” and “Last Modified”. Only data between those two columns will sync with Unito.

Step 1. Connect Trello and Google Sheets to Unito

  • Navigate to the Unito App and select +Create Flow.
  • Next, select Start Here to connect Trello and Google Sheets.
  • Choose the accounts you want connected to Unito.
  • Then, select the Trello board and Google Sheet you want to sync.
Connecting Trello accounts and Google Sheets to Unito

If you haven’t yet installed Unito Spreadsheet Sync, you’ll be prompted to do so at this stage. You can get the extension from the Google Workspace Marketplace.

(optional) Set a date/time format for your spreadsheet

You can adjust the date-time format in your spreadsheet to any format you wish.

  1. Open your sheet and select the column with your dates.
  2. Then click Format > Number > Custom date and time.
  3. From there you can choose the format you wish and apply it to all the cells in your date columns.
Screenshot of setting the date time format in Google Sheets for a Unito sync

When you’re ready, click Confirm.

Step 2. Set a Flow Direction between Trello and Google Sheets

Flow direction determines how new rows or cards are created but not modified. We’ll determine how cards and rows will be modified later on.

Setting a flow direction between Trello and Google Sheets with Unito

NOTE: Here’s a breakdown of each option:

  • One-way from Trello to Google Sheets: cards created in your Trello Board will appear as new rows in the connected sheet, but not vice versa.
  • One-way from Google Sheets to Trello: Rows created in your connected sheet will appear as new cards in your Trello board, but not vice versa.
  • Two-way sync: Any new sheet rows or cards created in their respective tools will appear in the other (rows as cards, and cards as rows).

Click Confirm when you’ve chosen a flow direction. 

Step 3. Set up rules to filter data between Trello and Google Sheets

Now we can set up rules to determine which trigger events will send data between our tools.

Select Add a new trigger to establish your rules for each directional flow.

NOTE: These triggers are intended to help you keep only the most relevant information in sync to avoid oversharing unnecessary details. There can be a lot of variability here that will depend on your particular needs and tool setup. By customizing your Trello labels, you can be even more precise about what kind of data is shared with Google Sheets.

Set up rules to filter data between Trello and Google Sheets

For this demo, we’ve told the system to create a matching row in Google Sheets for every card in our Trello board with a green label which we’ve named “in progress” that was created after our chosen date.

We’ll also set rules to create a new, matching card in Trello for every row in our selected sheet that was created on or after the selected date.

Find out more about setting rules.

Step 4. Choose field mappings between cards and rows

At this screen, select Start from scratch. For most tools, Unito can auto-map similar field types (e.g., title to title), but since every field in Google Sheets is a custom field, we have to link up our fields manually.

This image has an empty alt attribute; its file name is Asana-master-project-mappings-method-selection.png

Click +Add mapping to select a Trello card field and a matching Google Sheets field to keep in sync. This is where the fields you created in your row header will appear in Unito.

In our demo, we’ve given one of our columns the same name to keep things simple. Click Select a field for each tool, and find the appropriate field to map. See below for an example:

Choose field mappings between Trello cards and Google Sheets rows

Click Confirm when you’re satisfied with your field mappings to proceed.

Note: If you change a column name in a synced spreadsheet, be sure to update your flow’s field mappings in Unito or else your data will stop syncing.

Find out more about setting field mappings.

Step 5. Save, close, and launch your connected Trello-Google Sheets workflow!

If you’ve followed the steps above, your flow will now create a row in Google Sheets whenever a new card is added in Trello based on the rules we set up.

If you have any questions, don’t hesitate to reach out and let us know.

Call-to-action block - Sign up and create your first Trello + Google Sheets flow in a few steps.

Learn more about this flow:

Read our overviews of Trello and Google Sheets to better understand the limits and capabilities of each.

Read about our internal Trello – Google Sheets use case.

What can you do after syncing Trello and Google Sheets?

  • Populate a spreadsheet with Trello card details, including: title, member, label, due date, status, description footer, checklists, and custom fields.
  • Create new cards in Trello based on Google Sheets rows with specified fields.

Unito’s integrations are all code-free, meaning you don’t need a dedicated IT team or professional services to implement anything. You can do it all yourself just by following this guide.

Syncing cards to rows will save valuable time by eliminating manual input for business and data reporting, project management, customer tracking and more. You can even set rules to tell Unito which cards should (or should not) become spreadsheet rows.

Frequently Asked Questions about Unito’s Trello Google Sheets Integration

Why export Trello cards to Google Sheets with Unito?

This setup not only saves significant time by eliminating manual data entry but also enhances your business reporting, project management, and customer tracking processes. We’ll also show you how to create custom rules based on Trello fields – like labels or assignees – to control which cards get synced. And while we focus on Trello and Google Sheets here, the same principles apply to other Unito integrations with spreadsheet tools.

Review project progress, report to stakeholders or share updates

There are a number of valuable use cases for this workflow: you can use it to review project progress from your spreadsheet, build a report for stakeholders, or simply share Trello updates with other teams using a simplified, yet flexible Google Sheet.

Automating this process saves you the time it takes to manually copy and paste card details into your sheet. By connecting Trello and Google Sheets with Unito, you eliminate the need to jump back and forth between tabs to double-check your data since everything will be automatically kept up-to-date in real-time.

Can Unito integrate Trello with Google Sheets?

Yes! Unito can integrate Google Sheets with Trello through our standalone sync platform, or embedded in Trello with our Board Sync Power-Up or the new Export & Sync Power-Up to sync card data to spreadsheets in just a few clicks!

How do I sync my Trello boards?

If you’d like to connect Trello boards together with Unito, simply follow the steps in this integration walkthrough for Trello users.

How do I create a spreadsheet from Trello?

Unito can’t create new spreadsheets from Trello, although you can tell Unito to create new Trello boards for your 2-way integrations in the connect tool step. But you’ll have to set up a spreadsheet manually before importing Trello project data automatically with Unito. Just make sure your header row includes the names of each Trello field.

How do I power-up E in Trello?

Unito’s Board Sync Power-Up enables integrating Google Sheets and Trello to link cards with Google Sheets rows for your reporting workflow. Unito also supports Microsoft Excel, Airtable, Notion and many other reporting and database tools.

How do I import data from Trello to Google Sheets?

You can integrate Google Sheets and Trello to Unito with the steps outlined above. A Unito flow is able to automatically keep spreadsheets up-to-date with the latest data from Trello with individual cards synced to spreadsheet rows. The easiest method for importing data from entire Trello boards to Google Sheets is with the Export & Sync Trello Power-Up.

What can Unito and Trello sync with?

Unito can sync Trello to Google Sheets, Microsoft Excel, Outlook, Asana, Wrike, Airtable, Salesforce, GitHub, GitLab, Azure DevOps, Notion, ClickUp, Google Calendar, Jira and many others. Here’s a full list of Unito’s integrations.

What’s next after syncing Google Sheets and Trello?