Save WhatsApp conversations in Google Sheets in realtime

Log WhatsApp messages in Google Sheets when keywords are matched, using webhooks in 2Chat

Save WhatsApp conversations in Google Sheets in realtime

Registering WhatsApp conversations in Google Sheets for specific keywords can offer several benefits, particularly if you need to analyze, track, or organize the data. Here are some advantages of doing so:

  1. Brand and Reputation Management: Keyword tracking allows businesses to monitor mentions of their brand and products, helping them manage their reputation and respond to customer feedback and issues promptly.
  2. Competitor Analysis: Tracking keywords related to competitors enables organizations to gain insights into customer sentiment, market trends, and competitive strategies, aiding in decision-making.
  3. Customer Support and Feedback: By tracking keywords like "bugs" or "support," companies can enhance their customer support processes and address customer concerns more effectively.
  4. Campaign and Promotion Optimization: Marketers can track campaign-specific keywords to evaluate the effectiveness of their advertising efforts and make real-time adjustments to maximize results.
  5. Contest or promotions registration: Register customers for specific contests or offers when they send a message using a predefined keyword.

For this case, you must copy our Google Sheets template from this link and follow the instructions provided in the following video:

The Google Sheet uses Google Apps Script and a basic process to expose your sheet as a web application. If you follow the steps provided you will be able to:

  • Make a copy of this sheet to your own Google Drive
  • Enter the Apps Script console:
  • Deploy the script as a Web App
  • In the worksheet "Parameters", cell A2, enter the words the customer must send in the message to add a new record to the "Messages" worksheet. If you need more than one word, write them separated by commas.

Now you can send a WhatsApp message to your phone number and thanks to the integration with 2Chat you will get a row added for every message containing the keywords defined. Every record will have information like date and time, source phone number, and the sender's name and last name if the customer exists in your contacts.