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 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
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
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 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 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
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
About 2Chat
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Send whatsapp group messages in 2Chat for new or updated rows in Google Sheets
- Create multiple Google Sheets rows for new whatsapp messages in 2Chat
- 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
- Track new 2Chat whatsapp conversations by creating rows in Google Sheets
- Send whatsapp text messages in 2Chat for new spreadsheet 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
- Send a whatsapp message via 2Chat for every new spreadsheet row in Google Sheets
- Track removed 2Chat participants by creating rows in Google Sheets
- Track 2Chat participants leaving a whatsapp group by creating a row in Google Sheets
- "create Google Sheets rows from new whatsapp messages received in 2Chat"
- Send a whatsapp group message in 2Chat for new or updated rows in Google Sheets team drive
- Create multiple Google Sheets rows when new participants join a whatsapp group in 2Chat
- Clear Google Sheets rows when new whatsapp group messages are received in 2Chat
- Log new 2Chat whatsapp calls as rows in Google Sheets
- "copy new whatsapp messages received in 2Chat to Google Sheets worksheets"
- Create Google Sheets columns every time new participants join a whatsapp group 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
- Send whatsapp text messages in 2Chat for new spreadsheet rows in Google Sheets
- Create multiple rows in Google Sheets from new whatsapp conversations in 2Chat
- Transcribe new 2Chat whatsapp audio messages and create rows in Google Sheets
- Send a whatsapp message via 2Chat for every new spreadsheet row in Google Sheets
- "create Google Sheets rows from new whatsapp messages received in 2Chat"
- Clear Google Sheets rows when new whatsapp group messages are received in 2Chat
- Create Google Sheets columns every time new participants join a whatsapp group in 2Chat
- Create multiple Google Sheets rows for new whatsapp messages in 2Chat
- 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
- Track new 2Chat whatsapp conversations by creating rows in Google Sheets
- 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
- Clear Google Sheets rows for every new whatsapp message in 2Chat
- Track 2Chat participants leaving a whatsapp group by creating a row in Google Sheets
- Create multiple Google Sheets rows when new participants join a whatsapp group in 2Chat
- "copy new whatsapp messages received in 2Chat to Google Sheets worksheets"