{"product_id":"n8n-workflow-fix-wordpress-noindex-with-google-sheets","title":"n8n Workflow: Fix WordPress noindex with Google Sheets","description":"\u003ch3\u003eAutomatically fix WordPress “noindex” pages using Google Sheets + RankMath (via n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks every URL you list in Google Sheets for \u003cem\u003enoindex\u003c\/em\u003e directives (in both the HTML meta robots and the \u003cstrong\u003eX-Robots-Tag\u003c\/strong\u003e header). When a page needs indexing, it updates RankMath’s WordPress REST API to switch robots settings back to \u003cem\u003eindex\u003c\/em\u003e—and writes the results straight back to your sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads URLs from Google Sheets:\u003c\/strong\u003e Starts manually, loads URL rows from the \u003cstrong\u003e“All URLs”\u003c\/strong\u003e tab, and processes only rows matching the configured filter.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects noindex signals:\u003c\/strong\u003e Fetches each page over HTTP and parses both \u003cem\u003emeta robots\u003c\/em\u003e and \u003cstrong\u003eX-Robots-Tag\u003c\/strong\u003e values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates sheet status:\u003c\/strong\u003e Writes detected robots status back to the sheet (e.g., \u003cstrong\u003eNOINDEX\u003c\/strong\u003e, \u003cstrong\u003eINDEX\u003c\/strong\u003e, noindex via header, no meta robots found, or an HTTP error).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTargets rows marked “Needs index”:\u003c\/strong\u003e After the check, it reads rows where the \u003cstrong\u003eNote\u003c\/strong\u003e column equals \u003cstrong\u003eNeeds index\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds the new robots value:\u003c\/strong\u003e Extracts the underlying WordPress post\/term object ID from headers or page markup, then prepares a robots value that replaces \u003cem\u003enoindex\u003c\/em\u003e with \u003cem\u003eindex\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates WordPress via RankMath:\u003c\/strong\u003e Calls the RankMath WordPress REST endpoint \u003cstrong\u003eupdateMeta\u003c\/strong\u003e to apply the change, recording API errors when no valid object ID is found.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinal reporting:\u003c\/strong\u003e Writes \u003cstrong\u003eINDEX\u003c\/strong\u003e or error statuses back to Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRecover SEO traffic after accidental \u003cem\u003enoindex\u003c\/em\u003e settings in WordPress.\u003c\/li\u003e\n  \u003cli\u003eAudit large URL lists and bulk-fix indexing using n8n and RankMath.\u003c\/li\u003e\n  \u003cli\u003eOngoing SEO hygiene for SaaS operators managing many pages\/terms.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Tab \u003cstrong\u003e“All URLs”\u003c\/strong\u003e with columns exactly: \u003cstrong\u003eURL\u003c\/strong\u003e, \u003cstrong\u003eRobots Tag\u003c\/strong\u003e, \u003cstrong\u003eNote\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request:\u003c\/strong\u003e Fetches pages and inspects HTML + headers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\u003c\/strong\u003e if, code, limit, sticky note, http request, google sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRankMath integration:\u003c\/strong\u003e Uses the WordPress REST API \u003cstrong\u003eupdateMeta\u003c\/strong\u003e to switch robots from noindex to index.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e Add your Google Sheets credential in n8n and replace \u003cem\u003eYOUR_GOOGLE_SHEET_ID\u003c\/em\u003e in the Google Sheets nodes.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46288987029683,"sku":"N8N-21695","price":11.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/GFjeYaK-xwZe0BDESAaUa_nWQm69nr.png?v=1793005603","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-fix-wordpress-noindex-with-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}