GPT for Google Sheets
GPT for Sheets is an AI tool for Google Sheets. With this add-on, Google Sheets can take advantage of the power of OpenAI GPT3 and Bard AI.
To start using GPT for Google Sheets directly in your spreadsheet, you will need to enable the GPT Function for each sheet

Enable GPT functions for your current sheet
With GPT for Sheets, you can effortlessly craft attention-grabbing ad copy, taglines, and subject lines that perfectly align with your brand, captivating and retaining your customers' interest.

To get started, select a cell and input then use the following formula
=GPT(prompt,
[value]
)
Parameter | Description | Default |
---|---|---|
prompt | the prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand") | "" |
value | The cell you are referring to in your prompt (ex: A1) | null |
Transforming your data has never been easier with GPT for Sheets. Its user-friendly custom functions enable you to swiftly cleanse and standardize any list or array of data, saving you time and hassle.

=GPT_LIST(prompt,
[value]
)
Parameter | Description | Default |
---|---|---|
prompt | the prompt describing the data you want to generate. (ex: "States in the US") | "" |
value | The cell you are referring to in your prompt (ex: A1) | null |
You can generate a full table of data with ChatGPT, you can specify the number of columns too!
.gif?alt=media&token=3b001706-e8f6-4a32-b590-dd8301db456a)
To get started, select a cell and input then use the following formula
=GPT_TABLE(prompt)
Parameter | Description | Default |
---|---|---|
prompt | the prompt describing the data you want to generate. You can specify the number of columns you want to get. (ex: "3 columns, countries in Europe, capital, food specialty ") | "" |
Say goodbye to language barriers with GPT for Sheets! With over 30 languages available, our tool can suggest translations that sound like they were written by a human, making it effortless to reply to emails in the recipient's language.

Last modified 5mo ago