{"product_id":"track-weekly-chatgpt-citations-with-n8n-data-tables","title":"Track Weekly ChatGPT Citations with n8n Data Tables","description":"\u003ch3\u003eTrack weekly whether ChatGPT cites your site—automatically with n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow sends your buyer questions to the OpenAI Responses API with web search enabled every week, extracts all returned citation URLs, checks if your domain is cited and your brand is mentioned, and stores a weekly scorecard in an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e called \u003cstrong\u003eai_citation_results\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules weekly (or runs manually):\u003c\/strong\u003e It runs every Monday at 8:00 AM or can be triggered on demand.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your settings:\u003c\/strong\u003e Reads your configured \u003cem\u003ebrand domain\u003c\/em\u003e, \u003cem\u003ebrand name\u003c\/em\u003e, \u003cem\u003emodel\u003c\/em\u003e, and an array of \u003cem\u003ebuyer questions\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueries OpenAI with web search:\u003c\/strong\u003e For each question, it calls \u003cstrong\u003ehttps:\/\/api.openai.com\/v1\/responses\u003c\/strong\u003e and uses the \u003cstrong\u003eweb_search\u003c\/strong\u003e tool.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts citations and context flags:\u003c\/strong\u003e It captures the answer text, whether web search occurred, and all URL citations returned by OpenAI.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores your presence:\u003c\/strong\u003e It checks whether any cited URL contains your domain, whether the answer mentions your brand name, counts the number of sources, and records the cited URLs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves a weekly row:\u003c\/strong\u003e Inserts \u003cem\u003erun_date, prompt, cited, mentioned, sources, cited_urls\u003c\/em\u003e into the n8n Data Table.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor how often ChatGPT cites your site for specific buyer questions over time.\u003c\/li\u003e\n  \u003cli\u003eDetect brand visibility changes (your domain cited vs. brand name mentioned) after website updates.\u003c\/li\u003e\n  \u003cli\u003eCompare outcomes across multiple models by swapping the model in workflow Settings.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI integration:\u003c\/strong\u003e OpenAI Responses API (HTTP request to \u003cstrong\u003e\/v1\/responses\u003c\/strong\u003e) with \u003cstrong\u003eweb_search\u003c\/strong\u003e enabled.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Data Tables:\u003c\/strong\u003e Stores results in \u003cstrong\u003eai_citation_results\u003c\/strong\u003e (columns: run_date, prompt, cited, mentioned, sources, cited_urls).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes used:\u003c\/strong\u003e set, split out, data table, sticky note, http request, manual trigger.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup checklist:\u003c\/strong\u003e Add an OpenAI API credential for the HTTP request, create the Data Table named \u003cstrong\u003eai_citation_results\u003c\/strong\u003e, and update Settings for \u003cstrong\u003ebrand_domain\u003c\/strong\u003e, \u003cstrong\u003ebrand_name\u003c\/strong\u003e, \u003cstrong\u003emodel\u003c\/strong\u003e, and your \u003cstrong\u003eprompts\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46190206877875,"sku":"N8N-20652","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Xz0JyqqJWduggvUEhCcU3_44IuVR5r.png?v=1791450239","url":"https:\/\/buyflowscripts.com\/products\/track-weekly-chatgpt-citations-with-n8n-data-tables","provider":"N8N Commerce","version":"1.0","type":"link"}