Scrape LinkedIn profiles & save to Google Sheets with Apify
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs from “Read LinkedIn URLs” (no trigger node, so run it manually or call it from another workflow). Along the way it connects Google Sheets and Gmail. It also calls api.apify.com over HTTP.
How it runs
Trigger: From “Read LinkedIn URLs” (no trigger node, so run it manually or call it from another workflow).
- Read LinkedIn URLs (Google Sheets): uses Google Sheets
- Schedule Scraper Trigger (Loop Over Items (Split in Batches)): loops over the items in batches
- Execute Apify LinkedIn Scraper (Google Sheets): uses Google Sheets
- Data Formatting (Code): runs custom JavaScript code
- Send Success Notification (Gmail): uses Gmail
- Fetch Profile Data (HTTP Request): calls api.apify.com (POST)
- Run Scraper Actor (HTTP Request): calls an HTTP API
- Get Scraped Results (HTTP Request): calls an HTTP API
- Save to Google Sheets (Google Sheets): append
- Update Progress Tracker (Google Sheets): append or update
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - Gmail
n8n-nodes-base.gmail - Code
n8n-nodes-base.code
From the author
This n8n workflow automates the process of scraping LinkedIn profiles using the Apify platform and organizing the extracted data into Google Sheets for easy analysis and follow-up. Use Cases - Lead Generation: Extract contact information and professional…