📊 Build backlink prospecting lead lists with Apify and Google Sheets
⚡ 97 views · 📊 Market Research & Insights
💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.
Description
Quick overview
This workflow runs manually or on a schedule to pull search queries and excluded domains from Google Sheets, launches Apify’s Link Prospecting Tool, then uses an Apify “run succeeded” webhook to fetch the resulting datasets and append leads and newly discovered domains back into Google Sheets.
How it works
- Scrape search results: get results for your queries across Google Search, ChatGPT, Gemini, Copilot, and Perplexity.
- Filter domains: remove any sources that already gave you a backlink.
- Filter irrelevant domains: filter out competitor and social media domains.
- Enrich leads: get contact details for each source so you can run cold outreach.
- Save results: save leads in Google Sheets.
- Blacklist known domains: exclude all domains for which you got contact details, so they’re skipped on the next run.
Setup
- Create or copy the provided Google Sheets template, then set the spreadsheet ID and the correct sheet tabs for queries, excluded domains, and output sheets in the Google Sheets nodes.
- Add Google Sheets OAuth2 credentials to allow reading from and appending to the spreadsheet.
- Add Apify OAuth2 credentials, select the Link Prospecting Tool actor, and update the actor input values (brand, ownDomains, and organicResult).
- Copy the n8n webhook URL and configure it in Apify Actor integrations as an HTTP request that triggers on “Run succeeded.”
- (Optional) Adjust the schedule trigger interval if you want recurring runs (for example, monthly).
Additional info
Use cases
- SEO teams: identify backlink opportunities for link-building campaigns.
- Affiliate managers: identify influencers to recruit for your affiliate program.
- Content marketing: find relevant websites for guest posting.
- Competitive analysis: find articles that mention your competitors.
🔗 Nodes Used
Google Sheets, Webhook, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File