Turns each planned project in Notion into an Asana task with a subtask for every step, and never sends the same project twice.
Uses
Asana
Notion
Break planned projects into Asana tasks and subtasks
Run every 2 hours.Run every 2 hours.
Set notionDatabaseId to blank.Set notionDatabaseId to blank.Set asanaProjectIds to blank.Set asanaProjectIds to blank.Set plannedProjects to an empty list.Set plannedProjects to an empty list.
If a step below fails, save the error as notionErrorIf a step below fails, save the error as notionErrorTry
NotionFind pages in notionDatabaseId. Save it as plannedWork.Find pages in notionDatabaseId. Save it as plannedWork.
Change plannedProjects to plannedWork.results.Change plannedProjects to plannedWork.results.On error
Set notionFailure to Could not read that Notion database: notionError.message.Set notionFailure to Could not read that Notion database: notionError.message.Set notionAdvice to Check the id in the 'notionDatabaseId' step, that the database is shared with your Notion connection, and that it has a text property named exactly 'Asana task'..Set notionAdvice to Check the id in the 'notionDatabaseId' step, that the database is shared with your Notion connection, and that it has a text property named exactly 'Asana task'..
Stop and report a problem: notionFailure plus notionAdvice.Stop and report a problem: notionFailure plus notionAdvice.Set createdCount to 0.Set createdCount to 0.
For each projectRow in plannedProjects:For each projectRow in plannedProjects:Set projectName to blank.Set projectName to blank.If a step below fails, save the error as titleErrorIf a step below fails, save the error as titleErrorTry
Trim projectRow.title and save it as projectName.Trim projectRow.title and save it as projectName.On error
Change projectName to blank.Change projectName to blank.
If projectName is emptyIf projectName is emptyYes
Show in the output: Skipped a row in the Notion database because it has no title, so there is nothing to call the Asana task..Show in the output: Skipped a row in the Notion database because it has no title, so there is nothing to call the Asana task..No
Set stepsText to blank.Set stepsText to blank.If a step below fails, save the error as stepsErrorIf a step below fails, save the error as stepsErrorTry
Trim projectRow.properties.Steps and save it as stepsText.Trim projectRow.properties.Steps and save it as stepsText.On error
Change stepsText to blank.Change stepsText to blank.Split stepsText with ; replaced by "Split stepsText with ; replaced by
by a new line and save it as stepLines.Set steps to an empty list.Set steps to an empty list.Set stepsListed to 0.Set stepsListed to 0.For each stepLine in stepLines:For each stepLine in stepLines: Trim stepLine and save it as stepName. Trim stepLine and save it as stepName. If stepName isn't empty If stepName isn't emptyYes
Add 1 to stepsListed.Add 1 to stepsListed.If the length of steps is less than 15If the length of steps is less than 15Yes
Add stepName to the end of steps and save it as steps.Add stepName to the end of steps and save it as steps.No
No steps
No
No steps
If steps is emptyIf steps is emptyYes
Show in the output: Left the Notion row '@projectName' for a later run: its 'Steps' property is empty, so there are no steps to break it into yet.Show in the output: Left the Notion row '@projectName' for a later run: its 'Steps' property is empty, so there are no steps to break it into yet.No
If stepsListed is greater than 15If stepsListed is greater than 15Yes
Show in the output: The Notion row '@projectName' lists stepsListed steps; only the first 15 became subtasks. Add the rest in Asana by hand.Show in the output: The Notion row '@projectName' lists stepsListed steps; only the first 15 became subtasks. Add the rest in Asana by hand.No
No steps
Set dueDate to blank.Set dueDate to blank.If a step below fails, save the error as dueDateErrorIf a step below fails, save the error as dueDateErrorTry
Trim projectRow.properties["Due date"] and save it as dueValue.Trim projectRow.properties["Due date"] and save it as dueValue.Get the first item of the first item of dueValue split by a space split by T and save it as dueDay.Get the first item of the first item of dueValue split by a space split by T and save it as dueDay.If the length of dueDay is 10 and dueDay contains -If the length of dueDay is 10 and dueDay contains -Yes
Change dueDate to dueDay.Change dueDate to dueDay.No
No steps
On error
Change dueDate to blank.Change dueDate to blank.Set projectLink to blank.Set projectLink to blank.If a step below fails, save the error as linkErrorIf a step below fails, save the error as linkErrorTry
Trim projectRow.url and save it as projectLink.Trim projectRow.url and save it as projectLink.On error
Change projectLink to blank.Change projectLink to blank.Set taskNotes to Broken out of your Notion planning database..Set taskNotes to Broken out of your Notion planning database..If projectLink isn't emptyIf projectLink isn't emptyYes
Change taskNotes to Broken out of your Notion planning database: projectLink.Change taskNotes to Broken out of your Notion planning database: projectLink.No
No steps
Set parentTaskId to blank.Set parentTaskId to blank.If a step below fails, save the error as createErrorIf a step below fails, save the error as createErrorTry
AsanaCreate task projectName. Save it as createdTask.Create task projectName. Save it as createdTask.
Due date: dueDatetaskNotesTrim createdTask.gid and save it as parentTaskId.Trim createdTask.gid and save it as parentTaskId.On error
Show in the output: Could not create the Asana task for the Notion row '@projectName': createError.message The row was left unmarked, so it is picked up again on the next run.Show in the output: Could not create the Asana task for the Notion row '@projectName': createError.message The row was left unmarked, so it is picked up again on the next run.If parentTaskId isn't emptyIf parentTaskId isn't emptyYes
For each step in steps:For each step in steps: If a step below fails, save the error as subtaskError If a step below fails, save the error as subtaskErrorTry
AsanaCreate subtask step under task parentTaskId.Create subtask step under task parentTaskId.On error
Set subtaskFailure to Created the Asana task for '@projectName' but could not add the subtask '@step': subtaskError.message.Set subtaskFailure to Created the Asana task for '@projectName' but could not add the subtask '@step': subtaskError.message.Set subtaskAdvice to The run stopped there and the Notion row was left unmarked, so this project is built again from scratch on the next run - delete the half-built task in Asana first..Set subtaskAdvice to The run stopped there and the Notion row was left unmarked, so this project is built again from scratch on the next run - delete the half-built task in Asana first..Stop and report a problem: subtaskFailure plus subtaskAdvice.Stop and report a problem: subtaskFailure plus subtaskAdvice.If a step below fails, save the error as writeBackErrorIf a step below fails, save the error as writeBackErrorTry
NotionUpdate projectRow.Update projectRow.Add 1 to createdCount.Add 1 to createdCount.On error
Set writeBackFailure to Broke the Notion row '@projectName' out into Asana but could not record the task id on that row: writeBackError.message.Set writeBackFailure to Broke the Notion row '@projectName' out into Asana but could not record the task id on that row: writeBackError.message.Set writeBackAdvice to The run stopped there rather than send the rest of the database across twice. Check that the database has a text property named exactly 'Asana task' that Lodol is allowed to edit..Set writeBackAdvice to The run stopped there rather than send the rest of the database across twice. Check that the database has a text property named exactly 'Asana task' that Lodol is allowed to edit..Stop and report a problem: writeBackFailure plus writeBackAdvice.Stop and report a problem: writeBackFailure plus writeBackAdvice.No
No steps
Show in the output: Broke createdCount planned project(s) out of Notion into Asana tasks with subtasks.Show in the output: Broke createdCount planned project(s) out of Notion into Asana tasks with subtasks.