Send a daily sales report to WhatsApp from Google Sheets with MoltFlow

How it works

Runs every day at 6 PM and reads sales data from Google Sheets Filters rows matching today's date and calculates total revenue, order count, and top product Sends a formatted sales summary to your WhatsApp via MoltFlow If no sales today, sends a "no sales" notification instead

Set up steps (~5 min)

Create a MoltFlow account at molt.waiflow.app and connect your WhatsApp Create a Google Sheet with columns: Date, Product, Amount, Customer Connect your Google Sheets OAuth2 credential in n8n Paste your Sheet URL in the Google Sheets node Set YOUR_SESSION_ID and YOUR_PHONE in the Build Report code node Add your MoltFlow API Key as Header Auth credential (header name: X-API-Key)

Prerequisites

MoltFlow account with active WhatsApp session Google Sheet with daily sales data (Date column in YYYY-MM-DD format) Google Sheets OAuth2 credential configured in n8n