用 Todoist 的 UI 将数据输入到notion数据库页面和/或页面块中
{
"name": "Todoist to Notion",
"nodes": [
{
"parameters": {},
"name": "Start",
"type": "n8n-nodes-base.start",
"typeVersion": 1,
"position": [
250,
300
]
},
{
"parameters": {
"conditions": {
"string": [],
"number": [
{
"value1": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"project_id\"]}}",
"operation": "equal",
"value2": 2267354620
}
]
}
},
"name": "if idea",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
929,
707
]
},
{
"parameters": {
"conditions": {
"string": [],
"number": [
{
"value1": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"project_id\"]}}",
"operation": "equal",
"value2": 2267354621
}
]
}
},
"name": "if question",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
930,
850
]
},
{
"parameters": {
"httpMethod": "POST",
"path": "todoist",
"options": {}
},
"name": "New Todoist Task Added",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
100,
860
],
"webhookId": "5076b20d-431d-4dd2-9a9a-d3a9fea1c018"
},
{
"parameters": {
"conditions": {
"string": [],
"number": [
{
"value1": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"project_id\"]}}",
"operation": "equal",
"value2": 2267354598
}
]
}
},
"name": "if Issue",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
930,
980
]
},
{
"parameters": {
"authentication": "oAuth2",
"operation": "delete",
"taskId": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"id\"]}}"
},
"name": "Remove Task!",
"type": "n8n-nodes-base.todoist",
"typeVersion": 1,
"position": [
1590,
930
],
"credentials": {
"todoistOAuth2Api": "Todoist Integration API"
}
},
{
"parameters": {
"action": "hmac",
"type": "SHA256",
"value": "={{JSON.stringify($node[\"New Todoist Task Added\"].json[\"body\"])}}",
"secret": "da26bbbb61c240619b834120b0ab679a",
"encoding": "base64"
},
"name": "Crypto",
"type": "n8n-nodes-base.crypto",
"typeVersion": 1,
"position": [
270,
860
]
},
{
"parameters": {},
"name": "NoOp",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
1100,
1760
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{$node[\"Crypto\"].json[\"data\"]}}",
"value2": "={{$node[\"New Todoist Task Added\"].json[\"headers\"][\"x-todoist-hmac-sha256\"]}}"
}
]
}
},
"name": "IF",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
420,
860
]
},
{
"parameters": {
"conditions": {
"string": [],
"number": [
{
"value1": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"project_id\"]}}",
"operation": "equal",
"value2": 2267354612
}
]
}
},
"name": "if Grocery",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
930,
1120
]
},
{
"parameters": {
"resource": "block",
"blockId": "9a15c50bd1854c96b8f7c1a711f942ec",
"blockUi": {
"blockValues": [
{
"type": "to_do",
"textContent": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"content\"]}}"
}
]
}
},
"name": "Add to Grocery List",
"type": "n8n-nodes-base.notion",
"typeVersion": 1,
"position": [
1160,
1120
],
"credentials": {
"notionApi": "Todoist to Notion Databases"
}
},
{
"parameters": {
"resource": "databasePage",
"databaseId": "e1e83c2a-9df3-4d31-98ef-0bafcd6e5084",
"propertiesUi": {
"propertyValues": [
{
"key": "Title|title",
"title": "={{$json[\"title\"]}}"
},
{
"key": "Issue|rich_text",
"textContent": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"description\"]}}"
},
{
"key": "Status|select",
"selectValue": "bbe3c0ce-7ec5-4ef7-acac-b9aa78f5620d"
}
]
}
},
"name": "Add to Issues DB",
"type": "n8n-nodes-base.notion",
"typeVersion": 1,
"position": [
1160,
970
],
"credentials": {
"notionApi": "Todoist to Notion Databases"
}
},
{
"parameters": {
"resource": "databasePage",
"databaseId": "bc1719ce-a7c7-4ed9-ab2a-18fe0885f49e",
"propertiesUi": {
"propertyValues": [
{
"key": "Tite|title",
"title": "={{$json[\"title\"]}}"
},
{
"key": "Question|rich_text",
"textContent": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"description\"]}}"
},
{
"key": "Status|select",
"selectValue": "7d6c5754-3c34-4028-bb7f-35a863491a23"
}
]
}
},
"name": "Add to Notion DB",
"type": "n8n-nodes-base.notion",
"typeVersion": 1,
"position": [
1160,
820
],
"credentials": {
"notionApi": "Todoist to Notion Databases"
}
},
{
"parameters": {
"resource": "databasePage",
"databaseId": "223c5bed-5e44-457f-a0ef-52634f365e74",
"propertiesUi": {
"propertyValues": [
{
"key": "Title|title",
"title": "={{$json[\"title\"]}}"
},
{
"key": "Idea|rich_text",
"textContent": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"description\"]}}"
},
{
"key": "Status|select",
"selectValue": "6faf66bc-ccb8-4a31-97ca-9c40c6f83736"
}
]
}
},
"name": "Add to Ideas DB",
"type": "n8n-nodes-base.notion",
"typeVersion": 1,
"position": [
1160,
670
],
"credentials": {
"notionApi": "Todoist to Notion Databases"
}
},
{
"parameters": {
"conditions": {
"string": [],
"number": [
{
"value1": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"project_id\"]}}",
"operation": "equal",
"value2": 2267354637
}
]
}
},
"name": "if Shopping",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
930,
1290
]
},
{
"parameters": {
"resource": "block",
"blockId": "5b10ab6887e54825a03473b6888608ae",
"blockUi": {
"blockValues": [
{
"type": "to_do",
"textContent": "={{$json[\"title\"]}}"
},
{
"textContent": "=\t{{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"description\"]}}"
}
]
}
},
"name": "Add to Shopping List",
"type": "n8n-nodes-base.notion",
"typeVersion": 1,
"position": [
1150,
1300
],
"credentials": {
"notionApi": "Todoist to Notion Databases"
}
},
{
"parameters": {
"resource": "databasePage",
"databaseId": "edd3fd7f-5967-4a12-8aa3-619712fac833",
"propertiesUi": {
"propertyValues": [
{
"key": "Name|title",
"title": "={{$json[\"title\"]}}"
}
]
}
},
"name": "Add to Notes DB",
"type": "n8n-nodes-base.notion",
"typeVersion": 1,
"position": [
1150,
1480
],
"credentials": {
"notionApi": "Todoist to Notion Databases"
}
},
{
"parameters": {
"conditions": {
"string": [],
"number": [
{
"value1": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"project_id\"]}}",
"operation": "equal",
"value2": 2267354627
}
]
}
},
"name": "if Notes",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
940,
1480
]
},
{
"parameters": {
"functionCode": "// Code here will run only once, no matter how many input items there are.\n// More info and help: https://docs.n8n.io/nodes/n8n-nodes-base.function\n\nconst toTitleCase = (str) => {\n const articles = ['a', 'an', 'the'];\n const conjunctions = ['for', 'and', 'nor', 'but', 'or', 'yet', 'so'];\n const prepositions = [\n 'with', 'at', 'from', 'into','upon', 'of', 'to', 'in', 'for',\n 'on', 'by', 'like', 'over', 'plus', 'but', 'up', 'down', 'off', 'near'\n ];\n\n // The list of spacial characters can be tweaked here\n const replaceCharsWithSpace = (str) => str.replace(/[^0-9a-z&/\\\\]/gi, ' ').replace(/(\\s\\s+)/gi, ' ');\n const capitalizeFirstLetter = (str) => str.charAt(0).toUpperCase() + str.substr(1);\n const normalizeStr = (str) => str.toLowerCase().trim();\n const shouldCapitalize = (word, fullWordList, posWithinStr) => {\n if ((posWithinStr == 0) || (posWithinStr == fullWordList.length - 1)) {\n return true;\n }\n\n return !(articles.includes(word) || conjunctions.includes(word) || prepositions.includes(word));\n }\n\n str = replaceCharsWithSpace(str);\n str = normalizeStr(str);\n\n let words = str.split(' ');\n if (words.length <= 2) { // Strings less than 3 words long should always have first words capitalized\n words = words.map(w => capitalizeFirstLetter(w));\n }\n else {\n for (let i = 0; i < words.length; i++) {\n words[i] = (shouldCapitalize(words[i], words, i) ? capitalizeFirstLetter(words[i], words, i) : words[i]);\n }\n }\n\n return words.join(' ');\n}\n\n// Loop over inputs and add a new field called 'myNewField' to the JSON of each one\nfor (item of items) {\n item.json.title = toTitleCase($item(0).$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"content\"]);\n}\n\nreturn items;"
},
"name": "Function2",
"type": "n8n-nodes-base.function",
"typeVersion": 1,
"position": [
620,
850
]
},
{
"parameters": {
"resource": "block",
"blockId": "={{$json[\"id\"]}}",
"blockUi": {
"blockValues": [
{
"textContent": "={{$node[\"New Todoist Task Added\"].json[\"body\"][\"event_data\"][\"description\"]}}"
}
]
}
},
"name": "Notion",
"type": "n8n-nodes-base.notion",
"typeVersion": 1,
"position": [
1330,
1480
],
"credentials": {
"notionApi": "Todoist to Notion Databases"
}
}
],
"connections": {
"if idea": {
"main": [
[
{
"node": "Add to Ideas DB",
"type": "main",
"index": 0
}
],
[
{
"node": "NoOp",
"type": "main",
"index": 0
}
]
]
},
"if question": {
"main": [
[
{
"node": "Add to Notion DB",
"type": "main",
"index": 0
}
],
[
{
"node": "NoOp",
"type": "main",
"index": 0
}
]
]
},
"New Todoist Task Added": {
"main": [
[
{
"node": "Crypto",
"type": "main",
"index": 0
}
]
]
},
"if Issue": {
"main": [
[
{
"node": "Add to Issues DB",
"type": "main",
"index": 0
}
],
[
{
"node": "NoOp",
"type": "main",
"index": 0
}
]
]
},
"Crypto": {
"main": [
[
{
"node": "IF",
"type": "main",
"index": 0
}
]
]
},
"IF": {
"main": [
[
{
"node": "Function2",
"type": "main",
"index": 0
}
],
[
{
"node": "NoOp",
"type": "main",
"index": 0
}
]
]
},
"if Grocery": {
"main": [
[
{
"node": "Add to Grocery List",
"type": "main",
"index": 0
}
],
[
{
"node": "NoOp",
"type": "main",
"index": 0
}
]
]
},
"Add to Grocery List": {
"main": [
[
{
"node": "Remove Task!",
"type": "main",
"index": 0
}
]
]
},
"Add to Issues DB": {
"main": [
[
{
"node": "Remove Task!",
"type": "main",
"index": 0
}
]
]
},
"Add to Notion DB": {
"main": [
[
{
"node": "Remove Task!",
"type": "main",
"index": 0
}
]
]
},
"Add to Ideas DB": {
"main": [
[
{
"node": "Remove Task!",
"type": "main",
"index": 0
}
]
]
},
"if Shopping": {
"main": [
[
{
"node": "Add to Shopping List",
"type": "main",
"index": 0
}
],
[
{
"node": "NoOp",
"type": "main",
"index": 0
}
]
]
},
"Add to Shopping List": {
"main": [
[
{
"node": "Remove Task!",
"type": "main",
"index": 0
}
]
]
},
"Add to Notes DB": {
"main": [
[
{
"node": "Notion",
"type": "main",
"index": 0
}
]
]
},
"if Notes": {
"main": [
[
{
"node": "Add to Notes DB",
"type": "main",
"index": 0
}
]
]
},
"Function2": {
"main": [
[
{
"node": "if idea",
"type": "main",
"index": 0
},
{
"node": "if question",
"type": "main",
"index": 0
},
{
"node": "if Issue",
"type": "main",
"index": 0
},
{
"node": "if Grocery",
"type": "main",
"index": 0
},
{
"node": "if Shopping",
"type": "main",
"index": 0
},
{
"node": "if Notes",
"type": "main",
"index": 0
}
]
]
},
"Notion": {
"main": [
[
{
"node": "Remove Task!",
"type": "main",
"index": 0
}
]
]
}
},
"active": true,
"settings": {
"saveExecutionProgress": true,
"saveDataSuccessExecution": "all"
},
"id": 4
}