SUMMARIZE

Get a clear summary from a spreadsheet range with any data using ChatGPT

Ideal for use in domains like market research, academic studies, or financial analysis; this function uses ChatGPT to summarize columns of customer reviews, lengthy reports, or even complex datasets, providing quick insights without the need to sift through your Google Sheets tables.

Examples

Arguments List

=SUMMARIZE_X(range, [as_bullet_points],[options])
=SUMMARIZE_Y(range, [as_bullet_points],[options])

Options List

Particular object at the end of a formula which contains optional parameters values in the form {"parameter_name",value; "next_parameter_name",value}
For Example: {"output_language","French"; "extra_instructions","Remember this info: " & A1; "act_like","Data Analyst"}

mode

The type of summary generated from the spreadsheet range via ChatGPT determines the cost, execution time, and quality of the outcome.

Short: Focus on providing a short summary
Balanced (default): provide a balanced summary. and
Detailed: Provide a detailed summary of the range and try to do data analysis.
Options: "short", "balanced", or "extensive"

output_language

The output language for the AI-generated summary. It can be set independently of the Google Sheet range or arguments language.
For Example: "EN", "French", or "Most Popular Language in the US"

temperature

A scale for adjusting the variability of ChatGPT-generated summaries from 0 (deterministic) to 1 (more variable, creative).
For Example: 0, 0.4, or 1

act_like

Specifying a role, profession, or perspective for the AI to assume when generating the summary directs the AI to produce more tailored or specialized results. This parameter enables the creation of context-specific outcomes.
For example: "Products Expert", "Marketer", or "Google Sheet Table"

extra_instructions

Additional information or instructions to better tailor the summary of the spreadsheet range to your specific needs.

For example: "Should have 5 points", "Find connections between time and KPI", or "Remember this: " & B2

model

Model affects quality, speed, and tokens count of tokens to use. We choose the optimal model ("default") by default, and here it's gpt-4. Information about models.
Options: "default", "gpt-4, "gpt-3.5-turbo", or "gpt-3.5-turbo-16k"

max_tokens

Control the token count used per ChatGPT function execution. It limits token usage to a reasonable value by default.

1 token ≈ 4 chars in English
1 token ≈ 3/4 words
100 tokens ≈ 75 words
1-2 sentences ≈ 30 tokens
1 paragraph ≈ 100 tokens
1,500 words ≈ 2048 tokens
For Example: 100, 350, or 2048

generate

If set to TRUE, the formula will carry out the calculation. If set to FALSE, a warning text will appear instead of generating a summary for the spreadsheet range. To avoid accidental costs, connect this setting to a Google Sheets cell equipped with a checkbox or an input-validation formula

For Example: TRUE, FALSE, or G18

generate_warning

This text will appear when 'generate' is set to FALSE. As a best practice, include instructions on what actions are required to activate the calculation. Use the codeword [STOP] to halt the calculation of related formulas; this will not be visible to the user. Use the word "default" to display a standard warning message.

For Example: "default", "Choose a type of the summary", or J18

Sidebar Option

Due to Google Sheets' limitations, a specific feature may not be available for Smart Formulas. However, this feature can be accessed through a Smart Function in the Websheet AI sidebar.