WhatsApp Business Cloud workflows
4 results — all source-linked n8n references
Follow up on abandoned carts with WhatsApp and Google Sheets
Quick overview This workflow runs every hour to read abandoned cart rows from Google Sheets, sends a WhatsApp reminder (with a discount for high-value carts), and then updates the sheet to log the follow-up count and timestamp. How it works Runs every hour on a schedule trigger. Loads configuration values (sheet details, WhatsApp phone number ID, value threshold, discount settings, and follow-up rules). Fetches cart records from a Google Sheets worksheet. Filters to carts abandoned before the configured cutoff, not marked as purchased, and still under the maximum follow-up count. Sends a WhatsApp message via WhatsApp Business Cloud with a discount offer for carts above the high-value threshold, or a plain reminder for lower-value carts. Updates the matching row in Google Sheets to increment the follow_up_count and set last_follow_up_at to the current timestamp. Setup Add Google Sheets OAuth2 credentials and set the Google Sheet ID and sheet name in the configuration values. Add WhatsApp Business Cloud credentials and set your WhatsApp phone number ID in the configuration values. Ensure your Google Sheet includes the required columns: row_id, customer_name, phone_number, cart_value,
Send WhatsApp booking links for Facebook leads with Sheets, Redis, and Cal.com
Quick overview Youtube Video: https://youtu.be/2yB1Imaa6AY?si=FAY4YCeSqqnxCdgW This workflow captures new Facebook Lead Ads leads, stores or updates them in Google Sheets, generates a personalized Cal.com booking link, and sends it via WhatsApp, while also logging the outreach session to Redis and marking the lead as contacted. How it works Triggers when a new lead is submitted through Facebook Lead Ads. Looks up the lead in Google Sheets by phone number to see if an existing row is present. Appends or updates the lead record in Google Sheets when the row does not exist, otherwise checks whether the lead is already marked as contacted or set to do-not-disturb. Prepares a Cal.com base booking link for the selected property and builds an autofilled booking URL using the lead’s name, email, and phone. Sends the lead a WhatsApp message containing the personalized Cal.com booking link. Stores the outbound message as a session entry in Redis and updates Google Sheets to mark the lead as contacted. Setup Connect your Facebook Lead Ads OAuth credentials and select the target Facebook Page and Lead Form in the trigger. Add Google Sheets credentials (service account or OAuth) and update the
Send daily appointment reminders from Google Sheets to WhatsApp
Quick overview This workflow runs daily to read appointment bookings from Google Sheets, filter for tomorrow’s appointments that have not been reminded yet, send each client a WhatsApp reminder message, and then update the sheet to mark the reminder as sent. How it works Runs every day at 9 AM on a schedule. Sets the Google Sheet ID, sheet tab name, WhatsApp phone number ID, and calculates tomorrow’s date. Reads all appointment rows from the specified Google Sheets tab. Filters to appointments where the appointment_date is tomorrow and reminder_sent is not true. Sends a WhatsApp message to each remaining client using their phone_number and appointment details. Updates the corresponding Google Sheets row (matched by row_id) to set reminder_sent to true. Setup Add Google Sheets OAuth credentials and set the target spreadsheet ID and sheet/tab name in the configuration values. Add WhatsApp Business Cloud (WhatsApp) credentials and set your WhatsApp phone number ID used to send messages. Ensure your Google Sheet includes the columns row_id (unique), client_name, phone_number, service, appointment_time, appointment_date (yyyy-MM-dd), and reminder_sent (boolean).
🚀 Boost your customer service with this WhatsApp Business bot!
This n8n workflow demonstrates how to automate customer interactions and appointment management via WhatsApp Business bot. After submitting a Google Form, the user receives a notification via WhatsApp. These notifications are sent via a template message. In case user sends a message to the bot, the text and user data is stored in Google Sheets. To reply back to the user, fill in the ReplyText column and change the Status to 'Ready'. In a few seconds n8n will fetch the unsent replies and deliver them one by one via WhatsApp Business node. Customize this workflow to fit your specific needs, connect different online services and enhance your customer communication! 🎉 Setup Instructions To get this workflow up and running, you'll need to: 👇 Create a WhatsApp template message on the Meta Business portal. Obtain an Access Token and WhatsApp Business Account ID from the Meta Developers Portal. This is needed for the WhatsApp Business Node to send messages. Set up a WhatsApp Trigger node with App ID and App Secret from the Meta Developers Portal. Right after that copy the WhatsApp Trigger URL and add it as a Callback URL in the Meta Developers Portal. This trigger is needed to receive in