Trello sync to OmniFocus

Update: I rewrote this script as a much faster and robust JavaScript. This is hosted here on github. I will still let this original page for future reference, but the AppleScript won’t be maintained.

I love Trello.

And I love OmniFocus.

I use Trello to manage tasks and projets with my students. As soon as there are more than one person working on a project, I have a Trello board for it.

But I also have very big lists of tasks that are only mine, and for managing these lists, there is nothing like OmniFocus.

The problem is that both programs are not obvious to keep in sync, and I still want to have one place to manage my day, and this place is OmniFocus.

So I adapted a very nice applescript from Matthew Conto (thanks a lot, Matthew – https://github.com/nsh87/trello-geektool) to fetch all the Trello cards, on all my Trello boards, that are assigned to me and that are not labelled ‘Done’ or ‘Terminé’ (In French). These cards are then created as tasks in OmniFocus in a dedicated “Trello” project. The nice part of it is that if a Trello card becomes completed or is not assigned to me anymore, then it becomes completed in OmniFocus. And if it becomes not-completed or becomes again assigned to me in Trello, then is also becomes not-completed in OmniFocus. Due dates are also synced.

Okay, you need to be a little bit tech savvy to use this script, but I think it’s pretty well commented, so if you want to try it out by yourself, here it is.

You have to install “JSON Helper” before using this script : https://apps.apple.com/us/app/json-helper-for-applescript/id453114608

Good luck !

-- This script fetches for all my tasks on every board and adds them or update them in OmniFocus, in a project named Trello.
 -- For every Trello tasks that is assigned to me, an OmniFocus task is created or its status (completed/not completed) is updated. This is an unidirectional sync. Every modification must be done in Trello and  then synced to OmniFocus. Defer dates and new tags can however be assigned to the tasks in OmniFocus.
 -- Application "JSON Helper" must be installed for this script to work.
 -- https://apps.apple.com/us/app/json-helper-for-applescript/id453114608
 

 

 on ConvertURLtoTrelloApp(inURL)
 -- Convert a https://trello.com/xxxxxx url to a trello://trello.com/xxxxxx one.
 set nChars to count of inURL
 set outURL to "trello://" & characters 9 through nChars of inURL
 return outURL
 end ConvertURLtoTrelloApp
 

 

 on run
 
 -- Based on the GetTrelloCards applescript by Matthew Conto
 -- https://github.com/nsh87/trello-geektool
 
 set tagName to "Trello"
 set trelloCompletedString to {"Terminé", "Done"}
 set linkToTrelloApp to false -- Set to true to link to Trello App instead of Trello website
 
 set trelloAppKey to "PUT_YOUR_OWN_APP_KEY_HERE" -- get your key at https://trello.com/1/appKey/generate
 set trelloUserToken to "PUT_YOUR_OWN_TOKEN_HERE" -- then get your token at https://trello.com/1/authorize?key=**YOURKEY**&name=**YOURAPP**&expiration=never&response_type=token&scope=read
 
 -- NEVER POST OR COMMIT YOUR APP KEYS OR USER TOKENS ONLINE.
 -- Bad things happen to good people.
 
 set nCompletedTasks to 0
 set nOpenTasks to 0
 set nNewTasks to 0
 set newTaskNames to ""
 
 tell front document of application "OmniFocus"
 
 set allProjects to flattened projects whose name is "Trello"
 if length of allProjects is 0 then
 --Create the project
 set omnifocusToplevelProject to make new project with properties {name:"Trello"}
 else
 set omnifocusToplevelProject to first item of allProjects
 end if
 
 -- Mark all task in Trello project complete. We will update it after using information from Trello.
 tell tasks of omnifocusToplevelProject to mark complete
 set omnifocusTasks to tasks of omnifocusToplevelProject
 set nCompletedTasks to length of omnifocusTasks
 
 end tell
 
 
 
 
 tell application "JSON Helper"
 set jsonString to fetch JSON from "https://trello.com/1/members/my/cards?fields=idList,name,url,desc,labels,due,idBoard&key=" & trelloAppKey & "&token=" & trelloUserToken
 
 set nCards to count of jsonString
 repeat with iCard from 1 to nCards
 
 -- Get the ID, URL and title
 set taskID to |id| of item iCard of jsonString as string
 set taskURL to |url| of item iCard of jsonString as string
 if linkToTrelloApp is true then
 set taskURL to my ConvertURLtoTrelloApp(taskURL)
 end if
 set taskName to |name| of item iCard of jsonString as string
 set taskNote to desc of item iCard of jsonString as string
 set boardID to idBoard of item iCard of jsonString as string
 set listID to idList of item iCard of jsonString as string
 set boardURL to "https://trello.com/b/" & boardID
 set taskDue to due of item iCard of jsonString as string
 if taskDue is not "missing value" then
 -- Reformat due date
 set taskDueYear to characters 1 thru 4 of taskDue as string
 set taskDueMonth to characters 6 thru 7 of taskDue as string
 set taskDueDate to characters 9 thru 10 of taskDue as string
 set taskDue to the current date
 set the year of taskDue to taskDueYear
 set the day of taskDue to taskDueDate
 set the month of taskDue to taskDueMonth
 set the time of taskDue to 0
 else
 set taskDue to missing value
 end if
 
 -- Get board name and append it to the task name
 set jsonBoardString to fetch JSON from "https://trello.com/1/boards/" & boardID & "?fields=name,url&key=" & trelloAppKey & "&token=" & trelloUserToken
 set boardName to |name| of jsonBoardString as string
 set boardURL to |url| of jsonBoardString as string
 if linkToTrelloApp is true then
 set boardURL to my ConvertURLtoTrelloApp(boardURL)
 end if
 set taskName to "Trello - " & boardName & " - " & taskName
 
 -- Get list name and append it to the task name
 set jsonListString to fetch JSON from "https://trello.com/1/cards/" & taskID & "/list?fields=name&key=" & trelloAppKey & "&token=" & trelloUserToken
 set listName to |name| of jsonListString as string
 
 -- Check in the labels if the task is complete
 set taskComplete to false
 set nLabels to count of labels of item iCard of jsonString
 if nLabels > 0 then
 repeat with iLabel from 1 to nLabels
 set taskLabel to |name| of item iLabel of labels of item iCard of jsonString
 if trelloCompletedString contains taskLabel then
 set taskComplete to true
 end if
 end repeat
 end if
 
 -- Check the list name if the task is complete
 if trelloCompletedString contains listName then
 set taskComplete to true
 end if
 
 
 -- Search for this task in OmniFocus and update it. If it doesn't exist, create it.
 tell front document of application "OmniFocus"
 set omnifocusTasks to (tasks of omnifocusToplevelProject whose note begins with "Trello Card #" & taskID)
 if length of omnifocusTasks > 0 then
 -- The task exists
 set omnifocusTask to first item of omnifocusTasks
 set name of omnifocusTask to taskName
 else
 -- The task must be created
 tell omnifocusToplevelProject
 set omnifocusTask to make new task with properties {name:taskName, note:taskNote}
 end tell
 set nNewTasks to nNewTasks + 1
 set nCompletedTasks to nCompletedTasks + 1
 set newTaskNames to newTaskNames & "- " & taskName & "
 "
 end if
 
 -- Update the card
 set name of omnifocusTask to taskName
 set note of omnifocusTask to "Trello Card #" & taskID & "
 

 This task must be edited in Trello and not directly in OmniFocus. See below for more information.
 

 Go to the Trello board:
 " & boardURL & "
 

 Edit this task in Trello:
 " & taskURL & "
 

 " & taskNote & "
 

 -----------------------------
 

 This is an unidirectional sync. Every update must be done in Trello.
 Defer dates and tags can however be assigned to the task in OmniFocus.
 

 After editing the task in Trello, run the sync script again to reflect the changes in OmniFocus."
 
 if taskComplete is true then
 tell omnifocusTask to mark complete
 else
 set nOpenTasks to nOpenTasks + 1
 set nCompletedTasks to nCompletedTasks - 1
 tell omnifocusTask to mark incomplete
 end if
 
 set due date of omnifocusTask to taskDue
 
 end tell
 
 
 end repeat
 
 
 end tell
 
 tell application "JSON Helper" to quit
 
 display dialog "Sync complete: 
 " & nNewTasks & " new tasks
 " & newTaskNames & " 
 " & nOpenTasks & " open tasks
 " & nCompletedTasks & " completed tasks." with title "Trello importer" buttons "OK"
 
 end run