How to import cards into Trello using Google Sheets

TECHWEBEXTENSIONSTRELLOTUTORIAL

Is it possible to import cards into Trello from a spreadsheet, complete with card descriptions and members assigned? Yes, and here’s how to do just that.

This approach uses Trello’s handy email to board feature.

Ingredients:

  • A Trello board to work with
  • The email address of the list you want to import to
  • A Google Sheet
  • The Yet Another Mail Merge (YAMM) add-on for Google Sheets
  • Gmail

Directions:

To get started, head into the settings of your Trello board and copy the email address for the list you want to import your cards to.

Next, create a new Google Sheet with the following columns starting with email, title, members and description.

Under the email header paste the email address you copied from Trello earlier. You’ll want to fill that down for as many cards are you plan to import.

Each row on the sheet will import into Trello as a new card. Next, fill in as many rows on the sheet as you need. Under the members header you only need to enter the @username of the person you want the card assigned to. Of course, the person has to be a member of the board to begin with.

Alright, once you’ve got all of this done, from your Google Sheet click Add-ons and search for Yet Another Mail Merge. Install it and authorize it to connect with your Google Account. Before heading to Gmail, copy the title, members and description headers to your clipboard.

In Gmail, compose a new message. Hit Ctrl + Shift + v to paste the plain text into the body of your email. Now, wrap the headers with two angle brackets on either side. Like this, <<title>>, <<members>> and <<description>>.

Select <<title>> and <<members>> and drag it to the subject line of your Draft message. Your email should look like this.

YAMM Gmail Draft

Now, let’s head back to our Google Sheet and start the Mail Merge. Click Add-ons, YAMM and Start Mail Merge.

Give it a couple of moments before you start seeing the cards trickle into Trello.

Caveats:

  1. YAMM allows you to send up to 100 emails a day. That means you can import 100 cards into Trello for free. If you need more, consider supporting the developer for a higher send limit.

  2. The order in which you list your rows for your Trello cards isn’t preserved. I’d be well out of my depth if I tried to explain it. Suffice to say, don’t get attached to the order in which your cards appear, or be prepared to reorder them if needed.

  3. Lastly, things change and so this approach may not work at anytime. Google might update their API for Google Sheets or Gmail, Trello might do something at their end and its possible the YAMM add-on may not be maintained. It might break is what I’m saying. Hopefully it doesn’t.