2Chat + Google Sheets
Create Google Sheets rows for new WhatsApp messages via 2Chat
Keep a record of each new WhatsApp message you send or receive via 2Chat in a Google Sheets spreadsheet.
Keep a record of each new WhatsApp message you send or receive via 2Chat in a Google Sheets spreadsheet.
- When this happens...
New WhatsApp MessageTriggers when a new message is either sent or received on 2Chat. Works for messages sent by agents or sent by your users/customers.
TriggerInstantThis event starts a Zap instantly. - automatically 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
Connected NumberRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Connected NumberRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Connected NumberRequired
WhatsApp Group IDRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Connected NumberRequired
WhatsApp Group IDRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Connected NumberRequired
Time PeriodRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.First NameRequired
Last Name
Profile Picture URL
Phone Number
Email Address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Connected NumberRequired
Product NameRequired
Default Image URLRequired
Product Description
Product Price
Product Currency
Hide Product
Product URL
Custom Product ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Connected NumberRequired
Product IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Connected NumberRequired
Product IDRequired
Product Name
Default Image URL
Product Description
Product Price
Hide Product
Product URL
Custom Product ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Connected NumberRequired
WhatsApp Group IDRequired
Media Public URLRequired
Caption
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.From NumberRequired
To NumberRequired
Media Public URLRequired
Caption
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Connected NumberRequired
Image Public URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Connected NumberRequired
Target NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appConnected NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
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.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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 found
Connected NumberRequired
WhatsApp Group IDRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Connected NumberRequired
WhatsApp Group IDRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Connected NumberRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Connected NumberRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Connected NumberRequired
Collection NameRequired
Product IDs to AddRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Connected NumberRequired
Collection IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Connected NumberRequired
Collection IDRequired
Product IDs to Add
Product IDs to Remove
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.From NumberRequired
Phone Number to CheckRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Connected NumberRequired
WhatsApp Group IDRequired
Text Message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To NumberRequired
From NumberRequired
Text MessageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Connected NumberRequired
WhatsApp StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Connected NumberRequired
Target NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appConnected NumberRequired
WhatsApp Group IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNo 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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
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
Headers
Overwrite existing worksheets
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
Text Bold
Text Italic
Text 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
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
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 2Chat
2Chat is a conversational commerce automation tool for WhatsApp, Instagram, Messenger, and SMS.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- Send whatsapp group messages in 2Chat for new or updated rows in Google Sheets
- Send whatsapp text messages in 2Chat for new spreadsheet rows in Google Sheets
- Log new 2Chat whatsapp messages as rows in Google Sheets
- Add rows to Google Sheets for new whatsapp messages in 2Chat
- Transform new 2Chat whatsapp messages into Google Sheets spreadsheets
- Create spreadsheet rows in Google Sheets when new whatsapp group messages are received in 2Chat
- Create spreadsheet columns in Google Sheets for new whatsapp messages in 2Chat
- Create multiple spreadsheet rows in Google Sheets when new whatsapp messages are received in 2Chat
- Create multiple Google Sheets rows for new whatsapp messages in 2Chat
- Track new 2Chat whatsapp conversations by creating rows in Google Sheets
- Send whatsapp group messages via 2Chat for new rows in Google Sheets
- Send whatsapp messages from 2Chat for new or updated rows in Google Sheets
- Create multiple rows in Google Sheets from new whatsapp conversations in 2Chat
- Log new whatsapp messages from 2Chat with custom actions in Google Sheets
- Create multiple rows in Google Sheets when new whatsapp group messages are received in 2Chat
- Transcribe new 2Chat whatsapp audio messages and create rows in Google Sheets
- Track new 2Chat group participants by creating rows in Google Sheets
- Clear Google Sheets rows for every new whatsapp message in 2Chat
Related Zap Templates
- Send whatsapp group messages in 2Chat for new or updated rows in Google Sheets
- Add rows to Google Sheets for new whatsapp messages in 2Chat
- Create spreadsheet columns in Google Sheets for new whatsapp messages in 2Chat
- Track new 2Chat whatsapp conversations by creating rows in Google Sheets
- Create multiple rows in Google Sheets from new whatsapp conversations in 2Chat
- Send whatsapp text messages in 2Chat for new spreadsheet rows in Google Sheets
- Transform new 2Chat whatsapp messages into Google Sheets spreadsheets
- Create multiple spreadsheet rows in Google Sheets when new whatsapp messages are received in 2Chat
- Send whatsapp group messages via 2Chat for new rows in Google Sheets
- Log new whatsapp messages from 2Chat with custom actions in Google Sheets
- Log new 2Chat whatsapp messages as rows in Google Sheets
- Create spreadsheet rows in Google Sheets when new whatsapp group messages are received in 2Chat
- Create multiple Google Sheets rows for new whatsapp messages in 2Chat
- Send whatsapp messages from 2Chat for new or updated rows in Google Sheets
- Create multiple rows in Google Sheets when new whatsapp group messages are received in 2Chat