Skip to main content

Get started with GPT for Sheets

Create AI-generated content in Google Sheets with the GPT for Sheets and Docs add-on.

This article demonstrates how GPT for Sheets can be used to suggest a tagline for an ice-cream shop, along with various other tasks, all directly from a Google spreadsheet.

Prerequisites

  1. Create a Google spreadsheet or open a spreadsheet that you own.

  2. Select Extensions > GPT for Sheets and Docs > Launch & Enable functions.

  3. Describe the task you want to get done (here in cell A2):

    Write a tagline for an ice-cream shop

  4. In the adjacent cell B2, use the GPT formula to send your task:

    =GPT(A2)

    The result appears directly in your cell.

  5. Write additional tasks under the first one.

    Tasks include Write a short email to thank my banker for the loan, Describe Deep Learning to a 5 year old, and How can I promote the website for my real estate agency?

  6. Copy the formula from B2 into the cells below by dragging the bottom right corner of B2 over the desired cells (B3 to B5).

    The fill handle is available when you select a cell and hover over its bottom right corner
    info

    You can also copy B2, select all applicable cells and paste it.

You have used the GPT function to perform a few simple tasks in a Google spreadsheet.

Go further