{"product_id":"n8n-workflow-review-content-ideas-with-hasdata-openai","title":"n8n Workflow: Review Content Ideas with HasData + OpenAI","description":"\u003ch3\u003eTurn content ideas into data-backed decisions—using HasData + OpenAI inside n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reviews your proposed content topics by scraping sitemap-scoped pages with \u003cstrong\u003eHasData\u003c\/strong\u003e, checking live \u003cstrong\u003eGoogle SERP evidence\u003c\/strong\u003e, and using \u003cstrong\u003eOpenAI\u003c\/strong\u003e to recommend the right next step—update an existing page, create a new one, or request review—while recording everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e and reads your configured site, sitemap scope, query, limits, and Google Sheets spreadsheet ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate work\u003c\/strong\u003e by checking the “Review queue” tab in Google Sheets to skip ideas that already have an approval decision or an existing brief.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCrawls your XML sitemap\u003c\/strong\u003e, fetches up to the configured number of same-host child sitemaps, filters URLs by your path prefix, and selects up to the configured number of pages to inspect.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes on-page text\u003c\/strong\u003e with HasData for each selected URL, extracting the main content from your chosen CSS selector.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects SERP evidence\u003c\/strong\u003e with HasData by fetching Google organic results (and related questions when available) for the same query.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvaluates using OpenAI\u003c\/strong\u003e by sending page excerpts plus SERP evidence to generate a structured decision with supporting rationale and next actions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates evidence consistency\u003c\/strong\u003e by confirming that evidence links and quotes align.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Google Sheets\u003c\/strong\u003e by appending or updating the matching row with the decision, gaps, and a compact JSON evidence payload; in brief mode after approval, it generates and saves an OpenAI editorial brief.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDeciding whether to \u003cstrong\u003erefresh an existing SEO page\u003c\/strong\u003e based on current Google SERP patterns.\u003c\/li\u003e\n  \u003cli\u003eDetermining whether a topic warrants a \u003cstrong\u003enew content page\u003c\/strong\u003e versus revisions to current coverage.\u003c\/li\u003e\n  \u003cli\u003eProducing a structured \u003cstrong\u003ereview request\u003c\/strong\u003e when evidence is missing or conflicting—tracked in your “Review queue”.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/workflow logic: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003exml\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ehtml\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eExternal services: \u003cstrong\u003eHasData\u003c\/strong\u003e (page scraping + Google SERP retrieval) and \u003cstrong\u003eOpenAI\u003c\/strong\u003e (structured decision + brief generation).\u003c\/li\u003e\n  \u003cli\u003eStorage: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (reads “Review queue”, then appends\/updates decisions and evidence).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146331672755,"sku":"N8N-20244","price":69.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/4t9VVPM46QWUZT2SxWBlN_3L3ZMIO9.png?v=1790846102","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-review-content-ideas-with-hasdata-openai","provider":"N8N Commerce","version":"1.0","type":"link"}