---
title: "How to add an AI-generated results summary in Google Sheets and Excel"
slug: "how-to-add-an-ai-generated-results-summary-in-google-sheets-and-excel"
description: "Summarize your marketing data effortlessly with Supermetrics for Google Sheets and Excel, using AI-driven insights for better decision-making."
tags: ["video"]
updated: 2026-04-29T07:02:11Z
published: 2026-04-29T07:02:11Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to add an AI-generated results summary in Google Sheets and Excel

Supermetrics for Google Sheets and Supermetrics for Excel include the option to add a results summary to your queries. The results summaries are supported for all data source connectors except for the JSON/CSV and Database connectors.

[Embedded content](https://www.youtube.com/embed/F3nDjEf3iVI?&wmode=opaque)

For most queries, the results summary option uses GPT 4 (OpenAI) to summarize the results of your data. If your query exceeds the model's content size limit, the option switches to using GPT 3.5.

The results summary gives you a quick and easy way to understand the key takeaways from your marketing data. By default, we ask the Al model to be a marketing analyst and summarize the results from that perspective. The summary option summarizes the data that you choose to include in your query.

## Instructions

### Google Sheets

1. Select a query to add the summary for, and click the 3-dot menu.
2. Select **View query insights**, and check the **Add results summary by AI** checkbox. To use a custom prompt instead, type your custom prompt into the **Custom prompt** field. The summary will be automatically generated and added to the top of your spreadsheet. ![Settings panel for AI results summary with options for query updates.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/google-sheets-ai-results-summary.png)
3. Update the query.

### Excel

1. Select a query to modify or start creating a new one.
2. Under Options, check the **Add results summary by AI** checkbox. If you want to use a custom prompt instead of the default prompt, navigate to **Options** in the Supermetrics sidebar and type `AI_SUMMARIZE_PROMPT_"This is the prompt`" into the Advanced settings box. ![Options menu with checkboxes for report settings and AI summary feature.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/excel-ai-results-summary.png)
3. Update the query.

## Limitations and data use

Users with a subscription for Supermetrics for Google Sheets or Supermetrics for Excel or users with a Supermetrics trial can run 15 results summary queries per month. Users with a Supermetrics Enterprise package can run 500 results summary queries per month.

The ChatGPT API is used to pass the data. The data is retained for 30 days, and the data is not used in any form to train the OpenAI data models. [Learn more about the ChatGPT API and data use from OpenAI](https://help.openai.com/en/articles/7232945-how-can-i-use-the-chatgpt-api).