Review content ideas against existing pages with HasData, OpenAI and Google Sheets
UnknownWhat this workflow does
This workflow has 27 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Hasdata (community). It also calls api.openai.com and api.hasdata.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Settings (Edit Fields (Set)): sets 11 fields: mode, site, sitemap…
- Validate settings (Code): runs custom JavaScript code
- Read review queue (Google Sheets): read (sheet)
- Check review state (Code): runs custom JavaScript code
- Analyze or approved brief (If): checks a condition and branches into true / false
- Read root sitemap (HTTP Request): calls an HTTP API
- Build approved brief request (Code): runs custom JavaScript code
- Parse root sitemap (XML): converts between XML and JSON
- Draft editorial brief (HTTP Request): calls api.openai.com (POST)
- Plan sitemap reads (Code): runs custom JavaScript code
…plus 16 more steps. See the full node list below.
Services it uses
HTTP calls to: api.openai.com, api.hasdata.com
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @hasdata/n8n-nodes-hasdata is verified or supports 3.0 (used in Read SERP with HasData).
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - XML
n8n-nodes-base.xml - HTML
n8n-nodes-base.html - Has Data
@hasdata/n8n-nodes-hasdata.hasData
From the author
Quick overview This workflow evaluates a proposed content topic by crawling a sitemap-scoped set of your pages with HasData, comparing it with live Google SERP evidence, and using OpenAI to recommend whether to update an existing page, create a new one, or…