|
e78ccbea-1e92-42ee-bdce-06ab8ec22868
|
mxxAEjU7oSwhgMr4
|
Damon Hess
|
2025-12-05 06:23:22.517000
|
2025-12-05 06:23:22.517000
|
[{"parameters":{"method":"POST [{"parameters":{"method":"POST","url":"rapidapi.com","sendHeaders":true,"headerParameters":{"parameters":[{"name":"X-RapidAPI-Host","value":"home-depot-product-lookup.p.rapidapi.com"},{"name":"Content-Type","value":"application/json"},{"name":"X-RapidAPI-Key","value":"dc94ea3acbmshb75d467367b8913p190ceejsn2a639985e561"}]},"sendBody":true,"bodyParameters":{"parameters":[{"name":"action","value":"product-lookup"},{"name":"productId","value":"PRODUCT_ID"},{"name":"zip","value":"ZIP_CODE"}]},"options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[208,0],"id":"ab7362b3-bb73-4d9b-90eb-ae573339f8b6","name":"HTTP Request"},{"parameters":{"formTitle":"Product","formFields":{"values":[{"fieldLabel":"Product Id","requiredField":true},{"fieldLabel":"Zip code","requiredField":true}]},"options":{}},"type":"n8n-nodes-base.formTrigger","typeVersion":2.3,"position":[0,0],"id":"cf652ef7-054a-4d78-954b-8dcfec50ea17","name":"On form submission","webhookId":"e78e0570-65a9-4f78-9e01-004f760b3cc3"}]...
|
{"On form submission":{"main":[[]] {"On form submission":{"main":[[]]}}...
|
NULL
|
False
|
NULL
|
Edit
Delete
|
|
0af25fff-0a54-44ec-9818-5d416754690f
|
cb9k410KbuopXxP5
|
Damon Hess
|
2025-11-30 23:18:22.358000
|
2025-11-30 23:18:22.358000
|
[{"parameters":{"html":"<!D [{"parameters":{"html":"<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n <meta charset=\"UTF-8\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n <title>Success</title>\n</head>\n<body style=\"margin: 0; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, sans-serif; background-color: #f0f2f5; display: flex; align-items: center; justify-content: center; height: 100vh;\">\n\n <!-- The main success card -->\n <div style=\"background-color: #ffffff; padding: 40px 50px; border-radius: 12px; box-shadow: 0 5px 25px rgba(0, 0, 0, 0.1); text-align: center; max-width: 400px; margin: 20px;\">\n\n <!-- Circular Green Checkmark -->\n <div style=\"width: 100px; height: 100px; background-color: #28a745; border-radius: 50%; margin: 0 auto 25px auto; display: flex; align-items: center; justify-content: center;\">\n <span style=\"color: white; font-size: 60px; line-height: 1;\">✔</span>\n </div>\n\n <!-- Main Text -->\n <h1 style=\"font-size: 36px; font-weight: 600; color: #333; margin: 0 0 10px 0;\">\n Success!\n </h1>\n\n <!-- Call to Action Text & Link -->\n <p style=\"font-size: 16px; color: #555; line-height: 1.5; margin: 0;\">\n To go further, you can\n </p>\n <p style=\"font-size: 16px; color: #555; line-height: 1.5; margin: 0;\">\n <a href=\"https://n8n.io/creators/lucaspeyrin\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"color: #007bff; text-decoration: none; font-weight: 500;\">check out more templates</a>.\n </p>\n\n </div>\n\n</body>\n</html>"},"id":"03466e9d-3ab1-4966-85ce-2d7ca73be9e2","cid":"Ikx1Y2FzIFBleXJpbiI","name":"🎉 SUCCESS 🎉","type":"n8n-nodes-base.html","creator":"Lucas Peyrin","position":[3344,256],"notesInFlow":true,"typeVersion":1.2,"notes":"Well done! You're awesome\n\n© 2025 Lucas Peyrin"},{"parameters":{"content":"### Step 2: Number\n\nModify the **\"Test - Number\"** node.\n\n**Task:** Create a JSON object with two keys:\n- `product_id` with the number `12345`\n- `price` with the decimal number `99.99`\n\n\n","height":508,"width":300,"color":6},"id":"d344cb00-9c2e-42c6-8aa2-894ae00aad89","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Instruction - Number","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-896,-64],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"❌ **Incorrect.**\n\n**Hint:** Numbers must not be in quotes. Check both the integer and the decimal value.","height":320,"color":7},"id":"02338032-53a6-4ce9-850d-217262c8955c","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Incorrect2","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-384,320],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"### Step 3: Boolean\n\nModify the **\"Test - Boolean\"** node.\n\n**Task:** Create a JSON object with two keys:\n- `is_active` with the value `true`\n- `has_permission` with the value `false`\n\n\n","height":700,"width":316,"color":6},"id":"ffd42371-8853-4a71-9c06-2a134c0688a2","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Instruction - Boolean","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-80,-144],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"is_active\": ,\n \"has_permission\": \n}\n","options":{}},"id":"eb3255ea-05b9-4a6b-86f3-e9c5d2c3581b","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Test - Boolean","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[32,256],"typeVersion":3.4,"disabled":true,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"d4e5f6a7-8901-2345-6789-0abcdef12345","operator":{"type":"boolean","operation":"equals"},"leftValue":"={{ $json.is_active }}","rightValue":true},{"id":"e5f6a789-0123-4567-890a-bcdef1234567","operator":{"type":"boolean","operation":"equals"},"leftValue":"={{ $json.has_permission }}","rightValue":false}]},"options":{}},"id":"7b780aa3-4457-4da5-a06d-6f70ad5dba73","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Check - Boolean","type":"n8n-nodes-base.if","creator":"Lucas Peyrin","position":[288,256],"typeVersion":2.2,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"✅ **Correct!**\n\nNow for the `null` value.","height":272,"color":7},"id":"062a73e6-c3df-4b2a-861e-35f29b96d158","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Correct3","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[448,32],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{},"id":"526a03c3-3a56-417c-8dd2-9da57d7f974b","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Success - Boolean","type":"n8n-nodes-base.noOp","creator":"Lucas Peyrin","position":[512,144],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"❌ **Incorrect.**\n\n**Hint:** Boolean values are `true` or `false` and must be written without any quotes.","height":320,"color":7},"id":"e2ffbe80-4971-4c8b-819c-8dec6006ac21","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Incorrect3","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[448,320],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"errorMessage":"Incorrect Boolean. Hint: Boolean values are `true` or `false` and must be written without any quotes."},"id":"3460ed6e-8337-44ec-8e53-3271aeb2364b","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Error - Boolean","type":"n8n-nodes-base.stopAndError","creator":"Lucas Peyrin","position":[512,496],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"is_active\": true,\n \"has_permission\": false\n}\n","options":{}},"id":"87e94f97-ac20-40eb-a312-6548a94bce55","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer - Boolean","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[32,720],"typeVersion":3.4,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"### Step 4: Null\n\nModify the **\"Test - Null\"** node.\n\n**Task:** Create a JSON object with a key `middle_name` whose value is explicitly nothing, or `null`.\n\n\n","height":492,"width":316,"color":6},"id":"2aaa3035-b500-448b-a575-07a7a48baa93","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Instruction - Null","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[736,-32],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"middle_name\": \n}\n","options":{}},"id":"6daa619e-f117-4dcf-9b63-d42859ef98b7","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Test - Null","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[848,256],"typeVersion":3.4,"disabled":true,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"e1234567-890a-bcde-f123-456789012345","operator":{"type":"any","operation":"isEmpty"},"leftValue":"={{ $json.middle_name }}"},{"id":"93811b17-9736-4f3a-bd69-0b297e6f7684","operator":{"type":"string","operation":"notExists","singleValue":true},"leftValue":"={{ $json.middle_name }}","rightValue":""}]},"options":{}},"id":"4b33b60c-7942-4adc-89df-ea51703e2f0a","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Check - Null","type":"n8n-nodes-base.if","creator":"Lucas Peyrin","position":[1104,256],"typeVersion":2.2,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"✅ **Correct!**\n\nExcellent. Time for arrays.","height":272,"color":7},"id":"8a330712-4375-47c7-9bdd-99a2fc540768","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Correct4","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[1264,32],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{},"id":"d72d23f7-137f-4549-8b1e-446f0e78558c","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Success - Null","type":"n8n-nodes-base.noOp","creator":"Lucas Peyrin","position":[1328,144],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"errorMessage":"Incorrect Null. Hint: The `null` value represents 'nothing' and is written as `null` without quotes."},"id":"e33c61f4-b8c8-460a-9b48-6b6be2c37526","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Error - Null","type":"n8n-nodes-base.stopAndError","creator":"Lucas Peyrin","position":[1328,496],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"middle_name\": null\n}\n","options":{}},"id":"9af951e5-fe25-48a5-9431-18420e26fc95","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer - Null","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[848,624],"typeVersion":3.4,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"### Step 5: Array\n\nModify the **\"Test - Array\"** node.\n\n**Task:** Create a JSON object with a key `tags` which is an array containing:\n- The string `'n8n'`\n- The string `'automation'`\n- The number `2024`\n\n\n","height":530,"width":300,"color":6},"id":"6760c97f-fae5-49ca-b0af-f36f7a092e6a","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Instruction - Array","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[1584,-96],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"tags\": \n}\n","options":{}},"id":"36db5a45-ff8f-4396-a11d-c7addc3a57bd","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Test - Array","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[1696,256],"typeVersion":3.4,"disabled":true,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"b0123456-7890-abcd-ef12-345678901234","operator":{"type":"string","operation":"equals"},"leftValue":"={{ $json.tags[0] }}","rightValue":"n8n"},{"id":"c1234567-890a-bcde-f123-456789012345","operator":{"type":"string","operation":"equals"},"leftValue":"={{ $json.tags[1] }}","rightValue":"automation"},{"id":"d2345678-90ab-cdef-1234-567890123456","operator":{"type":"number","operation":"equals"},"leftValue":"={{ $json.tags[2] }}","rightValue":2024}]},"options":{}},"id":"eacdd7b2-91c5-47c0-b005-998fe64bab58","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Check - Array","type":"n8n-nodes-base.if","creator":"Lucas Peyrin","position":[1920,256],"typeVersion":2.2,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"✅ **Correct!**\n\nAlmost there. Last one: objects.","height":272,"color":7},"id":"c29876bd-7e4a-4d8c-8226-c6ada47834cf","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Correct5","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[2096,32],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{},"id":"da17dc1e-13b5-4bd1-a144-55afe7c398c7","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Success - Array","type":"n8n-nodes-base.noOp","creator":"Lucas Peyrin","position":[2160,144],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"❌ **Incorrect.**\n\n**Hint:** Check the order of items, data types (string vs number), and the syntax: `[` `]` `,`.","height":320,"color":7},"id":"1ecf52f2-11db-453c-8023-8e1fb6b4a8b1","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Incorrect5","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[2096,320],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"errorMessage":"Incorrect Array. Hint: Check the order of items, data types (string vs number), and the syntax: `[` `]` `,`."},"id":"9b70c397-639d-4b83-b4ee-c5255534a0d5","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Error - Array","type":"n8n-nodes-base.stopAndError","creator":"Lucas Peyrin","position":[2160,496],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"tags\": [\"n8n\", \"automation\", 2024]\n}\n","options":{}},"id":"85fa0b2f-843f-48d6-a702-1d0e3245c82f","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer - Array","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[1696,608],"typeVersion":3.4,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"### Step 6: Object\n\nModify the **\"Test - Object\"** node.\n\n**Task:** Create a JSON object with a key `user`. Its value should be *another object* with two keys:\n- `name` (string: `'Alex'`)\n- `id` (number: `987`)\n\n\n","height":482,"width":316,"color":6},"id":"5c6e431e-3f47-47e4-97d1-0504a882a856","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Instruction - Object","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[2384,-48],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"user\": \n}\n","options":{}},"id":"211d5076-1909-4776-877e-91836c35842c","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Test - Object","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[2496,256],"typeVersion":3.4,"disabled":true,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"a1234567-890a-bcde-f123-456789012345","operator":{"type":"string","operation":"equals"},"leftValue":"={{ $json.user.name }}","rightValue":"Alex"},{"id":"b2345678-90ab-cdef-1234-567890123456","operator":{"type":"number","operation":"equals"},"leftValue":"={{ $json.user.id }}","rightValue":987}]},"options":{}},"id":"ebf8e605-de2d-4bee-a767-a7f23f751c79","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Check - Object","type":"n8n-nodes-base.if","creator":"Lucas Peyrin","position":[2752,256],"typeVersion":2.2,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"✅ **YOU DID IT!**","height":240,"color":7},"id":"a4a1a786-03e6-497d-b64f-a59fbd3ab511","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Correct6","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[2912,64],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{},"id":"ed215a97-6a87-40b8-9137-62889703ab71","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Success - Object","type":"n8n-nodes-base.noOp","creator":"Lucas Peyrin","position":[2976,144],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"❌ **Incorrect.**\n\n**Hint:** Remember to wrap the inner object in curly braces `{}` and check the data types inside it.","height":320,"color":7},"id":"970a3746-4ace-4189-a6f9-2f47c908333d","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Incorrect6","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[2912,320],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"errorMessage":"Incorrect Object. Hint: Remember to wrap the inner object in curly braces `{}` and check the data types inside it."},"id":"77e0c6a0-17e8-426b-9663-333439ae4bd0","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Error - Object","type":"n8n-nodes-base.stopAndError","creator":"Lucas Peyrin","position":[2976,496],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"user\": {\n \"name\": \"Alex\",\n \"id\": 987\n }\n}\n","options":{}},"id":"4aa1ae1f-93de-4768-b384-de3c296f0b5f","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer - Object","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[2496,608],"typeVersion":3.4,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"🎉 **Congratulations! You've passed the test!**\n\nYou have successfully demonstrated your understanding of all the basic JSON data types.\n\nYou are now ready to work with data in n8n.\n\n-- Well done! --","height":576,"width":416,"color":4},"id":"b031ad09-27fb-4a7a-904b-bd53e6b4107e","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Congratulations!","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[3184,64],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"### Step 1: The String\n\nModify the **\"Test - String\"** node below.\n\n**Task:** Create a JSON object with a single key named `my_string` whose value is the text `I love automation`.","height":396,"width":300,"color":6},"id":"470c3715-3944-480d-b9b3-729d975ca4b8","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Instruction - String1","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-1712,32],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"✅ **Correct!**\n\nLet's move on to numbers.","height":272,"color":7},"id":"acf61aa8-09b2-44b4-903a-a8d199a4711b","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Correct1","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-1200,32],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"❌ **Incorrect.**\n\n**Hint:** A string value must always be enclosed in double quotes `\" \"`. Check for typos!","height":320,"color":7},"id":"dfafc41b-e1a2-4068-950c-9c7c98742fe7","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Incorrect1","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-1200,320],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"## JSON Knowledge Test\n\nWelcome to the practical test! The goal is to check your understanding of the JSON concepts you've just learned.\n\n**How to use this test:**\n1. For each step, read the instructions on the purple sticky note.\n2. Modify the corresponding **\"Test - ...\"** node by writing the correct JSON in the text area.\n3. Click **\"Execute Workflow\"** to check your answers.\n4. A green path means a correct answer, a red path means it's incorrect. Keep trying until the path turns green!\n\n\nGood luck!","height":504,"width":460},"id":"bc02bd54-9c60-435e-a6fa-4e08f2516004","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Sticky Note13","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-2208,-80],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"✅ **Correct!**\n\nLet's move on to booleans.","height":272,"color":7},"id":"4c8a867e-33b8-4e9b-a79d-992bad951360","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Correct7","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-384,32],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"❌ **Incorrect.**\n\n**Hint:** The `null` value represents 'nothing' and is written as `null` without quotes.","height":320,"color":7},"id":"5ac32963-f042-4c73-8c4b-af4aa54673f9","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Feedback Incorrect7","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[1264,320],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"💡 **Answer Key**\n\nThis node contains the correct JSON for the **Number** step. You can use it as a reference if you get stuck.","height":304,"width":304,"color":7},"id":"43c2d0f2-3bda-494e-8bb1-8dcf5b65cf49","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer Note - Number","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-896,480],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"💡 **Answer Key**\n\nThis node contains the correct JSON for the **Boolean** step. You can use it as a reference if you get stuck.","height":288,"width":320,"color":7},"id":"402755eb-c28f-40c2-bf42-377c0c35a785","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer Note - Boolean","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-80,592],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"💡 **Answer Key**\n\nThis node contains the correct JSON for the **Null** step. You can use it as a reference if you get stuck.","height":288,"width":320,"color":7},"id":"7e14950b-f384-47d8-a753-b5c84cc052cb","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer Note - Null","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[736,496],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"💡 **Answer Key**\n\nThis node contains the correct JSON for the **Array** step. You can use it as a reference if you get stuck.","height":304,"width":304,"color":7},"id":"4da1ad9e-95ba-4edf-a02e-45c41cdba8b5","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer Note - Array","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[1584,464],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"💡 **Answer Key**\n\nThis node contains the correct JSON for the **Object** step. You can use it as a reference if you get stuck.","height":304,"width":320,"color":7},"id":"207a4bbf-3e09-4b4e-8f89-ce8e6c2cfb4a","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer Note - Object","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[2384,464],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"my_string\": \"I love automation.\"\n}\n","options":{}},"id":"540b17cc-86f6-433d-97fe-225f5c995acf","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Test - String","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[-1616,256],"typeVersion":3.4,"disabled":true,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"5ac1af5c-2769-42f8-9df7-ec092d2fec05","operator":{"type":"string","operation":"equals"},"leftValue":"={{ $json.my_string.trim().toLowerCase() }}","rightValue":"i love automation"}]},"options":{}},"id":"5fd71756-b314-44c3-91e8-51c7d253031a","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Check - String","type":"n8n-nodes-base.if","creator":"Lucas Peyrin","position":[-1360,256],"typeVersion":2.2,"notes":"© 2025 Lucas Peyrin"},{"parameters":{},"id":"3b61409a-7cd6-447b-8b17-5076a2354b42","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Success - String","type":"n8n-nodes-base.noOp","creator":"Lucas Peyrin","position":[-1136,144],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"errorMessage":"Incorrect String. Hint: A string value must always be enclosed in double quotes `\" \"`. Check for typos!"},"id":"3e9dc368-622a-4e00-8e0b-f8be17b61ab7","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Error - String","type":"n8n-nodes-base.stopAndError","creator":"Lucas Peyrin","position":[-1136,496],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"product_id\": ,\n \"price\": \n}\n","options":{}},"id":"c2d89961-e7b0-4fe5-adbc-c801d453353f","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Test - Number","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[-800,256],"typeVersion":3.4,"disabled":true,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"5ac1af5c-2769-42f8-9df7-ec092d2fec05","operator":{"type":"number","operation":"equals"},"leftValue":"={{ $json.product_id }}","rightValue":12345},{"id":"7c1937fa-393c-4b5c-88f5-788df2f99295","operator":{"type":"number","operation":"equals"},"leftValue":"={{ $json.price }}","rightValue":99.99}]},"options":{}},"id":"a8e1b99b-075d-4db2-b624-2d240d269050","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Check - Number","type":"n8n-nodes-base.if","creator":"Lucas Peyrin","position":[-544,256],"typeVersion":2.2,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"errorMessage":"Incorrect Number. Hint: Numbers must not be in quotes. Check both the integer and the decimal value."},"id":"96985cc4-41f7-49f1-9b8b-8b9d03ab9c8f","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Error - Number","type":"n8n-nodes-base.stopAndError","creator":"Lucas Peyrin","position":[-320,496],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"product_id\": 12345,\n \"price\": 99.99\n}\n","options":{}},"id":"93dfe1ee-acb0-416d-b771-550230f893d7","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer - Number","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[-800,624],"typeVersion":3.4,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"mode":"raw","jsonOutput":"{\n \"my_string\": \"I love automation\"\n}\n","options":{}},"id":"7f46b02b-f5a7-4e7c-9b9c-5d70ef7d720d","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer - String","type":"n8n-nodes-base.set","creator":"Lucas Peyrin","position":[-1616,608],"typeVersion":3.4,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"💡 **Answer Key**\n\nThis node contains the correct JSON for the **String** step. You can use it as a reference if you get stuck.","height":304,"width":304,"color":7},"id":"175460f3-9d26-4b58-a616-4b4371f28ea8","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer Note - String","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-1712,464],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{},"id":"72b06c92-3325-40db-8406-2b175132437d","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Success - Number","type":"n8n-nodes-base.noOp","creator":"Lucas Peyrin","position":[-320,144],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{},"id":"6d312e86-59dd-4f9b-a987-cbe1b4a0a351","name":"Start Test!","type":"n8n-nodes-base.manualTrigger","position":[-1952,256],"typeVersion":1},{"parameters":{"content":"### How to pass a test\n","height":304,"width":464,"color":7},"id":"a7ba19a3-5b62-403b-b37a-476476f931e7","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Answer Note - String1","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[-2208,464],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"},{"parameters":{"content":"[](https://n8n.io/creators/lucaspeyrin)","height":184,"width":272,"color":4},"id":"4a6e9ae7-1efa-4dde-b616-d51a49e42239","cid":"Ikx1Y2FzIFBleXJpbiI","name":"Sticky Note16","type":"n8n-nodes-base.stickyNote","creator":"Lucas Peyrin","position":[3264,432],"typeVersion":1,"notes":"© 2025 Lucas Peyrin"}]...
|
{"Start Test!":{"main":[[{"nod {"Start Test!":{"main":[[{"node":"Test - String","type":"main","index":0}]]},"Test - Null":{"main":[[{"node":"Check - Null","type":"main","index":0}]]},"Check - Null":{"main":[[{"node":"Success - Null","type":"main","index":0}],[{"node":"Error - Null","type":"main","index":0}]]},"Test - Array":{"main":[[{"node":"Check - Array","type":"main","index":0}]]},"Check - Array":{"main":[[{"node":"Success - Array","type":"main","index":0}],[{"node":"Error - Array","type":"main","index":0}]]},"Test - Number":{"main":[[{"node":"Check - Number","type":"main","index":0}]]},"Test - Object":{"main":[[{"node":"Check - Object","type":"main","index":0}]]},"Test - String":{"main":[[{"node":"Check - String","type":"main","index":0}]]},"Check - Number":{"main":[[{"node":"Success - Number","type":"main","index":0}],[{"node":"Error - Number","type":"main","index":0}]]},"Check - Object":{"main":[[{"node":"Success - Object","type":"main","index":0}],[{"node":"Error - Object","type":"main","index":0}]]},"Check - String":{"main":[[{"node":"Success - String","type":"main","index":0}],[{"node":"Error - String","type":"main","index":0}]]},"Success - Null":{"main":[[{"node":"Test - Array","type":"main","index":0}]]},"Test - Boolean":{"main":[[{"node":"Check - Boolean","type":"main","index":0}]]},"Check - Boolean":{"main":[[{"node":"Success - Boolean","type":"main","index":0}],[{"node":"Error - Boolean","type":"main","index":0}]]},"Success - Array":{"main":[[{"node":"Test - Object","type":"main","index":0}]]},"Success - Number":{"main":[[{"node":"Test - Boolean","type":"main","index":0}]]},"Success - Object":{"main":[[{"node":"🎉 SUCCESS 🎉","type":"main","index":0}]]},"Success - String":{"main":[[{"node":"Test - Number","type":"main","index":0}]]},"Success - Boolean":{"main":[[{"node":"Test - Null","type":"main","index":0}]]}}...
|
NULL
|
False
|
NULL
|
Edit
Delete
|
|
ce334a5a-eb28-4b12-b1a0-1b96aa9fc68d
|
S15JdQx6jSR0WBqV
|
Damon Hess
|
2025-12-01 17:49:15.929000
|
2025-12-01 17:49:15.929000
|
[{"parameters":{"rule":{"inter [{"parameters":{"rule":{"interval":[{}]}},"type":"n8n-nodes-base.scheduleTrigger","typeVersion":1.2,"position":[-1152,176],"id":"f5b0bf42-94d5-49d0-9fa5-fbfa0c9e5f56","name":"Schedule Trigger"},{"parameters":{"content":"## Save Content","height":520,"width":540,"color":3},"type":"n8n-nodes-base.stickyNote","typeVersion":1,"position":[144,32],"id":"4939fca2-bc76-4ddd-845b-77cb9572fa81","name":"Sticky Note3"},{"parameters":{"content":"## Create a Video","height":740,"width":320,"color":6},"type":"n8n-nodes-base.stickyNote","typeVersion":1,"position":[-224,-112],"id":"473def2a-255d-4284-8412-8ae78f51925d","name":"Sticky Note2"},{"parameters":{"content":"# Input: Video Topic","height":520,"width":840,"color":5},"type":"n8n-nodes-base.stickyNote","typeVersion":1,"position":[-1200,32],"id":"f06c53eb-8f80-43d9-bfdc-c6ee92d7c9b4","name":"Sticky Note"},{"parameters":{"model":{"__rl":true,"mode":"list","value":"gpt-4o-mini"},"options":{}},"type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","typeVersion":1.2,"position":[-1072,368],"id":"acbcee00-89d0-4987-ae85-cd56d9e93882","name":"OpenAI Chat Model1"},{"parameters":{},"type":"@n8n/n8n-nodes-langchain.toolThink","typeVersion":1,"position":[-944,368],"id":"eca01b0a-e6e5-4836-920c-b27cff297d16","name":"Think1"},{"parameters":{"jsonSchemaExample":"{\n \"caption\": \"\",\n \"idea\": \"\",\n \"environment\": \"\",\n \"status\": \"\"\n}"},"type":"@n8n/n8n-nodes-langchain.outputParserStructured","typeVersion":1.2,"position":[-832,368],"id":"20d06661-23bc-407f-9b75-49302be094eb","name":"Structured Output Parser1"},{"parameters":{"model":{"__rl":true,"mode":"list","value":"gpt-4o-mini"},"options":{}},"type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","typeVersion":1.2,"position":[-672,368],"id":"951a8f16-1afb-4349-aaf4-45377851b9f4","name":"OpenAI Chat Model"},{"parameters":{},"type":"@n8n/n8n-nodes-langchain.toolThink","typeVersion":1,"position":[-512,368],"id":"d098b11b-9634-4964-8ee1-bdc3f477aeb8","name":"Think"},{"parameters":{"promptType":"define","text":"Give me an idea to create the content about biblical characters speaking to thecamera and making a vlog","hasOutputParser":true,"options":{"systemMessage":"=** Purpose **\nYou generate viral short-form video ideas inspired by biblical characters or scenes, styled like modern TikTok vlogs. These should feel personal, emotional, and often humorous.\n\n** Think Tool Prompt (used before generation) **\n“How can I take a biblical moment or character and turn it into a relatable, viral, or funny TikTok-style video idea that feels natural, emotional, or modern?”\n\n** Output Requirements **\nYour response must include:\n\n- caption – Short, poetic or funny, TikTok-style. Include emojis and 3–5 hashtags (e.g., #biblevlog #foryou #holycomedy #ancientvibes).\n- idea – 1–2 sentence summary of the action, story, or twist in the video.\n- environment – Describe what the set looks like: light, textures, mood, setting. Think “GoPro meets ancient Jerusalem.”\n- status – Must be \"to create\", without quotation marks\n\n** JSON Output Parser **\nEvery output must strictly follow this format:\n\n{\n \"caption\": \"\",\n \"idea\": \"\",\n \"environment\": \"\",\n \"status\": \"\"\n}\n\n** Sample Outputs **\n\nExample 1\n{\n \"caption\": \"When Jesus gives you the silent treatment 🕊️😶 #jesusvlog #holycomedy\",\n \"idea\": \"Jesus calmly stares at the camera while the disciple keeps asking, 'Are we lost?' – awkward silence builds up.\",\n \"environment\": \"Desert trail, golden hour light, dry bushes around, warm rocky textures and wind softly blowing.\",\n \"status\": \"ready for production\"\n}\n\nExample 2\n{\n \"caption\": \"POV: You just met Mary Magdalene and she’s not what you expected 😳✨ #biblevlog #foryou\",\n \"idea\": \"A modern-style introduction of Mary Magdalene where she breaks the fourth wall with sarcasm and confidence.\",\n \"environment\": \"Dusty stone home with narrow light beams, clay walls, fabric drapes blowing slightly in the breeze.\",\n \"status\": \"ready for production\"\n}\n\nExample 3\n{\n \"caption\": \"Me trying to explain the flood before it happened 🌧️🐘 #noahvibes #bibletok\",\n \"idea\": \"Noah explains why he’s building the ark, while others laugh in the background — like a vlog rant.\",\n \"environment\": \"Half-built wooden structure, cloudy sky, goats wandering around, mud everywhere, distant laughter.\",\n \"status\": \"concept only\"\n}"}},"type":"@n8n/n8n-nodes-langchain.agent","typeVersion":1.9,"position":[-992,176],"id":"75b9d54e-5541-4a76-bc4a-2b1b722c0a02","name":"Generate Video Idea"},{"parameters":{"promptType":"define","text":"=Create a prompt for the Veo3 video based on the following information:\n\nIdea: {{ $json.output.idea }}\nEnvironment: {{ $json.output.environment }}","options":{"systemMessage":"=** System Message **\n\nYou are a professional cinematic prompt generator for AI video tools. Your task is to convert a short-form video idea and its environment description (inspired by biblical or ancient-world themes) into a highly detailed, camera-aware, emotionally rich prompt suitable for generating a cinematic AI video using Veo3.\n\nYou must understand the emotional tone, visual aesthetics, and storytelling style of short-form TikTok videos that imitate biblical scenes with modern pacing and framing.\n\n** Veo3 Prompt Structure Guidelines **\n\nEach prompt should be natural, cinematic, and visually immersive, including:\n\n- Scene description – Describe the overall environment clearly (terrain, buildings, light, movement).\n- Character focus – If the idea involves a person, include their position, outfit style (biblical era), mood/expression, and framing (e.g., close-up, wide shot).\n- Camera movement – Always include one cinematic camera motion (e.g., slow push-in, handheld tracking, drone pan, orbit, dolly backward).\n- Time of day & lighting – Set the mood with light (e.g., golden hour, harsh daylight, candlelit interior).\n- Atmosphere & texture – Mention dust, wind, fabric movement, shadows, reflections, or imperfections in the scene to increase realism.\n- Style & quality – Include cinematic tone, analog warmth, slightly soft vintage film look, GoPro-like closeness if appropriate.\n\n** Input **\n- You will receive two fields: idea, environment\n- Return only the complete and detailed Veo3 prompt, no additional text.\n\n** Example Output **\nA biblical man stands in front of a half-built wooden ark, gesturing passionately as he explains something to the camera. The camera follows him handheld-style, moving slightly as he paces. In the background, groups of villagers are laughing and pointing. The sky is overcast with low clouds, and goats wander through muddy terrain. The man wears worn, ancient robes, his feet muddy, his tone frustrated but hopeful. The scene has a documentary-style realism, with soft golden highlights breaking through cloud gaps. Light wind moves fabric and rustles dry straw around the ark. Shot in cinematic 24fps with natural tones and slight vintage softness."}},"type":"@n8n/n8n-nodes-langchain.agent","typeVersion":1.9,"position":[-672,176],"id":"7c2941ba-42d5-4fb8-8d1f-2898fc44bb11","name":"Generate Veo3 Prompt"},{"parameters":{"method":"POST","url":"https://queue.fal.run/fal-ai/veo3","authentication":"genericCredentialType","genericAuthType":"httpHeaderAuth","sendBody":true,"contentType":"raw","rawContentType":"application/json","body":"={ \"prompt\": \"{{ $('Generate Veo3 Prompt').item.json.output }}\" }","options":{"batching":{"batch":{"batchSize":1,"batchInterval":2000}}}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[-128,-32],"id":"85c3f12a-0f6e-4b50-9165-3efefe2f69fb","name":"Create Video","credentials":{"httpHeaderAuth":{"id":"0eolXfvDWLGmr4lv","name":"Fal AI"}}},{"parameters":{"url":"=https://queue.fal.run/fal-ai/veo3/requests/{{ $json.request_id }}\n","authentication":"genericCredentialType","genericAuthType":"httpHeaderAuth","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[-128,368],"id":"703b02b9-7714-4a27-9a52-f4043946836b","name":"Get Video","credentials":{"httpHeaderAuth":{"id":"0eolXfvDWLGmr4lv","name":"Fal AI"}}},{"parameters":{"amount":2,"unit":"minutes"},"type":"n8n-nodes-base.wait","typeVersion":1.1,"position":[-128,176],"id":"27001980-b208-4e21-9e2e-88417a242626","name":"Wait 10 Minutes","webhookId":"9fdae74d-0f36-4408-9c09-5fb55e66fed1"},{"parameters":{"operation":"append","documentId":{"__rl":true,"value":"1iXvUGDNzW0dbpIR-ErJwM9dMx7884IQY9IhdCGaeMno","mode":"list","cachedResultName":"Veo3 Videos [TEMPLATE]","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1iXvUGDNzW0dbpIR-ErJwM9dMx7884IQY9IhdCGaeMno/edit?usp=drivesdk"},"sheetName":{"__rl":true,"value":"gid=0","mode":"list","cachedResultName":"Sheet1","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1iXvUGDNzW0dbpIR-ErJwM9dMx7884IQY9IhdCGaeMno/edit#gid=0"},"columns":{"mappingMode":"defineBelow","value":{"Video URL":"={{ $json.video.url }}","Idea":"={{ $('Generate Video Idea').item.json.output.idea }}","Captions":"={{ $('Generate Video Idea').item.json.output.caption }}","Environment":"={{ $('Generate Video Idea').item.json.output.environment }}","Status":"=Complete"},"matchingColumns":[],"schema":[{"id":"Idea","displayName":"Idea","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Captions","displayName":"Captions","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Status","displayName":"Status","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Environment","displayName":"Environment","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Video URL","displayName":"Video URL","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true}],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{}},"type":"n8n-nodes-base.googleSheets","typeVersion":4.5,"position":[368,208],"id":"ad79983c-6268-40f9-829e-97473a2b7b77","name":"Store the Video","credentials":{"googleSheetsOAuth2Api":{"id":"NufmenCs2JQN68sm","name":"Google Sheets account"}}},{"parameters":{"operation":"append","documentId":{"__rl":true,"value":"1iXvUGDNzW0dbpIR-ErJwM9dMx7884IQY9IhdCGaeMno","mode":"list","cachedResultName":"Veo3 Videos [TEMPLATE]","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1iXvUGDNzW0dbpIR-ErJwM9dMx7884IQY9IhdCGaeMno/edit?usp=drivesdk"},"sheetName":{"__rl":true,"value":"gid=0","mode":"list","cachedResultName":"Sheet1","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1iXvUGDNzW0dbpIR-ErJwM9dMx7884IQY9IhdCGaeMno/edit#gid=0"},"columns":{"mappingMode":"defineBelow","value":{"Idea":"={{ $('Generate Video Idea').item.json.output.idea }}","Status":"={{ $('Generate Video Idea').item.json.output.status }}","Environment":"={{ $('Generate Video Idea').item.json.output.environment }}","Captions":"={{ $('Generate Video Idea').item.json.output.caption }}"},"matchingColumns":[],"schema":[{"id":"Idea","displayName":"Idea","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Captions","displayName":"Captions","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Status","displayName":"Status","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Environment","displayName":"Environment","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Video URL","displayName":"Video URL","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true}],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{}},"type":"n8n-nodes-base.googleSheets","typeVersion":4.5,"position":[-352,176],"id":"1e01bf33-7fe2-4b26-9c78-ad6258a3bcaa","name":"Save Content Information","credentials":{"googleSheetsOAuth2Api":{"id":"NufmenCs2JQN68sm","name":"Google Sheets account"}}}]...
|
{"Schedule Trigger":{"main":[[{ {"Schedule Trigger":{"main":[[{"node":"Generate Video Idea","type":"main","index":0}]]},"OpenAI Chat Model1":{"ai_languageModel":[[{"node":"Generate Video Idea","type":"ai_languageModel","index":0}]]},"Think1":{"ai_tool":[[{"node":"Generate Video Idea","type":"ai_tool","index":0}]]},"Structured Output Parser1":{"ai_outputParser":[[{"node":"Generate Video Idea","type":"ai_outputParser","index":0}]]},"OpenAI Chat Model":{"ai_languageModel":[[{"node":"Generate Veo3 Prompt","type":"ai_languageModel","index":0}]]},"Think":{"ai_tool":[[{"node":"Generate Veo3 Prompt","type":"ai_tool","index":0}]]},"Generate Video Idea":{"main":[[{"node":"Generate Veo3 Prompt","type":"main","index":0}]]},"Generate Veo3 Prompt":{"main":[[{"node":"Save Content Information","type":"main","index":0}]]},"Create Video":{"main":[[{"node":"Wait 10 Minutes","type":"main","index":0}]]},"Get Video":{"main":[[{"node":"Store the Video","type":"main","index":0}]]},"Wait 10 Minutes":{"main":[[{"node":"Get Video","type":"main","index":0}]]},"Save Content Information":{"main":[[{"node":"Create Video","type":"main","index":0}]]}}...
|
NULL
|
False
|
NULL
|
Edit
Delete
|
|
296f90b4-b155-4472-8256-73e1765a13f7
|
HhEZikdtm5ZZuKtm
|
Damon Hess
|
2025-12-01 23:16:26.852000
|
2025-12-01 23:16:26.852000
|
[{"parameters":{"formTitle":"O [{"parameters":{"formTitle":"Onboarding System","formDescription":"Please fulfill all of the fields","formFields":{"values":[{"fieldLabel":"Name","placeholder":"Enter Your Name","requiredField":true},{"fieldLabel":"Email","placeholder":"Please Enter Your Email","requiredField":true},{"fieldLabel":"Company Industry","placeholder":"e.g. Finances, Health Care","requiredField":true},{"fieldLabel":"What do you want to achieve with us in 5 months","requiredField":true}]},"options":{"appendAttribution":false}},"type":"n8n-nodes-base.formTrigger","typeVersion":2.2,"position":[-896,-128],"id":"88677045-dca5-4658-8884-e9956ad30e71","name":"On form submission","webhookId":"12a1a279-5ebd-44fb-985f-0a072f63e2dd"},{"parameters":{"promptType":"define","text":"=Can you generate a warm and professional welcome email for a new client based on the information provided? The message should be friendly, brief, and personalized—while still sounding professional. It should reflect the client’s industry and their goals for our collaboration. Below is the client’s information:\n\nName: {{ $json.Name }}\n\nEmail: {{ $json.Email }}\n\nCompany Industry: {{ $json['Company Industry'] }}\n\nGoals for the Partnership: {{ $json['What do you want to achieve with us in 5 months'] }}\n\nMake sure to always end the email with the following sign-off:\n\nBest regards,\nBob Bob\nVP of Internal Relations\nABC Corp\n\nDo not use placeholders like [Your Name] or [Your Contact Information] under any circumstances, even if some information is missing.\n\nReturn the result in 3 separate fields:\n\nSubject: The email’s subject line\n\nBody: The main email content\n\nEmail: {{ $json.Email }}","options":{}},"type":"@n8n/n8n-nodes-langchain.agent","typeVersion":1.9,"position":[-432,-352],"id":"277fce44-7c1a-4eda-83c6-ebb1e1acd9ca","name":"AI Agent"},{"parameters":{"model":{"__rl":true,"value":"gpt-4o","mode":"list","cachedResultName":"gpt-4o"},"options":{}},"type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","typeVersion":1.2,"position":[-400,-192],"id":"2752d5a3-30a2-4958-aff7-8bbea2d26610","name":"OpenAI Chat Model","credentials":{"openAiApi":{"id":"5DFuvUPLavfaWChn","name":"OpenAi account"}}},{"parameters":{"modelId":{"__rl":true,"value":"gpt-4o","mode":"list","cachedResultName":"GPT-4O"},"messages":{"values":[{"content":"Parse the JSON query and output the parameters seperately:\n\nSubject\nBody\nEmail","role":"system"},{"content":"={{ $json.output }}"}]},"jsonOutput":true,"options":{}},"type":"@n8n/n8n-nodes-langchain.openAi","typeVersion":1.8,"position":[-96,-352],"id":"011afeed-566d-4268-bd9d-b18e7b27ec9c","name":"OpenAI","credentials":{"openAiApi":{"id":"5DFuvUPLavfaWChn","name":"OpenAi account"}}},{"parameters":{"sendTo":"={{ $json.message.content.Email }}","subject":"={{ $json.message.content.Subject }}","message":"={{ $json.message.content.Body }}","options":{"appendAttribution":false}},"type":"n8n-nodes-base.gmail","typeVersion":2.1,"position":[272,-352],"id":"b62dc869-63a3-494f-ad6c-094c374bb9b2","name":"Gmail","webhookId":"803e30f5-7321-4612-8c73-9c7923f30356","credentials":{"gmailOAuth2":{"id":"jq5N8RrWCTNs4opL","name":"Gmail account"}}},{"parameters":{"promptType":"define","text":"=Use the client details below to generate a clear summary of their profile. Here is the information provided:\n\nName: {{ $json.Name }}\n\nCompany Industry: {{ $json['Company Industry'] }}\n\nGoals with Us: {{ $json['What do you want to achieve with us in 5 months'] }}\n\nReturn the following fields separately:\n\nName: {{ $json.Name }}\n\nEmail: {{ $json.Email }}\n\nSummary: A concise overview of the client based on the information provided above\n","options":{}},"type":"@n8n/n8n-nodes-langchain.agent","typeVersion":1.9,"position":[-560,32],"id":"1c257b43-9d15-4bf6-ba3d-5879d9d39642","name":"AI Agent1"},{"parameters":{"model":{"__rl":true,"value":"gpt-4o","mode":"list","cachedResultName":"gpt-4o"},"options":{}},"type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","typeVersion":1.2,"position":[-608,208],"id":"5cf0053e-3d69-49da-8b21-d0c6550c353b","name":"OpenAI Chat Model1","credentials":{"openAiApi":{"id":"5DFuvUPLavfaWChn","name":"OpenAi account"}}},{"parameters":{"modelId":{"__rl":true,"value":"gpt-4o","mode":"list","cachedResultName":"GPT-4O"},"messages":{"values":[{"content":"Parse the JSON query into 3 fields\n\nName\nEmail\nSummary","role":"system"},{"content":"={{ $json.output }}"}]},"jsonOutput":true,"options":{}},"type":"@n8n/n8n-nodes-langchain.openAi","typeVersion":1.8,"position":[-128,32],"id":"f0070d92-8c39-43a8-ab40-3d0b43031a7b","name":"OpenAI1","credentials":{"openAiApi":{"id":"5DFuvUPLavfaWChn","name":"OpenAi account"}}},{"parameters":{"operation":"append","documentId":{"__rl":true,"value":"1cHZ6V1w3lfPtVfNWZhZi5Y7DDCSff5MlILfyJqW2iRk","mode":"list","cachedResultName":"Automated Onboarding System","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1cHZ6V1w3lfPtVfNWZhZi5Y7DDCSff5MlILfyJqW2iRk/edit?usp=drivesdk"},"sheetName":{"__rl":true,"value":"gid=0","mode":"list","cachedResultName":"Sheet1","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1cHZ6V1w3lfPtVfNWZhZi5Y7DDCSff5MlILfyJqW2iRk/edit#gid=0"},"columns":{"mappingMode":"defineBelow","value":{"Name":"={{ $json.message.content.Name }}","Email":"={{ $json.message.content.Email }}","Summary":"={{ $json.message.content.Summary }}"},"matchingColumns":[],"schema":[{"id":"Name","displayName":"Name","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Email","displayName":"Email","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Summary","displayName":"Summary","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true}],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{}},"type":"n8n-nodes-base.googleSheets","typeVersion":4.5,"position":[240,32],"id":"b3816505-1846-4cfe-af19-dd97cee68d5f","name":"Google Sheets","credentials":{"googleSheetsOAuth2Api":{"id":"NufmenCs2JQN68sm","name":"Google Sheets account"}}}]...
|
{"On form submission":{"main":[[{& {"On form submission":{"main":[[{"node":"AI Agent1","type":"main","index":0},{"node":"AI Agent","type":"main","index":0}]]},"OpenAI Chat Model":{"ai_languageModel":[[{"node":"AI Agent","type":"ai_languageModel","index":0}]]},"AI Agent":{"main":[[{"node":"OpenAI","type":"main","index":0}]]},"OpenAI":{"main":[[{"node":"Gmail","type":"main","index":0}]]},"AI Agent1":{"main":[[{"node":"OpenAI1","type":"main","index":0}]]},"OpenAI Chat Model1":{"ai_languageModel":[[{"node":"AI Agent1","type":"ai_languageModel","index":0}]]},"OpenAI1":{"main":[[{"node":"Google Sheets","type":"main","index":0}]]}}...
|
NULL
|
False
|
NULL
|
Edit
Delete
|
|
e2ff0bde-fe94-49b4-bfc1-51c36ba99c2c
|
2B85eBwnhrBGciaP
|
Damon Hess
|
2025-12-04 07:20:49.704000
|
2025-12-04 07:20:49.704000
|
[{"parameters":{"formTitle":"R [{"parameters":{"formTitle":"Real Estate - Form","formDescription":"Please provide all of your metrics to get the best real estate deals.","formFields":{"values":[{"fieldLabel":"Location","requiredField":true},{"fieldLabel":"Status","fieldType":"dropdown","fieldOptions":{"values":[{"option":"forSale"}]},"requiredField":true},{"fieldLabel":"Minimum Price","requiredField":true},{"fieldLabel":"Maximum Price","requiredField":true},{"fieldLabel":"Minimum Number of Beds","requiredField":true},{"fieldLabel":"Minimum Number of Bathrooms","requiredField":true},{"fieldLabel":"sortselection","fieldType":"dropdown","fieldOptions":{"values":[{"option":"Price"}]},"requiredField":true},{"fieldLabel":"Multi Family?","fieldType":"dropdown","fieldOptions":{"values":[{"option":"true"},{"option":"false"}]},"requiredField":true}]},"options":{}},"type":"n8n-nodes-base.formTrigger","typeVersion":2.3,"position":[0,0],"id":"5b2356a7-a20d-4ae7-b9ea-53395848c39a","name":"On form submission","webhookId":"ea20f37f-8676-4c8e-807a-e18200f9aa62"},{"parameters":{"url":"https://zillow56.p.rapidapi.com/search?","authentication":"genericCredentialType","genericAuthType":"httpHeaderAuth","sendQuery":true,"queryParameters":{"parameters":[{"name":"location","value":"={{ $json.Location }}"},{"name":"status","value":"={{ $json.Status }}"},{"name":"price_min","value":"={{ $json['Minimum Price'] }}"},{"name":"price_max","value":"={{ $json['Maximum Price'] }}"},{"name":"beds_min","value":"={{ $json['Minimum Number of Beds'] }}"},{"name":"baths_min","value":"={{ $json['Minimum Number of Bathrooms'] }}"},{"name":"sortSelection","value":"={{ $json.sortselection }}"},{"name":"isMultiFamily","value":"={{ $json['Multi Family?'] }}"}]},"options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[208,0],"id":"ddb750b1-e1f9-44f6-845c-40d792a6520d","name":"Search for Deals","credentials":{"httpHeaderAuth":{"id":"Zgd6WeNleJH1GJW4","name":"Header Auth account"}}},{"parameters":{"fieldToSplitOut":"results","options":{}},"type":"n8n-nodes-base.splitOut","typeVersion":1,"position":[416,0],"id":"090fc404-e8cb-413c-9566-449222d89a36","name":"Split Out"},{"parameters":{"jsCode":"// ── CONFIGURABLE ASSUMPTIONS ─────────────────────────────────────────\nconst downPaymentPct = 0.20; // 20 % down\nconst closingCostPct = 0.03; // 3 % closing costs\nconst annualInterestRate = 0.05; // 5 % APR\nconst loanTermYears = 30; // 30‑yr mortgage\nconst propertyTaxRate = 0.012; // 1.2 % of assessed value per year\nconst insuranceRate = 0.003; // 0.3 % of price per year\nconst maintenanceRate = 0.01; // 1 % of price per year\n// ─────────────────────────────────────────────────────────────────────\n// IMPORTANT for n8n: return array of { json: … }\nreturn items.map(item => {\n // —— raw inputs (fall back to 0 if missing) ————————————————\n const j = item.json;\n const price = parseFloat(j.price) || 0;\n const rent = parseFloat(j.rentZestimate) || 0;\n const livingArea = parseFloat(j.LivingArea) || 0; // sqft\n const zEstimate = parseFloat(j.zestimate) || 0;\n const taxAssessedVal = parseFloat(j.taxAssessedValue)|| price;\n // ————————————————————————————————————————————————————————\n // —— Financing ——————————————————————————\n const downPayment = price * downPaymentPct;\n const closingCosts = price * closingCostPct;\n const loanAmount = price - downPayment;\n const monthlyRate = annualInterestRate / 12;\n const numPayments = loanTermYears * 12;\n const mortgagePayment= loanAmount * monthlyRate /\n (1 - Math.pow(1 + monthlyRate, -numPayments));\n // —— Operating expenses ———————————————\n const annualTax = taxAssessedVal * propertyTaxRate;\n const annualIns = price * insuranceRate;\n const annualMaint = price * maintenanceRate;\n const monthlyTax = annualTax / 12;\n const monthlyIns = annualIns / 12;\n const monthlyMaint = annualMaint / 12;\n // —— Cash‑flow & returns ——————————————\n const totalMonthlyExp = mortgagePayment + monthlyTax + monthlyIns + monthlyMaint;\n const monthlyCashFlow = rent - totalMonthlyExp;\n const annualCashFlow = monthlyCashFlow * 12;\n const capRate = annualCashFlow / price; // NOI ÷ price\n const cashOnCashROI = annualCashFlow / (downPayment + closingCosts);\n // —— Extra metrics ————————————————\n const pricePerSqft = livingArea ? price / livingArea : 0;\n const rentPerSqft = livingArea ? rent / livingArea : 0;\n const rentToPricePct = price ? (rent * 12) / price : 0; // GRM inverse\n const priceVsZestPct = zEstimate ? (price - zEstimate) / zEstimate : 0;\n // ————————————————————————————————————————————————————————\n // —— Attach everything to output JSON ——\n Object.assign(j, {\n downPayment: +downPayment.toFixed(2),\n closingCosts: +closingCosts.toFixed(2),\n loanAmount: +loanAmount.toFixed(2),\n mortgagePayment: +mortgagePayment.toFixed(2),\n monthlyPropertyTax: +monthlyTax.toFixed(2),\n monthlyInsurance: +monthlyIns.toFixed(2),\n monthlyMaintenance: +monthlyMaint.toFixed(2),\n totalMonthlyExpenses: +totalMonthlyExp.toFixed(2),\n monthlyCashFlow: +monthlyCashFlow.toFixed(2),\n annualCashFlow: +annualCashFlow.toFixed(2),\n capRate: +capRate.toFixed(4), // 0.0523 ➜ 5.23 %\n cashOnCashROI: +cashOnCashROI.toFixed(4), // 0.1234 ➜ 12.34 %\n pricePerSqft: +pricePerSqft.toFixed(2),\n rentPerSqft: +rentPerSqft.toFixed(2),\n rentToPricePct: +(rentToPricePct*100).toFixed(2), // % of price per yr\n priceVsZestimatePct: +(priceVsZestPct*100).toFixed(2) // over/under %\n });\n // Return a proper n8n item\n return { json: j };\n});\n"},"type":"n8n-nodes-base.code","typeVersion":2,"position":[864,0],"id":"0840379e-e03a-442a-bcdb-4e4d7833e916","name":"Code in JavaScript"},{"parameters":{"assignments":{"assignments":[{"id":"8bdbd5fe-78d0-4569-8076-573f46dd5034","name":"Address","value":"={{ $json.streetAddress }} {{ $json.city }} {{ $json.state }} {{ $json.zipcode }} {{ $json.country }}","type":"string"},{"id":"eed9bcfb-4f00-482f-9414-a7570bdf8f5f","name":"homeStatus","value":"={{ $json.homeStatus }}","type":"string"},{"id":"4ef1f2eb-aea6-405b-85a1-fffe21f85b34","name":"homeType","value":"={{ $json.homeType }}","type":"string"},{"id":"8263a3b2-b408-4f55-91bb-86c9520fdb44","name":"totalSize","value":"={{ $json.lotAreaValue }} {{ $json.lotAreaUnit }}","type":"string"},{"id":"e3f552dc-53bd-45cf-bea6-af8229731f87","name":"livingArea","value":"={{ $json.livingArea }}","type":"number"},{"id":"2207b169-47a3-428c-be30-b751447f8a53","name":"price","value":"={{ $json.price }}","type":"number"},{"id":"16a0e52a-9377-497a-83fd-3afa25598c04","name":"taxAssessedValue","value":"={{ $json.taxAssessedValue }}","type":"number"},{"id":"f6147499-df03-4cde-affc-2fcd13626d32","name":"zestimate","value":"={{ $json.zestimate }}","type":"number"},{"id":"1c0f0085-e321-4dd2-9f9d-ff72b505f025","name":"rentZestimate","value":"={{ $json.rentZestimate }}","type":"number"},{"id":"54ae01bc-e9d6-44fb-a8bf-cb7181374409","name":"priceReduction","value":"={{ $json.priceReduction }}","type":"string"},{"id":"06f2f109-5fcb-4042-bab2-823bd700c8d0","name":"bathrooms","value":"={{ $json.bathrooms }}","type":"number"},{"id":"54672fbf-3454-459c-a7e5-f04eea02bb3d","name":"bedrooms","value":"={{ $json.bedrooms }}","type":"number"},{"id":"1d2d6bab-dbf5-472b-bb05-9fbb7f824424","name":"isNonOwnerOccupied","value":"={{ $json.isNonOwnerOccupied }}","type":"boolean"},{"id":"4384ee7b-6064-4464-8826-c4d4056f85de","name":"isPreforeclosureAuction","value":"={{ $json.isPreforeclosureAuction }}","type":"boolean"},{"id":"b8fb5175-5260-4f70-9f87-f01348acdf25","name":"isPremierBuilder","value":"={{ $json.isPremierBuilder }}","type":"boolean"},{"id":"598ef3a5-ec3c-4ead-b3c7-85a5ec46fb4f","name":"isShowcaseListing","value":"={{ $json.isShowcaseListing }}","type":"boolean"}]},"options":{}},"type":"n8n-nodes-base.set","typeVersion":3.4,"position":[624,0],"id":"0367649e-6e55-44bd-977d-7f60844e897b","name":"Edit Fields"},{"parameters":{"operation":"appendOrUpdate","documentId":{"__rl":true,"value":"1Pjkm9z5fQg_QQLYYtRDSgJPJxIm5ukt2hu9pwvG_52E","mode":"list","cachedResultName":"Real Estate Deals [TEMPLATE]","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1Pjkm9z5fQg_QQLYYtRDSgJPJxIm5ukt2hu9pwvG_52E/edit?usp=drivesdk"},"sheetName":{"__rl":true,"value":"gid=0","mode":"list","cachedResultName":"Sheet1","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1Pjkm9z5fQg_QQLYYtRDSgJPJxIm5ukt2hu9pwvG_52E/edit#gid=0"},"columns":{"mappingMode":"defineBelow","value":{"Address":"={{ $json.Address }}","homeStatus":"={{ $json.homeStatus }}","homeType":"={{ $json.homeType }}","totalSize":"={{ $json.totalSize }}","LivingArea":"={{ $json.livingArea }}","price":"={{ $json.price }}","taxAssessedValue":"={{ $json.taxAssessedValue }}","zestimate":"={{ $json.zestimate }}","rentZestimate":"={{ $json.rentZestimate }}","priceReduction":"={{ $json.priceReduction }}","bathrooms":"={{ $json.bathrooms }}","bedrooms":"={{ $json.bedrooms }}","isNonOwnerOccupied":"={{ $json.isNonOwnerOccupied }}","isPreforeclosureAuction":"={{ $json.isPreforeclosureAuction }}","isPremierBuilder":"={{ $json.isPremierBuilder }}","isShowcaseListing":"={{ $json.isShowcaseListing }}","downPayment":"={{ $json.downPayment }}","closingCosts":"={{ $json.closingCosts }}","loanAmount":"={{ $json.loanAmount }}","mortgagePayment":"={{ $json.mortgagePayment }}","monthlyPropertyTax":"={{ $json.monthlyPropertyTax }}","monthlyMaintenance":"={{ $json.monthlyMaintenance }}","monthlyInsurance":"={{ $json.monthlyInsurance }}","totalMonthlyExpenses":"={{ $json.totalMonthlyExpenses }}","annualCashFlow":"={{ $json.annualCashFlow }}","monthlyCashFlow":"={{ $json.monthlyCashFlow }}","capRate":"={{ $json.capRate }}","cashOnCashROI":"={{ $json.cashOnCashROI }}","pricePerSqft":"={{ $json.pricePerSqft }}","rentPerSqft":"={{ $json.rentPerSqft }}","rentToPricePct":"={{ $json.rentToPricePct }}","priceVsZestimatePct":"={{ $json.priceVsZestimatePct }}"},"matchingColumns":["Address"],"schema":[{"id":"Address","displayName":"Address","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"homeStatus","displayName":"homeStatus","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"homeType","displayName":"homeType","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"totalSize","displayName":"totalSize","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"LivingArea","displayName":"LivingArea","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"price","displayName":"price","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"taxAssessedValue","displayName":"taxAssessedValue","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"zestimate","displayName":"zestimate","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"rentZestimate","displayName":"rentZestimate","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"priceReduction","displayName":"priceReduction","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"bathrooms","displayName":"bathrooms","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"bedrooms","displayName":"bedrooms","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"isNonOwnerOccupied","displayName":"isNonOwnerOccupied","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"isPreforeclosureAuction","displayName":"isPreforeclosureAuction","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"isPremierBuilder","displayName":"isPremierBuilder","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"isShowcaseListing","displayName":"isShowcaseListing","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"downPayment","displayName":"downPayment","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"closingCosts","displayName":"closingCosts","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"loanAmount","displayName":"loanAmount","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"mortgagePayment","displayName":"mortgagePayment","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"monthlyPropertyTax","displayName":"monthlyPropertyTax","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"monthlyInsurance","displayName":"monthlyInsurance","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"monthlyMaintenance","displayName":"monthlyMaintenance","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"totalMonthlyExpenses","displayName":"totalMonthlyExpenses","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"monthlyCashFlow","displayName":"monthlyCashFlow","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"annualCashFlow","displayName":"annualCashFlow","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"capRate","displayName":"capRate","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"cashOnCashROI","displayName":"cashOnCashROI","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"pricePerSqft","displayName":"pricePerSqft","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"rentPerSqft","displayName":"rentPerSqft","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"rentToPricePct","displayName":"rentToPricePct","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"priceVsZestimatePct","displayName":"priceVsZestimatePct","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true}],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{}},"type":"n8n-nodes-base.googleSheets","typeVersion":4.7,"position":[1184,208],"id":"d9efc71a-2d86-49e7-ac5f-6a8870261acc","name":"Append or update row in sheet","credentials":{"googleSheetsOAuth2Api":{"id":"NufmenCs2JQN68sm","name":"Google Sheets account"}}},{"parameters":{"aggregate":"aggregateAllItemData","options":{}},"type":"n8n-nodes-base.aggregate","typeVersion":1,"position":[1184,-160],"id":"733f904c-d2da-4651-b75b-364618f9cfb3","name":"Aggregate"},{"parameters":{"promptType":"define","text":"=You are a seasoned real estate investment analyst. Each day, you'll receive a JSON array of property records with fields such as:\nAddress\nhomeStatus, homeType, size\nprice, taxAssessedValue, zestimate, rentZestimate\ndownPayment, closingCosts, loanAmount, mortgagePayment\nmonthlyPropertyTax, monthlyInsurance, monthlyMaintenance\ntotalMonthlyExpenses, monthlyCashFlow, annualCashFlow\ncapRate, cashOnCashROI\nThe input is available as:\n{{ JSON.stringify($json.data) }}\nYour tasks:\nWrite a short one-sentence summary of the overall real estate market sentiment.\nList the Top 3 properties ranked by cash-on-cash ROI, and for each show:\nAddress\nROI (%)\nMonthly cash flow\nList the Top 3 properties ranked by cap rate, and for each show:\nAddress\nCap rate (%)\nAnnual cash flow\nHighlight any properties with negative monthly cash flow.\nCalculate and display portfolio-wide averages for:\nCap rate (%)\nCash-on-cash ROI (%)\nMonthly cash flow (USD)\nSuggest up to two next actions, for example:\n“Schedule showings for properties X, Y”\n“Consider raising your max price filter to find better cap rates”\nFormat your output as a clean daily report with headings and bullet points.\nUse the Gmail tool to email this summary.\nSet the email subject to:\nDaily Real Estate KPI Report for {{ $now }}\n(Ensure the date is in YYYY-MM-DD format.)\nMake sure the email is HTML formatted and easy to read.\n","options":{}},"type":"@n8n/n8n-nodes-langchain.agent","typeVersion":3,"position":[1392,-160],"id":"fc43feb3-18ca-41f9-aa8d-2ee89ab7b38d","name":"AI Agent"},{"parameters":{"model":{"__rl":true,"value":"gpt-4o-mini","mode":"list","cachedResultName":"gpt-4o-mini"},"builtInTools":{},"options":{}},"type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","typeVersion":1.3,"position":[1264,48],"id":"251d85a3-b9aa-4e1d-bc78-533c59a3c330","name":"OpenAI Chat Model","credentials":{"openAiApi":{"id":"5DFuvUPLavfaWChn","name":"OpenAi account"}}},{"parameters":{},"type":"@n8n/n8n-nodes-langchain.toolCalculator","typeVersion":1,"position":[1536,48],"id":"b02f0deb-d55d-45f2-936b-9b911c19a2cb","name":"Calculator"},{"parameters":{"sendTo":"[email protected]","subject":"={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Subject', ``, 'string') }}","message":"={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Message', ``, 'string') }}","options":{}},"type":"n8n-nodes-base.gmailTool","typeVersion":2.1,"position":[1744,32],"id":"d0609e07-bcba-4276-a509-1eca5491c7e9","name":"Send a message in Gmail","webhookId":"b6f424d4-57be-4c06-a208-aea7541ceee9","credentials":{"gmailOAuth2":{"id":"jq5N8RrWCTNs4opL","name":"Gmail account"}}}]...
|
{"On form submission":{"main":[[{& {"On form submission":{"main":[[{"node":"Search for Deals","type":"main","index":0}]]},"Search for Deals":{"main":[[{"node":"Split Out","type":"main","index":0}]]},"Split Out":{"main":[[{"node":"Edit Fields","type":"main","index":0}]]},"Edit Fields":{"main":[[{"node":"Code in JavaScript","type":"main","index":0}]]},"Code in JavaScript":{"main":[[{"node":"Append or update row in sheet","type":"main","index":0},{"node":"Aggregate","type":"main","index":0}]]},"Aggregate":{"main":[[{"node":"AI Agent","type":"main","index":0}]]},"OpenAI Chat Model":{"ai_languageModel":[[{"node":"AI Agent","type":"ai_languageModel","index":0}]]},"Calculator":{"ai_tool":[[{"node":"AI Agent","type":"ai_tool","index":0}]]},"Send a message in Gmail":{"ai_tool":[[{"node":"AI Agent","type":"ai_tool","index":0}]]}}...
|
NULL
|
False
|
NULL
|
Edit
Delete
|