HumationHuman + Automation
Back to Catalog

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

Oneclick AI SquadOneclick AI Squad
649 views
2/3/2026
Web ScrapingLead GenerationContact EnrichmentEmail ExtractionLinkedIn
Official Page

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 data, and sends comprehensive project updates to buyers via email and WhatsApp. Perfect for real estate developers wanting to maintain transparent communication with buyers and ensure timely project status updates.

Good to know

  • Daily automated monitoring ensures no construction updates are missed
  • Multi-channel communication (Email + WhatsApp) reaches buyers through their preferred method
  • Smart filtering system only processes today's reports for relevant updates
  • Comprehensive logging tracks all notification activities for audit purposes
  • Built-in alert system notifies administrators when contractors fail to submit reports
  • Handles multiple projects and contractors simultaneously without data conflicts

How it works

Daily Monitoring Workflow

  • System triggers automatically every day at 8:00 AM IST to check for new construction reports
  • Google Sheet configuration is set with Sheet ID, sheet name, and today's date for filtering
  • All construction data is read from the designated Google Sheet containing contractor submissions
  • Advanced filtering isolates only today's reports based on the Date column for processing

Report Processing Workflow

  • System checks if any construction reports were submitted for the current date
  • If reports are found: Detailed notifications are prepared and sent to all registered buyers
  • If no reports are found: Alert notifications are sent to administrators about missing submissions
  • All project data is compiled into comprehensive summaries with progress percentages and status updates

Notification Distribution Workflow

  • Email notifications contain detailed construction summaries with all project information
  • WhatsApp messages provide concise updates with key progress indicators and status
  • Messages are personalized with project names, completion percentages, and contractor details
  • Multiple recipients receive notifications simultaneously through both communication channels

Activity Logging Workflow

  • All notification activities are logged with precise timestamps and recipient information
  • Success logs record project count, recipient numbers, and delivery confirmation
  • Warning logs capture instances when no reports are found for administrative follow-up
  • Complete audit trail maintains compliance and tracking for project management

Google Sheet Structure

Construction Reports Sheet

  • Date - Report submission date (DD/MM/YYYY format)
  • Project_Name - Name of the construction project
  • Contractor_Name - Name of the responsible contractor
  • Location - Project location or site address
  • Progress_Percentage - Current completion percentage (0-100%)
  • Status - Current project status (On Track, Delayed, Completed, etc.)
  • Work_Description - Detailed description of today's construction activities
  • Issues - Any problems or challenges encountered (optional)
  • Budget_Status - Financial status update (On Budget, Over Budget, Under Budget)
  • Next_Milestone - Upcoming project milestone or target date

How to use

  • Import the workflow into your n8n instance and configure Google Sheets integration
  • Set up your Google Sheet with the required column structure for construction reports
  • Configure email SMTP settings for professional construction update delivery
  • Set up WhatsApp Business API for instant mobile notifications to buyers
  • Add buyer email addresses and WhatsApp numbers to the notification recipient lists
  • Contractors submit daily reports to the Google Sheet before 8:00 AM for same-day processing
  • System automatically processes and distributes updates to all registered buyers
  • Monitor logs for delivery confirmation and missing report alerts

Requirements

  • Google Sheets account for construction report data storage and management
  • Email service integration (Gmail, SMTP, or corporate email system)
  • WhatsApp Business API account for mobile messaging capabilities
  • n8n instance with Google Sheets, Email, and WhatsApp connectors properly configured
  • Valid credentials for all integrated services (Google OAuth, SMTP, WhatsApp API)

Customising this workflow

  • Construction update automation can be adapted for different project types and development scales
  • Try popular use-cases such as weekly progress summaries, milestone notifications, or emergency construction alerts
  • The workflow can be extended to include photo attachments from construction sites, weather impact assessments, and safety compliance reporting
  • Integration possibilities include CRM systems for buyer management, project management tools for contractor coordination, and financial systems for budget tracking
  • Notification scheduling can be adjusted for different time zones, multiple daily updates, or project-specific timing requirements
  • Advanced features can include buyer feedback collection, contractor performance ratings, and automated delay notifications with mitigation plans

n8n Workflow: Daily Real Estate & Construction Updates via Email & WhatsApp

This n8n workflow automates the process of sending daily real estate and construction updates to a list of recipients via both Email and WhatsApp, based on data retrieved from a Google Sheet. It allows for conditional messaging, ensuring updates are only sent when specific criteria are met.

What it does

This workflow simplifies and automates the delivery of daily updates by:

  1. Scheduling Daily Execution: The workflow is triggered to run automatically at a set interval (e.g., daily).
  2. Fetching Data from Google Sheets: It retrieves a list of real estate and construction updates, along with recipient information, from a specified Google Sheet.
  3. Filtering for Relevant Updates: It filters the retrieved data, likely to only process updates that meet certain criteria (e.g., new updates, updates marked for today, etc.).
  4. Preparing Data for Messaging: It processes and formats the data to be suitable for sending via both email and WhatsApp.
  5. Conditional Email Sending: It checks if an email should be sent for each update. If the condition is met, it sends an email with the relevant update details.
  6. Conditional WhatsApp Message Sending: It checks if a WhatsApp message should be sent for each update. If the condition is met, it sends a WhatsApp message with the relevant update details.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running instance of n8n.
  • Google Sheets Account: Configured with the necessary credentials to read data from your specified spreadsheet.
  • Email Sending Service: Configured with SMTP credentials or a similar email service for sending emails.
  • WhatsApp Business Cloud Account: Configured with the necessary credentials to send messages via the WhatsApp Business API.

Setup/Usage

  1. Import the workflow: Import the provided JSON into your n8n instance.
  2. Configure Credentials:
    • Google Sheets: Set up your Google Sheets credential to access the spreadsheet containing your daily updates and recipient information.
    • Send Email: Configure your email sending credentials (e.g., SMTP).
    • WhatsApp Business Cloud: Set up your WhatsApp Business Cloud credentials.
  3. Customize Google Sheets Node:
    • Specify the Spreadsheet ID and Sheet Name from which to read the updates.
    • Ensure the sheet contains columns for update content, recipient email addresses, WhatsApp numbers, and any other data used for filtering.
  4. Customize Filter Node (ID: 844):
    • Adjust the conditions to filter updates based on your specific requirements (e.g., a "Send Today" column set to TRUE, a date matching the current date, etc.).
  5. Customize Edit Fields (Set) Node (ID: 38):
    • Map the incoming data from Google Sheets to the desired fields for your email and WhatsApp messages. This node is crucial for formatting the data correctly before sending.
  6. Customize Send Email Node (ID: 11):
    • Define the To address using an expression from your Google Sheet data (e.g., {{$json.email}}).
    • Set the Subject and Body of the email, using expressions to dynamically insert update details (e.g., {{$json.updateTitle}}, {{$json.updateContent}}).
  7. Customize WhatsApp Business Cloud Node (ID: 827):
    • Define the To number using an expression from your Google Sheet data (e.g., {{$json.whatsappNumber}}).
    • Configure the message template or content to be sent, using expressions for dynamic data.
  8. Customize Schedule Trigger Node (ID: 839):
    • Set the desired schedule for the workflow to run (e.g., daily at a specific time).
  9. Activate the workflow: Once configured, activate the workflow to start sending daily updates automatically.

Related Templates

Synchronizing WooCommerce inventory and creating products with Google Gemini AI and BrowserAct

Synchronize WooCommerce Inventory & Create Products with Gemini AI & BrowserAct This sophisticated n8n template automates WooCommerce inventory management by scraping supplier data, updating existing products, and intelligently creating new ones with AI-formatted descriptions. This workflow is essential for e-commerce operators, dropshippers, and inventory managers who need to ensure their product pricing and stock levels are synchronized with multiple third-party suppliers, minimizing overselling and maximizing profit. --- Self-Hosted Only This Workflow uses a community contribution and is designed and tested for self-hosted n8n instances only. --- How it works The workflow is typically run by a Schedule Trigger (though a Manual Trigger is also shown) to check stock automatically. It reads a list of suppliers and their inventory page URLs from a central Google Sheet. The workflow loops through each supplier: A BrowserAct node scrapes the current stock and price data from the supplier's inventory page. A Code node parses this bulk data into individual product items. It then loops through each individual product found. The workflow checks WooCommerce to see if the product already exists based on its name. If the product exists: It proceeds to update the existing product's price and stock quantity. If the product DOES NOT exist: An If node checks if the missing product's category matches a predefined type (optional filtering). If it passes the filter, a second BrowserAct workflow scrapes detailed product attributes from a dedicated product page (e.g., DigiKey). An AI Agent (Gemini) transforms these attributes into a specific, styled HTML table for the product description. Finally, the product is created in WooCommerce with all scraped details and the AI-generated description. Error Handling: Multiple Slack nodes are configured to alert your team immediately if any scraping task fails or if the product update/creation process encounters an issue. Note: This workflow does not support image uploads for new products. To enable this functionality, you must modify both the n8n and BrowserAct workflows. --- Requirements BrowserAct API account for web scraping BrowserAct n8n Community Node -> (n8n Nodes BrowserAct) BrowserAct templates named “WooCommerce Inventory & Stock Synchronization” and “WooCommerce Product Data Reconciliation” Google Sheets credentials for the supplier list WooCommerce credentials for product management Google Gemini account for the AI Agent Slack credentials for error alerts --- Need Help? How to Find Your BrowseAct API Key & Workflow ID How to Connect n8n to Browseract How to Use & Customize BrowserAct Templates How to Use the BrowserAct N8N Community Node --- Workflow Guidance and Showcase STOP Overselling! Auto-Sync WooCommerce Inventory from ANY Supplier

Madame AI Team | KaiBy Madame AI Team | Kai
600

Send WooCommerce discount coupons to customers via WhatsApp using Rapiwa API

Who is this for? This workflow is ideal for WooCommerce store owners who want to automatically send promotional WhatsApp messages to their customers when new coupons are created. It’s designed for marketers and eCommerce managers looking to boost engagement, streamline coupon sharing, and track campaign performance effortlessly through Google Sheets. Overview This workflow listens for WooCommerce coupon creation events (coupon.created) and uses customer billing data to send promotional WhatsApp messages via the Rapiwa API. The flow formats the coupon data, cleans phone numbers, verifies WhatsApp registration with Rapiwa, sends the promotional message when verified, and logs each attempt to Google Sheets (separate sheets for verified/sent and unverified/not sent). What this Workflow Does Listens for new coupon creation events in WooCommerce via the WooCommerce Trigger node Retrieves all customer data from the WooCommerce store Processes customers in batches to control throughput Cleans and formats customer phone numbers for WhatsApp Verifies if phone numbers are valid WhatsApp accounts using Rapiwa API Sends personalized WhatsApp messages with coupon details to verified numbers Logs all activities to Google Sheets for tracking and analysis Handles both verified and unverified numbers appropriately Key Features Automated coupon distribution: Triggers when new coupons are created in WooCommerce Customer data retrieval: Fetches all customer information from WooCommerce Phone number validation: Verifies WhatsApp numbers before sending messages Personalized messaging: Includes customer name and coupon details in messages Dual logging system: Tracks both successful and failed message attempts Rate limiting: Uses batching and wait nodes to prevent API overload Data formatting: Structures coupon information for consistent messaging Google Sheet Column Structure A Google Sheet formatted like this ➤ sample The workflow uses a Google Sheet with the following columns to track coupon distribution: | name | number | email | address1 | couponCode | couponTitle | couponType | couponAmount | createDate | expireDate | validity | status | | ----------- | ------------- | --------------------------------------------------- | --------- | ---------- | -------------- | ---------- | ------------ | ------------------- | ------------------- | ---------- | -------- | | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur-DOHS | 62dhryst | eid offer 2025 | percent | 20.00 | 2025-09-11 06:08:02 | 2025-09-15 00:00:00 | unverified | not sent | | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur-DOHS | 62dhryst | eid offer 2025 | percent | 20.00 | 2025-09-11 06:08:02 | 2025-09-15 00:00:00 | verified | sent | Requirements n8n instance with the following nodes: WooCommerce Trigger, Code, SplitInBatches, HTTP Request, IF, Google Sheets, Wait WooCommerce store with API access Rapiwa account with API access for WhatsApp verification and messaging Google account with Sheets access Customer phone numbers in WooCommerce (stored in billing.phone field) Important Notes Phone Number Format: The workflow cleans phone numbers by removing all non-digit characters. Ensure your WooCommerce phone numbers are in a compatible format. API Rate Limits: Rapiwa and WooCommerce APIs have rate limits. Adjust batch sizes and wait times accordingly. Data Privacy: Ensure compliance with data protection regulations when sending marketing messages. Error Handling: The workflow logs unverified numbers but doesn't have extensive error handling. Consider adding error notifications for failed API calls. Message Content: The current message template references the first coupon only (coupons[0]). Adjust if you need to handle multiple coupons. Useful Links Dashboard: https://app.rapiwa.com Official Website: https://rapiwa.com Documentation: https://docs.rapiwa.com Support & Help WhatsApp: Chat on WhatsApp Discord: SpaGreen Community Facebook Group: SpaGreen Support Website: https://spagreen.net Developer Portfolio: Codecanyon SpaGreen

RapiwaBy Rapiwa
110

Generate viral Instagram scripts by analyzing trending reels with Apify and GPT-4

This n8n template demonstrates how to leverage AI to analyze trending short-form video content and automatically generate original, high-engagement video scripts inspired by proven viral formats. Use cases are many: Create consistent content calendars for beauty salons and aestheticians, maintain a steady stream of reels without creative burnout, or study viral patterns to understand what drives engagement across Instagram's trending hashtags! Good to know The workflow scrapes real trending reels from Instagram based on your chosen hashtag, ensuring you're always learning from current viral patterns Video transcription happens automatically, extracting the core messaging and pacing strategies from successful content Generated scripts use proven engagement structures—hook, value delivery, and call-to-action timing—without copying original content All data is organized in Google Sheets for easy review, editing, and tracking of script performance The AI model intelligently mirrors the emotional tone and narrative structure while creating entirely new storylines How it works A form trigger collects your hashtag and desired number of reels to analyze The Apify API scrapes trending Instagram reels matching your hashtag, filtering for high engagement (1000+ likes from the last 7 days) Filtered reels are added to your Google Sheet with metadata: captions, engagement metrics, video links, and music information Each reel is automatically transcribed using video-to-text technology, capturing the exact dialogue and timing The AI Agent analyzes each transcript to understand its underlying structure—pacing, tone, curiosity hooks, and CTA placement Using this analysis, Claude generates a completely original script that follows the same proven engagement formula but with a fresh topic or angle Generated scripts are saved back to your Google Sheet alongside the source materials for comparison and refinement A summary email is sent confirming the number of scripts created and ready for production How to use Start by entering a beauty or lifestyle hashtag (e.g., aiautomation, beautysalon, haircare) and specify how many trending reels to analyze Review the scraped content in your Google Sheet to understand what's currently resonating Check the generated scripts and use them as jumping-off points for your own video production Iterate on the process with different hashtags to discover emerging trends in your niche Requirements Apify account and API key for Instagram scraping (free tier available) Google Sheets document set up to store reel data and generated scripts OpenAI API key for the AI script generation Gmail account for the completion notification (optional but recommended) Customising this workflow Adjust the engagement filter thresholds (currently 1000+ likes, 7 days old) to capture micro-trends or evergreen content Modify the AI prompt in the "AI Agent" node to enforce specific brand voice, tone, or content guidelines Add additional Google Sheet columns to track metrics like script-to-video conversion rates or audience response Connect to additional distribution channels—automatically post scripts to team Slack, create video production briefs, or trigger video editing templates Experiment with different video categories by creating multiple instances of this workflow for different hashtags or niches

Nitin DixitBy Nitin Dixit
1097