Send an approved WhatsApp template message to every new lead you add to a Google Sheet, using the official WhatsApp Business API through TimelinesAI. **How it works** Step 1: Google Sheets checks your Leads sheet every 15 minutes for new rows that have a phone number and have not been messaged yet. Step 2: TimelinesAI sends your approved WhatsApp template to that number. Step 3: The row is updated with the status, the chat ID and the time. If sending fails, the row is marked Failed with the error message. **What you need** • A TimelinesAI account with a WhatsApp Business API (WABA) number and an approved message template • A Google account and a Leads sheet with the phone number in column B • A TimelinesAI API token for the HTTP step **Before you turn it on** In the HTTP step, set your waba_account_id, your approved template name and its language. [New to TimelinesAI? Connect your WhatsApp number and start your free trial →](https://timelines.ai/whatsapp-make-integration?utm_source=make&utm_medium=template&utm_campaign=sheets-waba-template)
This is a predefined template that will make the creation of your scenario much easier. Of course, you can always expand and customize the scenario to meet your own individual needs.
Google Sheets
HTTP