ConditionalVisibility

new-products-promo

connect-google-sheets-with-chatgpt-01

connect-google-sheets-with-chatgpt-02

connect-google-sheets-with-chatgpt-03

connect-google-sheets-with-chatgpt-04

connect-google-sheets-with-chatgpt-05

connect-google-sheets-with-chatgpt-06

connect-google-sheets-with-chatgpt-07

connect-google-sheets-with-chatgpt-08

connect-google-sheets-with-chatgpt-09

connect-google-sheets-with-chatgpt-10

Zapier tutorials

connect-google-sheets-with-chatgpt-00-hero

Google Sheets

ChatGPT

Here's how to send prompts to ChatGPT from your Google Sheet and add the response to the same row—automatically.

How to connect ChatGPT with Google Sheets

Easily send prompts to ChatGPT with this workflow. When you add a new prompt to Google Sheets, this automated workflow will send the prompt to ChatGPT, then save the response in the same Google Sheet.

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

ChatGPT is an AI tool built by OpenAI that enables conversational automation.

A more powerful OpenAI integration is available here: https://zapier.com/apps/openai/integrations

Find Assistant

Find File

This best matches a query string (like "big animal") to a list of document strings (like "mouse", "cat", "buffalo", and "blue whale").

Search Embeddings

Find or Create Assistant

Find or Create File

Upload an image and send a message or question about it.

Analyze Image Content With Vision

Generate an analysis of the overall sentiment of a block of text.

Analyze Text Sentiment

Sends a Chat to OpenAI and generate a Completion, optionally storing messages as we do.

Conversation

Classifies if text is potentially harmful.

Check Moderations

Classify your text into one of your provided categories.

Classify Text

Create Assistant

Sends a message to ChatGPT and generates a response, optionally storing the message history for a continuous conversation.

Conversation With Assistant

Creates a new transcription, using Whisper, from an audio or video file.

Create Transcription

Create Vector Store

Sends unstructured text and returns structured data using OpenAI's "Function Calling" capability.

Extract Structured Data

Generate An Image With DALL-E

Sends a prompt to OpenAI and generates a completion. _Note:_ this uses the legacy OpenAI Completions API. We recommend using `Conversation` or `Conversation With Assistant` actions instead, which are powered by the latest OpenAI APIs.

Send Prompt

Enter a block of text and generate a summary.

Summarize Text

Convert Text to Speech

Create Translation

Uploads a file so it can be used with assistants or fine-tuning.

Upload File

Writes the content of an email based on your provided prompt for use in a subsequent step.

How to connect ChatGPT with Google Sheets

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.