You can receive (Free!) and send WhatsApp Messages from Google AppSheet.
Receiving and sending messages on AppSheet is very simple. No account/registrations is required. Just follow the instructions below.
SETUP
- Create an AppSheet Database named “whatsapp” with the following columns:
- date -> datetime column
- from -> text column
- message -> text column

- Get your AppId and and create a new Application Access Key on AppSheet

- Configure your AppId and Access Key into Inout.bot
- Send “Setup AppSheet” to the InOut.bot phone number (+12343322110)
- Answer the questions from the chatbot

How to receive a WhatsApp Message in AppSheet?
Every time that you send a WhatsApp Text Message to InOut.bot Number (+12343322110), the message will be saved into your AppSheet database. You can check the message received and trigger different actions based on the content.
How to send a WhatsApp Message in AppSheet?
- Copy the “AppSheet webhook” received during Setup
- Create a new Automation
- Configure the trigger (When this EVENT occurs) based on your needs
- Create a new Process
- Create a new “Call a Webhook” Step
- Paste the webhook received in step 1) into the “url” field
- Done. The message will be sent to your number from the InOut.bot WhatsApp Account

