Import OpenAI (ChatGPT) Data to Google Sheets

In this guide, we’ll walk through how to pull data from the OpenAPI (ChatGPT) API directly into Google Sheets, using the API Connector add-on for Sheets. You can use this method to generate text content and images in response to prompts you enter in your spreadsheet.

Contents

• Before You Begin
• Part 1: Get OpenAI API Key
• Part 2: Generate a Chat Completion to a Text Prompt (ChatGPT)
• Part 3: Generate an Image with Dall-E
• Part 4: Create a Custom Request
  • Example 1: ChatGPT API
  • Example 2: GPT4 with Vision
• Part 5: Run Requests Based on Sheet Data (Reference Cells)
• Part 6: API Documentation

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your OpenAI API Key

1. Create a free OpenAPI account at https://beta.openai.com/signup
   
2. Once you're logged in, click the account menu in the top right, and then View API keys (or just navigate to https://beta.openai.com/account/api-keys directly)
   
3. Click Create new secret key
   
4. Your API key will appear in a modal. Copy it and keep it safe, you'll need it in a moment!
   
   

Part 2: Generate a Chat Completion to a Text Prompt (ChatGPT)

OpenAI has many endpoints, each providing a different type of AI function, and the easiest way to get started is through API Connector's built-in integration. Here's how to send a message to OpenAI and automatically generate a text "completion" (a response) that matches the context you provided.

1. In Sheets, open API Connector and create a new request (Extensions > API Connector > Open > Create request)
2. Select OpenAI from the drop-down list of applications
   
3. Under Authorization, enter your credentials from above, with the word Bearer in front.
4. Choose the /chat/completions endpoint to access OpenAI's newest language models.
   
5. In the Body parameters section, open the messages parameter and select a role and message. If you'd like to keep things simple with a single-turn task, simply select user and enter your message.
   
6. (Optional) The /chat/completions endpoint allows you to create a multi-turn conversation, where you first set a system message followed by alternating user and assistant messages (you're the user, and the AI is the assistant). To add multiple steps, click the +Add button and enter each role and message you'd like to process. More info >
7. In the model parameter, select an OpenAI model. Currently, the most powerful model is gpt-4o, but that's available only for paying users. If you don't have access, select gpt-3.5-turbo.
8. Optionally fill out the other parameters to customize your request. See here for information about these parameters.
9. Select a destination sheet, name your request, and hit Run.
   
   

Part 3: Generate an Image with Dall-E

OpenAI's Dall-E model enables image creation. Here's how you'd send a prompt to OpenAI and automatically generate an image.

1. In Sheets, open API Connector and create a new request (Extensions > API Connector > Open > Create request)
2. Select OpenAI from the drop-down list of applications
   Under Authorization, enter your credentials from above, with the word Bearer in front.
3. Choose the /images/generations endpoint.
   In the Body parameters section, enter your prompt. Optionally fill out the other parameters to customize your request.
4. Select a destination sheet, name your request, and hit Run. A moment later you’ll see OpenAPI's response in your spreadsheet. The data.url field will contain a link to the generated image; use Google Sheets' =IMAGE function to see the image in your sheet, or just click the link to see the image in your browser.
   
   

Part 4: Create a Custom Request

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the endpoints and parameters shown in the API documentation.

Example 1: ChatGPT API

1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
2. In the request form enter the following:
   • Application: Custom
   • Method: POST
   • Request URL: https://api.openai.com/v1/chat/completions
   • OAuth: None
   • Headers:
     • Authorization: Bearer your_api_key
     • Content-Type: application/json
   • Request body: {"model":"gpt-3.5-turbo","messages": [{"role": "user", "content": "How is gpt-3.5-turbo different from text-davinci-003"}],"temperature":0.5,"max_tokens":1000,"top_p":0.3,"frequency_penalty":0,"presence_penalty":0,"n":1}
3. Replace the content parameter above with a prompt of your choosing. The other parameters can be left as is, or edited.
4. Create a new tab and click Set current to use that tab as your data destination.
5. Name your request and click Run. A moment later you’ll see OpenAPI's response in your spreadsheet.
   
   

Note: The /v1/chat/completions endpoint is compatible only with specific models, as shown here (and the gpt-4 models are available only with a paid subscription to ChatGPT+)

Example 2: GPT-4 with Vision

This API lets you analyze images.

1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
2. In the request form enter the following:
   • Application: Custom
   • Method: POST
   • Request URL: https://api.openai.com/v1/chat/completions
   • OAuth: None
   • Headers:
     • Authorization: Bearer your_api_key
     • Content-Type: application/json
   • Request body: {"model":"gpt-4-vision-preview","messages":[{"role":"user","content":[{"type":"text","text":"What’s in this image?"},{"type":"image_url","image_url":{"url":"https://upload.wikimedia.org/wikipedia/commons/thumb/d/dd/Gfp-wisconsin-madison-the-nature-boardwalk.jpg/2560px-Gfp-wisconsin-madison-the-nature-boardwalk.jpg"}}]}],"max_tokens":300}
3. Replace the url parameter above with the image URL you'd like to analyze, and the text parameter with the question you'd like to ask about the image.
4. Create a new tab and click Set current to use that tab as your data destination.
5. Name your request and click Run. A moment later you’ll see OpenAPI's response in your spreadsheet.

Note: you'll need to buy credits (at least $5) to access the GPT-4 with Vision API (info).

Part 5: Run Requests Based on Sheet Data (Cell References)

You may configure your request such that it uses prompts located in cells of your spreadsheet.

#1 Reference a cell in your request (info):

• Reference cells in your request body by wrapping the cell reference in 3 plus signs on either side, e.g. +++Sheet1!A1+++
  
• Save the request. It will now automatically pull in the value from cell A1 each time it runs.

#2 Reference a list of cells in your request (info):

To run through a list of cells, running a request for each one, you'll need to create a custom request. Insert the word :::BREAK::: between each request body, e.g.

{"model":"gpt-3.5-turbo","messages": [{"role": "user", "content": "+++Sheet1!A1+++"}],"temperature":0.5,"max_tokens":1000,"top_p":0.3,"frequency_penalty":0,"presence_penalty":0,"n":1}

:::BREAK:::

{"model":"gpt-3.5-turbo","messages": [{"role": "user", "content": "+++Sheet1!A2+++"}],"temperature":0.5,"max_tokens":1000,"top_p":0.3,"frequency_penalty":0,"presence_penalty":0,"n":1}

:::BREAK:::

{"model":"gpt-3.5-turbo","messages": [{"role": "user", "content": "+++Sheet1!A3+++"}],"temperature":0.5,"max_tokens":1000,"top_p":0.3,"frequency_penalty":0,"presence_penalty":0,"n":1}

Demo sheet

This process can be semi-automated by concatenating all the request bodies in your sheet rather than pasting them in one by one. View/copy this sheet for example setups on either the /chat/completions or /completions endpoint: OpenAI Demo Sheet

Part 6: API Documentation

Official API documentation: https://beta.openai.com/docs/introduction/overview

Note: When you first get your API key, you'll be on a free trial. Check https://beta.openai.com/account/billing/overview to see your usage and pricing information.