2Chat + Google Sheets

"create Google Sheets rows from new whatsapp messages received in 2Chat"

Keep a permanent record of your WhatsApp messages from 2Chat in a Google Sheets spreadsheet. With this automation, whenever you receive a new message in 2Chat on WhatsApp, a new row will be created in your selected Google Sheets. This way, you can effortlessly maintain an organized log of all your conversations, enhancing your communication management.

When this happens...
WhatsApp Message Received
Triggers when a WhatsApp message is received on your 2Chat connected number.
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

- Connected NumberRequired
Trigger
Instant
Try It
- Connected NumberRequired
Trigger
Instant
Try It
- Connected NumberRequired
- WhatsApp Group IDRequired
Trigger
Instant
Try It
- Connected NumberRequired
- WhatsApp Group IDRequired
Trigger
Instant
Try It
- Connected NumberRequired
- Time PeriodRequired
Trigger
Instant
Try It

- First NameRequired
- Last Name
- Profile Picture URL
- Phone Number
- Email Address
Action
Write
- Connected NumberRequired
- Product NameRequired
- Default Image URLRequired
- Product Description
- Product Price
- Product Currency
- Hide Product
- Product URL
- Custom Product ID
Action
Write

- Connected NumberRequired
- Product IDRequired
Action
Write
- Connected NumberRequired
- Product IDRequired
- Product Name
- Default Image URL
- Product Description
- Product Price
- Hide Product
- Product URL
- Custom Product ID
Action
Write
- Connected NumberRequired
- WhatsApp Group IDRequired
- Media Public URLRequired
- Caption
Action
Write
- From NumberRequired
- To NumberRequired
- Media Public URLRequired
- Caption
Action
Write
- Connected NumberRequired
- Image Public URLRequired
Action
Write
- Connected NumberRequired
- Target NumberRequired
Action
Search
- Connected NumberRequired
Action
Search
- 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
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- First row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

- From NumberRequired
Trigger
Instant
Try It
- Connected NumberRequired
- WhatsApp Group IDRequired
Trigger
Instant
Try It
- Connected NumberRequired
- WhatsApp Group IDRequired
Trigger
Instant
Try It
- Connected NumberRequired
Trigger
Instant
Try It
- Connected NumberRequired
Trigger
Instant
Try It
- Connected NumberRequired
- Collection NameRequired
- Product IDs to AddRequired
Action
Write
- Connected NumberRequired
- Collection IDRequired
Action
Write
- Connected NumberRequired
- Collection IDRequired
- Product IDs to Add
- Product IDs to Remove
Action
Write
- From NumberRequired
- Phone Number to CheckRequired
Action
Write
- Connected NumberRequired
- WhatsApp Group IDRequired
- Text Message
Action
Write
- To NumberRequired
- From NumberRequired
- Text MessageRequired
Action
Write
- Connected NumberRequired
- WhatsApp StatusRequired
Action
Write
- Connected NumberRequired
- Target NumberRequired
Action
Search
- Connected NumberRequired
- WhatsApp Group 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 Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Apply standard error handling?Required
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
Action
Search or write

About 2Chat

2Chat is a conversational commerce automation tool for WhatsApp, Instagram, Messenger, and SMS.

Learn more

Related categories

eCommerce

About Google Sheets

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

Related categories

Similar apps

2Chat + Google Sheets

"create Google Sheets rows from new whatsapp messages received in 2Chat"

WhatsApp Call Received

WhatsApp Audio Message Transcribed

Participant Joined a WhatsApp Group

Participant Was Removed From a WhatsApp Group

New WhatsApp Conversation

Create Contact

Add WhatsApp Business Product

Delete WhatsApp Business Product

Edit WhatsApp Business Product

Send a WhatsApp Group Media Message

Send a WhatsApp Media Message

Set WhatsApp Profile Picture

Get WhatsApp Business Collections

Get WhatsApp Groups

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Create Spreadsheet

Clear Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

New WhatsApp Message

WhatsApp Group Message Received

Participant Left a WhatsApp Group

WhatsApp Message Received

WhatsApp Order Received

Add WhatsApp Business Collection

Delete WhatsApp Business Collection

Edit WhatsApp Business Collection

Check if a Phone Number Has WhatsApp

Send a WhatsApp Group Text Message

Send a WhatsApp Text Message

Set WhatsApp Status

Get WhatsApp Business Products

Get WhatsApp Group Participants

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Copy Worksheet

Create Worksheet

Delete Spreadsheet Row(s)

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

About 2Chat

Related categories

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

Related Zap Templates

Related Zap Templates