New Version (2.4) Of Trello Scrum Backlog Upload

January 03, 2017 by Iain Brown in Trello, Javascript, Google Apps Script

There is a new version of my Trello Scrum Backlog spreadsheet available. It will now add lists if they don't exist, and can be used to just add empty lists to a board.

If you're new to the script you can find out more details here.

Trello Import From Google Spreadsheet - V2.2

November 03, 2015 by Iain Brown in Google Apps Script, Javascript, Trello, Scrum

I've updated the Trello Import spreadsheet to version 2.2 as the api it was using to create checklists is being deprecated.

Trello Backup 3.4 Supports Consumed Points

April 20, 2015 by Iain Brown in Trello, Scrum, Javascript, Google Apps Script

The Trello Backup Script has been updated to version 3.4.

This update adds support for Consumed Points in the excellent Scrum For Trello.

Trello Import From Google Spreadsheet - V2.0

January 08, 2015 by Iain Brown in AppleScript, Google Apps Script, Scrum, Trello

I've had a few requests to improve the Google spreadsheet that allows you to import data into Trello, and this has culminated in Version 2.0 of the spreadsheet.

The new version has the following improvements:

It has been converted to use the new Google Sheets.
You can specify Label names, rather than colours.
There is the ability to import any number of checklists.

Trello Backup 3.0

November 23, 2014 by Iain Brown in Trello, Google Apps Script, Javascript, Scrum

When I created the original Trello Backup a little over 2 years ago, it was primarily to ensure that we had a copy of our data, in the event that Trello was ever unavailable, but I've copied and customised it many times since then for a variety of reasons...

Flexible Trello Backup and Story Card Printing

March 22, 2014 by Iain Brown in Google Apps Script, Javascript, Scrum, Trello

...my Trello Backup Script just got a whole lot more flexible...

Add Enhanced Workflow To Trello

December 05, 2013 by Iain Brown in Javascript, Scrum, Trello

... a month ago I released a Google Apps Script that allowed you to Pimp your Trello cards by automatically adding checklists, descriptions and Google Docs (based on a template card), and assigning cost estimates to cards. I received some excellent feedback on what would improve the script and am pleased to announce that Pimp your Trello 2.0 is now available...

Automatic Trello Backups Using a Google Spreadsheet

November 12, 2013 by Iain Brown in Google Apps Script, Trello

...I posted last year about backing up the Trello Boards that we were using for our Scrum backlogs. There's been a fair amount of interest in the post, and some requests for the data to not be displayed in such as Scrum-centric manor...

Pimp Your Trello Cards

November 07, 2013 by Iain Brown in Google Apps Script, Javascript, Trello

...I therefore turned to Google Apps Script, and the Trello API to come up with the Pimp Your Trello Cards spreadsheet which has the following features:

Runs immediately (Using Webhooks) to pimp any new cards added to a board.
Runs hourly to re-pimp all cards on the board, in case any webhooks failed, or if the pimping requirements have changed.
The pimping of a card involves:
- Adding a "cost" to a card title based on the story points on the card (If you're using Scrum For Trello) - This also happens immediately if you change the card description.
- Creating (in specified folders) and then attaching multiple Google Docs.
- Adding a description (based on a template card) if it's missing (e.g. "As a I want to so that").
- Adding any missing (based on name) checklists that appear on a template card.
- Adding missing checklist items that appear on an identically named checklist on a template card.
- Removing identical checklist items that are "checked" on the template card.

Automated Trello Reporting Using Google Spreadsheets

March 20, 2013 by Iain Brown in Google Apps Script, Javascript, Trello

... I recently did some work for a client who wanted some reports that outlined changes to their Trello boards week to week, and whilst I can't share the resulting code, I thought it would be useful to share how I approached the problem...

Be Prepared

November 01, 2012 by Iain Brown in General, Scrum, Trello

...whether it's because I've experienced a natural disaster or because I spent some of my formative years in the Boy Scouts I'm not sure, but events half a world away this week have re-enforced the notion that it's good to "be prepared"...

Online Scrum Tools – Part 4 – Trello Backup

July 19, 2012 by Iain Brown in Google Apps Script, Javascript, Scrum, Trello

...As well as constantly backing up the boards, I use the spreadsheet regularly to create the story cards we use during sprint planning...

Online Scrum Tools – Part 3 – Import Backlog into Trello

July 09, 2012 by Iain Brown in Google Apps Script, Javascript, Scrum, Trello

But what if you already have an existing backlog, and don't want to spend time re-keying the entries? Well luckily, like most things in 2012, there's an App for that.

Before you get too excited, I should mention that "The App" in this case is a Google Spreadsheet, with a Google Apps Script that leverages the Trello API to import the data. It's simple, effective, and in true agile fashion, it does just enough to get the job done without unnecessary bells and whistles.