top of page
Search

Log sent replies to Google Sheets or a webhook in AutoResponder

  • Writer: Tim Kosmala
    Tim Kosmala
  • Jul 13
  • 3 min read

Updated: Jul 14

With the message output feature, AutoResponder keeps a record of every reply it sends. Each time a rule fires, the app can append a row to a Google Spreadsheet, send an HTTP POST request to your own server, or both — including rules that match without replying (###). Sending a log entry happens in the background and never delays or changes the reply itself.


Google Sheets and webhook output with AutoResponder

This gives you a live log of your bot's conversations: track which rules fire and how often, keep a record of customer requests, collect leads in a spreadsheet, or forward replies into your own systems like a CRM. It works with all supported messengers: WhatsApp, Facebook Messenger, Instagram, Telegram, Signal and Viber.


Setting the defaults for all rules


Open Settings → Message output. Here you find two switches — Google Sheets output and Webhook output — and everything you configure on this screen becomes the default for all rules.


Turn on the output you want to use and its settings appear below the switch. From now on, every rule logs its replies there. If you only want to log specific rules, or log different rules to different places, see Message output within a rule further down.


Google Sheets output


Every sent reply adds a new row to the bottom of your spreadsheet.


  1. Tap Connect Google Account. Message output needs edit access to Google Sheets, so accept the requested permission.

  2. Choose the right spreadsheet with the Google file picker.

  3. Optionally pick a tab name. If you leave it empty, the first tab is used.

  4. Define the columns: each field is one spreadsheet column (A, B, C…) and can contain any text and placeholders. Tap the tag icon to insert them.


The columns are pre-filled with a ready-to-use conversation log: the date and time, the chat name, the contact, the received message, the sent reply and the rule ID. You can add, remove and change columns however you like, and all the usual answer replacements are available — including your custom ones.


If you want to reply with values from Google Sheets, please check here.


Webhook output


The webhook output sends an HTTP POST request with a JSON body to your URL every time a rule sends a reply:


{
  "appPackageName": "tkstudio.autoresponderforwa",
  "messengerPackageName": "com.whatsapp",
  "timestamp": 1751791234567,
  "query": {
    "sender": "John Smith",
    "message": "How much is the price?",
    "reply": "Our service costs $9.99 per month.",
    "isGroup": false,
    "groupParticipant": "",
    "ruleId": 12,
    "isTestMessage": false
  }
}

If your server requires authentication, you can set Basic Auth credentials or add custom headers (one Key: Value pair per line), for example an API key.


Note the difference from the web server connection: the web server creates the reply and AutoResponder waits for its response, while the webhook output only reports the reply afterwards. Your server does not need to answer, and when the reply was suppressed with ###, the reply field is simply empty.


Message output within a rule


Every rule has its own Message output section (also available in the Tasker plugin). There you find a When to log selection for Google Sheets and for the webhook, each with three options:


  • Use global setting — the default: the rule follows the switches in Settings → Message output.

  • Always log — this rule logs even if the output is turned off globally.

  • Never log — this rule is excluded from logging.


When you select Always log, additional fields appear to override the defaults for this rule only: a different spreadsheet, tab or column layout, or a different webhook URL, auth and headers. Any field you leave empty falls back to the global setting. This way you can, for example, collect orders in one spreadsheet and support requests in another.


Good to know


  • You can only add spreadsheets manually if you have previously granted AutoResponder permission to access them with the Google file picker.

  • New rows are always appended to the bottom of the sheet — existing data is never overwritten.

  • The logged reply is the rule's plain reply text, without your global reply header and footer.

  • Test messages from the built-in test chat are logged too, marked with "isTestMessage": true in the webhook payload, so you can try everything safely.

bottom of page