ChatGPT (OpenAI) + Google Sheets
Create ChatGPT conversations for new Google Sheets rows
Create engaging content from your Google Sheets data using this workflow. When you add a new row to your spreadsheet, the Conversation action in the ChatGPT app is initiated, turning your data into an interactive conversation. Save time and make your data more accessible with this seamless automation.
Create engaging content from your Google Sheets data using this workflow. When you add a new row to your spreadsheet, the Conversation action in the ChatGPT app is initiated, turning your data into an interactive conversation. Save time and make your data more accessible with this seamless automation.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Conversation (Legacy)Sends a Chat to OpenAI and generates a Completion, optionally storing messages as we do. Powered by Chat Completions API.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundMessage
ImagesRequired
Max Tokens
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Text to Be AnalyzedRequired
ModelRequired
Analysis TypeRequired
Info 1
Temperature
Top P
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User MessageRequired
ModelRequired
Use Latest Stable Version
Memory Key
User Name
Assistant Name
Assistant Instructions
Max Tokens
Temperature
Top P
Info 2
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Text to Be ClassifiedRequired
CategoriesRequired
ModelRequired
Max Tokens
Temperature
Top P
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Model
Name
Description
Instructions
Tools
New Files
Existing Files
Vector Store
Metadata
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Prompt
Response Format
Language of the Audio
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Unstructured TextRequired
ModelRequired
DescriptionRequired
Values to ExtractRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PromptRequired
Model
User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Text to Be SummarizedRequired
ModelRequired
Max Tokens
Temperature
Top P
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Prompt
Response Format
Temperature
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient NameRequired
Recipient EmailRequired
From NameRequired
Email PromptRequired
ToneRequired
Body TypeRequired
Info 3
ModelRequired
Max Tokens
Temperature
Top P
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name To Search ForRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appQueryRequired
DocumentsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFilename To Search ForRequired
File Purpose To Search For
FileRequired
Purpose
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundMessage
ImageRequired
Max Tokens
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Text to Be AnalyzedRequired
Info 1
Max Tokens
ModelRequired
Temperature
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy
Moderation ModelRequired
Text to be classifiedRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ModelRequired
User MessageRequired
Instructions
Memory Key
Images
File Clarification
Files
Max Tokens
Temperature
Top P
Tools
Response Format
Tool Choice
Info 2
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MessageRequired
Assistant
Assistant Name
Assistant Instructions
Model
Tools
Conversation ID
New Files
Existing Files
Response Instructions
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
New Files
Existing Files
Metadata
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Unstructured TextRequired
ModelRequired
DescriptionRequired
Values to ExtractRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info 1
Info 2
ModelRequired
PromptRequired
Temperature
Maximum Length
Stop Sequences
Top P
Frequency Penalty
Presence Penalty
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info 1
Info 2
ModelRequired
TextRequired
VoiceRequired
Response Format
Speed
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Purpose
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Filename To Search ForRequired
File Purpose To Search For
ActionThis is an event a Zap performs.SearchFind existing data in your appName To Search ForRequired
Model
Name
Description
Instructions
Tools
New Files
Existing Files
Vector Store
Metadata
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About ChatGPT (OpenAI)
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Send prompts to ChatGPT for Google Forms responses and add the ChatGPT response to a Google Sheet
- Send prompts to ChatGPT from Google Sheets and save the responses
- Extract key information from labeled emails and use ChatGPT to categorize important information and add to a Google Sheet
- Add new DialZara calls to Google Sheets
- Generate images with DALLE 3 based on Google Form responses and save them in Google Sheets
- Analyze images with ChatGPT and send to Google Sheets
- Add enriched Zendesk ticket information to a Google sheet using ChatGPT to categorize a conversation
- Send prompts to ChatGPT for Google Forms responses and add the ChatGPT response to a Google Sheet
- Analyze Intercom customer conversations with ChatGPT
- Translate audio files in Dropbox into text with ChatGPT
- Add AI-generated insights from TL;DV to Google Sheets
- Rewrite copy in a Google Sheets row using ChatGPT and add to a table in Coda
- Analyze Delighted responses with ChatGPT and add to Google Sheets
- Analyze G2 Crowd reviews with ChatGPT and add to Google Sheets
- Categorize Typeform responses with ChatGPT
- Categorize formless responses with ChatGPT
- Collect Slack messages and classify them with ChatGPT
- Create detailed summaries of Grain recordings with ChatGPT
- Translate audio files into different languages with ChatGPT
- Schedule social media posts via Buffer with ChatGPT captions and Imagior images based on new Google Sheets rows
- Analyze new Typeform entries with ChatGPT and send to a Google Sheet
- Send channel messages in Slack with ChatGPT responses to new Google Sheets rows
- Pull sales success from Fathom transcripts with ChatGPT and add to Google Sheets
- Analyze user behavior with ChatGPT based on HubSpot updates and send to Google Sheets
- Generate images with OpenAI based on prompts in Google Sheets and update in Google Sheets
- Spot trends in Browse AI data with ChatGPT and save insights to Google Sheets
Related Zap Templates
- Send prompts to ChatGPT for Google Forms responses and add the ChatGPT response to a Google Sheet
- Add new DialZara calls to Google Sheets
- Add enriched Zendesk ticket information to a Google sheet using ChatGPT to categorize a conversation
- Translate audio files in Dropbox into text with ChatGPT
- Analyze Delighted responses with ChatGPT and add to Google Sheets
- Send prompts to ChatGPT from Google Sheets and save the responses
- Generate images with DALLE 3 based on Google Form responses and save them in Google Sheets
- Send prompts to ChatGPT for Google Forms responses and add the ChatGPT response to a Google Sheet
- Add AI-generated insights from TL;DV to Google Sheets
- Analyze G2 Crowd reviews with ChatGPT and add to Google Sheets
- Collect Slack messages and classify them with ChatGPT
- Schedule social media posts via Buffer with ChatGPT captions and Imagior images based on new Google Sheets rows
- Pull sales success from Fathom transcripts with ChatGPT and add to Google Sheets
- Spot trends in Browse AI data with ChatGPT and save insights to Google Sheets
- Extract key information from labeled emails and use ChatGPT to categorize important information and add to a Google Sheet
- Analyze images with ChatGPT and send to Google Sheets
- Analyze Intercom customer conversations with ChatGPT
- Rewrite copy in a Google Sheets row using ChatGPT and add to a table in Coda
- Categorize Typeform responses with ChatGPT