Templates / Send daily real estate construction updates via Gmail & WhatsApp with Google Sheets

Send daily real estate construction updates via Gmail & WhatsApp with Google Sheets

Ready for 3.0

by Oneclick AI Squad ✓ · 897 views · created 2025-07-30 · Project Management

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 10 nodes and runs on a schedule (every day at 08:00). Along the way it connects Google Sheets and WhatsApp Business Cloud.

How it runs

Trigger: On a schedule (every day at 08:00).

  1. Set Google Sheet Config (Edit Fields (Set)): sets 3 fields: Sheet_ID, Sheet_Name, Today_Date
  2. Read Google Sheet Data (Google Sheets): uses Google Sheets
  3. Filter: keeps only the items that match a condition
  4. Check If Reports Found (If): checks a condition and branches into true / false
  5. Set Notification Recipients (Edit Fields (Set)): sets 3 fields: Notification_Users, WhatsApp_Numbers, Admin_Email
  6. Create Notification Content (Edit Fields (Set)): sets 3 fields: Report_Summary, Email_Subject, WhatsApp_Message
  7. Send WhatsApp Notification (WhatsApp Business Cloud): send
  8. Send Email: sends an email over SMTP
  9. Log Successful Notifications (Edit Fields (Set)): sets 3 fields: Success_Log, Log_Status, Projects_Reported

Services it uses

Google SheetsWhatsApp Business Cloud

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (7)

From the author

This n8n template demonstrates how to create an automated construction progress notification system for real estate companies. The workflow triggers daily at 8:00 AM IST to check a Google Sheet for contractor construction reports, automatically processes the…

Excerpt from Oneclick AI Squad's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.