n8n

How to Automate Bright Data to Sheets Lead Scoring?

Collect fresh job listings, score their fit for your ideal customer, and record every result in Google Sheets. Sales and growth teams use it to spot hiring intent and build targeted outreach lists without manual research.

A simple web form asks for location, keyword, country, and time range. The form triggers a Bright Data snapshot through an HTTP request. The flow waits and checks progress every minute, then pulls the snapshot data when ready. All job posts are added to Google Sheets. A Split Out node sends each row to an AI model that rates fit using a basic chain. The score and notes are then written back to Google Sheets so your team can act fast.

You need a Bright Data API key, an OpenAI key, and a connected Google Sheets account. Set your Bright Data dataset id and point the Google Sheets nodes to your spreadsheet. Expect a big cut in research time and faster, more relevant outreach. Great for outbound prospecting, account research, and market mapping. For accounts, see the Tools Required section above before you start.

What are the key features?

  • Form trigger collects search inputs like location, keyword, and country to start each run.
  • HTTP request starts a Bright Data dataset snapshot using your filters and dataset id.
  • Wait and progress check loop polls Bright Data every minute until data is ready.
  • HTTP request downloads the snapshot results when the status is complete.
  • Google Sheets node appends all job posts to your chosen spreadsheet.
  • Split Out processes each row so the AI can review every job post.
  • OpenAI Chat Model with a basic chain rates fit and adds notes for context.
  • Final Google Sheets node writes the fit score and comments back to the sheet.

What are the benefits?

  • Reduce manual research from hours to minutes per search run
  • Automate up to 90 percent of job sourcing and scoring work
  • Cut copy and paste errors by over 80 percent with structured imports
  • Handle 10 times more job posts each day without extra staff
  • Connect Bright Data, OpenAI and Google Sheets in one flow

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Bright Data, Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
  3. In n8n, open the Form Trigger node and review the fields for location, keyword, country, and time range. Keep them as is or adjust labels to match your team terms.
  4. Bright Data authentication: double click each HTTP Request node, choose Credential to connect with, click Create new credential, and follow the on screen steps. If using an API key, set Authorization header to Bearer YOUR_BRIGHT_DATA_API_KEY.
  5. Set your Bright Data dataset id in the trigger HTTP Request query parameter. Replace the placeholder with the id of your Indeed dataset in your Bright Data dashboard.
  6. Google Sheets connection: open both Google Sheets nodes, choose Credential to connect with, click Create new credential, and approve OAuth with the right Google account.
  7. In each Google Sheets node, select the spreadsheet and worksheet. Map fields for job title, company, location, link, and any extra columns for fit score and notes.
  8. OpenAI setup: double click the OpenAI Chat Model node, create a new OpenAI credential, and paste your API key from your account. Choose a suitable model.
  9. Run a test: open the form URL from the Form Trigger node, submit a small search, and watch execution. The Wait node should loop until Bright Data shows complete, then data should appear in your sheet.
  10. If you see 401 errors, recheck the Bright Data Authorization header. If rows do not appear, confirm the spreadsheet and sheet names and verify your Google Sheets OAuth access.
  11. Adjust the Wait time if snapshots are large. Increase the interval to reduce API load or decrease it for faster checks if allowed by your limits.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Bright Data

Sign up

Pay as you go: $1.5 per 1K records (Web/LinkedIn Scraper API)

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Credits:
Author: Yaron Been. YouTube video LinkedIn Contact: Yaron@nofluff.online

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.