See llms.txt for all machine-readable content.

Back to Templates

Analyze Google AI answer formats by topic with DataForSEO and Sheets

Quick overview

Sorts every element of Google's AI Overview and AI Mode answers for your keywords by format (paragraph, numbered list, bulleted list, table, shopping, video) using the DataForSEO SERP API. Saves formats per keyword and format shares per topic to Google Sheets, showing which page structure AI answers favor.

How it works

  1. Runs on a weekly schedule.
  2. Fetches keywords and their topics from the Keywords tab of your Google Sheet, and cleans and deduplicates them.
  3. Gets the AI Overview for each keyword from the live Google SERP with asynchronous AI Overviews loaded, then the AI Mode answer for the same keyword.
  4. Classifies each AI answer’s elements into formats (table, shopping, numbered list, bulleted list, video, paragraph, or other), determines a main format for each surface, and generates a page-format suggestion.
  5. Saves one row per keyword to the Answer formats tab. Rows are matched by keyword, so re-runs update existing rows instead of adding duplicates.
  6. Groups the results by topic and surface, calculates the share of answers that contain each format and the most common main format, and saves them to the Topic summary tab (matched by summary_id).

Setup

  1. Make a copy of the example Google Sheet and add your keywords to the Keyword column and their topic cluster to the Topic column of the Keywords tab.
  2. Install the verified community node n8n-nodes-dataforseo.
  3. Create or select your DataForSEO connection (use your API login and password).
  4. Create or select a Google Sheets connection.
  5. In the Config node, paste your sheet URL into sheet_url and set location_name and language_name (see supported SERP locations and AI Mode languages).
  6. Set the preferred workflow schedule.

Requirements

  • DataForSEO account with API access.
  • Google account with Google Sheets.

Customization

  • Topics: leave the Topic column empty to analyze all keywords as one group (shown as (no topic)), or set topic_column in Config to use another column (default: Topic).