Monitor AI search visibility with Talordata SERP, OpenAI, and Google Sheets

Description

Quick overview
This workflow runs on demand to crawl Google SERP pages via Talordata, aggregates organic results and related searches, uses OpenAI to produce a structured AI Search Visibility report with GEO recommendations and a score, and appends or updates the results in Google Sheets.

How it works
Starts when you manually execute the workflow and sets the target query, search engine (Google), and initial page.
Calls the Talordata MCP Search API to fetch the first SERP page, then extracts pagination metadata and builds a list of pages to crawl.
Loops through each SERP page and requests additional results from Talordata using the corresponding page/start value.
Normalizes each page into structured datasets for organic results and related searches, and aggregates all page data into a single consolidated SERP payload.
Sends the consolidated SERP dataset to OpenAI to generate a structured AI Search Visibility report (metrics, domain categorization, opportunities, recommendations, executive summary, and score).
Parses the model output into JSON and appends or updates a matching row in Google Sheets keyed by the SERP link.

Setup
Add a Talordata Bearer Auth credential and confirm access to the MCP endpoint (https://mcp.talordata.net/mcp).
Add an OpenAI API credential and ensure the selected chat model (gpt-4.1-mini) is available in your account.
Add a Google Sheets OAuth2 credential, select the destination spreadsheet and sheet, and make sure it has columns for link and ai_visibility_response.
Update the workflow input values (query, engine, and starting page) to match the brand/keyword you want to monitor.

Requirements
Make sure to sign up for Talordata and OpenAI to get the API keys