, , and
tags. \nAlways output both the Subject and the Email Body separately. \nDo not include or tags. \nThe tone should be polite, conversational, and slightly persuasive. \nEnd with a clear call to action (like booking a meeting) and sign off as “YOUR_NAME, YOUR_COMPANY.”\nReturn your answer in JSON format with two keys:\n{\n \"subject\": \"...\",\n \"body_html\": \"...\"\n}\n"
},
"promptType": "define"
},
"typeVersion": 2.1
},
{
"id": "eb74688d-5d4b-4a8f-ba88-03111715fb52",
"name": "Parse AI Email Output (JavaScript)",
"type": "n8n-nodes-base.code",
"position": [
448,
320
],
"parameters": {
"jsCode": "// Loop through AI results and clean up JSON output\nreturn items.map(item => {\n let raw = item.json.output || '';\n \n // Remove code block markers like ```json or ```\n raw = raw.replace(/```json|```/g, '').trim();\n\n // Parse JSON safely\n let parsed;\n try {\n parsed = JSON.parse(raw);\n } catch (e) {\n parsed = { subject: \"No Subject\", body_html: \"Error parsing AI output.\" };\n }\n\n return { json: parsed };\n});\n"
},
"typeVersion": 2
},
{
"id": "5e6c825b-1739-411b-b7b5-291937596a9f",
"name": "Send Initial Outreach Email via Gmail",
"type": "n8n-nodes-base.gmail",
"position": [
768,
320
],
"parameters": {
"sendTo": "={{ $('Retrieve Lead Records from Google Sheets').item.json.Email }}",
"message": "={{ $json.body_html }}",
"options": {},
"subject": "={{ $json.subject }}"
},
"typeVersion": 2.1
},
{
"id": "540211f0-f006-4845-8fed-02d41d9fc634",
"name": "Wait Before Thread Check (24 hr)",
"type": "n8n-nodes-base.wait",
"position": [
1040,
320
],
"parameters": {
"amount": 24
},
"typeVersion": 1
},
{
"id": "537915a6-88d4-4353-b5f7-d0c2424119ce",
"name": "Fetch Sent Email Thread from Gmail",
"type": "n8n-nodes-base.gmail",
"position": [
1312,
320
],
"parameters": {
"options": {},
"resource": "thread",
"threadId": "={{ $('Send Initial Outreach Email via Gmail').item.json.threadId }}",
"operation": "get"
},
"typeVersion": 2.1
},
{
"id": "80bbd250-f9ab-46de-9ad6-b3ab8e7f3233",
"name": "Check for Client Reply (If Condition)",
"type": "n8n-nodes-base.if",
"position": [
1568,
320
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "4a6d1310-29be-4559-8bea-afe8fe0f0f30",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{$json[\"messages\"][1][\"snippet\"]}}",
"rightValue": "Yes"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "5366521f-fc42-4907-9e1e-29994458578c",
"name": "Extract Reply Details (JavaScript)",
"type": "n8n-nodes-base.code",
"position": [
1920,
48
],
"parameters": {
"jsCode": "// Loop through all email threads where reply = true\nreturn items.map(item => {\n const data = item.json;\n\n // Extract the reply message (second email in thread)\n const reply = data.messages?.[1];\n const original = data.messages?.[0];\n\n // Clean the reply text (remove quoted text from Gmail)\n let clientMessage = reply?.snippet || \"\";\n clientMessage = clientMessage.split(\"On Wed\")[0].trim(); // basic cleanup example\n\n // Prepare clean structured output\n return {\n json: {\n Email: reply?.From?.match(/<(.+?)>/)?.[1] || reply?.From || \"\",\n ContactPerson: reply?.From?.split(\"<\")[0].trim() || \"\",\n ThreadID: reply?.threadId || data.id || \"\",\n Subject: reply?.Subject || original?.Subject || \"\",\n ClientMessage: clientMessage,\n BookingStatus: \"BOOKED\",\n LastUpdated: new Date().toISOString()\n }\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "dfc24134-8604-47d3-8932-41df52d14620",
"name": "Update Lead Record – Booked (Google Sheets)",
"type": "n8n-nodes-base.googleSheets",
"position": [
2224,
48
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $json.Email }}",
"ThreadID": "={{ $json.ThreadID }}",
"LastUpdated": "={{ $json.LastUpdated }}",
"ClientMessage": "={{ $json.ClientMessage }}",
"Booking Status": "={{ $json.BookingStatus }}"
},
"schema": [
{
"id": "Company Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contact Person",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Contact Person",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Job Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Source",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Lead Source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Booking Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Booking Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ClientMessage",
"type": "string",
"display": true,
"required": false,
"displayName": "ClientMessage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LastUpdated",
"type": "string",
"display": true,
"required": false,
"displayName": "LastUpdated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ThreadID",
"type": "string",
"display": true,
"required": false,
"displayName": "ThreadID",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "outreach automation"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"typeVersion": 4.6
},
{
"id": "bf3a2ee4-1bbc-445e-8c3f-2119dd16e95d",
"name": "Wait Before Second Thread Check (24 hr)",
"type": "n8n-nodes-base.wait",
"position": [
2224,
544
],
"parameters": {
"unit": "hours",
"amount": 24
},
"typeVersion": 1
},
{
"id": "6ac3e8ce-2dac-4953-97d2-3221e3d5be82",
"name": "Send Second Follow-Up Email via Gmail",
"type": "n8n-nodes-base.gmail",
"position": [
1888,
544
],
"parameters": {
"sendTo": "={{ $json.messages[0].To }}",
"message": "=
Hi {{ $json[\"Contact Person\"] || \"there\" }},
\n\nI wanted to quickly follow up on my previous email. \nI understand things can get busy, so just checking if you had a chance to review my message.
\n\nI’d love to schedule a short chat to explore how we could support {{ $('Retrieve Lead Records from Google Sheets').item.json['Contact Person'] }} in your upcoming initiatives.
\n\nIf now’s not a good time, no worries — just let me know when it might be better for you.
\n\nBest regards,
\nYOUR_NAME
\nYOUR_COMPANY