G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
All Automations

Scrape LinkedIn profiles & save to Google Sheets with Apify

Scrapes LinkedIn profiles using Apify and automatically saves the extracted data to Google Sheets for lead generation and analysis.

workflowlead_generation
Oneclick AI Squadby Oneclick AI Squadon n8n
Nodes

15

Platform

n8n

Tech Stack
Google Sheets
Google Sheets
Gmail
Gmail
How It Works

This workflow takes LinkedIn profile URLs from Google Sheets, uses Apify to scrape profile data including contact information and professional details, then saves all extracted data back to Google Sheets. Perfect for building prospect lists and gathering candidate information at scale.

1

Read LinkedIn URLs from Google Sheets

Retrieves LinkedIn profile URLs from your Google Sheets spreadsheet to begin the scraping process.

2

Format data for Apify scraper

Prepares and structures the LinkedIn URLs into the proper format required by the Apify LinkedIn scraper actor.

3

Execute Apify LinkedIn scraper

Runs the Apify scraper actor to extract profile data including names, job titles, companies, and contact information.

4

Retrieve scraped profile data

Fetches the completed scraping results from Apify containing all extracted LinkedIn profile information.

5
Attached Files
workflow.json

Save results to Google Sheets

Stores all scraped profile data in organized columns within your Google Sheets spreadsheet for easy analysis.

6

Send completion notification

Updates progress tracking and sends notification when the scraping workflow has successfully completed.

What You'll Need

Google SheetsHttp RequestGmail
  • Apify account with API token and sufficient credits
  • Google Sheets with LinkedIn profile URLs in linkedin_url column
  • Access to LinkedIn Profile Scraper actor on Apify
  • Gmail account for notifications

This automation has 4 configurable settings you'll customize during setup.