Scrape LinkedIn Profiles & Save to Google Sheets with Apify
VerifiedScrapes LinkedIn profiles via Apify and saves results to Google Sheets with email alerts.
What this workflow does
This automation reads profile URLs from Google Sheets, executes scraping through HTTP calls to Apify, stores the extracted data in Sheets, and sends status updates by Gmail.
It is designed for sales teams and recruiters who need to collect and organize LinkedIn profile information on a recurring basis.
Who is this for?
Sales teams, recruiters, and market researchers who need to pull LinkedIn profile data into spreadsheets without manual copy-paste.
What problem it solves
Manually collecting LinkedIn profile details is slow and error-prone; this workflow automates extraction via Apify and stores results directly in Google Sheets.
Live workflow preview
Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.
Open the template on n8n to import and run it. View source template →
What it automates
Lead Generation
Pull contact and professional details from a list of LinkedIn URLs into a shared Google Sheet for outreach tracking.
Recruitment
Collect candidate profiles on a schedule and append them to a hiring pipeline spreadsheet.
Sales Prospecting
Build targeted prospect lists by scraping selected LinkedIn profiles and saving structured data for follow-up.
How the workflow works
The 4 nodes in this automation, in order.
- 1Google SheetsgoogleSheets
- 2HTTP RequesthttpRequest
- 3Gmailgmail
- 4Codecode
Apps & integrations used
How to set up Scrape LinkedIn Profiles & Save to Google Sheets with Apify
- 1Import the workflow JSON into n8n and connect your Apify API token in the HTTP Request node.
- 2Create a Google Sheet with a column of LinkedIn profile URLs and link it via the Google Sheets node.
- 3Configure the Webhook node (or Schedule node) as the starting trigger.
- 4Map the Apify actor output fields to the correct columns in the Save to Google Sheets node.
- 5Add your Gmail credentials and connect the success notification node.
- 6Activate the workflow and test with a small batch of URLs.
How to customize this workflow
- →Swap the Webhook trigger for a Schedule node to run daily or weekly.
- →Add a filter after the Read LinkedIn URLs step to skip already-processed rows.
- →Route failed Apify calls to a separate Gmail error alert instead of the success notification.
- →Append an extra Google Sheets node to log run timestamps and credit usage.
Scrape LinkedIn Profiles & Save to Google Sheets with Apify: pros & cons
Pros
- +Uses existing Apify LinkedIn scraper without custom code
- +Direct write to Google Sheets keeps data accessible to non-technical users
- +Webhook + schedule options support both on-demand and recurring runs
- +Gmail node provides simple completion alerts
Cons
- –Requires paid Apify credits for each profile scraped
- –LinkedIn scraping may violate platform terms of service
- –No built-in deduplication of profile URLs
Frequently asked questions
It reads LinkedIn URLs from Google Sheets, runs them through an Apify scraper via HTTP, and writes the results back to Sheets with an optional Gmail notification.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar workflows
Other sales & crm automations worth a look.