{ "edges": [ { "to": "597b672e-5187-47cd-8c11-9558c357affc", "from": "1e8565dd-9538-4875-b31a-da53b69b849d", "toPort": "0", "fromPort": "0" }, { "to": "01540a94-d3a7-4e87-b47c-4ef9d62355c0", "from": "00840730-9479-431c-a116-49b158352763", "toPort": "0", "fromPort": "0" }, { "to": "c1e12098-b371-4a04-b20b-c1453ad24a5d", "from": "00840730-9479-431c-a116-49b158352763", "toPort": "0", "fromPort": "1" }, { "to": "5da4dd2e-a654-44b0-9801-b60ce3189924", "from": "065a88d7-8ad2-421f-af63-f37d34519ccd", "toPort": "0", "fromPort": "0" }, { "to": "00840730-9479-431c-a116-49b158352763", "from": "5da4dd2e-a654-44b0-9801-b60ce3189924", "toPort": "0", "fromPort": "0" }, { "to": "065a88d7-8ad2-421f-af63-f37d34519ccd", "from": "1e8ae181-0d83-4be2-a225-3f11cb7163dc", "toPort": "0", "fromPort": "0" }, { "to": "1e8ae181-0d83-4be2-a225-3f11cb7163dc", "from": "597b672e-5187-47cd-8c11-9558c357affc", "toPort": "0", "fromPort": "0" }, { "to": "1e8ae181-0d83-4be2-a225-3f11cb7163dc", "from": "90fb7e98-29a0-4f57-9fbc-49a92ecb0bb6", "toPort": "0", "fromPort": "ai_languageModel" } ], "nodes": [ { "id": "90fb7e98-29a0-4f57-9fbc-49a92ecb0bb6", "name": "Google Gemini Chat Model2", "type": "llm", "params": { "options": {}, "provider": "google" }, "position": [ 5376, 3904 ] }, { "id": "c1e12098-b371-4a04-b20b-c1453ad24a5d", "name": "Nurture Email — Medium/Low Lead2", "type": "integration", "params": { "html": "=\n

\n\n\n\n\n

We Received Your Inquiry

Our team will be in touch shortly

Hi {{ $('Parse AI Output2').first().json.full_name }},

Thanks for your inquiry! Based on your requirements, we may have available properties that match what you are looking for.

Would you like to schedule a showing this week?

Your Inquiry Summary

Property: {{ $('Parse AI Output2').first().json.property_type }}

Location: {{ $('Parse AI Output2').first().json.location }}

Budget: {{ $('Parse AI Output2').first().json.budget }}

While you wait:

- Browse our latest listings on our website

- Prepare your documents: ID and proof of income

- Shortlist your must-have features

We will be in touch within 1-2 business days.

Warm regards,
The Leasing Team

You received this because you submitted a property inquiry.

\n", "options": { "appendAttribution": false }, "service": "smtp", "subject": "=Thanks for reaching out, {{ $('Parse AI Output2').first().json.full_name }}!", "toEmail": "={{ $('Parse AI Output2').first().json.email }}", "fromEmail": "user@example.com", "operation": "read" }, "position": [ 6816, 3840 ] }, { "id": "01540a94-d3a7-4e87-b47c-4ef9d62355c0", "name": "Priority Email — High Lead2", "type": "integration", "params": { "html": "=\n

\n\n\n\n\n

Great News!

We have matching properties for you

Hi {{ $('Parse AI Output2').first().json.full_name }},

Thanks for your inquiry! Based on your requirements, we may have available properties that are a great match.

Would you like to schedule a showing this week?

Your Inquiry Summary

Property: {{ $('Parse AI Output2').first().json.property_type }}

Purpose: {{ $('Parse AI Output2').first().json.purpose }}

Location: {{ $('Parse AI Output2').first().json.location }}

Budget: {{ $('Parse AI Output2').first().json.budget }}

Timeline: {{ $('Parse AI Output2').first().json.timeline }}

Our Assessment

A senior agent will contact you within 2 hours.

Warm regards,
The Leasing Team

You received this because you submitted a property inquiry.

\n", "options": { "appendAttribution": false }, "service": "smtp", "subject": "=🏠 {{ $('Parse AI Output2').first().json.full_name }}, we have properties matching your needs!", "toEmail": "={{ $('Parse AI Output2').first().json.email }}", "fromEmail": "user@example.com", "operation": "read" }, "position": [ 6816, 3360 ] }, { "id": "00840730-9479-431c-a116-49b158352763", "name": "High Lead?2", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 1, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "check-high", "operator": { "type": "string", "operation": "equals" }, "leftValue": "={{ $('Parse AI Output2').first().json.lead_score }}", "rightValue": "High" } ] } }, "position": [ 6464, 3600 ] }, { "id": "5da4dd2e-a654-44b0-9801-b60ce3189924", "name": "Save to Airtable2", "type": "integration", "params": { "base": { "__rl": true, "mode": "id", "value": "apphmQzLXYHppqZTB" }, "table": { "__rl": true, "mode": "id", "value": "tbl9t6jSZ8Eg2qn7d" }, "columns": { "value": { "Notes": "={{ $json.notes }}", "Intent": "={{ $json.intent }}", "Purpose": "={{ $json.purpose }}", "Timeline": "={{ $json.timeline }}", "Full Name": "={{ $json.full_name }}", "Lead Score": "={{ $json.lead_score }}", "Submit Date": "={{ $json.submit_date }}", "Budget Range": "={{ $json.budget }}", "Requirements": "={{ $json.requirements }}", "Email Address": "={{ $json.email }}", "Property Type": "={{ $json.property_type }}", "Preferred Location": "={{ $json.location }}", "Mobile Phone Number": "={{ $json.phone }}" }, "schema": [ { "id": "Full Name", "type": "string", "display": true, "required": false, "displayName": "Full Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email Address", "type": "string", "display": true, "required": false, "displayName": "Email Address", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Mobile Phone Number", "type": "string", "display": true, "required": false, "displayName": "Mobile Phone Number", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Property Type", "type": "string", "display": true, "required": false, "displayName": "Property Type", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Purpose", "type": "string", "display": true, "required": false, "displayName": "Purpose", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Preferred Location", "type": "string", "display": true, "required": false, "displayName": "Preferred Location", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Budget Range", "type": "string", "display": true, "required": false, "displayName": "Budget Range", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Requirements", "type": "string", "display": true, "required": false, "displayName": "Requirements", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Submit Date", "type": "string", "display": true, "required": false, "displayName": "Submit Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Lead Score", "type": "string", "display": true, "required": false, "displayName": "Lead Score", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Intent", "type": "string", "display": true, "required": false, "displayName": "Intent", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Timeline", "type": "string", "display": true, "required": false, "displayName": "Timeline", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Notes", "type": "string", "display": true, "required": false, "displayName": "Notes", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow" }, "options": { "typecast": true }, "service": "airtable", "operation": "create" }, "position": [ 6096, 3600 ] }, { "id": "065a88d7-8ad2-421f-af63-f37d34519ccd", "name": "Parse AI Output2", "type": "code", "params": { "jsCode": "const aiRaw = $input.first().json.output || '';\nconst formData = $('Extract Typeform Fields1').first().json;\n\nconsole.log('Raw AI output:', aiRaw);\n\nlet parsed = null;\n\n// Attempt 1: direct parse\ntry { parsed = JSON.parse(aiRaw.trim()); } catch(e) {}\n\n// Attempt 2: strip markdown fences\nif (!parsed) {\n try {\n const s = aiRaw.replace(/```json/gi,'').replace(/```/g,'').trim();\n parsed = JSON.parse(s);\n } catch(e) {}\n}\n\n// Attempt 3: extract JSON block\nif (!parsed) {\n try {\n const m = aiRaw.match(/\\{[\\s\\S]*\\}/);\n if (m) parsed = JSON.parse(m[0]);\n } catch(e) {}\n}\n\n// Attempt 4: regex fallback\nif (!parsed) {\n const s = aiRaw.match(/lead_score[\"'\\s:]+([\"']?)(High|Medium|Low)\\1/i);\n const i = aiRaw.match(/intent[\"'\\s:]+[\"']([^\"'\\n,}]{3,100})[\"']/);\n const t = aiRaw.match(/timeline[\"'\\s:]+[\"']([^\"'\\n,}]{3,100})[\"']/);\n const n = aiRaw.match(/notes[\"'\\s:]+[\"']([^\"'\\n,}]{3,300})[\"']/);\n parsed = {\n lead_score: s ? s[2] : 'Medium',\n intent: i ? i[1].trim() : 'Needs review',\n timeline: t ? t[1].trim() : 'Not specified',\n notes: n ? n[1].trim() : 'Manual review required'\n };\n}\n\n// Ensure lead_score is exactly High / Medium / Low\nconst validScores = ['High', 'Medium', 'Low'];\nif (!validScores.includes(parsed.lead_score)) {\n parsed.lead_score = 'Medium';\n}\n\nconsole.log('Final parsed:', parsed);\n\nreturn [{\n json: {\n full_name: formData.name || '',\n email: formData.email || '',\n phone: formData.phone || '',\n property_type: formData.property_type || '',\n purpose: formData.purpose || '',\n location: formData.location || '',\n budget: formData.budget || '',\n requirements: formData.requirements || '',\n submit_date: formData.submit_date || new Date().toISOString(),\n lead_score: parsed.lead_score,\n intent: parsed.intent || '',\n timeline: parsed.timeline || '',\n notes: parsed.notes || ''\n }\n}];" }, "position": [ 5728, 3600 ] }, { "id": "1e8ae181-0d83-4be2-a225-3f11cb7163dc", "name": "AI Lead Qualifier2", "type": "llm", "params": { "text": "=You are an AI leasing assistant for a real estate company.\n\nAnalyze this property inquiry and return ONLY a raw JSON object.\nNo markdown. No code fences. No explanation. Just the JSON.\n\nExact format:\n{\"lead_score\":\"High\",\"intent\":\"...\",\"timeline\":\"...\",\"notes\":\"...\"}\n\nlead_score must be exactly one of: High, Medium, Low\n\nLead Data:\n- Name: {{ $json.name }}\n- Email: {{ $json.email }}\n- Phone: {{ $json.phone }}\n- Property Type: {{ $json.property_type }}\n- Purpose: {{ $json.purpose }}\n- Location: {{ $json.location }}\n- Budget: {{ $json.budget }}\n- Requirements: {{ $json.requirements }}\n\nScoring Rules:\n- High = has budget + specific location + clear purpose (investment or near-term)\n- Medium = partial info, needs follow-up\n- Low = vague, missing budget or location\n\nReturn JSON only. No other text whatsoever.", "prompt": "=You are an AI leasing assistant for a real estate company.\n\nAnalyze this property inquiry and return ONLY a raw JSON object.\nNo markdown. No code fences. No explanation. Just the JSON.\n\nExact format:\n{\"lead_score\":\"High\",\"intent\":\"...\",\"timeline\":\"...\",\"notes\":\"...\"}\n\nlead_score must be exactly one of: High, Medium, Low\n\nLead Data:\n- Name: {{ $json.name }}\n- Email: {{ $json.email }}\n- Phone: {{ $json.phone }}\n- Property Type: {{ $json.property_type }}\n- Purpose: {{ $json.purpose }}\n- Location: {{ $json.location }}\n- Budget: {{ $json.budget }}\n- Requirements: {{ $json.requirements }}\n\nScoring Rules:\n- High = has budget + specific location + clear purpose (investment or near-term)\n- Medium = partial info, needs follow-up\n- Low = vague, missing budget or location\n\nReturn JSON only. No other text whatsoever.", "options": { "systemMessage": "You are a real estate lead qualification AI. Return raw JSON only. No markdown. No code blocks. No explanation. Just the JSON object on a single line." }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "You are a real estate lead qualification AI. Return raw JSON only. No markdown. No code blocks. No explanation. Just the JSON object on a single line." }, "position": [ 5264, 3600 ] }, { "id": "597b672e-5187-47cd-8c11-9558c357affc", "name": "Extract Typeform Fields1", "type": "code", "params": { "jsCode": "// ============================================================\n// EXACT TYPEFORM FIELD EXTRACTOR\n// Based on confirmed payload with exact field refs\n// ============================================================\n\nconst input = $input.first().json;\n\n// Typeform sends data inside form_response\nconst fr = input.body?.form_response || input.form_response || input.body || input;\nconst answers = fr.answers || [];\n\nconsole.log('Total answers received:', answers.length);\nconsole.log('Raw answers:', JSON.stringify(answers));\n\n// Known field refs from your form\nconst REF_NAME = '12829b05-575d-4c31-9569-79ddd0d9f2c2';\nconst REF_PHONE = 'afd6483f-643d-4656-8e9d-d343c3745356';\nconst REF_EMAIL = 'ebf62b12-c7f5-437f-aefd-848d645794cc';\nconst REF_PROP_TYPE = 'eebd1c48-17b6-4139-a479-c6426b0fd968';\nconst REF_PURPOSE = '9bd9f234-e544-49ae-b8a7-db3ed0b7764e';\nconst REF_LOCATION = '44dc617b-f453-4ec3-8737-be40897c8505';\nconst REF_BUDGET = '15471e0f-d172-4b2f-aaf1-c7f0799fc4bf';\nconst REF_REQUIREMENTS= '60ddbcf2-dd8b-490a-a0dd-f48bd629a30d';\nconst REF_CONSENT = '5b0075bb-75fe-47e9-9b0c-ad4364d45ea9';\n\n// Build a ref -> answer map\nconst refMap = {};\nfor (const a of answers) {\n const ref = a.field?.ref;\n if (ref) refMap[ref] = a;\n}\n\n// Extract value from answer object\nfunction extract(ref) {\n const a = refMap[ref];\n if (!a) return '';\n if (a.type === 'text') return a.text || '';\n if (a.type === 'email') return a.email || '';\n if (a.type === 'phone_number') return a.phone_number || '';\n if (a.type === 'choice') return a.choice?.label || '';\n if (a.type === 'choices') return (a.choices?.labels || []).join(', ');\n if (a.type === 'boolean') return a.boolean ? 'Yes' : 'No';\n if (a.type === 'number') return String(a.number || '');\n return '';\n}\n\nconst name = extract(REF_NAME);\nconst phone = extract(REF_PHONE);\nconst email = extract(REF_EMAIL);\nconst propertyType = extract(REF_PROP_TYPE);\nconst purpose = extract(REF_PURPOSE);\nconst location = extract(REF_LOCATION);\nconst budget = extract(REF_BUDGET);\nconst requirements = extract(REF_REQUIREMENTS);\nconst consent = extract(REF_CONSENT);\nconst submitDate = fr.submitted_at || new Date().toISOString();\n\nconsole.log('Extracted:', { name, phone, email, propertyType, purpose, location, budget, requirements });\n\nreturn [{\n json: {\n name,\n email,\n phone,\n property_type: propertyType,\n purpose,\n location,\n budget,\n requirements,\n consent,\n submit_date: submitDate\n }\n}];" }, "position": [ 4912, 3600 ] }, { "id": "1e8565dd-9538-4875-b31a-da53b69b849d", "name": "Webhook1", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "1676a463-d7fc-43e0-8eba-c654b1e31599", "options": {}, "httpMethod": "POST" }, "position": [ 4528, 3600 ] } ] }

Qualify real estate leads from Typeform to Airtable with Gemini and smart email routing