n8n

How to Automate Google Sheets LinkedIn Enrichment?

Save time on LinkedIn research and first line writing. This setup reads leads from Google Sheets, enriches profile data, and creates a short ice breaker you can paste into outreach. It suits sales teams that want personal messages at scale without manual work.

The run starts on a schedule or by clicking play. Rows are read from your sheet and handled one by one. A request is sent to Bright Data to build a snapshot, the flow waits, checks status, and then fetches profile fields like city and about text. Those details are saved to the same row. The data is then sent to Claude through the Anthropic nodes to write a short opening line. The message is added to the sheet, and the loop moves to the next person.

You need Google Sheets access, a Bright Data API key, and an Anthropic API key. Expect faster research and more consistent outreach, with fewer copy paste errors and a single source of truth in Sheets. It works well for SDR teams, founders, and agencies preparing cold messages. Start with a small batch and tune the wait and retry settings to match snapshot speed.

What are the key features?

  • Manual and scheduled triggers to control when runs happen
  • Reads and updates rows in Google Sheets as the single source of truth
  • Batch loop processes each prospect one at a time for reliability
  • Creates a Bright Data snapshot via HTTP Request for each LinkedIn URL
  • Waits and polls snapshot status with a check loop before fetching data
  • Pulls fields like city and about text from the snapshot endpoint
  • Generates a personalized ice breaker using the Anthropic Chat Model and an LLM chain
  • Writes the AI message back to the same row and continues through the list

What are the benefits?

  • Reduce manual research from 10 minutes per lead to 30 seconds
  • Streamline prospecting by 80 percent with batch runs
  • Improve data quality by 90 percent using API sourced fields
  • Handle 10 times more leads per day with scheduled processing
  • Connect Google Sheets, Bright Data, and Anthropic 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 Google Sheets, Bright Data and Anthropic. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, create a Google Sheets OAuth2 credential. Open the Google Sheets nodes and select this credential so the workflow can read and update your sheet.
  4. Make a copy of the Google Sheet template. In the Get rows node, set the Document ID and Sheet name. Do the same in the two Update Row nodes so they point to the same sheet and tab.
  5. In your Bright Data dashboard, create an API key on the API page. In the HTTP Request nodes named Post Request and Snapshot Progress, set the Authorization header to Bearer YOUR_BRIGHTDATA_API_KEY.
  6. In your Anthropic account, create an API key on the API page. Open the Anthropic Chat Model node in n8n, click Create new credential, paste the key, and select the Claude 3.5 Haiku model.
  7. Verify your sheet has a LinkedIn URL column and a unique row number used to update the correct row. Map these fields in the Google Sheets nodes as shown in the template.
  8. Run a small test with one or two rows using the manual trigger. Watch the execution to confirm the snapshot is created, status is checked, data is fetched, and rows are updated.
  9. If the status loop takes too long, increase the Wait node delay. Add or adjust a retry limit in the check loop to avoid endless polling.
  10. Review the ice breaker output in the sheet. Tweak the LLM prompt in the Ice Breaker chain if you want a different tone or length.
  11. Set the schedule trigger to run at off peak hours to respect Bright Data rate limits. Enable the workflow when you are satisfied with the results.
  12. Troubleshoot common issues: invalid LinkedIn URLs, expired API keys, permission errors on the sheet, or rate limit responses. Update credentials or node settings and test again.

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.

Anthropic

Sign up

Pay-as-you-go: Claude 3 Haiku at $0.25 per 1M input tokens and $1.25 per 1M output tokens

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)

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.