Sample Workflows (As demoed in the video)

    Shared 11/7/2025

    472 views

    Visual Workflow

    JSON Code

    {
      "meta": {
        "instanceId": "125637e355429ab06f8886794f7df9252a3e338f92a1957141a8989e48f2b612",
        "templateCredsSetupCompleted": true
      },
      "nodes": [
        {
          "id": "11a8f7b0-a953-4816-8eac-b57ef4fb0b56",
          "name": "When clicking ‘Execute workflow’",
          "type": "n8n-nodes-base.manualTrigger",
          "position": [
            -16,
            640
          ],
          "parameters": {},
          "typeVersion": 1
        },
        {
          "id": "ee76d3d8-0a32-44da-9416-44c8039780ac",
          "name": "Get row(s) in sheet",
          "type": "n8n-nodes-base.googleSheets",
          "position": [
            224,
            224
          ],
          "parameters": {
            "options": {},
            "sheetName": {
              "__rl": true,
              "mode": "list",
              "value": "gid=0",
              "cachedResultUrl": "https://docs.google.com/spreadsheets/d/10gtOvyk00xWNaw5tVxfaklnfw3dAiL0PBr6gzaG3cHQ/edit#gid=0",
              "cachedResultName": "Sheet1"
            },
            "documentId": {
              "__rl": true,
              "mode": "list",
              "value": "10gtOvyk00xWNaw5tVxfaklnfw3dAiL0PBr6gzaG3cHQ",
              "cachedResultUrl": "https://docs.google.com/spreadsheets/d/10gtOvyk00xWNaw5tVxfaklnfw3dAiL0PBr6gzaG3cHQ/edit?usp=drivesdk",
              "cachedResultName": "Freelance n8n Automation Specialist for Ad-hoc Workflow Challenges"
            }
          },
          "credentials": {
            "googleSheetsOAuth2Api": {
              "id": "qVntjW61XxH91qGU",
              "name": "Google Sheets account"
            }
          },
          "typeVersion": 4.7
        },
        {
          "id": "9c5dceb9-3c59-4e87-a555-8fa847deaf20",
          "name": "Loop Over Items",
          "type": "n8n-nodes-base.splitInBatches",
          "position": [
            448,
            224
          ],
          "parameters": {
            "options": {},
            "batchSize": 20
          },
          "typeVersion": 3
        },
        {
          "id": "37a42dae-da09-4043-8960-2e3f370ff321",
          "name": "Code in JavaScript",
          "type": "n8n-nodes-base.code",
          "onError": "continueErrorOutput",
          "position": [
            672,
            0
          ],
          "parameters": {
            "jsCode": "return $input.all();"
          },
          "typeVersion": 2
        },
        {
          "id": "bd19c2ef-2ed4-4076-8b2a-8219ea00d90b",
          "name": "Wait",
          "type": "n8n-nodes-base.wait",
          "position": [
            1424,
            64
          ],
          "webhookId": "1d33d664-b16f-4b4b-a730-ee9923d4dd28",
          "parameters": {
            "amount": 3
          },
          "typeVersion": 1.1
        },
        {
          "id": "f57a4873-1486-416a-b1cc-236bb6782710",
          "name": "Send a message",
          "type": "n8n-nodes-base.slack",
          "position": [
            1232,
            272
          ],
          "webhookId": "0714eb98-6e9a-4f26-8129-4dee469b1554",
          "parameters": {
            "text": "=Error occured while processing item: {{ $json.id }}",
            "select": "channel",
            "channelId": {
              "__rl": true,
              "mode": "list",
              "value": "C08UF135L6S",
              "cachedResultName": "new-channel"
            },
            "otherOptions": {},
            "authentication": "oAuth2"
          },
          "credentials": {
            "slackOAuth2Api": {
              "id": "IJybsiElOZ9GaNUr",
              "name": "Error Notificator"
            }
          },
          "typeVersion": 2.3
        },
        {
          "id": "96282203-6121-4ede-b7ee-e8fc804840a9",
          "name": "Wait1",
          "type": "n8n-nodes-base.wait",
          "position": [
            1440,
            272
          ],
          "webhookId": "8fc0ce0b-d49a-4283-8547-5d1f2c1082f3",
          "parameters": {},
          "typeVersion": 1.1
        },
        {
          "id": "030c5d84-3588-49ec-962f-f90aa573f1f9",
          "name": "Append or update row in sheet",
          "type": "n8n-nodes-base.googleSheets",
          "onError": "continueErrorOutput",
          "position": [
            992,
            -80
          ],
          "parameters": {
            "columns": {
              "value": {
                "id": "={{ $json.id }}",
                "status": "processed"
              },
              "schema": [
                {
                  "id": "id",
                  "type": "string",
                  "display": true,
                  "removed": false,
                  "required": false,
                  "displayName": "id",
                  "defaultMatch": true,
                  "canBeUsedToMatch": true
                },
                {
                  "id": "status",
                  "type": "string",
                  "display": true,
                  "required": false,
                  "displayName": "status",
                  "defaultMatch": false,
                  "canBeUsedToMatch": true
                }
              ],
              "mappingMode": "defineBelow",
              "matchingColumns": [
                "id"
              ],
              "attemptToConvertTypes": false,
              "convertFieldsToString": false
            },
            "options": {},
            "operation": "appendOrUpdate",
            "sheetName": {
              "__rl": true,
              "mode": "list",
              "value": "gid=0",
              "cachedResultUrl": "https://docs.google.com/spreadsheets/d/10gtOvyk00xWNaw5tVxfaklnfw3dAiL0PBr6gzaG3cHQ/edit#gid=0",
              "cachedResultName": "Sheet1"
            },
            "documentId": {
              "__rl": true,
              "mode": "list",
              "value": "10gtOvyk00xWNaw5tVxfaklnfw3dAiL0PBr6gzaG3cHQ",
              "cachedResultUrl": "https://docs.google.com/spreadsheets/d/10gtOvyk00xWNaw5tVxfaklnfw3dAiL0PBr6gzaG3cHQ/edit?usp=drivesdk",
              "cachedResultName": "Freelance n8n Automation Specialist for Ad-hoc Workflow Challenges"
            }
          },
          "credentials": {
            "googleSheetsOAuth2Api": {
              "id": "qVntjW61XxH91qGU",
              "name": "Google Sheets account"
            }
          },
          "retryOnFail": true,
          "typeVersion": 4.7
        },
        {
          "id": "78e47428-b2ca-4af5-b8b2-40e62d9561e4",
          "name": "Get a row",
          "type": "n8n-nodes-base.supabase",
          "position": [
            224,
            640
          ],
          "parameters": {
            "filters": {
              "conditions": [
                {
                  "keyName": "status",
                  "keyValue": "active"
                }
              ]
            },
            "tableId": "users",
            "operation": "get"
          },
          "credentials": {
            "supabaseApi": {
              "id": "3HihurEjJq0rhCa2",
              "name": "temp 2"
            }
          },
          "typeVersion": 1
        },
        {
          "id": "403fa102-eee1-4728-93c0-35e5f8d105ac",
          "name": "AI Agent",
          "type": "@n8n/n8n-nodes-langchain.agent",
          "position": [
            432,
            640
          ],
          "parameters": {
            "text": "=First Name: {{ $json.first_name }}\n\nCompany: {{ $json.company }}\n\nIndustry: {{ $json.industry }}\n\nJob Title: {{ $json.job_title }}",
            "options": {
              "systemMessage": "=You are a cold outreach email specialist. Generate personalized, concise cold emails based on prospect data.\n\nRequirements:\n- Keep emails under 100 words\n- Start with a personalized hook referencing their industry or role\n- Provide clear value proposition\n- End with a simple, low-friction call-to-action\n- Use a professional yet conversational tone\n- Avoid generic phrases like \"I hope this email finds you well\"\n- Include a compelling subject line\n\nFormat:\nSubject: [subject line]\n\n[email body]\n\nAlways personalize based on the prospect's: name, company, industry, and job title."
            },
            "promptType": "define",
            "needsFallback": true,
            "hasOutputParser": true
          },
          "typeVersion": 3
        },
        {
          "id": "bedd7e9c-b79a-4ba7-ad6e-5f151a64b5c9",
          "name": "OpenAI Chat Model",
          "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
          "position": [
            288,
            848
          ],
          "parameters": {
            "model": {
              "__rl": true,
              "mode": "list",
              "value": "gpt-4.1-mini"
            },
            "options": {}
          },
          "credentials": {
            "openAiApi": {
              "id": "WK5EDtpDCVBHQRrI",
              "name": "My acc"
            }
          },
          "typeVersion": 1.2
        },
        {
          "id": "029ed6af-8bd0-45d3-a97f-6c7ce3edf6b8",
          "name": "Google Gemini Chat Model",
          "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
          "position": [
            448,
            848
          ],
          "parameters": {
            "options": {}
          },
          "credentials": {
            "googlePalmApi": {
              "id": "3wDLBiW4NvJSZyUI",
              "name": "Google Gemini(PaLM) Api account"
            }
          },
          "typeVersion": 1
        },
        {
          "id": "c2d3f018-1c46-426a-9382-fc89e61e6fbd",
          "name": "Structured Output Parser",
          "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
          "position": [
            672,
            848
          ],
          "parameters": {
            "jsonSchemaExample": "{\n  \"subject\": \"email_subject\",\n  \"body\": \"email_body\"\n}"
          },
          "typeVersion": 1.3
        },
        {
          "id": "86fef2db-8697-45ec-a1b2-839b6d11caf4",
          "name": "Update a row",
          "type": "n8n-nodes-base.supabase",
          "position": [
            784,
            640
          ],
          "parameters": {
            "filters": {
              "conditions": [
                {
                  "keyName": "id",
                  "keyValue": "={{ $('Get a row').item.json.id }}",
                  "condition": "eq"
                }
              ]
            },
            "tableId": "users",
            "fieldsUi": {
              "fieldValues": [
                {
                  "fieldId": "email_subject",
                  "fieldValue": "={{ $json.output.subject }}"
                },
                {
                  "fieldId": "email_body",
                  "fieldValue": "={{ $json.output.body }}"
                }
              ]
            },
            "operation": "update"
          },
          "credentials": {
            "supabaseApi": {
              "id": "3HihurEjJq0rhCa2",
              "name": "temp 2"
            }
          },
          "typeVersion": 1
        },
        {
          "id": "3e203adb-4d4b-4256-a282-bd51ccceca56",
          "name": "Env var",
          "type": "n8n-nodes-base.set",
          "position": [
            288,
            1072
          ],
          "parameters": {
            "options": {},
            "assignments": {
              "assignments": [
                {
                  "id": "1602fc08-238e-4345-8f60-d2ec9f1f76a1",
                  "name": "apify_api_key",
                  "type": "string",
                  "value": "={{ $env.APIFY_API_KEY }}"
                }
              ]
            }
          },
          "typeVersion": 3.4
        }
      ],
      "pinData": {
        "Env var": []
      },
      "connections": {
        "Wait": {
          "main": [
            [
              {
                "node": "Loop Over Items",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "Wait1": {
          "main": [
            [
              {
                "node": "Loop Over Items",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "AI Agent": {
          "main": [
            [
              {
                "node": "Update a row",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "Get a row": {
          "main": [
            [
              {
                "node": "AI Agent",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "Update a row": {
          "main": [
            []
          ]
        },
        "Send a message": {
          "main": [
            [
              {
                "node": "Wait1",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "Loop Over Items": {
          "main": [
            [],
            [
              {
                "node": "Code in JavaScript",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "OpenAI Chat Model": {
          "ai_languageModel": [
            [
              {
                "node": "AI Agent",
                "type": "ai_languageModel",
                "index": 0
              }
            ]
          ]
        },
        "Code in JavaScript": {
          "main": [
            [
              {
                "node": "Append or update row in sheet",
                "type": "main",
                "index": 0
              }
            ],
            [
              {
                "node": "Send a message",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "Get row(s) in sheet": {
          "main": [
            [
              {
                "node": "Loop Over Items",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "Google Gemini Chat Model": {
          "ai_languageModel": [
            [
              {
                "node": "AI Agent",
                "type": "ai_languageModel",
                "index": 1
              }
            ]
          ]
        },
        "Structured Output Parser": {
          "ai_outputParser": [
            [
              {
                "node": "AI Agent",
                "type": "ai_outputParser",
                "index": 0
              }
            ]
          ]
        },
        "Append or update row in sheet": {
          "main": [
            [
              {
                "node": "Wait",
                "type": "main",
                "index": 0
              }
            ],
            [
              {
                "node": "Send a message",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "When clicking ‘Execute workflow’": {
          "main": [
            [
              {
                "node": "Get a row",
                "type": "main",
                "index": 0
              }
            ]
          ]
        }
      }
    }