2Chat + Google Sheets

2Chat + Google Sheets integrations

Create new rows at the top of a Google Sheets document for every new whatsapp message in 2Chat

Ensure that you never miss important WhatsApp messages in the 2Chat app with this convenient workflow. Every time you receive a new WhatsApp message in 2Chat, a row will be swiftly created at the top of your preferred Google Sheets spreadsheet. This simplifies your message tracking process, allowing you to stay organised and keep essential communications at your fingertips.

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.
TriggerInstant
automatically do this!
Create Spreadsheet Row at TopCreates a new spreadsheet row at the top of a spreadsheet (after the header row).
ActionWrite

Start free with email

Start free with Google

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

More things you can do with 2Chat and Google Sheets

Discover other triggers and actions you can use with 2Chat and Google Sheets

- Virtual Number ID
  Required
Trigger
Instant
Try It
- Virtual Number ID
  Required
Trigger
Instant
Try It
- From Number
  Required
Trigger
Instant
Try It
- Connected Number
  Required
Trigger
Instant
Try It
- Connected Number
  Required
- WhatsApp Group ID
  Required
Trigger
Instant
Try It

- Connected Number
  Required
- WhatsApp Group ID
  Required
Trigger
Instant
Try It
- Connected Number
  Required
- Time Period
  Required
Trigger
Instant
Try It

- First Name
  Required
- Last Name
- Profile Picture URL
- Phone Number
- Email Address
Action
Write
- Connected Number
  Required
- Product Name
  Required
- Default Image URL
  Required
- Product Description
- Product Price
- Product Currency
- Hide Product
- Product URL
- Custom Product ID
Action
Write
- Connected Number
  Required
- Product ID
  Required
Action
Write
- Connected Number
  Required
- Product ID
  Required
- Product Name
- Default Image URL
- Product Description
- Product Price
- Hide Product
- Product URL
- Custom Product ID
Action
Write
- Connected Number
  Required
- WhatsApp Group ID
  Required
- Media Public URL
  Required
- Caption
Action
Write
- From Number
  Required
- To Number
  Required
- Media Public URL
  Required
- Caption
Action
Write
- Connected Number
  Required
- Image Public URL
  Required
Action
Write
- Connected Number
  Required
- WhatsApp Status
  Required
Action
Write
- Connected Number
  Required
- Video Public URL
  Required
Action
Write
- Connected Number
  Required
- Target Number
  Required
Action
Search
- Connected Number
  Required
- WhatsApp Group ID
  Required
Action
Search
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write

- Virtual Number ID
  Required
Trigger
Instant
Try It
- Connected Number
  Required
Trigger
Instant
Try It
- Connected Number
  Required
Trigger
Instant
Try It
- Connected Number
  Required
- WhatsApp Group ID
  Required
Trigger
Instant
Try It
- Connected Number
  Required
- WhatsApp Group ID
  Required
Trigger
Instant
Try It
- Connected Number
  Required
Trigger
Instant
Try It
- Connected Number
  Required
Trigger
Instant
Try It
- Connected Number
  Required
- Collection Name
  Required
- Product IDs to Add
  Required
Action
Write
- Connected Number
  Required
- Collection ID
  Required
Action
Write
- Connected Number
  Required
- Collection ID
  Required
- Product IDs to Add
- Product IDs to Remove
Action
Write
- From Number
  Required
- Phone Number to Check
  Required
Action
Write
- Connected Number
  Required
- WhatsApp Group ID
  Required
- Text Message
Action
Write
- To Number
  Required
- From Number
  Required
- Text Message
  Required
Action
Write
- Connected Number
  Required
- Image Public URL
  Required
Action
Write
- Connected Number
  Required
- Text Status
  Required
- Background Color
  Required
- Font Size
  Required
Action
Write
- Connected Number
  Required
- Target Number
  Required
Action
Search
- Connected Number
  Required
Action
Search
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write
- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

About 2Chat

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

Learn moreLearn moreHelpHelp

Related categories

eCommerce

About Google Sheets

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

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

2Chat + Google Sheets

2Chat + Google Sheets

Create new rows at the top of a Google Sheets document for every new whatsapp message in 2Chat

More things you can do with 2Chat and Google Sheets

Related Zap Templates

Related Zap Templates