Channel Talk + Google Sheets

Add new Channel.io userchat messages to Google Sheets as rows

Easily track customer interactions from Channel.io in a Google Sheets spreadsheet with this automation. When a new UserChat message occurs in Channel.io, this workflow will create a new row in your specified Google Sheets spreadsheet, keeping all your communication data organized and easily accessible. Stay effortlessly organized and never miss a conversation detail with this seamless integration.

When this happens...
New UserChat Message
Triggers when a new message is created in a user chat.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- Use whitelist for tagsRequired
Trigger
Instant
Try It
New Message Posted to Team Chat Group
Triggers when a new message is posted in Team Chat Group.
Trigger
Instant
Try It
- Check email qualifiedRequired
- Check mobileNumber qualifiedRequired
Trigger
Instant
Try It
UserChat Closed
Triggers when UserChat is closed.
Trigger
Instant
Try It
- Filter only when first openedRequired
Trigger
Instant
Try It

- ProfileRequired
Action
Write
- Member IDRequired
- Profile
Action
Write

- UserChatRequired
- Bot Name
- Message TextRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search or write

Manager Assigned to UserChat
Triggers when a manager is assigned to user chat.
Trigger
Instant
Try It
- Check email qualifiedRequired
- Check mobileNumber qualifiedRequired
Trigger
Instant
Try It
- Use whitelist for tagsRequired
Trigger
Instant
Try It
New UserChat Message
Triggers when a new message is created in a user chat.
Trigger
Instant
Try It
UserChat Snoozed
Triggers when UserChat is snoozed.
Trigger
Instant
Try It
- UserRequired
Action
Write
- GroupRequired
- Bot Name
- Message TextRequired
Action
Write
- Member IDRequired
Action
Search
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Search or write

About Channel Talk

Channel Talk: an all-in-one business messenger that combines live chat, team messaging, and a built-in customer database in one platform.

Related categories

Customer Support

About Google Sheets

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

Learn more Help

Related categories

Similar apps

Zapier Tables

Databases, Spreadsheets, Zapier

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

PRODUCTS

CAPABILITIES

By team

Channel Talk + Google Sheets

Add new Channel.io userchat messages to Google Sheets as rows

UserChat Tags Added

New Message Posted to Team Chat Group

Member Contact Created or Updated

Check email qualifiedRequired

Check mobileNumber qualifiedRequired

UserChat Closed

UserChat Opened

Filter only when first openedRequired

Creates a New Lead

ProfileRequired

Create or Update Member

Member IDRequired

Profile

Send Message to UserChat

UserChatRequired

Bot Name

Message TextRequired

New Spreadsheet Row (Team Drive)

Drive

SpreadsheetRequired

WorksheetRequired

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

SpreadsheetRequired

WorksheetRequired

Trigger Column

Create Spreadsheet Column

Drive

SpreadsheetRequired

WorksheetRequired

Column NameRequired

Index

Create Multiple Spreadsheet Rows

Drive

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

TitleRequired

Spreadsheet to Copy

Headers

Delete Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

Update Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Worksheet

Drive

SpreadsheetRequired

TitleRequired

Lookup Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column

Supporting Lookup Value

Bottom-Up

Find or Create Row

Drive