Audit page schema and AI citation signals with GPT-4o-mini and Google Sheets

by Sara Soleymani ✓ · 18 views · created 2026-07-13 · Market Research, AI Summarization

What this workflow does

This workflow has 6 nodes and runs from “Read from Google Sheets” (no trigger node, so run it manually or call it from another workflow). Along the way it connects Google Sheets. It also calls api.openai.com over HTTP.

How it runs

Trigger: From “Read from Google Sheets” (no trigger node, so run it manually or call it from another workflow).

1. Read from Google Sheets (Google Sheets): uses Google Sheets
2. Fetch Page Content (HTTP Request): calls an HTTP API
3. Extract Page Signals (Code): runs custom JavaScript code
4. Send to OpenAI for Audit (HTTP Request): calls api.openai.com (POST)
5. Calculate Audit Scores (Code): runs custom JavaScript code
6. Append Audit to Sheets (Google Sheets): append

Services it uses

Google Sheets

HTTP calls to: api.openai.com

Before you upgrade to n8n 3.0

Nodes used (3)

• Google Sheetsn8n-nodes-base.googleSheets
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code

From the author

Quick overview This workflow reads page URLs from Google Sheets, fetches each page to extract schema and SEO freshness signals, uses OpenAI GPT-4o-mini to assess entity consistency and generate recommended JSON-LD, then writes an audit row with scores and…

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