Templates / Build ranked PR media lists from Google News with Bright Data, GPT-5.6 and Google Docs

Build ranked PR media lists from Google News with Bright Data, GPT-5.6 and Google Docs

Ready for 3.0

by Daniel Shashko ✓ · 2 views · created 2026-08-30 · 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 AI workflow has 23 nodes and runs when someone submits an n8n form (“Build a media list”). Along the way it connects OpenAI Chat Model and Google Docs. It also calls api.brightdata.com over HTTP.

How it runs

Trigger: When someone submits an n8n form (“Build a media list”).

  1. Settings (Edit Fields (Set)): sets 4 fields: max_articles, drive_folder, serp_zone…
  2. Read The Request (Code): runs custom JavaScript code
  3. Search Your Subject (HTTP Request): calls api.brightdata.com (POST)
  4. Search Your Comparables (HTTP Request): calls api.brightdata.com (POST)
  5. Wait For Both Searches (Merge): merges the data from its input branches
  6. Find The Bylines (Code): runs custom JavaScript code
  7. Anyone Writing? (If): checks a condition and branches into true / false
  8. Pick What To Read (Limit): keeps the first few items
  9. Nobody Covered It (n8n Form): shows the next form page
  10. Find The Real Link (HTTP Request): calls api.brightdata.com (POST)

…plus 11 more steps. See the full node list below.

Services it uses

OpenAI Chat ModelGoogle Docs

HTTP calls to: api.brightdata.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 (11)

From the author

Quick overview This workflow collects recent Google News coverage for a topic and comparable companies using Bright Data, extracts bylines from the full article HTML, then uses OpenAI (GPT-5.6) to rank the best journalists and draft pitch opening angles,…

Excerpt from Daniel Shashko'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.