January 22, 2026

GitHub + Google Sheets: clean leads, no duplicates

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Finding developer leads sounds simple until you actually do it. You search GitHub, open profiles, copy details into a sheet, then realize half the list is missing emails or full of repeats.

GitHub lead automation hits recruiters first, honestly. But SaaS founders running outbound and agencies building prospect lists feel the same drag: hours burned on “research” that’s mostly copy-paste and cleanup.

This workflow pulls developers from GitHub, enriches missing emails with Hunter.io, removes duplicates, and appends clean records into Google Sheets. You’ll see what it does, what you need, and how to make it fit your lead criteria.

How This Automation Works

Here’s the complete workflow you’ll be setting up:

n8n Workflow Template: GitHub + Google Sheets: clean leads, no duplicates

Click to explore

flowchart LR

    subgraph sg0["Schedule Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", pos: "b", h: 48 }
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Define Developer Searches"]
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Search GitHub Users"]
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Parse Users"]
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Get User Details"]
        n5["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Extract Developer Data"]
        n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Need Email Enrichment?", pos: "b", h: 48 }
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Hunter.io Email Lookup"]
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Update With Email"]
        n9@{ icon: "mdi:database", form: "rounded", label: "Check For Duplicates", pos: "b", h: 48 }
        n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Filter Duplicates"]
        n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Format For Database"]
        n12@{ icon: "mdi:database", form: "rounded", label: "Add to Lead Database", pos: "b", h: 48 }
        n13["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge"]
        n13 --> n10
        n3 --> n4
        n4 --> n5
        n0 --> n1
        n10 --> n11
        n8 --> n9
        n8 --> n13
        n11 --> n12
        n2 --> n3
        n9 --> n13
        n5 --> n6
        n7 --> n8
        n6 --> n7
        n6 --> n10
        n1 --> n2
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n0 trigger
    class n6 decision
    class n9,n12 database
    class n2,n4,n7 api
    class n1,n3,n5,n8,n10,n11 code
    classDef customIcon fill:none,stroke:none
    class n1,n2,n3,n4,n5,n7,n8,n10,n11,n13 customIcon

Why This Matters: Clean dev leads without the busywork

Manual GitHub sourcing has a nasty pattern: it starts “just for a few leads,” then quietly eats your week. You collect profiles, paste them into a sheet, and by the time outreach starts you’re already doubting the list. Emails are missing, names don’t match usernames, and duplicates show up because two different searches surfaced the same person. Worst part? You only notice the problems after you’ve sent messages or imported the list into your CRM. That’s when it becomes expensive.

The friction compounds. Here’s where it breaks down in real life.

Every new GitHub search creates another “version” of the same lead list, so duplicates are almost guaranteed.
Email enrichment happens late (or not at all), which means outreach gets delayed or filled with guesswork.
People copy inconsistent fields into Sheets, so filtering by location, company, or tech stack becomes unreliable.
When a teammate asks “Where did this lead come from?”, you end up re-opening GitHub profiles to rebuild context.

What You’ll Build: GitHub to Sheets lead sourcing with enrichment

This automation runs on a schedule, searches GitHub for developers based on your query list, and then pulls back profile details for each result. Once it has the developer data, it checks whether an email is already available. If not, it calls Hunter.io to look up a professional email using the developer’s domain context, then applies that enrichment back onto the lead record. After that, it compares the lead against your existing Google Sheets database to catch duplicates before anything gets added. Finally, it appends only the cleaned, structured record into your Google Sheets “CRM” so your outreach list stays trusted instead of bloated.

The workflow starts from a scheduled trigger, then GitHub is queried and profiles are compiled into a consistent schema. Hunter.io enrichment runs only when needed, and a separate Google Sheets lookup helps the workflow decide what’s genuinely new. The output is a single sheet that stays clean over time.

What You’re Building

What Gets Automated

What You’ll Achieve

A scheduled GitHub search runs automatically from your saved queries.
Each GitHub user’s profile is fetched and normalized into consistent fields.
Missing emails are enriched via Hunter.io only when the workflow needs it.
Google Sheets is checked before write, so duplicates are filtered out.

Get a fresh batch of leads daily without spending about 2 hours searching.
Stop re-cleaning your sheet every time you run a new query.
Fewer bounced emails because enrichment is systematic, not manual guesswork.
Outreach can start the same day because the list is already structured.
More confidence in handoffs since the sheet becomes the shared source of truth.

Expected Results

Say you want 30 new developer leads per day. Manually, you might spend about 3 minutes per lead opening profiles, copying fields, and checking if they’re already in your sheet, which is roughly 90 minutes before you even think about emails. Add another minute per lead to hunt for contact details and it creeps toward 2 hours. With this workflow, you spend about 10 minutes refining your GitHub queries and reviewing the sheet, while the enrichment, duplicate checks, and appending run in the background.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
GitHub API to search users and profiles
Google Sheets to store your lead database
Hunter.io API key (get it from your Hunter dashboard)

Skill level: Intermediate. You’ll connect accounts, paste API keys, and adjust a query list (light editing, not heavy coding).

Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).

Step by Step

A scheduled run kicks things off. The workflow starts with a Schedule Trigger, so you can run it hourly, daily, or on whatever cadence matches your outbound rhythm.

Your GitHub queries are set, then executed. A query list is prepared (for example: language filters, location keywords, or role hints), and an HTTP request searches GitHub users. The results are parsed so the workflow can loop through them safely.

Profiles are fetched and compiled into a clean record. For each user, the workflow pulls profile details, then compiles the fields you actually care about into a consistent lead format that plays nicely in Google Sheets.

Email enrichment and dedupe happen before the sheet is updated. An “email present?” check routes leads either directly forward or through Hunter.io enrichment, then a Google Sheets lookup plus a dedupe step prevents the same person from being added twice.

You can easily modify the GitHub query list to target different stacks, regions, or seniority. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Schedule Trigger

Set the workflow cadence so the lead capture runs automatically on a weekly basis.

Select Scheduled Automation Start and open the scheduling rule settings.
Set Interval to weeks to match the existing weekly trigger configuration.
Confirm the node is connected to Set Developer Query List as the next step in the chain.

Step 2: Connect GitHub Search Inputs

Define the developer search profiles and configure the GitHub search request that uses those parameters.

In Set Developer Query List, review the jsCode array of searches and update location, language, and minFollowers as needed.
Open GitHub User Search and set URL to https://api.github.com/search/users.
Under Query Parameters, set q to =location:{{ $json.location }} followers:>{{ $json.minFollowers }} language:{{ $json.language }} and per_page to 30.
Under Header Parameters, set Accept to application/vnd.github.v3+json and replace [CONFIGURE_YOUR_TOKEN] in Authorization with your GitHub token.
Credential Required: Connect your httpHeaderAuth credentials in GitHub User Search.

⚠️ Common Pitfall: Leaving the Authorization header as [CONFIGURE_YOUR_TOKEN] will cause GitHub API calls to fail or be rate-limited.

Step 3: Set Up Developer Profile Processing

Parse the GitHub search response, fetch individual profiles, and compute lead scoring and metadata.

In Parse User Results, keep the current jsCode which maps the search results into individual developer items.
In Fetch User Profiles, set URL to ={{ $json.userApiUrl }} and keep Send Headers enabled.
In Fetch User Profiles, update the Authorization header to your GitHub token (same value used in GitHub User Search).
Verify Compile Developer Details uses the existing scoring logic in jsCode to set leadScore, leadQuality, and domain.

Step 4: Configure Email Enrichment and Lead Routing

Check for missing emails, enrich with Hunter, then route into duplicate checking and merge logic.

In Email Enrichment Check, confirm the conditions include ={{ $json.domain }} not equals and ={{ $json.email }} equals Check website.
In Hunter Domain Email Lookup, set URL to https://api.hunter.io/v2/domain-search and set domain to ={{ $json.domain }}, api_key to your Hunter key, and limit to 3.
Review Apply Enriched Email to ensure it pulls from Compile Developer Details and overwrites email based on best confidence.
Apply Enriched Email outputs to both Lookup Existing Leads and Combine Lead Paths in parallel.
Confirm Combine Lead Paths is set to Mode chooseBranch with Use Data Of Input 2 to pass enriched results through the merge.

Strong domain extraction in Compile Developer Details is critical for email enrichment. Ensure blog URLs are valid and include a domain.

Step 5: Configure Google Sheets Output and Deduplication

Check existing leads, remove duplicates, format the record, and append it to your spreadsheet.

In Lookup Existing Leads, select your Document Lead Database and Sheet Sheet1.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Lookup Existing Leads.
Verify Remove Duplicate Leads uses data from Lookup Existing Leads to compare Business Name, Email, and Notes.
In Prepare Database Record, keep the lead ID format GITHUB-${timestamp}-${randomNum} and field mapping to match your sheet columns.
In Append Lead to Sheet, set Operation to append and confirm the sheet columns include Lead ID, Business Name, Email, Lead Score, and Status.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Lead to Sheet.

Step 6: Test and Activate Your Workflow

Run the workflow manually to confirm end-to-end data capture, then activate for weekly lead scraping.

Click Execute Workflow to run a manual test from Scheduled Automation Start.
Verify GitHub User Search returns users and Parse User Results outputs developer items.
Check that Apply Enriched Email produces an updated email when enrichment applies.
Confirm Remove Duplicate Leads allows only new leads through and Append Lead to Sheet appends rows to Lead Database.
Once verified, toggle the workflow to Active to run on the weekly schedule.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

GitHub credentials can expire or need specific permissions. If things break, check your token scopes in GitHub Developer Settings first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Quick Answers

What’s the setup time for this GitHub lead automation automation?

About 30 minutes if your API keys are ready.

Is coding required for this lead enrichment from GitHub?

No. You’ll mostly connect accounts and edit a query list. The workflow already handles parsing, enrichment, and deduping.

Is n8n free to use for this GitHub lead automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Hunter.io API usage, which depends on how many lookups you run.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I modify this GitHub lead automation workflow for different use cases?

Yes, and you should. Most teams adjust the “Set Developer Query List” logic to match their target stack and locations, then tweak the Google Sheets lookup keys used in “Lookup Existing Leads” and “Remove Duplicate Leads.” You can also swap Hunter.io enrichment for “enrich only when company domain exists,” which keeps costs sane. If you want the leads to go somewhere else, replace the “Append Lead to Sheet” step with HubSpot, Airtable, or your CRM.

Why is my GitHub connection failing in this workflow?

Usually it’s an expired or revoked GitHub token. Regenerate the token, then update the credential used by the GitHub HTTP Request nodes. If it still fails, check rate limits in the GitHub API response headers and reduce how many profiles you fetch per run. Permissions matter too; some org settings can block access depending on how the token was created.

What volume can this GitHub lead automation workflow process?

On n8n Cloud, your monthly execution limit depends on the plan, and self-hosting has no hard cap beyond your server. Practically, GitHub rate limits and Hunter credits will be the bottleneck, so most teams run smaller batches a few times per day instead of one massive pull.

Is this GitHub lead automation automation better than using Zapier or Make?

Often, yes, because GitHub sourcing usually needs looping, branching, and dedupe logic that gets awkward (and pricey) in simpler builders. n8n handles “search results → loop profiles → enrich conditionally → merge paths” cleanly, and you can self-host if you’re doing this at volume. Zapier or Make can still work if you only enrich a handful of leads and don’t care about a strict dedupe check. The bigger difference is control: with n8n you can tune queries, batching, and record formatting without fighting platform limits. If you want help choosing, Talk to an automation expert.

You end up with a lead sheet your team doesn’t have to apologize for. Set it once, let it run, and use the time you get back to actually write messages and book calls.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"versionId": null,
"name": "Automated GitHub Lead Capture",
"meta": {
"instanceId": "beaf817c287dac8cb28ee7368f940e0b6c85b951467a8c7ae1b7543bbb61157e",
"templateId": null,
"templateCredsSetupCompleted": null
},
"nodes": [
{
"id": "flowpast-topbar-11375",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1190,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "01ba443c-da8b-4f6e-a010-a3ef376f4139",
"name": "Scheduled Automation Start",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
1090,
175
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "855969ab-cdb5-4966-8ed2-87377f859318",
"name": "Set Developer Query List",
"type": "n8n-nodes-base.code",
"position": [
860,
120
],
"parameters": {
"jsCode": "// Define your target developer searches\nconst searches = [\n  {\n    location: \"New Jersey\",\n    language: \"javascript\",\n    minFollowers: 50\n  },\n  {\n    location: \"Texas\",\n    language: \"python\",\n    minFollowers: 100\n  },\n  {\n    location: \"New York\",\n    language: \"react\",\n    minFollowers: 200\n  }\n];\n\nreturn searches.map(search => ({ json: search }));"
},
"typeVersion": 2
},
{
"id": "cf6adb6b-b5b4-4a17-bff6-06b46df66887",
"name": "GitHub User Search",
"type": "n8n-nodes-base.httpRequest",
"position": [
520,
160
],
"parameters": {
"url": "https://api.github.com/search/users",
"options": [],
"sendQuery": true,
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "q",
"value": "=location:{{ $json.location }} followers:>{{ $json.minFollowers }} language:{{ $json.language }}"
},
{
"name": "per_page",
"value": "30"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Accept",
"value": "application/vnd.github.v3+json"
},
{
"name": "Authorization",
"value": "[CONFIGURE_YOUR_TOKEN]"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.1
},
{
"id": "ae61b477-85c5-4d18-9883-6ff7a1200511",
"name": "Parse User Results",
"type": "n8n-nodes-base.code",
"position": [
310,
185
],
"parameters": {
"jsCode": "const allInputs = $input.all();   // get all input items\nconst developers = [];\n\nallInputs.forEach(input => {\n  const users = input.json.items || [];\n\n  users.forEach(user => {\n    developers.push({\n      json: {\n        username: user.login,\n        profileUrl: user.html_url,\n        avatarUrl: user.avatar_url,\n        userApiUrl: user.url\n      }\n    });\n  });\n});\n\nreturn developers;\n"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "57e872f8-4778-4272-af2d-5dbcc7104b1b",
"name": "Fetch User Profiles",
"type": "n8n-nodes-base.httpRequest",
"position": [
275,
270
],
"parameters": {
"url": "={{ $json.userApiUrl }}",
"options": [],
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Accept",
"value": "application/vnd.github.v3+json"
},
{
"name": "Authorization",
"value": "[CONFIGURE_YOUR_TOKEN]"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "e00f0903-9776-48ac-97a2-81ca557dc374",
"name": "Compile Developer Details",
"type": "n8n-nodes-base.code",
"position": [
625,
305
],
"parameters": {
"jsCode": "const data = $input.item.json;\n\n// Extract website/blog URL and domain\nlet website = data.blog || \"\";\nlet domain = \"\";\n\nif (website) {\n  try {\n    // Clean up the URL\n    if (!website.startsWith('http')) {\n      website = 'https://' + website;\n    }\n    const url = new URL(website);\n    domain = url.hostname.replace('www.', '');\n  } catch (e) {\n    domain = website;\n  }\n}\n\n// Calculate lead score based on GitHub activity\nlet score = 20; // Base score\n\n// Followers (max 30 points)\nconst followers = data.followers || 0;\nif (followers > 500) score += 30;\nelse if (followers > 200) score += 25;\nelse if (followers > 100) score += 20;\nelse if (followers > 50) score += 15;\nelse score += 10;\n\n// Public repos (max 20 points)\nconst repos = data.public_repos || 0;\nif (repos > 50) score += 20;\nelse if (repos > 20) score += 15;\nelse if (repos > 10) score += 10;\nelse score += 5;\n\n// Has contact info (max 30 points)\nif (data.email) score += 15;\nif (website && website !== \"\") score += 10;\nif (data.company) score += 5;\n\n// Determine quality\nlet quality = \"Cold\";\nif (score >= 70) quality = \"Hot\";\nelse if (score >= 50) quality = \"Warm\";\n\nconst today = new Date().toISOString().split('T')[0];\n\nreturn {\n  json: {\n    name: data.name || data.login,\n    username: data.login,\n    email: data.email || \"Check website\",\n    bio: data.bio || \"\",\n    company: data.company || \"\",\n    location: data.location || \"\",\n    website: website,\n    domain: domain,\n    twitter: data.twitter_username ? `https://twitter.com/${data.twitter_username}` : \"\",\n    followers: followers,\n    following: data.following || 0,\n    publicRepos: repos,\n    profileUrl: data.html_url,\n    avatarUrl: data.avatar_url,\n    leadSource: \"GitHub\",\n    leadScore: Math.min(score, 100),\n    leadQuality: quality,\n    scrapedDate: today,\n    notes: `GitHub developer with ${repos} repos and ${followers} followers. ${data.bio || ''}`\n  }\n};"
},
"typeVersion": 2
},
{
"id": "078acd2a-fc09-4896-a587-f5decf3f123e",
"name": "Email Enrichment Check",
"type": "n8n-nodes-base.if",
"position": [
825,
320
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 1,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "condition-1",
"operator": {
"type": "string",
"operation": "notEquals"
},
"leftValue": "={{ $json.domain }}",
"rightValue": ""
},
{
"id": "condition-2",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.email }}",
"rightValue": "Check website"
},
{
"id": "0c2a31a2-5e74-44bc-b5c4-78ee30e4bbf4",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "75d37ae2-6945-44c5-a3ad-79a1c6df6155",
"name": "Hunter Domain Email Lookup",
"type": "n8n-nodes-base.httpRequest",
"position": [
840,
395
],
"parameters": {
"url": "https://api.hunter.io/v2/domain-search",
"options": [],
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "domain",
"value": "={{ $json.domain }}"
},
{
"name": "api_key",
"value": "[CONFIGURE_YOUR_API_KEY]"
},
{
"name": "limit",
"value": "3"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "38c503d3-fd25-4159-9129-c81ee51e356c",
"name": "Apply Enriched Email",
"type": "n8n-nodes-base.code",
"position": [
605,
450
],
"parameters": {
"jsCode": "const hunterData = $input.item.json.data || {};\nconst emails = hunterData.emails || [];\nconst previousData = $('Compile Developer Details').item.json;\n\nlet bestEmail = previousData.email;\n\nif (emails.length > 0) {\n  const sortedEmails = emails.sort((a, b) => b.confidence - a.confidence);\n  bestEmail = sortedEmails[0].value;\n}\n\nreturn {\n  json: {\n    ...previousData,\n    email: bestEmail,\n    emailConfidence: emails[0]?.confidence || 0\n  }\n};"
},
"typeVersion": 2
},
{
"id": "4ee6842b-59e2-4d4f-ab23-3802fc9f46fd",
"name": "Lookup Existing Leads",
"type": "n8n-nodes-base.googleSheets",
"position": [
255,
460
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Lead Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.4
},
{
"id": "dd7b6634-4e7b-46e1-9c4f-275046257470",
"name": "Remove Duplicate Leads",
"type": "n8n-nodes-base.code",
"position": [
0,
595
],
"parameters": {
"jsCode": "const existingLeads = $('Lookup Existing Leads').all();\nconst currentLead = $input.item.json;\n\n// Check if username already exists\nconst isDuplicate = existingLeads.some(item => {\n  const row = item.json;\n  return row['Business Name'] === currentLead.name || \n         row.Email === currentLead.email ||\n         (row.Notes && row.Notes.includes(currentLead.username));\n});\n\nif (isDuplicate) {\n  return [];\n}\n\nreturn [{ json: currentLead }];"
},
"typeVersion": 2
},
{
"id": "530fc573-1c93-40d6-84f6-ec2ab1d33a9e",
"name": "Prepare Database Record",
"type": "n8n-nodes-base.code",
"position": [
330,
540
],
"parameters": {
"jsCode": "const data = $input.item.json;\nconst timestamp = Date.now();\nconst randomNum = Math.floor(Math.random() * 1000);\nconst leadId = `GITHUB-${timestamp}-${randomNum}`;\n\nreturn {\n  json: {\n    leadId: leadId,\n    businessName: data.name,\n    contactName: data.name,\n    jobTitle: \"Developer\",\n    email: data.email,\n    phone: \"Not available\",\n    website: data.website,\n    address: data.location,\n    industry: \"Software Development\",\n    companySize: data.company || \"Freelancer\",\n    rating: 0,\n    reviews: 0,\n    leadScore: data.leadScore,\n    leadQuality: data.leadQuality,\n    scrapedDate: data.scrapedDate,\n    status: \"New - Scraped\",\n    contacted: \"No\",\n    notes: data.notes,\n    leadSource: data.leadSource\n  }\n};"
},
"typeVersion": 2
},
{
"id": "be8f6c5d-fbea-404f-bf4b-603069f5a7b4",
"name": "Append Lead to Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
545,
585
],
"parameters": {
"columns": {
"value": [],
"schema": [
{
"id": "Lead ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Lead ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Business Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Business Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contact Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Contact Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title",
"type": "string",
"display": true,
"removed": false,
"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": false,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Size",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company Size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Source",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Lead Source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Rating",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reviews",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Reviews",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Score",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Lead Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Quality",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Lead Quality",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Scraped Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Scraped Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contacted",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Contacted",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Lead Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.4
},
{
"id": "071dc01a-1789-4382-be06-590d9f9ccb22",
"name": "Combine Lead Paths",
"type": "n8n-nodes-base.merge",
"position": [
55,
405
],
"parameters": {
"mode": "chooseBranch",
"useDataOfInput": 2
},
"typeVersion": 3.2
}
],
"pinData": [],
"connections": {
"Combine Lead Paths": {
"main": [
[
{
"node": "Remove Duplicate Leads",
"type": "main",
"index": 0
}
]
]
},
"Parse User Results": {
"main": [
[
{
"node": "Fetch User Profiles",
"type": "main",
"index": 0
}
]
]
},
"Fetch User Profiles": {
"main": [
[
{
"node": "Compile Developer Details",
"type": "main",
"index": 0
}
]
]
},
"Scheduled Automation Start": {
"main": [
[
{
"node": "Set Developer Query List",
"type": "main",
"index": 0
}
]
]
},
"Remove Duplicate Leads": {
"main": [
[
{
"node": "Prepare Database Record",
"type": "main",
"index": 0
}
]
]
},
"Apply Enriched Email": {
"main": [
[
{
"node": "Lookup Existing Leads",
"type": "main",
"index": 0
},
{
"node": "Combine Lead Paths",
"type": "main",
"index": 1
}
]
]
},
"Prepare Database Record": {
"main": [
[
{
"node": "Append Lead to Sheet",
"type": "main",
"index": 0
}
]
]
},
"GitHub User Search": {
"main": [
[
{
"node": "Parse User Results",
"type": "main",
"index": 0
}
]
]
},
"Append Lead to Sheet": {
"main": [
[]
]
},
"Lookup Existing Leads": {
"main": [
[
{
"node": "Combine Lead Paths",
"type": "main",
"index": 0
}
]
]
},
"Compile Developer Details": {
"main": [
[
{
"node": "Email Enrichment Check",
"type": "main",
"index": 0
}
]
]
},
"Hunter Domain Email Lookup": {
"main": [
[
{
"node": "Apply Enriched Email",
"type": "main",
"index": 0
}
]
]
},
"Email Enrichment Check": {
"main": [
[
{
"node": "Hunter Domain Email Lookup",
"type": "main",
"index": 0
}
],
[
{
"node": "Remove Duplicate Leads",
"type": "main",
"index": 0
}
]
]
},
"Set Developer Query List": {
"main": [
[
{
"node": "GitHub User Search",
"type": "main",
"index": 0
}
]
]
}
}
}