Crisp and Google Sheets integration
How to connect Crisp and Google Sheets
Create a new workflow and add the first step
In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Build your own Crisp and Google Sheets integration
Create custom Crisp and Google Sheets workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
Supported API Endpoints for Crisp
Invite an operator
Send an invitation to a new website operator.
List website operators
List all website operators.
Create website
Creates a new website.
Get website
Retrieves a specific website's details.
Delete website
Deletes a specified website.
Abort website deletion
Aborts the deletion process for a website.
Create website
Creates a new website.
Get website
Resolves an existing website information.
Abort website deletion
Aborts scheduled deletion for an existing website.
List conversations
Retrieves a list of all conversations.
Create a new conversation
Initiates a new conversation.
Get a conversation
Retrieves the details of a specific conversation.
Remove a conversation
Removes a specified conversation.
Send a message in conversation
Sends a message to a specific conversation.
Get messages in conversation
Retrieves all messages in a specific conversation.
List conversations
Lists conversations for website.
List conversations
Lists conversations for a specified website.
Suggest conversation segments
Lists suggested conversation segments for a specified website.
Delete suggested segment
Deletes a suggested conversation segment for a specified website.
Suggest conversation data keys
Lists suggested conversation data keys for a specified website.
Delete suggested data key
Deletes a suggested conversation data key for a specified website.
List people profiles
Retrieves a list of all people profiles.
Add new people profile
Creates a new profile for a person.
Get people profile
Retrieves the details of a specific people profile.
Save people profile
Saves changes made to a specific people profile.
Remove people profile
Deletes a specified people profile.
Get subscription status
Retrieve the subscription status of a person.
Export profiles
Export profiles of people.
Import profiles
Import profiles of people.
Create profile
A people profile was created.
Update profile
A people profile was updated.
Remove profile
A people profile was removed.
Bind session
A people profile was bound to session.
Sync profile
People profile was synchronized for session (ie.
Read profiles
Retrieve the profile of a specific person.
Count visitors
Get the count of website visitors.
List visitors
List all website visitors.
Clear blocked visitors in rule
Clear blocked visitors based on a specific rule.
Get website availability status
Retrieve the current availability status of the website.
Check if helpdesk exists
Verify the existence of a helpdesk.
Initialize helpdesk
Set up a new helpdesk.
List campaigns
Retrieve a list of campaigns.
Create a new campaign template
Establish a new template for campaigns.
Get a campaign template
Retrieve details of a specific campaign template.
Remove a campaign template
Delete an existing campaign template.
Create conversation
Creates a new conversation.
Check if conversation exists
Checks if given conversation session identifier exists.
Get conversation
Retrieves a conversation session.
Initiate conversation
Initiates a conversation from an existing session.
Get messages
Resolves messages in an existing conversation.
Compose message
Composes a message in an existing conversation for MagicType preview.
Mark messages as read
Marks messages as read in conversation using given message fingerprints or all messages.
Mark messages as delivered
Marks messages as delivered in conversation.
Update conversation open state
Updates conversation open state for authenticated operator user.
Get conversation routing assign
Resolves assigned operator for conversation routing.
Update conversation inbox
Updates inbox used for conversation.
Get conversation metas
Resolves conversation meta information.
Get an original message in conversation
Resolves an existing original message in an existing conversation.
Get messages
Retrieve messages from a specific conversation session.
Send a message
Sends a message in an existing conversation.
Send message
Send a text message during a conversation session.
Get message
Resolves an existing message in an existing conversation.
Update message
A message has been updated.
Send message
A message has been sent from a visitor (received by operators).
Receive message
A message has been sent from an operator (received by a visitor).
Remove message
A message has been removed.
Compose message
A message is being composed (MagicType from operator).
Acknowledge read message
Messages sent by visitor were read by an operator.
Acknowledge read received message
Messages sent by operators were read by visitor.
Acknowledge delivered message
Visitor client acknowledged delivery of an operator message.
Notify unread message
Messages sent by visitor were not read in due time by an operator.
Notify unread received message
Messages sent by operators were not read in due time by visitor.
Update session availability
session availability changed _(eg.
Verify session
session verification status changed
Initiate session
session has been initiated (conversation started)
Set email for session
an email has been set for session
Set phone for session
a phone number has been set for session
Set address for session
an address has been set for session
Set subject for session
a subject has been set for session
Set avatar for session
an avatar has been set for session
Set nickname for session
a nickname has been set for session
Set custom data for session
user custom data has been set for session
Set segments for session
user segments have been added to session
Block or unblock session
session was just blocked or unblocked
Open session
conversation has been opened by an operator (viewed by)
Sync locales
Current device locales were just pushed for session.
Sync pages
A page was just browsed by user on session.
Sync events
Events were just pushed from user on session.
Sync rating
A user rating was just submitted for session.
Sync topic
A topic was just detected from the session messages.
Remove session
Session has been removed (i.
Set session closed
Conversation has been closed by a viewing operator.
Set session participants
The list of conversation participants has been updated.
Set session mentions
An operator mentioned another operator.
Set session routing
A routing identifier was set on conversation.
Set session inbox
An inbox identifier was set on conversation.
Set session state
Session state changed (eg.
Sync session capabilities
User device just advertised its capabilities on session (eg.
Sync session geolocation
Current geolocation was just pushed for session.
Sync session system
Current device system was just pushed for session.
Sync session network
Current device network was just pushed for session.
Sync session timezone
Current device timezone was just pushed for session.
Progress
The campaign delivery is progressing (e.
Dispatched
The campaign was dispatched.
Initiate browsing request
MagicBrowse request initiated by visitor browser.
Reject browsing request
MagicBrowse request rejected by visitor browser (e.
Initiate call request
Call was initiated (accepted by user).
Reject call request
Call was rejected (declined by user).
Process widget action
Widget action processed result (success or failure).
Check status health
The status page health has changed (either: healthy, sick or dead).
Generate upload URL
An upload URL was generated for a status file upload (signed URL, usable once).
Generate processing URL
An upload URL was generated for a processing/import upload (signed URL, usable once).
List animations
Requested animation/GIF list is being returned.
Subscribe user
A user subscribed or unsubscribed to emails.
Track email view
A user viewed an email.
Channel event
Generic channel for plugins.
Event fired
A generic plugin event has been fired.
Save plugin settings
Plugin settings saved.
To set up Crisp integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Crisp to query the data you need using the API endpoint URLs you provide.
See the example hereThese API endpoints were generated using n8n
n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Crisp official documentation to get a full list of all API endpoints and verify the scraped ones!
Google Sheets supported actions
Create
Create a spreadsheet
Delete
Delete a spreadsheet
Append or Update Row
Append a new row or update an existing one (upsert)
Append Row
Create a new row in a sheet
Clear
Delete all the contents or a part of a sheet
Create
Create a new sheet
Delete
Permanently delete a sheet
Delete Rows or Columns
Delete columns or rows from a sheet
Get Row(s)
Retrieve one or more rows from a sheet
Update Row
Update an existing row in a sheet
Crisp and Google Sheets integration details
Other integrations with Google Sheets
Crisp and Google Sheets integration tutorials
How to use Google Sheets as a database
Dive into the versatility of Google Sheets as a database with our in-depth comparison of Python scripting and n8n automation. Get 7 free workflows to set up your Google Sheets database in n8n!
How to import CSV into Google Sheets: 3 best methods
Explore 3 efficient methods for importing CSV files into Google Sheets, comparing n8n's automated workflow with the manual import via native Google Sheets interface and the programmatic import via Python.
How to import XML to Google Sheets: 3 step-by-step techniques
Learn three different ways to import XML to Google sheets: with Google sheet’s IMPORTXML function, with Google AppScript and automation with n8n.
How to pull data from Google Spreadsheet to HTML: Code and no code approaches
Learn how to pull data from Google Spreadsheet to HTML using Google Apps Script and n8n automation tool.
How to connect Google Sheets to MySQL: Code and no-code methods
Discover two ways to connect MySQL with Google Sheets, and learn to build no-code workflows for automating it.
How to automatically import JSON into Google Sheets
Discover three ways to import JSON data into Google Sheets or a CSV file, and five no-code workflows for automatically moving data between JSON and spreadsheets.
FAQ
Can Crisp connect with Google Sheets?
Can I use Crisp’s API with n8n?
Can I use Google Sheets’s API with n8n?
Is n8n secure for integrating Crisp and Google Sheets?
How to get started with Crisp and Google Sheets integration in n8n.io?
Need help setting up your Crisp and Google Sheets integration?
Discover our latest community's recommendations and join the discussions about Crisp and Google Sheets integration.
Google Sheets Action is not picking up a list of available Sheets despite seeing the document itself
Sergey Komardenkov
Describe the problem/error/question I am testing a workflow where the final action is addition of a row into a Google sheet. I have created a new sheet, I gave it Edit permissions by link just in case, and of course I ad…
Open topic
The prompt is not being executed
sérgio eduardo floresta filho
Hello! My goal is to use Google Forms to collect information from my clients and then use n8n to automate the processing of this information. My workflow involves: Collecting data through Google Forms. Using n8n to re…
Open topic
Sending timestamp to Google Sheets with correct timezone
Julian
I’m trying to send a timestamp to a Google Sheet. Therefore, I use the expression $now.format(“HH:mm”).toString(). In n8n, the timestamp looks correct (see screenshot). However, in Google Sheets, the string value is …
Open topic
Filtering rows in google sheets with empty value in specific colum
therealJMT
Describe the problem/error/question edit: I guess I figured it out. The “isEmpty()” is a boolean function and has no output it just checks in the node if it’s true or not. For my workflow I got it running with a setup th…
Open topic
Error 400 | Google | n8n inserting too many characters in OAuth Redirect URL
Guilherme
Hello everyone, I’m having a problem logging into my Google account when I’m creating a credential for Google Sheets. :warning:Error 400: redirect_uri_mismatch I noticed that n8n is inserting an extra character in t…
Open topic
Looking to integrate Crisp and Google Sheets in your company?
The world's most popular workflow automation platform for technical teams including
Why use n8n to integrate Crisp with Google Sheets
Build complex workflows, really fast
