Step 2: Connect Google Sheets

The workflow reads companies from one sheet and appends enriched results to another.

1. Open Retrieve Sheet Company List and set Document to [YOUR_ID] and Sheet to data.
2. Open Append to Sheets Output and set Document to [YOUR_ID] and Sheet to output.
3. Keep Operation set to append in Append to Sheets Output.

Credential Required: Connect your Google Sheets credentials in Retrieve Sheet Company List and Append to Sheets Output.

⚠️ Common Pitfall: If your sheet columns don’t match the incoming JSON keys, auto-mapping in Append to Sheets Output may misalign values.

Step 3: Configure BrightData Batch Processing and Polling

This branch sends LinkedIn URLs to BrightData, polls for completion, and fetches the snapshot results.

1. Open Build BrightData Request and keep the Python code that assembles companies from incoming url fields.
2. In Submit BrightData Batch, set URL to https://api.brightdata.com/datasets/v3/trigger and Method to POST.
3. Set JSON Body to {{ $json.companies }} and include query parameters: dataset_id = [YOUR_ID], include_errors = true.
4. In Delay for BrightData Poll, set Amount to 15 seconds to throttle polling.
5. In Check Snapshot Progress, set URL to =https://api.brightdata.com/datasets/v3/progress/{{ $('Submit BrightData Batch').item.json.snapshot_id }}.
6. In Verify Snapshot Status, confirm the condition uses {{ $json.status }} equals running.
7. In Fetch BrightData Snapshot, set URL to =https://api.brightdata.com/datasets/v3/snapshot/{{ $json.snapshot_id }} and query format to json.

⚠️ Common Pitfall: Ensure the Authorization header uses Bearer [CONFIGURE_YOUR_TOKEN] in all BrightData HTTP nodes or requests will fail.

Node Flow Note: Verify Snapshot Status outputs to both Delay for BrightData Poll and Fetch BrightData Snapshot in parallel, enabling continuous polling until completion.

Step 4: Set Up Search Parsing and AI Extraction

This branch builds a Google search query, scrapes results via BrightData, and uses Gemini to extract the official LinkedIn profile.

1. In Compose Search URL, set google_search to =https://www.google.com/search?q=site%3Alinkedin.com+{{ encodeURIComponent($json["name"].trim()) }}.
2. Configure BrightData Search Request with URL https://api.brightdata.com/request, Method POST, and body parameters: zone = web_unlocker1, url = {{ $json.google_search }}, format = json, data_format = markdown.
3. In Extract Response Body, set result_body to {{ $json.body }}.
4. Open Parse LinkedIn Link, set Text to {{ $json.result_body }}, and keep the custom prompt for extracting the company LinkedIn profile.
5. Ensure Gemini Chat Model is connected as the language model for Parse LinkedIn Link with Model set to models/gemini-2.0-flash-lite.
6. Keep Structured Output Decoder attached to Parse LinkedIn Link and set the schema example to the provided JSON array with company_name and url.
7. In LinkedIn Link Exists?, verify the exists check uses {{ $json.output[0]['url'] }}.
8. For the success path, set Add Matched Result JSON Output to {{ $json.output[0] }}.
9. For the fallback path, set Add Blank Result JSON Output to { "company_name": "{{ $('Iterate Through Records').item.json['name']}} (NOT FOUND)", "url": "" }.

Credential Required: Connect your Google Gemini credentials in Gemini Chat Model.

Structured Output Decoder is attached to Parse LinkedIn Link; no separate credentials are required on the parser sub-node.

Node Flow Note: Iterate Through Records outputs to both Build BrightData Request and Compose Search URL in parallel to process enrichment and LinkedIn discovery at the same time.

Step 5: Configure Data Transformation and Output

Snapshot data is normalized and appended to the output sheet. LinkedIn lookup results are merged to keep the batch loop running.

1. In Transform Snapshot Payload, keep the Python code that maps BrightData fields such as name, country_code, employees_in_linkedin, website, and crunchbase_url into clean JSON.
2. Verify Append to Sheets Output is connected after Transform Snapshot Payload so records are appended to your output sheet.
3. Confirm Combine Results merges outputs from Add Matched Result and Add Blank Result before looping back to Iterate Through Records.

⚠️ Common Pitfall: If Transform Snapshot Payload throws “Missing input data,” verify that Fetch BrightData Snapshot returns JSON and includes expected fields.

Step 6: Test and Activate Your Workflow

Run a manual test to validate credentials, BrightData responses, and output mapping before production use.

1. Click Execute Workflow on Manual Execution Start to run a test.
2. Confirm Retrieve Sheet Company List returns records and Compose Search URL generates a valid Google query.
3. Check that Submit BrightData Batch returns a snapshot_id and that Verify Snapshot Status eventually routes to Fetch BrightData Snapshot.
4. Verify Append to Sheets Output appends rows in the output sheet with transformed fields.
5. Once validated, activate the workflow using the Active toggle for production use.