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

Description

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