n8n Workflow: Score Crowdfunding Leads via Google Sheets AI

Automatically score and enrich crowdfunding leads from Google Sheets using AI

This n8n workflow identifies crowdfunding campaigns listed in your Google Sheets, scrapes and extracts key details with AI, finds and verifies contacts with Lemlist and an email verification API, then assigns every lead a 0–100 score and priority—writing the enriched results back to the same sheet on a daily schedule.

What this workflow does

• Daily 1am run: Reads unresearched campaign rows from the Google Sheets Leads tab and processes them in batches.
• Scrapes campaign pages: Uses Firecrawl to fetch each campaign page, cleans the markdown, and extracts campaign metrics (e.g., amount raised, backers, and dates) using DeepSeek (with OpenAI fallback).
• Researches company and contacts: Runs an AI research agent (DeepSeek with OpenAI fallback) along with Jina AI, Perplexity, and Hunter to identify the company, website, key contact, and supporting details.
• Enriches via Lemlist: Extracts contact fields from research output, enriches the person in Lemlist to find/verify email, phone, and LinkedIn details, waits for results, then fetches the enrichment.
• Email verification: When an email is present, verifies it using QuickEmailVerification and updates the matching lead row in Google Sheets (optionally converting currency to USD).
• Daily 5am run: Pulls enriched leads from Google Sheets, skips rows without descriptions, then uses a DeepSeek scoring agent to assign a 0–100 score and priority label, saving results back to the sheet.

Use cases

• SaaS teams triaging inbound crowdfunding leads into outreach-ready candidates.
• Automation engineers building a repeatable “research → enrich → verify → score” pipeline.
• Operators keeping lead quality high by scoring based on campaign and contact enrichment signals.

Technical details

• Runs on two schedules (1am and 5am) with Google Sheets as the source of truth.
• Core nodes/steps include if, code, wait, merge, and filter with Lemlist enrichment.
• AI/research stack: Firecrawl, DeepSeek (+ OpenAI fallback), Jina AI, Perplexity, and Hunter, plus QuickEmailVerification for email validation.