Step 2: Connect Google Sheets

Configure the spreadsheet used for input rows and output updates.

1. Open Retrieve Rows for Enrichment and select your Document with [YOUR_ID] and Sheet gid=0.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Rows for Enrichment.
3. Open Update Sheet with Profile Data and verify Operation is set to update with Matching Columns set to row_number.
4. Credential Required: Add your googleSheetsOAuth2Api credentials to Update Sheet with Profile Data (no credentials are configured yet).
5. Open Write Ice Breaker to Sheet and confirm Operation is update with Matching Columns set to row_number.
6. Credential Required: Add your googleSheetsOAuth2Api credentials to Write Ice Breaker to Sheet (no credentials are configured yet).

Step 3: Set Up Looping and Snapshot Triggering

Prepare each LinkedIn URL for processing, then trigger BrightData snapshots in batches.

1. In Prepare Loop Inputs, keep the assignments that map person_input to {{ $json.Linkedin_URL_Person }} and row_number to {{ $json.row_number }}.
2. Open Batch Iterate Prospects and set your batch size if needed (defaults are acceptable for small runs).
3. In Trigger BrightData Snapshot, set URL to https://api.brightdata.com/datasets/v3/trigger and keep Method as POST.
4. Ensure JSON Body is set to =[ { "url": "{{ $json.person_input }}" } ].
5. Under Query Parameters, set dataset_id to [YOUR_ID] and include_errors to true.
6. Under Header Parameters, set Authorization to Bearer [CONFIGURE_YOUR_TOKEN].

Step 4: Configure Snapshot Polling and Data Retrieval

Poll BrightData until snapshots complete, then fetch the LinkedIn data and update your sheet.

1. In Pause for API Response, keep Amount set to 10 to delay between checks.
2. In Check Snapshot Progress, set URL to =https://api.brightdata.com/datasets/v3/progress/{{ $json.snapshot_id }} and ensure Authorization header is Bearer [CONFIGURE_YOUR_TOKEN].
3. In Branch on Snapshot Status, verify the condition checks {{ $json.status }} equals running to loop back to Pause for API Response.
4. In Fetch LinkedIn Snapshot, set URL to =https://api.brightdata.com/datasets/v3/snapshot/{{ $json.snapshot_id }} and add query parameter format = json.
5. In Update Sheet with Profile Data, verify the column mappings use expressions like {{ $json.name }}, {{ $json.city }}, and {{ $('Batch Iterate Prospects').item.json.row_number }}.

Step 5: Set Up the AI Ice Breaker Generation

Generate personalized ice breaker text using Anthropic and write it back to the sheet.

1. Open Anthropic Chat Engine and select the model claude-3-5-haiku-20241022.
2. Credential Required: Connect your Anthropic credentials in Anthropic Chat Engine (the AI model is used by Generate Ice Breaker Text).
3. In Generate Ice Breaker Text, keep the Text prompt as defined, including expressions like {{ $json.name }} and {{ $('Fetch LinkedIn Snapshot').item.json.posts[0].title }}.
4. In Write Ice Breaker to Sheet, confirm mappings for row_number = {{ $('Batch Iterate Prospects').item.json.row_number }} and Ice Breaker 1 = {{ $json.text }}.

Step 6: Test and Activate Your Workflow

Validate the workflow end-to-end, then turn on the scheduled trigger for production use.

1. Click Execute Workflow using Manual Execution Start to run a controlled test.
2. Confirm that Update Sheet with Profile Data writes profile fields and Write Ice Breaker to Sheet writes the generated text.
3. Check that Batch Iterate Prospects loops until all rows are processed.
4. Once verified, enable the workflow and rely on Scheduled Automation Trigger for ongoing runs.