ChatGPT

Two Minute Reports' ChatGPT connector sends prompts to OpenAI GPT models from Google Sheets and writes the responses into your sheet. You can add data from your sheet to a prompt, without writing any code.

What you can do

• Send a prompt to an OpenAI GPT model and write the response into your sheet
• Add data from a cell range in your sheet to the prompt
• Process that range as a whole (one response) or row by row (one response for each row)
• Choose the GPT model, the temperature and the maximum number of tokens

Prerequisites

• An OpenAI account
• An OpenAI API key

How to create a connection

1. In the Hub, open Connections & accounts.
2. Select Create connection.
3. Select ChatGPT in the connector list.
4. Select Next.

5. In Name the connection, enter a name.
6. In API key, paste your OpenAI API key.
7. Select Test connection.

8. Enable the account.
9. Select Done.

How to use ChatGPT in Google Sheets

To send a prompt from Google Sheets:

1. In the Two Minute Reports sidebar, open Data Queries.
2. Select Add.
3. Select your ChatGPT account. A query uses one account.
4. Enter your Prompt.
5. Optional: to add data from your sheet, set Spreadsheet Input to Yes. Enter the cell range in Spreadsheet Data (cell reference), and choose As a whole or Row wise under Process spreadsheet data.
6. Optional: under Model Configuration, choose the GPT Model, Temperature and Max Tokens.
7. Select Run query. Two Minute Reports writes the response into your sheet.