InOut.bot

the simplest WhatsApp Official API

WhatsApp with AppSheet

You can receive (Free!) and send WhatsApp Messages from Google AppSheet.

SETUP

  1. Create an AppSheet Database named “whatsapp” with the following columns:
    • date -> datetime column
    • from -> text column
    • message -> text column
Note: Respect the names “whatsapp”, “date”, “from” and “message”
  1. Get your AppId and and create a new Application Access Key on AppSheet
  1. 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?

    1. Copy the “AppSheet webhook” received during Setup
    2. Create a new Automation
    3. Configure the trigger (When this EVENT occurs) based on your needs
    4. Create a new Process
    5. Create a new “Call a Webhook” Step
    6. Paste the webhook received in step 1) into the “url” field
    7. Done. The message will be sent to your number from the InOut.bot WhatsApp Account