Google Sheets + Slack + ChatGPT (OpenAI)
Send channel messages in Slack with ChatGPT responses to new Google Sheets rows
Once active, this integration automatically sends a response from ChatGPT to a custom prompt generated by the details added to each new row in a specified Google Sheets spreadsheet. Provide your teams with AI-enriched text, images, or responses without leaving your spreadsheet!
Once active, this integration automatically sends a response from ChatGPT to a custom prompt generated by the details added to each new row in a specified Google Sheets spreadsheet. Provide your teams with AI-enriched text, images, or responses without leaving your spreadsheet!
- 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...
ConversationSends a Chat to OpenAI and generate a Completion, optionally storing messages as we do.
ActionWriteCreate a new record or update an existing record in your app. - then do this!
Send Channel MessageTriggers when a new message is posted to a specific #channel you choose.
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
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
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
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundText 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.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.Info 1
Info 2
ModelRequired
PromptRequired
Info 3
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 foundTrigger for Bot Messages?
Optimized data
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ChannelRequired
Trigger for Bot Messages?
Optimized data
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Channel
User Name
Shared
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Search QueryRequired
Optimized data
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planZap Identifier
Access type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Saved Message
Triggers when you save a message.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.TextRequired
Remind when?Required
Remind who?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ChannelRequired
Add Zapier app to channel automatically?
Message TextRequired
Send as a bot?
Bot Name
Bot Icon
Include a link to this Zap?
Attach Image by URL
Auto-Expand Links?
Link Usernames and Channel Names?
Schedule At
File
Thread
Send Channel Message?
Zap Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Channel NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Approval request messageRequired
ChannelRequired
Bot name
Bot icon
Approvers
Approve button URL
Approve button label
Include a Decline button?
Include a Details button?
Ask responders for confirmation?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Title
Email
Display Name
User
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.Delete Message
This action deletes an existing message in a specific channel on Slack. You need to provide the channel ID and the message timestamp as inputs.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Private Channel
This action creates a private channel in Slack.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Edit Message
This action updates a specific message sent by the same Authenticated user on Slack. You need to provide the Channel ID, the Timestamp of the message to be edited, and the new text for the message.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search QueryRequired
Sort By
Sort Direction
ActionThis is an event a Zap performs.SearchFind existing data in your appIDRequired
Return Raw Results?
ActionThis is an event a Zap performs.SearchFind existing data in your appUsernameRequired
Return Raw Results?
ActionThis is an event a Zap performs.SearchFind existing data in your app
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
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
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
ImageRequired
Max Tokens
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User MessageRequired
ModelRequired
Memory Key
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
Info 1
Max Tokens
ModelRequired
Temperature
Top P
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.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
Info 1
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 foundNew Channel
Triggers when a new #channel is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Username
Highlight Word
Trigger for Bot Messages?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ChannelRequired
Trigger for Bot Messages?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New User
Triggers when a new Slack user is created / first joins your org.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ChannelRequired
UsersRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Send Multi Message
Message TextRequired
Send as a bot?
Include a link to this Zap?
Attach Image by URL
Auto-Expand Links?
Link Usernames and Channel Names?
Schedule At
Zap Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ChannelRequired
Add Zapier app to channel automatically?
Message TextRequired
Send as a bot?
Bot Name
Bot Icon
Include a link to this Zap?
Attach Image by URL
Auto-Expand Links?
Link Usernames and Channel Names?
Schedule At
Zap Id
File
Thread
Send Channel Message?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ChannelRequired
TopicRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Status Text
Status Emoji
Expiration Time
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Remove User from Channel
This action removes a specified user from a specified channel in Slack.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Retrieve Thread Messages
This action retrieves all the messages sent to a specific thread in a selected channel.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find Public Channel
This action will find a public channel in Slack using either the channel's ID or name.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Get Message by Timestamp
This action retrieves a specific message from a conversation history in Slack using the message's timestamp.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Return Raw Results?
ActionThis is an event a Zap performs.SearchFind existing data in your appFull NameRequired
Return Raw Results?
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Sheets
Related categories
About Slack
Related categories
