Quick overview This workflow polls SAP Business One every 6 hours for active, unfrozen items whose on-hand quantity is below the minimum inventory level, then sends de-duplicated low-stock alerts via WhatsApp (Meta API) and email, storing the last-alerted quantity in an n8n Data Table to prevent repeated notifications. How it works Runs every 6 hours on a schedule. Logs in to SAP Business One Service Layer and queries the Items endpoint for valid, non-frozen items where QuantityOnStock is less than MinInventoryQuantity. Splits the SAP response into one item per record and skips the alert flow if no items are returned. Looks up each item’s previous alert state in an n8n Data Table and only continues if the item has never been alerted before or its stock has dropped further since the last alert. Formats a WhatsApp message and an HTML email (including an “out of stock” message when QuantityOnStock is 0). Sends the alert via the WhatsApp Business Cloud API (Meta Graph API) and via SMTP email, then upserts the latest alerted quantity to the Data Table. Logs out of SAP Business One.
Tags
Send EmailRelated workflows
See all Email Send→
Automated Property Lead Generation with BatchData and CRM Integration
How It Works This N8N workflow creates an automated system for discovering high-potential real estate investment opportunities. The workflow runs on a customizable schedule to scan the market for properties that match your specific criteria, then alerts your team about the most promising leads. The process follows these steps: Connects to BatchData API on a regular schedule to search for properties matching your parameters Compares new results with previous scans to identify new listings and property changes Applies intelligent filtering to focus on high-potential opportunities (high equity, absentee owners, etc.) Retrieves comprehensive property details and owner information for qualified leads Delivers formatted alerts through multiple channels (email and Slack/Teams) Each email alert includes detailed property information, owner details, equity percentage, and a direct Google Maps link to view the property location. The workflow also posts concise notifications to your team's communication channels for quick updates. Who It's For This workflow is designed for: Real Estate Investors: Find off-market properties with high equity and motivated sellers Real Estate Agents: Identify po
Automate Digital Delivery After PayPal Purchase Using n8n
Automate Digital Delivery After PayPal Purchase Using n8n A Complete Step-by-Step Guide to Seamless Template Delivery Built by Amjid Ali – SyncBricks Deliver personalized files instantly after PayPal transactions using n8n – without writing a single backend line. 🚀 What This n8n Workflow Does This automation template helps you automatically deliver a digital product (such as an n8n template or JSON file) to customers who pay via PayPal — within seconds. You can: Automatically extract customer info Identify what was purchased Send a clean, branded email with the product file Promote your other courses, books, and tools 📦 Use Case Example Product: AI-Powered Social Media Content Generator & Publisher When a customer buys this product through PayPal, this automation: Listens for a successful payment event Fetches order details via API Sends an HTML email with the template attached Promotes your other offerings with embedded links 🔧 Prerequisites You’ll need: An n8n instance (self-hosted or n8n Cloud) A PayPal developer account PayPal OAuth2 credentials configured in n8n Your product hosted as a downloadable .json file (Oracle, Dropbox, GitHub, etc.) SMTP email credentials in n8n 🧠
WReal-Time Security Threat Dashboard with Google Sheets, AI Risk Analysis & Email Alerts
👤 Who it’s for Blue Team leads, CISOs, and SOC managers who want automated visibility into threat metrics, endpoint alerts, and response actions — without needing a full SIEM or BI platform. Great for teams using Modules 1–5 and now ready to report, review, or share BlueOps data across stakeholders. ⚙️ How it works / What it does Fetches threat + response data from up to 5 Google Sheets Aggregates data into four key slices: summary_metrics: Total threats, actions, endpoints daily_trends: Time-based charting top_assets: High-risk endpoints or systems actions_taken: Logged IR activity Generates a clean HTML report and sends via email Logs report summary to a central reporting tracker sheet Optionally converts and stores PDF versions or links 🛠️ How to set up Google Sheets: Connect your live sheets from previous BlueOps modules (M1–M5) Email Setup: Insert sender credentials and recipient(s) Customize Your Charts: Edit the “📈 Format Charts” and “📋 Structure Report Body” nodes Trigger Options: Run weekly, monthly, or on-demand via Webhook/Cron Add PDF Generator (Optional): Use Puppeteer, HTML → PDF services, or internal scripts 📋 Requirements Google account with access to all BlueO