Capture job leads and write outreach messages in one flow. Team members enter a location, role, and country, and the system gathers live listings and prepares pitches. It suits sales and marketing teams that prospect by email or LinkedIn.

It starts with a hosted form. The form values trigger a Bright Data job through an API call to create a new snapshot of job posts. A wait and status check loop polls progress until the data is ready, then the results are pulled and pushed into Google Sheets. Each row is split and sent to an OpenAI model through a simple chain to create a short pitch, which gets written back to the same sheet.

Connect Google Sheets, Bright Data, and OpenAI with valid credentials, then paste your sheet URL. Set your dataset id and API keys, and choose a reasonable polling interval to avoid rate limits. Expect research time to drop from hours to minutes while keeping outreach personal for each role. This is helpful for SDR teams, agencies, and recruiters who need fresh roles and quick, tailored messages.

• Hosted form collects job location, keyword, and country from users
• API POST to Bright Data starts a new snapshot based on your filters
• Wait and progress check loop polls snapshot status until ready
• Conditional logic routes to fetch data only when the snapshot is complete
• Snapshot results are retrieved and written to Google Sheets as structured rows
• Split Out processes each job row one by one for message creation
• Basic LLM Chain with an OpenAI Chat model generates a short pitch per job
• Google Sheets update writes the pitch back into the matching row

• Reduce manual research from 3 hours to 10 minutes per market scan
• Automate 90% of copy and paste work when moving listings into sheets
• Cut data entry errors by 95 percent with API based collection
• Handle thousands of listings per run without extra effort
• Connect Bright Data, OpenAI, and Google Sheets in one flow
• Create tailored outreach messages for each role at scale

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 the n8n credentials manager, connect Google Sheets: double click the Google Sheets nodes, choose 'Credential to connect with', click 'Create new credential', then follow the on screen steps to grant access. Name the credential so your team can recognize it.
4. Connect OpenAI: double click the OpenAI Chat Model node, click 'Create new credential', then paste your OpenAI API key from your OpenAI account. Save and test the connection.
5. Add Bright Data authentication: open both HTTP Request nodes and set the Authorization header to Bearer followed by your Bright Data API key from the Bright Data account API page.
6. Configure the form: open the Form Trigger node and review the three fields for Job Location, Keyword, and Country two letters. Adjust labels if needed, then copy the form URL for testing.
7. Set Bright Data options: in the POST request node, enter your dataset id and confirm the JSON body maps location, keyword, and country to your form fields.
8. Tune polling: in the Wait node, set the interval in minutes. In the Snapshot Progress and If nodes, make sure the condition checks for a completed status before fetching data.
9. Point to your sheet: in the Google Sheets Add node, paste the URL of your spreadsheet copy and select the correct sheet and header row. Map the incoming fields to your columns.
10. Configure the LLM chain: open the Basic LLM Chain node and edit the prompt to include role, company, and location fields from each row. Confirm it is linked to the OpenAI Chat Model node.
11. Update pitches: in the Google Sheets Update node, choose the same spreadsheet and sheet. Set the key column to the job id or another unique field so the pitch updates the correct row.
12. Run a test: submit the form with sample values. In the n8n execution view, watch the polling loop, confirm rows appear in Google Sheets, and verify that the pitch column fills in for each job.
13. Troubleshoot: if no data arrives, check the dataset id and Bright Data plan. For 401 errors, recheck API keys. If Sheets does not update, ensure the connected Google account can edit the file. Increase the wait interval if you hit rate limits. If the LLM fails, verify your OpenAI credit and model selection.