{ "edges": [ { "to": "32163cef-cd7b-4892-908f-d789557728ca", "from": "49538d25-7891-4016-b209-88500e02042b", "toPort": "0", "fromPort": "0" }, { "to": "5f9cd328-150e-42aa-a3f2-e79f142b3245", "from": "01ce8811-eda1-4e23-a164-52b1f270db10", "toPort": "0", "fromPort": "0" }, { "to": "e1f030c5-c8f0-442f-bdb8-221bc1d5f3fe", "from": "5f9cd328-150e-42aa-a3f2-e79f142b3245", "toPort": "0", "fromPort": "0" }, { "to": "a775b2d8-00fd-4136-b948-dcad03b719fe", "from": "e1f030c5-c8f0-442f-bdb8-221bc1d5f3fe", "toPort": "0", "fromPort": "1" }, { "to": "f7e3185f-b4e3-41c3-9b3c-4e83759df231", "from": "a775b2d8-00fd-4136-b948-dcad03b719fe", "toPort": "0", "fromPort": "0" }, { "to": "01ce8811-eda1-4e23-a164-52b1f270db10", "from": "32163cef-cd7b-4892-908f-d789557728ca", "toPort": "0", "fromPort": "0" }, { "to": "91ee46c5-9e8f-47f3-8425-88cbe1d7b777", "from": "f7e3185f-b4e3-41c3-9b3c-4e83759df231", "toPort": "0", "fromPort": "0" }, { "to": "e1f030c5-c8f0-442f-bdb8-221bc1d5f3fe", "from": "aa256e93-8af3-4b47-90a6-731d3438e0af", "toPort": "0", "fromPort": "0" }, { "to": "49538d25-7891-4016-b209-88500e02042b", "from": "91ee46c5-9e8f-47f3-8425-88cbe1d7b777", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "a775b2d8-00fd-4136-b948-dcad03b719fe", "name": "Message a model", "type": "llm", "params": { "modelId": { "__rl": true, "mode": "list", "value": "models/gemini-2.5-flash", "cachedResultName": "models/gemini-2.5-flash" }, "options": {}, "messages": { "values": [ { "content": "=\"You are a world-class Sales Consultant. Write a professional, persuasive sales proposal based on these details:\n\nClient: {{ $json['Client Name'] }}\n\nCompany: {{ $json['Company Name'] }}\n\nGoals: {{ $json['Project Goals'] }}\n\nStructure your response with two headers:\n\nEXECUTIVE SUMMARY\n(Write a 2-paragraph summary here)\n\nPROPOSED SOLUTION\n(Write 3 bullet points of how we solve their specific goals)\n\nTone: Confident, professional, and helpful.\"" } ] }, "provider": "google" }, "position": [ 13328, 4272 ] }, { "id": "91ee46c5-9e8f-47f3-8425-88cbe1d7b777", "name": "Create or update a contact", "type": "integration", "params": { "email": "={{ $('Loop Over Items').item.json['Client Email'] }}", "options": {}, "service": "hubspot", "operation": "read", "authentication": "appToken", "additionalFields": { "firstName": "={{ $('Loop Over Items').item.json['Client Name'] }}", "companyName": "={{ $('Loop Over Items').item.json['Company Name'] }}" } }, "position": [ 13904, 4272 ] }, { "id": "49538d25-7891-4016-b209-88500e02042b", "name": "Copy file", "type": "integration", "params": { "name": "=Proposal - {{ $('Loop Over Items').item.json['Company Name'] }}", "fileId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_DRIVE_FILE_ID", "cachedResultUrl": "https://docs.google.com/document/d/YOUR_GOOGLE_DRIVE_FILE_ID/edit?usp=drivesdk", "cachedResultName": "Master Proposal Template" }, "options": {}, "service": "googleDrive", "operation": "copy" }, "position": [ 14128, 4272 ] }, { "id": "32163cef-cd7b-4892-908f-d789557728ca", "name": "Update a document", "type": "integration", "params": { "simple": false, "service": "googleDocs", "actionsUi": { "actionFields": [ { "text": "{{CompanyName}}", "action": "replaceAll", "matchCase": true, "replaceText": "={{ $('Loop Over Items').item.json['Company Name'] }}" }, { "text": "{{ClientName}}", "action": "replaceAll", "matchCase": true, "replaceText": "={{ $('Loop Over Items').item.json['Client Name'] }}" }, { "text": "{{AI_Summary}}", "action": "replaceAll", "matchCase": true, "replaceText": "={{ $('Code in JavaScript2').item.json.AI_Summary }}" }, { "text": "{{Budget}}", "action": "replaceAll", "matchCase": true, "replaceText": "={{ $('Loop Over Items').item.json['Budget Range'] }}" }, { "text": "{{Date}}", "action": "replaceAll", "matchCase": true, "replaceText": "={{ $('Loop Over Items').item.json.Timestamp }}" }, { "text": "{{AI_Solution}}", "action": "replaceAll", "matchCase": true, "replaceText": "={{ $('Code in JavaScript2').item.json.AI_Solution }}" } ] }, "operation": "update", "documentURL": "={{ $json.id }}" }, "position": [ 14352, 4272 ] }, { "id": "01ce8811-eda1-4e23-a164-52b1f270db10", "name": "Download file", "type": "integration", "params": { "fileId": { "__rl": true, "mode": "id", "value": "={{ $json.documentId }}" }, "options": { "googleFileConversion": { "conversion": { "docsToFormat": "application/pdf" } } }, "service": "googleDrive", "operation": "download" }, "position": [ 14576, 4272 ] }, { "id": "5f9cd328-150e-42aa-a3f2-e79f142b3245", "name": "Send a message", "type": "integration", "params": { "sendTo": "={{ $('Loop Over Items').item.json['Client Email'] }}", "message": "=

Hi <{{ $('Loop Over Items').item.json['Client Name'] }}/span>,

Thank you for reaching out to iTechNotion. It was a pleasure learning about your goals for {{ $('Loop Over Items').item.json['Company Name'] }}.

Based on our discussion regarding your {{ $('Loop Over Items').item.json['Project Goals'] }}, I have prepared a custom proposal for your review. You can find the detailed breakdown in the attached PDF.

What's included in the attachment:

A comprehensive Executive Summary
Our tailored Proposed Solution
Investment and Timeline details

Please let me know if you have any questions or if you would like to schedule a brief call to discuss the next steps.

Best regards,

Krish
Sales Strategy | iTechNotion

", "options": { "attachmentsUi": { "attachmentsBinary": [ {} ] } }, "service": "gmail", "subject": "=Proposal for {{ $('Loop Over Items').item.json['Company Name'] }}", "operation": "read" }, "position": [ 14800, 4352 ] }, { "id": "aa256e93-8af3-4b47-90a6-731d3438e0af", "name": "Google Sheets Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.googleSheetsTrigger", "event": "rowAdded", "options": {}, "pollTimes": { "item": [ { "mode": "everyMinute" } ] }, "sheetName": { "__rl": true, "mode": "list", "value": 397587448, "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit#gid=397587448", "cachedResultName": "Form Responses 1" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_SHEETS_DOCUMENT_ID", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit?usp=drivesdk", "cachedResultName": "Proposal Intake Form (Responses)" } }, "position": [ 12880, 4352 ] }, { "id": "e1f030c5-c8f0-442f-bdb8-221bc1d5f3fe", "name": "Loop Over Items", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ 13104, 4352 ] }, { "id": "f7e3185f-b4e3-41c3-9b3c-4e83759df231", "name": "Code in JavaScript2", "type": "code", "params": { "jsCode": "// Get the text from the previous node\nconst fullText = $input.first().json.content.parts[0].text;\n\n// Split using the Header \"## PROPOSED SOLUTION\"\nconst parts = fullText.split(\"## PROPOSED SOLUTION\");\n\nlet summary = parts[0];\n\n// 1. Remove \"## EXECUTIVE SUMMARY\" header if it exists\nif (summary.includes(\"## EXECUTIVE SUMMARY\")) {\n summary = summary.split(\"## EXECUTIVE SUMMARY\")[1];\n}\n\n// 2. Remove \"Dear [Name],\" intro\nsummary = summary.replace(/Dear .*?,/, \"\").trim();\n\n// 3. CLEANUP FUNCTION: This removes #, *, and extra dashes\nconst cleanText = (text) => {\n return text\n .replace(/[#*]/g, '') // Removes all # and *\n .replace(/---/g, '') // Removes horizontal lines/dashes\n .replace(/\\n\\s*\\n/g, '\\n\\n') // Fixes double spacing\n .trim();\n};\n\nreturn {\n AI_Summary: cleanText(summary),\n AI_Solution: parts[1] ? cleanText(parts[1]) : \"No solution generated.\"\n};" }, "position": [ 13680, 4272 ] } ] }

Create and send AI sales proposals using Gemini, Google Docs & Gmail