Templates / Detect offboarded client links on PBN sites with Google Sheets and HTTP

Detect offboarded client links on PBN sites with Google Sheets and HTTP

Ready for 3.0

by isaWOW ✓ · 31 views · created 2026-02-03 · Market Research, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. Read PBN Sites from Sheet (Google Sheets): uses Google Sheets
  2. Filter Unprocessed PBN Rows (Code): runs custom JavaScript code
  3. Loop Through Each PBN (Loop Over Items (Split in Batches)): loops over the items in batches
  4. Fetch PBN Site HTML (HTTP Request): calls an HTTP API
  5. Read Offboarded Project Domains (Google Sheets): uses Google Sheets
  6. Match Domains in HTML (Code): runs custom JavaScript code
  7. Prepare Row Update Payload (Edit Fields (Set)): sets 3 fields: url, mach, HTML
  8. Write Matched Domain to PBNs Sheet (Google Sheets): update
  9. Pause Before Next Iteration (Wait): pauses before continuing

Services it uses

Google Sheets

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 (7)

From the author

Automatically scan every PBN site in your Google Sheet, check if any removed client domain is still linked in the live HTML, and log all matches back into your tracking sheet — row by row, hands-free. --- What this workflow does Managing a network of PBN…

Excerpt from isaWOW's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.