Google Sheets + Intercom + ChatGPT (OpenAI)
Analyze Intercom customer conversations with ChatGPT
Automatically analyze customer sentiment and organize insights with this integration. When a conversation is closed in Intercom, the text is analyzed for sentiment using ChatGPT, and the results are logged in a Google Sheets spreadsheet. This streamlined process helps you track customer feedback and satisfaction, enabling data-driven decisions to enhance customer support.
Automatically analyze customer sentiment and organize insights with this integration. When a conversation is closed in Intercom, the text is analyzed for sentiment using ChatGPT, and the results are logged in a Google Sheets spreadsheet. This streamlined process helps you track customer feedback and satisfaction, enabling data-driven decisions to enhance customer support.
- When this happens...
New Closed ConversationTriggers when you close a Conversation.
TriggerInstantThis event starts a Zap instantly. - automatically do this...
Analyze Text Sentiment (Legacy)Generate an analysis of the overall sentiment of a block of text. Powered by Chat Completions API.
ActionWriteCreate a new record or update an existing record in your app. - then do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Lead Added Email
Triggers when a Lead enters an email address.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Lead
Triggers when a new Lead is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New AI Summary
Triggers when an AI-generated summary is created for a conversation in Intercom.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Company
Triggers when a new Company is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Ticket
Triggers when a new Ticket is created in Intercom.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Contact
Triggers when a Contact is updated in Intercom.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
Note TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Description
Body
AuthorRequired
State
Parent Collection
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event nameRequired
Created at
Contact identifier typeRequired
Metadata
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ticket typeRequired
Contact IDRequired
Company ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Conversation IDRequired
Reply TypeRequired
Reply BodyRequired
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FromRequired
ToRequired
Message TypeRequired
BodyRequired
Subject
Template
Create Conversation Without Contact Reply?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead ID
Full Name
Email
Phone Number
Unsubscribed From Emails
Created At
IP Address
Custom Attributes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lookup EmailRequired
Full Name
User ID
Company ID
Unsubscribed From Emails
Phone Number
Created At
IP Address
Custom Attributes
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.Search FieldRequired
Match TypeRequired
Conversation Status
Updated After
Updated Before
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch FieldRequired
Match TypeRequired
Ticket State
Updated After
Updated Before
ActionThis is an event a Zap performs.SearchFind existing data in your appConversation IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ModeRequired
Search ValueRequired
Lead ID
Full Name
Email
Phone Number
Unsubscribed From Emails
Created At
IP Address
Custom Attributes
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
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 foundDrive
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
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
TitleRequired
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 appSpreadsheet IDRequired
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 found
Lead Converted to User
Triggers when a lead converts to a user.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Replied
Triggers when a Contact replies to a Conversation in Intercom.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Conversation Rating
Triggers when a conversation receives a rating.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Conversation
Triggers when a new Conversation is created by a User in Intercom.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New User
Triggers when a new User is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Company
Triggers when a company is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.UpdatesRequired
Update sample
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Unsubscription
Triggers when a user unsubscribes from Intercom.io emails.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact identifier typeRequired
Tag selection method
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact TypeRequired
Message BodyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User Association Note
CompanyRequired
Warning
Name
Website
Size
Monthly Revenue
Plan
Industry
Custom Attributes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact identifier typeRequired
TagRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact Identifier
Message BodyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CompanyRequired
Tag NameRequired
Untag?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
Title
Description
State
Is Open
Snoozed Until
Assigned Admin
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Custom Attributes
Created At
User ID
Full Name
IP Address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search Mode
Search Value
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ModeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ModeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Mode
Search Value
User Association Note
Company NameRequired
Plan
Size
Website
Industry
Custom Attributes
Monthly Revenue
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
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 foundNo 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.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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 found
About Google Sheets
Related categories
About Intercom
Related categories
