Installing GPT for Sheets - Autosheet

Installing GPT for Sheets - Autosheet

October 3, 2025

A practical guide to installing GPT for Sheets - Autosheet, using formulas, and managing model usage.

Young Hurley

Hurley White

AI Operator

Updated October 26, 2026. GPT for Work is now Autosheet. The Google Sheets add-on is named GPT for Sheets - Autosheet.


GPT for Sheets - Autosheet lets you apply AI prompts across spreadsheet data. At ArcticBlue, we use it to prototype workflows and perform simple data transformations.


1. Install the add-on

  • Open a Google Sheet. In the menu, choose Extensions > Add-ons > Get add-ons.

  • Find GPT for Sheets - Autosheet, install it, and follow the authorization prompts for your Google account. If your organization manages add-ons centrally, use its approved installation process.

Official installation instructions

2. Use GPT functions

Open Extensions > GPT for Sheets - Autosheet > Open. You can then use GPT functions in the spreadsheet. Built-in models do not require your own API key.


Try this in a cell:


=GPT("What are some tips for using ChatGPT?")
=GPT("What are some tips for using ChatGPT?")
=GPT("What are some tips for using ChatGPT?")

To work with another cell:


=GPT("What is another way to say this: " & A2)
=GPT("What is another way to say this: " & A2)
=GPT("What is another way to say this: " & A2)

For a classification task, make the criteria explicit:


=GPT("Given the following framework, return a color classification of this comment.
FRAMEWORK: [Red, Yellow, Green].
Return Red if the comment is inappropriate in a professional context.
Return Yellow if it may be construed as inappropriate.
Return Green if it is appropriate.
COMMENT: " & A2)
=GPT("Given the following framework, return a color classification of this comment.
FRAMEWORK: [Red, Yellow, Green].
Return Red if the comment is inappropriate in a professional context.
Return Yellow if it may be construed as inappropriate.
Return Green if it is appropriate.
COMMENT: " & A2)
=GPT("Given the following framework, return a color classification of this comment.
FRAMEWORK: [Red, Yellow, Green].
Return Red if the comment is inappropriate in a professional context.
Return Yellow if it may be construed as inappropriate.
Return Green if it is appropriate.
COMMENT: " & A2)

The function accepts a prompt followed by optional value, temperature and model arguments:


=GPT(prompt, [value], [temperature], [model])
=GPT(prompt, [value], [temperature], [model])
=GPT(prompt, [value], [temperature], [model])
  • Prompt: the instruction you want the model to follow.

  • Value: the text, cell or range the prompt applies to.

  • Temperature: an optional response-variability setting, from 0 to 1 in GPT functions.

  • Model: use the exact model name shown in the current model selector.

Some spreadsheet locales use semicolons between arguments. Start with a few rows, inspect the results, then fill the formula down across the rows you want to process.


3. Choose settings and understand costs

Model choice: compare results on a small sample before processing a full dataset. Models differ in speed, cost and capabilities. For online research, select a model with web search enabled and check its answers against the sources.


Temperature: where supported, lower settings generally give more consistent wording and higher settings produce more varied responses. GPT functions use the sidebar setting unless you specify a temperature in the formula.


Reasoning effort: where supported, lower effort generally favors speed and lower token usage; higher effort allows more processing for demanding tasks. The available settings depend on the model. Test representative examples to choose a useful balance.


API keys: built-in models do not require your own provider key. If you connect one, your provider bills model usage directly and Autosheet charges its applicable service usage. Using your own key does not eliminate costs. Check your plan before running a large batch.


Current plans and usage charges

4. Practical tips

  • Monitor usage in the Autosheet dashboard. If you connect a provider key, monitor the provider account too.

  • Throughput depends on the model, provider limits and workload. Follow any rate-limit error instructions and retry after the applicable limit resets.

  • Keep reusable prompts in a cell and reference that cell in your formula. This makes the instructions easier to inspect and change.

  • To keep completed results fixed, review them and replace formulas with their values. Retain a copy of the formulas if you will need to run them again.

  • Compare total costs under your plan before choosing between built-in and provider-connected models.

Appendix: Connect an optional provider API key

An API lets software systems communicate. A provider key authorizes the model requests made through the add-on. Use a key approved by your organization and keep it out of spreadsheet cells.


  • Check that your plan supports provider-connected models. Request an approved key from your administrator or follow the provider instructions to create one.

  • A space owner or administrator can sign in to the Autosheet dashboard and select AI provider keys.

  • Choose the provider, enter the key, then select Check and Save.

Keys configured for a space can be used by its users. Review access and monitor both provider billing and Autosheet usage before processing a large dataset.


Provider-key setup instructions

GPT functions reference and examples

Grid