Question

How to export data from Trello to Airtable?

  • 25 May 2021
  • 5 replies
  • 320 views

Hi, I’m trying to setup a one-way sync where a user can press a button and grab all the current Trello board data and paste it into Airtable. Is there a way to automate this with Zapier? I see there’s automated triggers with Trello like activity, but I would rather it be controlled to something like a button a user hits. And I can’t figure out after the trigger happens how to get the data from trello to airtable because the systems don’t talk unless I put one as the trigger?

 

Thanks for any advice!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Userlevel 7
Badge +14

Hi @Daniel H 

FYI: Most Zap app integrations work on a per record basis, rather than for bulk records.

I think it’d be helpful if you further defined the project requirements. (For example, what Trello data points?)

Trello Help Articles about Exporting data:

https://help.trello.com/article/747-exporting-data-from-trello-1

https://trello.com/power-ups/5c9418019e56bd8abf98d83f/board-export-excel-csv-pdf

thanks man, that info helps. we already can get the trello data (card name, dates, descriptions) manually into airtable, but were hoping to automate it somehow. 

Userlevel 7
Badge +14

@Daniel H 

Trello has these available Zap triggers: https://zapier.com/apps/trello/integrations#triggers-and-actions

I think it’d be helpful if you further defined the project requirements for what Trello trigger should then send data to Airtable.

For example, try putting your project requirements into this template.

Zap Steps

  1. Trigger: [APP] - [EVENT]
  2. Action: [APP] - [EVENT]

 

We were hoping to trigger it with either a time or button. If we trigger it with activity it would happen too often because our data is constantly being updated.

Userlevel 7
Badge +14

@Daniel H 

There are a few factors that would impact the ideal solution.

  1. Depends on the frequency in which you’d be wanting to transfer data from Trello to Airtable
  2. Volume of Trello Cards

As mentioned before, most Zap app integrations work on a per record basis, rather than for bulk records.

 

Trello has export capabilities as indicated above.

Airtable has a CSV import app: https://support.airtable.com/hc/en-us/articles/115013249187-CSV-import-app

 

With what you’re seeking, you may have to venture into Trello/Airtable APIs.

OR you may determine that it’s not worth over engineering a solution for something that can be done manually infrequently via a defined process.