{ "edges": [ { "to": "a42f7772-338a-4fee-a65c-318b65a67a2f", "from": "c6f66df9-3531-4afc-996f-603a4b7a1a0d", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "a42f7772-338a-4fee-a65c-318b65a67a2f", "from": "f5d4f9fe-8a4c-4f6e-b711-7d94cf60e103", "toPort": "0", "fromPort": "0" }, { "to": "d3d7f9af-c98e-4b9b-b9b4-be7d51ec7a78", "from": "f5d4f9fe-8a4c-4f6e-b711-7d94cf60e103", "toPort": "0", "fromPort": "1" }, { "to": "a368613e-4bf0-4041-a419-8107c9398121", "from": "f22e31fc-6725-44c5-b0f5-b45bcf677700", "toPort": "0", "fromPort": "0" }, { "to": "6858bace-eeb4-4f16-b756-59f2e5dcc1ca", "from": "e7fcaca8-8bd8-41f0-8bee-100db9907de3", "toPort": "0", "fromPort": "0" }, { "to": "63cfea6b-7ecf-4b5b-966a-8dd3d1f88d7c", "from": "a368613e-4bf0-4041-a419-8107c9398121", "toPort": "0", "fromPort": "0" }, { "to": "8e5c8818-85e3-42d2-ab2b-46833fe341dc", "from": "c3c0edd3-9911-491c-810f-4bf571cad2ac", "toPort": "0", "fromPort": "0" }, { "to": "0cca83d1-8d20-46a0-8190-c8ab7411d2f7", "from": "63cfea6b-7ecf-4b5b-966a-8dd3d1f88d7c", "toPort": "0", "fromPort": "0" }, { "to": "f5d4f9fe-8a4c-4f6e-b711-7d94cf60e103", "from": "6858bace-eeb4-4f16-b756-59f2e5dcc1ca", "toPort": "0", "fromPort": "0" }, { "to": "f22e31fc-6725-44c5-b0f5-b45bcf677700", "from": "a42f7772-338a-4fee-a65c-318b65a67a2f", "toPort": "0", "fromPort": "0" }, { "to": "e7fcaca8-8bd8-41f0-8bee-100db9907de3", "from": "8e5c8818-85e3-42d2-ab2b-46833fe341dc", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "c3c0edd3-9911-491c-810f-4bf571cad2ac", "name": "Check for Vollna Alerts", "type": "trigger", "params": { "kind": "n8n-nodes-base.gmailTrigger", "filters": { "sender": "user@example.com", "readStatus": "unread" }, "pollTimes": { "item": [ { "mode": "everyX", "unit": "minutes", "value": 30 } ] } }, "position": [ 672, 208 ] }, { "id": "8e5c8818-85e3-42d2-ab2b-46833fe341dc", "name": "Configure Profile and Settings", "type": "code", "params": { "jsCode": "// ================================================\n// EDIT THIS NODE -- all your settings live here\n// ================================================\n\nconst YOUR_NAME = 'Your Name';\nconst YOUR_SKILLS = 'n8n, Make.com, Claude API, Zapier, AI agents, workflow automation';\nconst YOUR_BIO = 'I build AI-powered automations for B2B businesses. Recent work includes a hiring automation that screened 230 applications at 95% accuracy and a cold email reply classifier used in production.';\nconst YOUR_HOURLY_RATE = 30; // USD -- used for scoring budget fit\nconst MIN_BUDGET_FIXED = 75; // Skip fixed-price jobs below this\nconst MIN_BUDGET_HOURLY = 15; // Skip hourly jobs below this\nconst SCORE_THRESHOLD = 6; // Only write proposals for jobs scoring 6 or above (out of 10)\nconst SKIP_KEYWORDS = ['expert level', 'senior only', 'agency only', 'wordpress', 'shopify theme'];\n\n// ================================================\n// DO NOT EDIT BELOW THIS LINE\n// ================================================\n\nconst email = $input.first().json;\nconst rawHtml = email.html || email.body || '';\nconst subject = email.subject || '';\nconst timestamp = new Date().toISOString();\n\nreturn [{\n json: {\n your_name: YOUR_NAME,\n your_skills: YOUR_SKILLS,\n your_bio: YOUR_BIO,\n your_hourly_rate: YOUR_HOURLY_RATE,\n min_budget_fixed: MIN_BUDGET_FIXED,\n min_budget_hourly: MIN_BUDGET_HOURLY,\n score_threshold: SCORE_THRESHOLD,\n skip_keywords: SKIP_KEYWORDS,\n raw_html: rawHtml,\n email_subject: subject,\n timestamp: timestamp\n }\n}];" }, "position": [ 912, 208 ] }, { "id": "6858bace-eeb4-4f16-b756-59f2e5dcc1ca", "name": "Score Job Against Profile", "type": "code", "params": { "jsCode": "// Score this job 1-10 against the freelancer profile\nconst job = $input.first().json;\n\n// Skip if no jobs found in email\nif (job._no_jobs) {\n return [{ json: { ...job, score: 0, score_reasoning: 'No jobs found in email', status: 'SKIPPED' } }];\n}\n\nconst title = (job.title || '').toLowerCase();\nconst budgetText = (job.budget_text || '').toLowerCase();\nconst budgetType = (job.budget_type || '').toLowerCase();\nconst skills = (job.your_skills || '').toLowerCase();\nconst skipKeywords = job.skip_keywords || [];\n\nlet score = 5; // start neutral\nlet reasons = [];\n\n// Check skip keywords first\nfor (const kw of skipKeywords) {\n if (title.includes(kw.toLowerCase())) {\n return [{ json: {\n ...job,\n score: 0,\n score_reasoning: 'Contains skip keyword: ' + kw,\n status: 'SKIPPED'\n }}];\n }\n}\n\n// Score: skill match\nconst skillList = skills.split(',').map(s => s.trim());\nlet skillMatches = 0;\nfor (const skill of skillList) {\n if (skill.length > 2 && title.includes(skill)) skillMatches++;\n}\nif (skillMatches >= 2) { score += 2; reasons.push('strong skill match'); }\nelse if (skillMatches === 1) { score += 1; reasons.push('partial skill match'); }\nelse { score -= 1; reasons.push('low skill match'); }\n\n// Score: budget\nconst budgetNum = parseFloat(budgetText.replace(/[^0-9.]/g, '')) || 0;\nconst isHourly = budgetType.includes('hourly');\nconst isFixed = budgetType.includes('fixed');\nconst minFixed = job.min_budget_fixed || 75;\nconst minHourly = job.min_budget_hourly || 15;\n\nif (isFixed && budgetNum > 0 && budgetNum < minFixed) {\n score -= 2; reasons.push('budget below minimum');\n} else if (isHourly && budgetNum > 0 && budgetNum < minHourly) {\n score -= 2; reasons.push('rate below minimum');\n} else if (budgetNum === 0 || budgetText === 'not specified') {\n score -= 1; reasons.push('budget not specified');\n} else if (isFixed && budgetNum >= 300) {\n score += 2; reasons.push('high budget');\n} else if (isHourly && budgetNum >= job.your_hourly_rate) {\n score += 2; reasons.push('good rate');\n} else {\n score += 1; reasons.push('acceptable budget');\n}\n\n// Score: automation/AI keywords in title\nconst hotKeywords = ['n8n', 'make.com', 'zapier', 'claude', 'ai agent', 'automation', 'workflow', 'openai', 'chatgpt', 'anthropic', 'gohighlevel', 'ghl'];\nfor (const kw of hotKeywords) {\n if (title.includes(kw)) { score += 1; reasons.push('hot keyword: ' + kw); break; }\n}\n\n// Clamp score\nscore = Math.max(1, Math.min(10, score));\n\nconst threshold = job.score_threshold || 6;\nconst status = score >= threshold ? 'MATCH' : 'BELOW_THRESHOLD';\n\nreturn [{ json: {\n ...job,\n score,\n score_reasoning: reasons.join(', '),\n status\n}}];" }, "position": [ 1392, 208 ] }, { "id": "f5d4f9fe-8a4c-4f6e-b711-7d94cf60e103", "name": "Is It a Match", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": false, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "c0883937-3578-4096-a4a4-ac0a4aeef807", "operator": { "type": "string", "operation": "equals" }, "leftValue": "={{ $json.status }}", "rightValue": "MATCH" } ] } }, "position": [ 1632, 208 ] }, { "id": "a42f7772-338a-4fee-a65c-318b65a67a2f", "name": "Write Proposal with Claude", "type": "llm", "params": { "text": "=You are an expert Upwork freelancer writing a cover letter for a job posting.\n\nYOUR PROFILE:\nName: {{ $json.your_name }}\nSkills: {{ $json.your_skills }}\nBio: {{ $json.your_bio }}\n\nJOB:\nTitle: {{ $json.title }}\nBudget: {{ $json.budget_text }} {{ $json.budget_type }}\n\nWrite a cover letter following this exact formula (Nick Saraev style):\n1. Open with one sentence showing you do this exact thing regularly\n2. Add one specific proof point from the bio (number, outcome, or tool)\n3. State one specific thing you would do for this client\n4. End with a soft question or call to action\n\nSTRICT RULES:\n- Total length: 55 to 75 words. Count carefully.\n- No buzzwords: no \"passionate\", \"leverage\", \"synergy\", \"excited to apply\"\n- No generic openers like \"I saw your job posting\" or \"I am interested\"\n- Sound like a human expert, not an AI\n- Do not use any formatting, bullet points, or headers\n- Plain paragraph only\n- Do not mention the word \"proposal\" or \"cover letter\"\n\nWrite the cover letter now. Nothing else -- no preamble, no explanation.", "prompt": "=You are an expert Upwork freelancer writing a cover letter for a job posting.\n\nYOUR PROFILE:\nName: {{ $json.your_name }}\nSkills: {{ $json.your_skills }}\nBio: {{ $json.your_bio }}\n\nJOB:\nTitle: {{ $json.title }}\nBudget: {{ $json.budget_text }} {{ $json.budget_type }}\n\nWrite a cover letter following this exact formula (Nick Saraev style):\n1. Open with one sentence showing you do this exact thing regularly\n2. Add one specific proof point from the bio (number, outcome, or tool)\n3. State one specific thing you would do for this client\n4. End with a soft question or call to action\n\nSTRICT RULES:\n- Total length: 55 to 75 words. Count carefully.\n- No buzzwords: no \"passionate\", \"leverage\", \"synergy\", \"excited to apply\"\n- No generic openers like \"I saw your job posting\" or \"I am interested\"\n- Sound like a human expert, not an AI\n- Do not use any formatting, bullet points, or headers\n- Plain paragraph only\n- Do not mention the word \"proposal\" or \"cover letter\"\n\nWrite the cover letter now. Nothing else -- no preamble, no explanation.", "provider": "openai", "promptType": "define", "approximated": true }, "position": [ 1872, 80 ] }, { "id": "c6f66df9-3531-4afc-996f-603a4b7a1a0d", "name": "Claude Haiku", "type": "llm", "params": { "model": "claude-haiku-4-5-20251001", "options": { "temperature": 0.7 }, "provider": "anthropic", "temperature": 0.7 }, "position": [ 1872, 288 ] }, { "id": "f22e31fc-6725-44c5-b0f5-b45bcf677700", "name": "Extract Proposal Text", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "64c7ec20-14f2-427d-98c8-96d6f48a55c5", "name": "proposal_text", "type": "string", "value": "={{ $json.text.trim() }}" }, { "id": "b35ef786-bd0e-4df7-b206-5471afa0144d", "name": "title", "type": "string", "value": "={{ $('Score Job Against Profile').item.json.title }}" }, { "id": "b1125a9b-1321-4a85-9572-519ebd562c16", "name": "job_url", "type": "string", "value": "={{ $('Score Job Against Profile').item.json.job_url }}" }, { "id": "516e6a6c-d08d-4efe-aae4-076c646702f7", "name": "budget_text", "type": "string", "value": "={{ $('Score Job Against Profile').item.json.budget_text }}" }, { "id": "edca4e8f-9e78-453a-9ad2-f1b15233fe2b", "name": "budget_type", "type": "string", "value": "={{ $('Score Job Against Profile').item.json.budget_type }}" }, { "id": "0d1ed499-0fc6-4e01-903c-dabeece27b41", "name": "score", "type": "number", "value": "={{ $('Score Job Against Profile').item.json.score }}" }, { "id": "12215cff-ba78-40d2-9369-64e243bd04e4", "name": "score_reasoning", "type": "string", "value": "={{ $('Score Job Against Profile').item.json.score_reasoning }}" }, { "id": "55460a2b-a268-4128-a68f-550a07f1a8a8", "name": "timestamp", "type": "string", "value": "={{ $('Score Job Against Profile').item.json.timestamp }}" } ] } }, "position": [ 2000, 224 ] }, { "id": "a368613e-4bf0-4041-a419-8107c9398121", "name": "Save Proposal as Draft", "type": "integration", "params": { "service": "gmail", "operation": "createDraft" }, "position": [ 2304, 80 ] }, { "id": "63cfea6b-7ecf-4b5b-966a-8dd3d1f88d7c", "name": "Notify New Draft - Slack", "type": "integration", "params": { "text": "New proposal draft ready!\n\nJob: {{ $json.title }}\nBudget: {{ $json.budget_text }} {{ $json.budget_type }}\nScore: {{ $json.score }}/10\n\nReview it in Gmail drafts.", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "name", "value": "#upwork-proposals" }, "operation": "read", "otherOptions": {} }, "position": [ 2528, 80 ] }, { "id": "0cca83d1-8d20-46a0-8190-c8ab7411d2f7", "name": "Log Job to Sheets", "type": "integration", "params": { "columns": { "value": { "Score": "={{ $json.score }}", "Budget": "={{ $json.budget_text + ' ' + $json.budget_type }}", "Status": "Proposal Drafted", "Job URL": "={{ $json.job_url }}", "Job Title": "={{ $json.title }}", "Timestamp": "={{ $json.timestamp }}", "Draft Saved": "Yes" }, "mappingMode": "defineBelow" }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "name", "value": "Upwork Jobs" }, "documentId": { "__rl": true, "mode": "id", "value": "YOUR_GOOGLE_SHEET_ID" } }, "position": [ 2752, 80 ] }, { "id": "d3d7f9af-c98e-4b9b-b9b4-be7d51ec7a78", "name": "Log Skipped Job to Sheets", "type": "integration", "params": { "columns": { "value": { "Score": "={{ $json.score }}", "Budget": "={{ $json.budget_text + ' ' + $json.budget_type }}", "Status": "={{ $json.status }}", "Job URL": "={{ $json.job_url }}", "Job Title": "={{ $json.title }}", "Timestamp": "={{ $json.timestamp }}", "Draft Saved": "No" }, "mappingMode": "defineBelow" }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "name", "value": "Upwork Jobs" }, "documentId": { "__rl": true, "mode": "id", "value": "YOUR_GOOGLE_SHEET_ID" } }, "position": [ 1824, 480 ] }, { "id": "e7fcaca8-8bd8-41f0-8bee-100db9907de3", "name": "Parse Jobs from Email", "type": "code", "params": { "jsCode": "// Parse individual job listings from Vollna HTML email\nconst data = $input.first().json;\nconst html = data.raw_html || '';\n\n// Extract job rows from the Vollna table format\n// Vollna emails use TITLE inside tags\n// and budget appears as AMOUNT\n\nconst jobs = [];\n\n// Match each table row containing a job\nconst rowPattern = /]*style=\"border-bottom:1px solid #ecedee;\"[sS]*?/gi;\nconst rows = html.match(rowPattern) || [];\n\nfor (const row of rows) {\n // Extract job title\n const titleMatch = row.match(/([sS]*?)/i);\n const title = titleMatch ? titleMatch[1].replace(/<[^>]+>/g, '').trim() : '';\n\n // Extract job URL\n const urlMatch = row.match(/href=\"[^\"]*url=([^\"&]+)/i);\n let jobUrl = '';\n if (urlMatch) {\n try { jobUrl = decodeURIComponent(decodeURIComponent(urlMatch[1])); } catch(e) { jobUrl = urlMatch[1]; }\n }\n\n // Extract budget amount\n const budgetStrongMatch = row.match(/]*color: #f15d65[^>]*>([sS]*?)/i);\n const budgetText = budgetStrongMatch ? budgetStrongMatch[1].replace(/<[^>]+>/g, '').trim() : 'not specified';\n\n // Extract budget type (Fixed or Hourly)\n const budgetTypeMatch = row.match(/]*color: #666666[^>]*>([sS]*?)/i);\n const budgetType = budgetTypeMatch ? budgetTypeMatch[1].replace(/<[^>]+>/g, '').trim() : '';\n\n // Extract published date\n const dateMatch = row.match(/(d{2}/d{2}/d{4}s+d{1,2}:d{2}s+[AP]M)/i);\n const publishedAt = dateMatch ? dateMatch[1] : '';\n\n if (title && title.length > 3) {\n jobs.push({\n title,\n job_url: jobUrl,\n budget_text: budgetText,\n budget_type: budgetType,\n published_at: publishedAt,\n // Pass through profile settings\n your_name: data.your_name,\n your_skills: data.your_skills,\n your_bio: data.your_bio,\n your_hourly_rate: data.your_hourly_rate,\n min_budget_fixed: data.min_budget_fixed,\n min_budget_hourly: data.min_budget_hourly,\n score_threshold: data.score_threshold,\n skip_keywords: data.skip_keywords,\n timestamp: data.timestamp\n });\n }\n}\n\nif (jobs.length === 0) {\n return [{ json: { _no_jobs: true, timestamp: data.timestamp } }];\n}\n\nreturn jobs.map(j => ({ json: j }));" }, "position": [ 1152, 208 ] } ] }

Write Upwork proposals from Vollna alerts using Claude, Gmail and Sheets