Google Sheets + Trello Integration

Query from Trello into Google Sheets  or Post data from Google Sheets into Trello

What is Sheet Director?

Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho, PayPal, etc. 

It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on. 

What is Trello?

Trello is a terrific tool for project management and task management. The visual Kanban boards are flexible, shareable, and let you pack a ton of detail into each card. But Trello isn't just for work. You can use it to organize just about anything, perhaps your entire life 

Trello to Google Sheets: Use Case(s)

> Pull data from Trello objects and store it into a spreadsheet - Query

> Post data from Google Sheets into Trello - Post


Sheet Director

Google Sheets

Setting up Trello in Sheet Director

Choose App and Service:

Trello Configuration

Destination Settings:

Scheduler Settings:

Notification Settings:

Google Sheet to Trello - Post


Apply Template

Source Sheet

(the default value is A1, if you change the value you need to refresh the header by clicking on refresh icon on side)


Sample Output

It will show the counts of number of records posted successfully and failed to post.

Synchronize - Trello and Google Sheets

Synchronize settings:

Synchronization Keys:

The keys will be used for matching rows in Google Sheets with data in Trello.

Conflict Resolution:

Trello Wins: Latest data from Trello will be updated in Google Sheets.

Google Sheet Wins: Latest data from Google Sheets will be updated in Trello.

Note: The primary requirement in synchronization is the synchronize keys. If any of the keys does not have a value in the Google Sheet, Sheet Director will create it first and then the service will be executed.

Trello Wins

Select Trello wins under Synchronize Settings

Here the Trello Board name is updated from "Personal Improvements and tracking" to "Personal Improvements, Progress and tracking", and on execution, this data will be updated in Google Sheets.

Synchronize with Sheet Settings

Click Execute to execute the data.

Sample Output

Google Sheet Wins

Synchronize with Sheet Settings

Click Execute to execute the data.

Sample Output