Advertisement
Guest User

deadpool wf

a guest
Jun 12th, 2025
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.20 KB | None | 0 0
  1. {
  2. "name": "deadpool",
  3. "nodes": [
  4. {
  5. "parameters": {
  6. "documentId": {
  7. "__rl": true,
  8. "value": "1oOdLgughloINf_YaHR9HMJhKjLnj3hJCI-xnkU-lTO0",
  9. "mode": "list",
  10. "cachedResultName": "deadpool",
  11. "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oOdLgughloINf_YaHR9HMJhKjLnj3hJCI-xnkU-lTO0/edit?usp=drivesdk"
  12. },
  13. "sheetName": {
  14. "__rl": true,
  15. "value": "gid=0",
  16. "mode": "list",
  17. "cachedResultName": "pool",
  18. "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oOdLgughloINf_YaHR9HMJhKjLnj3hJCI-xnkU-lTO0/edit#gid=0"
  19. },
  20. "options": {}
  21. },
  22. "type": "n8n-nodes-base.googleSheets",
  23. "typeVersion": 4.6,
  24. "position": [
  25. 20,
  26. -200
  27. ],
  28. "id": "16b486a2-6eb5-46ec-828f-92e66688db11",
  29. "name": "Google Sheets",
  30. "credentials": {
  31. "googleSheetsOAuth2Api": {
  32. "id": "URSghmjsrQrN812J",
  33. "name": "n8n sheets"
  34. }
  35. }
  36. },
  37. {
  38. "parameters": {
  39. "promptType": "define",
  40. "text": "=you are tasked with updating some data on a google sheet you will be given a list of famous people your job is to search the web using the tools provided and to return this data in the same format with the empty fields populated ,\n\nhere is how you should populate each field \n\nage:\ncurrent age of the famous person\ndead:\ntrue/false if the person is deceased\npoints:\nleave blank \nmodifier:\nif the person has or had a critical illness \ndepending on the severity you can choose to assign a score between 1 - 10 ,\n1 for something like the flu\n10 would be something like late stage cancer\nthis should be a number only, no additional text\n\nscore:\nleave blank\n{{ $json.data.toJsonString() }}\n",
  41. "hasOutputParser": true,
  42. "options": {}
  43. },
  44. "type": "@n8n/n8n-nodes-langchain.agent",
  45. "typeVersion": 2,
  46. "position": [
  47. 440,
  48. 100
  49. ],
  50. "id": "ea309361-7f01-466c-8b59-3da8b41566ab",
  51. "name": "AI Agent",
  52. "alwaysOutputData": true
  53. },
  54. {
  55. "parameters": {
  56. "model": {
  57. "__rl": true,
  58. "mode": "list",
  59. "value": "gpt-4o-mini"
  60. },
  61. "options": {}
  62. },
  63. "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
  64. "typeVersion": 1.2,
  65. "position": [
  66. 340,
  67. 320
  68. ],
  69. "id": "704a55d1-5888-470a-b08a-c3986e70eadb",
  70. "name": "OpenAI Chat Model",
  71. "credentials": {
  72. "openAiApi": {
  73. "id": "suKA95KSHigE4YhI",
  74. "name": "n8n openai"
  75. }
  76. }
  77. },
  78. {
  79. "parameters": {
  80. "options": {
  81. "prompt": "Instructions:\n--------------\n{instructions}\n--------------\nCompletion:\n--------------\n{completion}\n--------------\n\nAbove, the Completion did not satisfy the constraints given in the Instructions.\nError:\n--------------\n{error}\n--------------\n\nPlease try again. Please only respond with an answer that satisfies the constraints laid out in the Instructions:"
  82. }
  83. },
  84. "type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
  85. "typeVersion": 1,
  86. "position": [
  87. 700,
  88. 320
  89. ],
  90. "id": "e0c1b83f-2817-4378-bd6d-c824898e41c5",
  91. "name": "Auto-fixing Output Parser"
  92. },
  93. {
  94. "parameters": {
  95. "model": {
  96. "__rl": true,
  97. "mode": "list",
  98. "value": "gpt-4o-mini"
  99. },
  100. "options": {}
  101. },
  102. "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
  103. "typeVersion": 1.2,
  104. "position": [
  105. 720,
  106. 520
  107. ],
  108. "id": "0a93e20f-22af-40cb-866d-94ce7147b0bb",
  109. "name": "OpenAI Chat Model1",
  110. "credentials": {
  111. "openAiApi": {
  112. "id": "suKA95KSHigE4YhI",
  113. "name": "n8n openai"
  114. }
  115. }
  116. },
  117. {
  118. "parameters": {
  119. "jsonSchemaExample": "[\n {\n \"row_number\": 2,\n \"player\": \"nick\",\n \"choice\": \"Clint Eastwood\",\n \"age\": \"\",\n \"dead\": \"\",\n \"points\": \"\",\n \"modifier\": \"\",\n \"score\": \"\"\n }\n]"
  120. },
  121. "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
  122. "typeVersion": 1.2,
  123. "position": [
  124. 840,
  125. 520
  126. ],
  127. "id": "898c8437-7c5a-4dd9-85d0-d11b0e193bad",
  128. "name": "Structured Output Parser"
  129. },
  130. {
  131. "parameters": {
  132. "aggregate": "aggregateAllItemData",
  133. "options": {}
  134. },
  135. "type": "n8n-nodes-base.aggregate",
  136. "typeVersion": 1,
  137. "position": [
  138. 240,
  139. -200
  140. ],
  141. "id": "ba169a52-d2ea-4dc5-8be9-07b2271d63b7",
  142. "name": "Aggregate"
  143. },
  144. {
  145. "parameters": {
  146. "fieldToSplitOut": "output",
  147. "options": {}
  148. },
  149. "type": "n8n-nodes-base.splitOut",
  150. "typeVersion": 1,
  151. "position": [
  152. 740,
  153. -140
  154. ],
  155. "id": "39f39bdd-6006-43aa-a8a6-0451101aff99",
  156. "name": "Split Out"
  157. },
  158. {
  159. "parameters": {},
  160. "type": "@n8n/n8n-nodes-langchain.toolWikipedia",
  161. "typeVersion": 1,
  162. "position": [
  163. 580,
  164. 320
  165. ],
  166. "id": "a3488a8a-0d46-4eec-a17f-60e9cfb282ac",
  167. "name": "Wikipedia1"
  168. },
  169. {
  170. "parameters": {
  171. "operation": "update",
  172. "documentId": {
  173. "__rl": true,
  174. "value": "1oOdLgughloINf_YaHR9HMJhKjLnj3hJCI-xnkU-lTO0",
  175. "mode": "list",
  176. "cachedResultName": "deadpool",
  177. "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oOdLgughloINf_YaHR9HMJhKjLnj3hJCI-xnkU-lTO0/edit?usp=drivesdk"
  178. },
  179. "sheetName": {
  180. "__rl": true,
  181. "value": "gid=0",
  182. "mode": "list",
  183. "cachedResultName": "pool",
  184. "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oOdLgughloINf_YaHR9HMJhKjLnj3hJCI-xnkU-lTO0/edit#gid=0"
  185. },
  186. "columns": {
  187. "mappingMode": "defineBelow",
  188. "value": {
  189. "player": "={{ $json.player }}",
  190. "age": "={{ $json.age }}",
  191. "dead": "={{ $json.dead }}",
  192. "points": "={{ $json.points }}",
  193. "modifier": "={{ $json.modifier }}",
  194. "choice": "={{ $json.choice }}",
  195. "row_number": "={{ $json.row_number }}"
  196. },
  197. "matchingColumns": [
  198. "row_number"
  199. ],
  200. "schema": [
  201. {
  202. "id": "player",
  203. "displayName": "player",
  204. "required": false,
  205. "defaultMatch": false,
  206. "display": true,
  207. "type": "string",
  208. "canBeUsedToMatch": true
  209. },
  210. {
  211. "id": "choice",
  212. "displayName": "choice",
  213. "required": false,
  214. "defaultMatch": false,
  215. "display": true,
  216. "type": "string",
  217. "canBeUsedToMatch": true
  218. },
  219. {
  220. "id": "age",
  221. "displayName": "age",
  222. "required": false,
  223. "defaultMatch": false,
  224. "display": true,
  225. "type": "string",
  226. "canBeUsedToMatch": true
  227. },
  228. {
  229. "id": "dead",
  230. "displayName": "dead",
  231. "required": false,
  232. "defaultMatch": false,
  233. "display": true,
  234. "type": "string",
  235. "canBeUsedToMatch": true
  236. },
  237. {
  238. "id": "points",
  239. "displayName": "points",
  240. "required": false,
  241. "defaultMatch": false,
  242. "display": true,
  243. "type": "string",
  244. "canBeUsedToMatch": true
  245. },
  246. {
  247. "id": "modifier",
  248. "displayName": "modifier",
  249. "required": false,
  250. "defaultMatch": false,
  251. "display": true,
  252. "type": "string",
  253. "canBeUsedToMatch": true
  254. },
  255. {
  256. "id": "score",
  257. "displayName": "score",
  258. "required": false,
  259. "defaultMatch": false,
  260. "display": true,
  261. "type": "string",
  262. "canBeUsedToMatch": true,
  263. "removed": true
  264. },
  265. {
  266. "id": "row_number",
  267. "displayName": "row_number",
  268. "required": false,
  269. "defaultMatch": false,
  270. "display": true,
  271. "type": "string",
  272. "canBeUsedToMatch": true,
  273. "readOnly": true,
  274. "removed": false
  275. }
  276. ],
  277. "attemptToConvertTypes": false,
  278. "convertFieldsToString": false
  279. },
  280. "options": {}
  281. },
  282. "type": "n8n-nodes-base.googleSheets",
  283. "typeVersion": 4.6,
  284. "position": [
  285. 900,
  286. -140
  287. ],
  288. "id": "4e959b5c-5849-4aee-9a47-d2c2d3a40936",
  289. "name": "Google Sheets1",
  290. "credentials": {
  291. "googleSheetsOAuth2Api": {
  292. "id": "URSghmjsrQrN812J",
  293. "name": "n8n sheets"
  294. }
  295. }
  296. },
  297. {
  298. "parameters": {
  299. "rule": {
  300. "interval": [
  301. {
  302. "triggerAtHour": 9
  303. }
  304. ]
  305. }
  306. },
  307. "type": "n8n-nodes-base.scheduleTrigger",
  308. "typeVersion": 1.2,
  309. "position": [
  310. -200,
  311. -200
  312. ],
  313. "id": "e066f676-afa8-452d-ac39-3b8015464644",
  314. "name": "Schedule Trigger"
  315. },
  316. {
  317. "parameters": {
  318. "pollTimes": {
  319. "item": [
  320. {
  321. "mode": "everyHour"
  322. }
  323. ]
  324. },
  325. "documentId": {
  326. "__rl": true,
  327. "value": "1oOdLgughloINf_YaHR9HMJhKjLnj3hJCI-xnkU-lTO0",
  328. "mode": "list",
  329. "cachedResultName": "deadpool",
  330. "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oOdLgughloINf_YaHR9HMJhKjLnj3hJCI-xnkU-lTO0/edit?usp=drivesdk"
  331. },
  332. "sheetName": {
  333. "__rl": true,
  334. "value": "gid=0",
  335. "mode": "list",
  336. "cachedResultName": "pool",
  337. "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oOdLgughloINf_YaHR9HMJhKjLnj3hJCI-xnkU-lTO0/edit#gid=0"
  338. },
  339. "options": {}
  340. },
  341. "type": "n8n-nodes-base.googleSheetsTrigger",
  342. "typeVersion": 1,
  343. "position": [
  344. -200,
  345. 0
  346. ],
  347. "id": "b3c3d36d-24fa-4932-9336-9c39aa45c667",
  348. "name": "Google Sheets Trigger",
  349. "credentials": {
  350. "googleSheetsTriggerOAuth2Api": {
  351. "id": "B0cQOmnQ0GEIIwC1",
  352. "name": "Google Sheets Trigger account"
  353. }
  354. }
  355. },
  356. {
  357. "parameters": {
  358. "sessionIdType": "customKey",
  359. "sessionKey": "deadpool",
  360. "databaseName": "deadpoolchat"
  361. },
  362. "type": "@n8n/n8n-nodes-langchain.memoryMongoDbChat",
  363. "typeVersion": 1,
  364. "position": [
  365. 460,
  366. 320
  367. ],
  368. "id": "b2cdc507-f942-4f46-95d6-10224cda190d",
  369. "name": "MongoDB Chat Memory",
  370. "credentials": {
  371. "mongoDb": {
  372. "id": "WWhQi5jdjFDvNas0",
  373. "name": "MongoDB account"
  374. }
  375. }
  376. }
  377. ],
  378. "pinData": {},
  379. "connections": {
  380. "Google Sheets": {
  381. "main": [
  382. [
  383. {
  384. "node": "Aggregate",
  385. "type": "main",
  386. "index": 0
  387. }
  388. ]
  389. ]
  390. },
  391. "OpenAI Chat Model": {
  392. "ai_languageModel": [
  393. [
  394. {
  395. "node": "AI Agent",
  396. "type": "ai_languageModel",
  397. "index": 0
  398. }
  399. ]
  400. ]
  401. },
  402. "Auto-fixing Output Parser": {
  403. "ai_outputParser": [
  404. [
  405. {
  406. "node": "AI Agent",
  407. "type": "ai_outputParser",
  408. "index": 0
  409. }
  410. ]
  411. ]
  412. },
  413. "OpenAI Chat Model1": {
  414. "ai_languageModel": [
  415. [
  416. {
  417. "node": "Auto-fixing Output Parser",
  418. "type": "ai_languageModel",
  419. "index": 0
  420. }
  421. ]
  422. ]
  423. },
  424. "Structured Output Parser": {
  425. "ai_outputParser": [
  426. [
  427. {
  428. "node": "Auto-fixing Output Parser",
  429. "type": "ai_outputParser",
  430. "index": 0
  431. }
  432. ]
  433. ]
  434. },
  435. "Aggregate": {
  436. "main": [
  437. [
  438. {
  439. "node": "AI Agent",
  440. "type": "main",
  441. "index": 0
  442. }
  443. ]
  444. ]
  445. },
  446. "AI Agent": {
  447. "main": [
  448. [
  449. {
  450. "node": "Split Out",
  451. "type": "main",
  452. "index": 0
  453. }
  454. ]
  455. ]
  456. },
  457. "Wikipedia1": {
  458. "ai_tool": [
  459. [
  460. {
  461. "node": "AI Agent",
  462. "type": "ai_tool",
  463. "index": 0
  464. }
  465. ]
  466. ]
  467. },
  468. "Split Out": {
  469. "main": [
  470. [
  471. {
  472. "node": "Google Sheets1",
  473. "type": "main",
  474. "index": 0
  475. }
  476. ]
  477. ]
  478. },
  479. "Schedule Trigger": {
  480. "main": [
  481. [
  482. {
  483. "node": "Google Sheets",
  484. "type": "main",
  485. "index": 0
  486. }
  487. ]
  488. ]
  489. },
  490. "Google Sheets Trigger": {
  491. "main": [
  492. [
  493. {
  494. "node": "Aggregate",
  495. "type": "main",
  496. "index": 0
  497. }
  498. ]
  499. ]
  500. },
  501. "MongoDB Chat Memory": {
  502. "ai_memory": [
  503. [
  504. {
  505. "node": "AI Agent",
  506. "type": "ai_memory",
  507. "index": 0
  508. }
  509. ]
  510. ]
  511. }
  512. },
  513. "active": false,
  514. "settings": {
  515. "executionOrder": "v1"
  516. },
  517. "versionId": "5162ed6d-2abe-4bc5-adbb-931c48b303b8",
  518. "meta": {
  519. "templateCredsSetupCompleted": true,
  520. "instanceId": "9034845b6bdc6c0c4308f692312da9ec6921b2d28e50fa5f7c73b559a07dcac5"
  521. },
  522. "id": "SgYDspB2J1b1aJih",
  523. "tags": []
  524. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement