{ "edges": [ { "to": "a8cb4707-79a1-4a1d-8f24-2881347fe74b", "from": "9535d998-9816-4aea-bee5-93c5a1323b1a", "toPort": "0", "fromPort": "0" }, { "to": "9535d998-9816-4aea-bee5-93c5a1323b1a", "from": "b66c9740-a51e-463f-bc1b-40747639ce45", "toPort": "0", "fromPort": "0" }, { "to": "9535d998-9816-4aea-bee5-93c5a1323b1a", "from": "47045630-171a-46a5-a8b6-3657675174d4", "toPort": "0", "fromPort": "0" }, { "to": "9535d998-9816-4aea-bee5-93c5a1323b1a", "from": "1dc10ddd-8aa9-4c64-bfbb-45be477a0fe3", "toPort": "0", "fromPort": "0" }, { "to": "cab90c6f-3d54-4ce0-9821-452a98cb0be7", "from": "a8cb4707-79a1-4a1d-8f24-2881347fe74b", "toPort": "0", "fromPort": "0" }, { "to": "48ba4123-9abe-4d95-85d3-7d29865bf019", "from": "f3b5cae7-d55c-4178-9573-8e0164e93341", "toPort": "0", "fromPort": "1" }, { "to": "9535d998-9816-4aea-bee5-93c5a1323b1a", "from": "8e477fd8-4b68-4b68-889a-e80e460b1245", "toPort": "0", "fromPort": "0" }, { "to": "4baba23c-0118-456c-a68b-a2bfbab88342", "from": "e8af0b57-5323-473d-9fd2-1d445b962057", "toPort": "0", "fromPort": "0" }, { "to": "5cbe9599-f05a-4dc7-9cd1-cca9b6fa424f", "from": "4baba23c-0118-456c-a68b-a2bfbab88342", "toPort": "0", "fromPort": "0" }, { "to": "5fbc77e6-0dca-42aa-9ba2-46d32bb9d625", "from": "48ba4123-9abe-4d95-85d3-7d29865bf019", "toPort": "0", "fromPort": "0" }, { "to": "f3b5cae7-d55c-4178-9573-8e0164e93341", "from": "cab90c6f-3d54-4ce0-9821-452a98cb0be7", "toPort": "0", "fromPort": "0" }, { "to": "1dc10ddd-8aa9-4c64-bfbb-45be477a0fe3", "from": "9ac6c324-8e04-46c9-b55f-3ee60eb46d28", "toPort": "0", "fromPort": "0" }, { "to": "8e477fd8-4b68-4b68-889a-e80e460b1245", "from": "9ac6c324-8e04-46c9-b55f-3ee60eb46d28", "toPort": "0", "fromPort": "1" }, { "to": "b66c9740-a51e-463f-bc1b-40747639ce45", "from": "9ac6c324-8e04-46c9-b55f-3ee60eb46d28", "toPort": "0", "fromPort": "2" }, { "to": "47045630-171a-46a5-a8b6-3657675174d4", "from": "9ac6c324-8e04-46c9-b55f-3ee60eb46d28", "toPort": "0", "fromPort": "3" }, { "to": "3520d855-5e99-466e-b636-4833c57ec66d", "from": "5cbe9599-f05a-4dc7-9cd1-cca9b6fa424f", "toPort": "0", "fromPort": "0" }, { "to": "f3b5cae7-d55c-4178-9573-8e0164e93341", "from": "3520d855-5e99-466e-b636-4833c57ec66d", "toPort": "0", "fromPort": "0" }, { "to": "9ac6c324-8e04-46c9-b55f-3ee60eb46d28", "from": "5fbc77e6-0dca-42aa-9ba2-46d32bb9d625", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "5cbe9599-f05a-4dc7-9cd1-cca9b6fa424f", "name": "Remove Duplicate Emails", "type": "passthrough", "params": { "mode": "removeDuplicates", "compare": "selectedFields", "options": { "removeOtherFields": false }, "fieldsToCompare": "Email" }, "position": [ 480, 512 ] }, { "id": "3520d855-5e99-466e-b636-4833c57ec66d", "name": "Validate Email and Name", "type": "passthrough", "params": { "mode": "filter", "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "email-check", "operator": { "type": "boolean", "operation": "equals" }, "leftValue": "={{ /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test($json['Email']) }}", "rightValue": true }, { "id": "name-check", "operator": { "type": "boolean", "operation": "equals" }, "leftValue": "={{ ($json['Name'] || '').trim().length > 0 }}", "rightValue": true } ] } }, "position": [ 704, 512 ] }, { "id": "f3b5cae7-d55c-4178-9573-8e0164e93341", "name": "Loop Over Items", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ 928, 512 ] }, { "id": "48ba4123-9abe-4d95-85d3-7d29865bf019", "name": "Read Tracking Sheet", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "YOUR_RESOURCE_ID_HERE" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_RESOURCE_ID_HERE" } }, "position": [ 1168, 528 ] }, { "id": "5fbc77e6-0dca-42aa-9ba2-46d32bb9d625", "name": "Skip If Already In Sequence", "type": "code", "params": { "jsCode": "// ── Per-item duplicate check — runs fresh each loop iteration ──\nconst BLOCKING = ['sent','followup_1','completed','replied','unsubscribed'];\n\n// Current lead from the loop (1 item at a time)\nconst lead = $('Loop Over Items').item.json;\nconst leadEmail = (lead['Email'] || '').toLowerCase().trim();\n\n// Check tracking sheet rows\nconst alreadyTracked = $input.all().some(row => {\n const rowEmail = (row.json['Email'] || row.json['email'] || '').toLowerCase().trim();\n const rowStatus = (row.json['status'] || row.json['Status'] || '').toLowerCase().trim();\n return rowEmail === leadEmail && BLOCKING.includes(rowStatus);\n});\n\nif (alreadyTracked) return [];\nreturn [{ json: lead }];\n" }, "position": [ 1376, 528 ] }, { "id": "9ac6c324-8e04-46c9-b55f-3ee60eb46d28", "name": "Route by Partner Type", "type": "switch", "params": { "rules": { "values": [ { "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "or", "conditions": [ { "id": "college-rule", "operator": { "type": "string", "operation": "contains" }, "leftValue": "={{ $json['partner_type'] }}", "rightValue": "College" } ] } }, { "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "or", "conditions": [ { "id": "influencer-rule", "operator": { "type": "string", "operation": "contains" }, "leftValue": "={{ $json['partner_type'] }}", "rightValue": "Influencer" } ] } }, { "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "or", "conditions": [ { "id": "brand-rule", "operator": { "type": "string", "operation": "contains" }, "leftValue": "={{ $json['partner_type'] }}", "rightValue": "Brand" } ] } } ] }, "options": { "fallbackOutput": "extra" } }, "position": [ 1616, 496 ] }, { "id": "1dc10ddd-8aa9-4c64-bfbb-45be477a0fe3", "name": "College Email", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "c-re", "name": "recipientEmail", "type": "string", "value": "={{ $json['Email'] }}" }, { "id": "c-rn", "name": "recipientName", "type": "string", "value": "={{ $json['Name'] }}" }, { "id": "c-pt", "name": "partnerType", "type": "string", "value": "College" }, { "id": "c-sub", "name": "emailSubject", "type": "string", "value": "=Collaboration opportunity with [YOUR COMPANY] — for {{ $json['Company'] || 'your' }} students" }, { "id": "c-bod", "name": "emailBody", "type": "string", "value": "=

Hi {{ $json['Name'].split(' ')[0] }},

We came across {{ $json['Company'] || 'your institution' }} and would love to explore a campus partnership with you!

Here is what a partnership with [YOUR COMPANY] looks like:

🎓 Guest lectures and workshops by our team for your students
💼 Internship and placement opportunities at [YOUR COMPANY]
🏆 Sponsored hackathons, case study competitions, and prizes
📚 Free access to [YOUR PRODUCT] for students and faculty

We already partner with leading institutions and have helped 500+ students kickstart their careers.

I'd love to jump on a quick 20-minute call to explore this — no pitch, just a genuine conversation.

📅 Schedule a Chat

Looking forward to it,
[YOUR NAME]
[YOUR TITLE] · [YOUR COMPANY]
[YOUR PHONE] · [YOUR EMAIL]

You received this because you filled out our partner interest form.
Unsubscribe

" } ] } }, "position": [ 1904, 464 ] }, { "id": "8e477fd8-4b68-4b68-889a-e80e460b1245", "name": "Influencer Email", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "i-re", "name": "recipientEmail", "type": "string", "value": "={{ $json['Email'] }}" }, { "id": "i-rn", "name": "recipientName", "type": "string", "value": "={{ $json['Name'] }}" }, { "id": "i-pt", "name": "partnerType", "type": "string", "value": "Influencer" }, { "id": "i-sub", "name": "emailSubject", "type": "string", "value": "=Collab opportunity — [YOUR COMPANY] x {{ $json['Name'].split(' ')[0] }} 🚀" }, { "id": "i-bod", "name": "emailBody", "type": "string", "value": "=

Hi {{ $json['Name'].split(' ')[0] }},

Huge fan of your content — we think [YOUR COMPANY] and you would be a perfect match!

Here is what a partnership with [YOUR COMPANY] looks like:

💰 Competitive flat fee + performance-based revenue share
🎁 Free lifetime access to [YOUR PRODUCT] for you and your audience
📸 Full creative freedom — no rigid scripts, just authentic content
📣 Cross-promotion to our audience of [X]K followers

Our creator partners see strong engagement and have driven thousands of signups with a single post.

I'd love to jump on a quick 20-minute call to explore this — no pitch, just a genuine conversation.

📅 Let's Talk Collab

Looking forward to it,
[YOUR NAME]
[YOUR TITLE] · [YOUR COMPANY]
[YOUR PHONE] · [YOUR EMAIL]

You received this because you filled out our partner interest form.
Unsubscribe

" } ] } }, "position": [ 1904, 640 ] }, { "id": "b66c9740-a51e-463f-bc1b-40747639ce45", "name": "Brand Email", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "b-re", "name": "recipientEmail", "type": "string", "value": "={{ $json['Email'] }}" }, { "id": "b-rn", "name": "recipientName", "type": "string", "value": "={{ $json['Name'] }}" }, { "id": "b-pt", "name": "partnerType", "type": "string", "value": "Brand" }, { "id": "b-sub", "name": "emailSubject", "type": "string", "value": "=Brand partnership with [YOUR COMPANY] — let's grow together, {{ $json['Name'].split(' ')[0] }}" }, { "id": "b-bod", "name": "emailBody", "type": "string", "value": "=

Hi {{ $json['Name'].split(' ')[0] }},

We'd love to explore a brand partnership between {{ $json['Company'] || 'your team' }} and {{ $json.Name }}!

Here is what a partnership with [YOUR COMPANY] looks like:

📣 Co-branded campaigns reaching both our audiences
🤝 Joint product bundles and exclusive offers
📊 Shared performance dashboards and transparent reporting
🚀 Co-sponsored events, webinars, and activations

Our brand partners typically see a 2–4x uplift in qualified leads within the first campaign.

I'd love to jump on a quick 20-minute call to explore this — no pitch, just a genuine conversation.

📅 Explore the Partnership

Looking forward to it,
[YOUR NAME]
[YOUR TITLE] · [YOUR COMPANY]
[YOUR PHONE] · [YOUR EMAIL]

You received this because you filled out our partner interest form.
Unsubscribe

" } ] } }, "position": [ 1904, 816 ] }, { "id": "47045630-171a-46a5-a8b6-3657675174d4", "name": "Other Email", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "o-re", "name": "recipientEmail", "type": "string", "value": "={{ $json['Email'] }}" }, { "id": "o-rn", "name": "recipientName", "type": "string", "value": "={{ $json['Name'] }}" }, { "id": "o-pt", "name": "partnerType", "type": "string", "value": "={{ $json['partner_type'] || 'Other' }}" }, { "id": "o-sub", "name": "emailSubject", "type": "string", "value": "=Thanks for reaching out, {{ $json['Name'].split(' ')[0] }} — let's connect" }, { "id": "o-bod", "name": "emailBody", "type": "string", "value": "=

Hi {{ $json['Name'].split(' ')[0] }},

Thanks for filling out our form — great to hear from {{ $json['Company'] || 'your team' }}!

Here is what a partnership with [YOUR COMPANY] looks like:

🤝 Flexible partnership structures tailored to your goals
🚀 Fast onboarding and a dedicated point of contact
📈 Mutual growth and cross-promotion opportunities

We are always open to exploring creative ways to work together.

I'd love to jump on a quick 20-minute call to explore this — no pitch, just a genuine conversation.

📅 Book a Quick Call

Looking forward to it,
[YOUR NAME]
[YOUR TITLE] · [YOUR COMPANY]
[YOUR PHONE] · [YOUR EMAIL]

You received this because you filled out our partner interest form.
Unsubscribe

" } ] } }, "position": [ 1904, 992 ] }, { "id": "cab90c6f-3d54-4ce0-9821-452a98cb0be7", "name": "Add to Tracking Sheet", "type": "integration", "params": { "columns": { "value": { "Name": "={{ $('Skip If Already In Sequence').item.json.Name }}", "Email": "={{ $('Skip If Already In Sequence').item.json['Email'] }}", "status": "sent", "sent_date": "={{ $now.toFormat(\"yyyy/MM/dd\") }}", "thread_id": "={{ $json.code }}", "email_type": "={{ $('Skip If Already In Sequence').item.json.email_type }}", "message_id": "={{ $json.code }}", "row_number": "={{ $('Skip If Already In Sequence').item.json.row_number }}", "partner_type": "={{ $('Skip If Already In Sequence').item.json['partner_type'] }}", "follow_up_date": "={{ $now.plus({days: 5}).toISODate() }}", "original_subject": "={{ $('Wait').item.json.emailSubject }}" }, "schema": [ { "id": "row_number", "type": "string", "display": true, "removed": false, "required": false, "displayName": "row_number", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Name", "type": "string", "display": true, "required": false, "displayName": "Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "partner_type", "type": "string", "display": true, "required": false, "displayName": "partner_type", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "status", "type": "string", "display": true, "required": false, "displayName": "status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "sent_date", "type": "string", "display": true, "required": false, "displayName": "sent_date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "email_type", "type": "string", "display": true, "required": false, "displayName": "email_type", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "follow_up_date", "type": "string", "display": true, "required": false, "displayName": "follow_up_date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "thread_id", "type": "string", "display": true, "required": false, "displayName": "thread_id", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "message_id", "type": "string", "display": true, "required": false, "displayName": "message_id", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "original_subject", "type": "string", "display": true, "removed": false, "required": false, "displayName": "original_subject", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "Email" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "appendOrUpdate", "sheetName": { "__rl": true, "mode": "list", "value": "YOUR_RESOURCE_ID_HERE" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_RESOURCE_ID_HERE" } }, "position": [ 2512, 736 ] }, { "id": "9535d998-9816-4aea-bee5-93c5a1323b1a", "name": "Wait", "type": "passthrough", "params": { "mode": "noOp", "amount": 10 }, "position": [ 2128, 736 ] }, { "id": "4baba23c-0118-456c-a68b-a2bfbab88342", "name": "Get row(s) in sheet", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "YOUR_RESOURCE_ID_HERE" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_RESOURCE_ID_HERE" } }, "position": [ 256, 512 ] }, { "id": "e8af0b57-5323-473d-9fd2-1d445b962057", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ {} ] } }, "position": [ 32, 512 ] }, { "id": "a8cb4707-79a1-4a1d-8f24-2881347fe74b", "name": "Initial Email", "type": "integration", "params": { "service": "zohozeptomail", "subject": "={{ $json.emailSubject }}", "htmlbody": "={{ $json.emailBody }}", "mailagent": "555046c28339d27e", "operation": "run", "toaddress": "={{ $json.recipientEmail }}", "attachment": {}, "fromaddress": { "name": "Think Sage", "address": "YOUR_EMAIL_HERE" }, "__originalType": "n8n-nodes-zohozeptomail.zohoZeptomail" }, "position": [ 2320, 736 ] } ] }

Send deduplicated partner outreach emails from Google Sheets via Zoho ZeptoMail