Code Workflows
1.006 Ergebnisse — ausschließlich quellenverknüpfte n8n-Referenzen
Triage and retry failed workflow executions with Anthropic, Jira and OpenTelemetry
Quick overview This workflow triggers on n8n execution errors, uses Anthropic (Claude) to classify the failure as transient or logic, and then either retries the failed execution via the n8n API with exponential backoff or creates a Jira issue, while also sending incident telemetry to an OpenTelemetry collector. How it works Triggers automatically when an n8n workflow execution errors. Extracts key telemetry like workflow name, failing node, error message/stack, execution URL, and any detected HTTP status code. Sends the error context to Anthropic (Claude) to return structured JSON with a category, confidence, and remediation guidance. Combines the AI diagnostics with telemetry and tracks a per-incident retry counter (up to three attempts) to decide if the failure is eligible for automated retry. If the error is transient with sufficient confidence and retry budget remains, waits using exponential backoff and calls the n8n API to retry the failed execution, then records the retry outcome. If the error is not retry-eligible (or the retry budget is exhausted), creates a Jira issue with the diagnostics, execution link, and failure details. Posts an OpenTelemetry trace span to your col
Monitor target account funding, acquisitions, and exec moves with Datahyena and Slack
Quick overview This workflow runs every morning and checks Datahyena for funding events, acquisitions, and executive moves from the last 24 hours, then posts matching updates for your target account domains to a Slack channel. How it works Runs every day at 9:00 AM. Loads a list of target company domains to monitor. Fetches the last 24 hours of funding events from the Datahyena API, filters to events where the company domain matches your target list, and posts each match to Slack. Fetches the last 24 hours of acquisition events from the Datahyena API, filters to deals where either the acquirer or target domain matches your list, and posts each match to Slack. Fetches the last 24 hours of executive move events from the Datahyena API, filters to moves where the current or previous company domain matches your list, and posts each match to Slack. Setup Create a Datahyena API key and configure an HTTP Header Auth credential with header name X-API-Key for the three Datahyena HTTP requests. Update the target domain list in the workflow’s target accounts step (the domains array). Connect your Slack credential and select the channel for the three Slack message steps.
Monitor AI search citations and competitors with OpenAI, Google Sheets, and Gmail
Quick overview This workflow runs weekly to test whether fairyfrills.in is cited in OpenAI answers to 15 shopping queries, logs citation details to Google Sheets, and emails a weekly HTML visibility report via Gmail, with optional Slack alerts on workflow errors. How it works Runs once a week on a schedule and generates 15 predefined shopping queries along with the target domain, brand name, and competitor domains. Sends each query to two OpenAI models in parallel: gpt-4o-mini (no browsing) and gpt-4o-search-preview (web search with URLs). Splits the two AI answers into separate items per platform and uses OpenAI to extract citation data (target-domain URLs, competitor citations, citation position, and totals) as structured JSON. Parses the extracted citation JSON, formats key fields (including URL lists, counts, and a response preview), and appends one log row per query and platform to a Google Sheets “Citation Log” sheet. After the final query (ID 15) completes, fetches the logged results from Google Sheets, calculates weekly citation metrics and breakdowns, and generates an HTML report. Sends the weekly citation report email through Gmail to the configured recipient. If any node
Monitor AI brand visibility and GEO gaps with OpenAI, Gmail and Slack
Quick Overview This workflow runs daily to test whether Fairy Frills appears in AI shopping recommendations by querying OpenAI with 10 brand-focused questions (with and without web search), extracting mention and competitor data, generating a GEO gap analysis, and emailing a consolidated HTML report via Gmail. How it works Runs every 24 hours on a schedule. Generates 10 predefined shopping queries for Fairy Frills and includes the brand URL and a competitor list with each query. Sends each query to OpenAI twice in parallel, once to gpt-4o-mini (no search) and once to gpt-4o-search-preview (web search enabled). Combines the two model responses per query and uses OpenAI to extract structured metrics such as whether Fairy Frills is mentioned, mention count and position, competitor mentions, sentiment, and a key snippet. Uses OpenAI again to perform a GEO (Generative Engine Optimization) gap analysis that explains why competitors ranked, why the target brand missed, and which content actions and exact phrases to add. Deduplicates and aggregates insights across all checks, builds an HTML summary, and sends the daily GEO report email via Gmail. Sends a Slack message when the workflow enc
Capture and route real estate leads with Google Sheets, Gmail, and Slack
Quick overview This workflow captures real estate property inquiries via a webhook, validates and normalizes lead details, upserts the lead into Google Sheets, sends an auto-reply through Gmail, and notifies your team in Slack, with separate handling for high-priority leads and workflow failure alerts. How it works Receives a website property inquiry via a POST webhook. Extracts the lead fields (name, email, phone, property ID, message, source, and timestamp) and rejects invalid submissions with a 400 JSON response explaining what’s missing. Normalizes the lead data by lowercasing the email address and stripping non-numeric characters from the phone number. Classifies the inquiry as high or standard priority based on keywords found in the message and property text. Appends or updates the lead in a Google Sheets CRM table, matching on email to avoid duplicates. Sends a Gmail auto-reply and posts a Slack notification, routing high-priority leads to a senior-agent message and standard leads to the general team. Returns a JSON confirmation to the webhook caller and posts a Slack alert if the workflow errors. Setup Copy the webhook URL from the trigger and configure your website form/ap
Predict sprint slip risk in Jira with OpenAI via OpenRouter and Slack alerts
Quick Overview This workflow runs on a weekday morning schedule (or manually) to pull the active Jira sprint and its issues, compute sprint health metrics, use an OpenRouter-hosted OpenAI model to assess slip risk, and post a motivating alert to a Slack channel when the sprint is behind. How it works Runs every weekday at 08:00 (or when executed manually). Calls the Jira Software Cloud Agile API to fetch the board’s active sprint and all issues in that sprint, including status, labels, and story points. Calculates sprint timing, completion percentage, slip margin, velocity gap, and a list of potentially blocked issues based on labels or status. Sends the computed metrics to an OpenRouter (OpenAI) chat model to return a structured JSON risk assessment (on_track, at_risk, or critical) with recommendations and tickets to watch. Parses the model output into JSON and merges it with the computed sprint metrics for reporting. If the risk level is not on_track, a second OpenRouter (OpenAI) agent drafts a team-focused status update and posts it to the configured Slack channel. If the risk level is on_track (or parsing fails and defaults to on_track), the workflow ends without posting to Sla
WCreate studio-quality car listing photos using Google Drive and Gemini 2.5
Quick overview This workflow manually processes car photos from Google Drive, sends each image plus a studio backdrop and logo to the Google Gemini Image API for background replacement and license-plate branding, and uploads the generated studio-style images back to an output Google Drive folder. How it works Runs when you manually execute the workflow. Lists all image files in a specified Google Drive input folder and processes them one at a time. Downloads the current car photo and also lists and downloads the studio asset images (virtual backdrop and logo) from a separate Google Drive folder. Builds a multimodal request that instructs Google Gemini to classify the shot (exterior vs interior/engine), replace the background accordingly, and swap any visible license plate with the provided logo. Sends the request to the Google Gemini image generation endpoint and receives a generated image in the response. Extracts the generated image, names it using the original filename with a “_studio.jpg” suffix, and uploads it to a specified Google Drive output folder. Setup Add Google Drive OAuth2 credentials and set the input, studio assets, and output folder IDs in the Google Drive nodes’ q
Generate vendor negotiation strategies from pricing data with GPT-4 and SendGrid
Quick overview This workflow ingests vendor pricing via a webhook or a weekly schedule, analyzes variance against historical and market benchmarks, uses OpenAI to draft negotiation strategies for high-priority cases, then emails recommendations through SendGrid and appends the analysis to a Google Sheets tracker. How it works Receives vendor pricing data from a POST webhook endpoint or runs every Monday at 8:00 to process a scheduled input. Normalizes incoming fields (vendor, pricing, benchmarks, volume, currency, renewal date, and notes) into a consistent schema. Calculates price variance versus historical and market benchmarks, estimates potential savings, derives a confidence score, and flags whether the opportunity is high priority. Filters to only high-priority opportunities and waits briefly to help manage API rate limits. Uses OpenAI to generate a structured, under-300-word negotiation strategy including tactics, target and walk-away prices, projected savings range, and risk flags. Formats the AI output into a report, emails it via the SendGrid API, and appends the analyzed record to a Google Sheets tab for tracking. Setup Add an OpenAI API credential for the OpenAI Chat Mod
Generate SRT subtitles for Google Drive audio with Smallest.ai
Quick Overview This workflow watches a Google Drive folder for new audio files, transcribes them with Smallest.ai, converts the transcription into an SRT subtitle file, and uploads the .srt back to the same Google Drive folder. How it works Triggers every minute when a new file is created in a specified Google Drive folder. Checks the file extension to confirm it is a supported audio format (mp3, wav, aac, ogg, flac, m4a, wma). Downloads the audio file from Google Drive. Sends the audio to Smallest.ai for speech-to-text transcription. Formats the transcription into timestamped SRT cues (using returned segments when available, otherwise estimating timings). Uploads the generated .srt subtitle file back to the watched Google Drive folder. Setup Add a Google Drive OAuth credential and select the folder to watch/upload to in both the trigger and upload steps. Add your Smallest.ai credentials in the transcription step. Ensure the monitored folder receives audio files with supported extensions, or update the extension-matching pattern to fit your media types.
Generate rich character bibles for writers with GPT-4.1 and Google Sheets
Quick overview This workflow accepts character details via webhook or manual trigger, uses OpenAI to generate psychology, backstory, and emotional arc drafts in parallel, then synthesizes them into a structured “Character Bible” JSON response and optionally appends a log row to Google Sheets. How it works Receives a POST request on an n8n webhook (or runs manually) with character parameters like name, age, archetype, world setting, story role, traits, and constraints. Normalizes the incoming fields, validates the archetype, and derives genre tags from the world setting using Python logic. Sends the enriched character inputs to OpenAI three times in parallel to generate a psychology profile, a backstory, and an emotional arc document. Combines the three AI documents into a single context object and passes it to OpenAI again to synthesize a unified Character Bible with defined sections. Parses the Character Bible into structured JSON fields (identity snapshot, personality core, backstory highlights, emotional arc, voice, and story hooks) and adds metadata like request ID and timestamp. Returns the completed character profile as a JSON webhook response and optionally appends a summary
Enrich contact emails and phone numbers with Tomba and Google Sheets
Quick overview This workflow runs on a schedule to read “Pending” contacts from Google Sheets, uses Tomba to find email addresses and (when available) phone numbers, then writes the enriched results back to the same spreadsheet. How it works Runs on a scheduled trigger. Reads rows from a Google Sheets worksheet where the Status column equals “Pending”. Processes the contacts in batches and sends each contact’s name, company, and domain to Tomba to find an email address. If Tomba indicates phone data is available, looks up the phone number in Tomba using the found email address. Normalizes the output (email, phone, score, and enrichment status) and updates the matching row in Google Sheets with the results and Status set to “Done”. Setup Connect your Google Sheets OAuth credentials and set the target spreadsheet and worksheet that contains your contacts. Add a Tomba API credential. Ensure your Google Sheet includes the expected columns (First Name, Last Name, Company, Domain, Status) and output columns (Email, Phone, Score), with Status set to “Pending” for rows you want to enrich.
Enrich LinkedIn profiles into full contacts with Tomba and Google Sheets
Quick overview This workflow runs on a schedule to read “Pending” LinkedIn profile URLs from Google Sheets, uses Tomba to find and enrich contact details (email and phone), and writes the results back to the same sheet with updated status and scoring. How it works Runs on a schedule trigger. Reads rows from a Google Sheets worksheet where the Status column is set to “Pending”. Processes each LinkedIn URL in batches and calls Tomba’s LinkedIn Finder to retrieve the person’s email and phone details. Normalizes the returned contact data (including combining multiple phone numbers) and sets an enrichment status based on whether an email is found. Updates the corresponding row in Google Sheets with the enriched fields (Email, Phone, Score) and marks the Status as “Done”. Setup Connect your Google Sheets OAuth2 credentials and set the target spreadsheet and worksheet that contains LinkedIn URL, Status, and output columns. Add your Tomba API credentials and ensure the LinkedIn URL column contains valid LinkedIn profile links. Make sure your sheet includes a row_number field (used for matching updates) and uses “Pending” as the Status value for rows you want to process.
Audit website SEO with Groq, Google PageSpeed and Google Sheets
Quick overview This workflow audits a submitted website URL by extracting on-page SEO signals from the HTML, pulling Google PageSpeed Insights scores, and using Groq (Llama 3.3 70B) to generate a scored SEO report, then logs the results to Google Sheets and returns the audit via webhook. How it works Receives a POST webhook request containing a JSON body with a target url to audit. Fetches the page HTML for the provided URL and stops with an error response if no HTML is returned. Extracts on-page SEO signals from the HTML (title, meta description/keywords, headings, image alt coverage, links, canonical, robots, viewport, Open Graph/Twitter tags, schema, word count, and language). Calls the Google PageSpeed Insights API for mobile to retrieve performance, accessibility, SEO, and best-practices results. Combines the extracted on-page data with the PageSpeed results and sends it to Groq via a LangChain agent to produce a strict, structured JSON audit with scores, findings, fixes, and top priorities. Parses and validates the AI JSON output, appends/updates the audit record in Google Sheets, and returns the final audit JSON to the webhook caller (or returns a 400 error if parsing fails)
Generate personalized cold email drafts from Google Sheets with Groq and Tavily
Quick overview This scheduled workflow reads leads from Google Sheets, researches each company with Tavily Search, uses Groq (Llama 3.3 70B) to generate a short personalized cold email, and saves the result as a Gmail draft while updating the lead status back in the sheet. How it works Runs on an hourly schedule trigger. Reads lead rows from Google Sheets and keeps only rows that have an email address and are not marked with status "sent". Processes leads one at a time and uses the Tavily Search API to fetch a brief company overview based on the lead’s company name. Sends the lead details plus the Tavily research summary to Groq (Llama 3.3 70B) to generate a JSON-formatted email subject, body, and personalization hook. Parses and validates the AI output to ensure a subject and body are present, and routes failures to an error log. Creates a Gmail draft with the generated subject and body, updates the corresponding row in Google Sheets with the new status and generated fields, and waits briefly before continuing to the next lead. Setup Create and connect a Google Sheets OAuth2 credential, then select the target spreadsheet and sheet in both the Google Sheets read and update steps. C
Nurture leads from Google Sheets with Gmail, SMS, and OpenRouter AI
Quick overview Automatically nurture leads with AI-personalized email follow-ups (plus optional SMS) across 3 stages triggered hourly, respecting business hours, and fully tracked in Google Sheets. How it works Runs every hour, filtered to a business-hours window (default 9am–6pm, timezone configurable). Reads all leads from Google Sheets and filters those due for follow-up skipping replies, unsubscribes, and completed leads. Routes by stage Stage 1 (Welcome), Stage 2 (Check-in), or Stage 3 (Final nudge). AI writes the email an LLM (via OpenRouter) generates a personalized subject + body using the lead's name, source, and service of interest. Sends via Gmail, and optionally an SMS via Seven/Twilio (Day 1 and Day 4, with consent and dedupe checks). Updates Google Sheets advances the lead's stage, sets the next follow-up timestamp, and marks SMS sent. Setup Import all 4 workflows they share one Google Sheet. Paste your Sheet ID/tab name into each 🔧 CONFIG node (same Sheet ID throughout). Connect Google Sheets, Gmail, and OpenRouter credentials. Edit the 3 LLM prompt nodes to replace "YOUR NAME/company" with your actual brand name. (Optional) Connect Seven/Twilio for SMS, and adjust
Rank resumes by job description similarity using Gemini embeddings
Quick overview This workflow collects resume PDFs and a job description via an n8n form, generates embeddings with Google Gemini, calculates cosine similarity between each resume and the job description, and returns a CSV-style ranked list of filenames. How it works Receives resume PDF uploads and a job description text through an n8n Form trigger. Creates a semantic embedding for the job description using the Google Gemini Embeddings API (gemini-embedding-2). Splits the uploaded files into individual resume items and converts each PDF binary to a Base64 string. Sends each Base64-encoded PDF to the Google Gemini Embeddings API to generate a multimodal embedding for the resume. Calculates cosine similarity between the job description embedding and each resume embedding, then sorts resumes from most similar to least similar. Returns a CSV-formatted ranking (Rank, File Name) in the form completion response. Setup Create and add a Google Gemini (PaLM) API credential in n8n with an API key that can access the gemini-embedding-2 model. Ensure the Google Gemini credential is selected on both HTTP requests that create the job description embedding and the resume embeddings. Use the workflo
Classify Salesforce deal complexity and notify sales with Groq and Slack
Quick overview This workflow monitors new Salesforce opportunities, enriches them with related contacts and products, uses Groq-hosted LLM analysis to classify deal complexity, then updates Salesforce with a processed flag, creates a follow-up task, and posts the outcome to a Slack channel. How it works Triggers when a new Opportunity is created in Salesforce. Retrieves Opportunity details and checks whether the opportunity has already been marked as processed. If it is already processed, posts a “no new opportunities” message to a Slack channel. If it is unprocessed, fetches related Salesforce Contacts for the Opportunity’s Account and OpportunityLineItem records for the Opportunity. Calculates simple deal metrics (stakeholder count, product count, and total product value) and sends them with Opportunity fields to a Groq LLM to classify complexity as Low/Medium/High with reasons and suggested actions. Parses the LLM’s JSON response, marks the Opportunity as Processed__c = true in Salesforce, creates a Salesforce Task containing the classification details, and sends a success notification to Slack. Setup Add Salesforce OAuth2 credentials and ensure your Opportunity object includes
WScore customer health and churn risk with Salesforce, Gemini, and Gmail
Quick Overview This workflow runs every minute to pull accounts from Salesforce, enrich each customer with order, payment, support, and marketing data via HTTP APIs, analyze the combined profile with Google Gemini, then update the Salesforce account and send Gmail alerts for high-risk customers and execution outcomes. How it works Runs every minute on a schedule and retrieves up to five Salesforce Account records. Processes accounts in batches and initializes a retry counter to control fault-tolerant data fetching. Fetches customer order data via an HTTP API, retrying up to three times with a wait delay and falling back to a backup HTTP endpoint if needed. Fetches payments, support tickets, and marketing engagement for the same customer via HTTP API requests and normalizes everything into a single customer profile. Sends the unified customer profile to Google Gemini to generate a JSON assessment with health score, churn risk, customer type, a summary, and a recommended action. Parses the AI output and emails a high-risk alert via Gmail when the churn risk equals HIGH. Routes by customer type, updates the Salesforce Account description with the AI summary, then logs the result and e
Send prioritized forex risk alerts from ForexLive RSS with OpenAI and Slack
Quick Overview This workflow polls the ForexLive RSS feed every five minutes, filters for forex-relevant headlines, uses OpenAI to generate structured risk analysis, deduplicates items in an n8n Data Table, and sends high-priority alerts to a Slack channel. How it works Polls the ForexLive RSS feed on a */5 * * * * schedule and ingests newly published items. Normalizes each RSS item into consistent fields (title, description, link, and date) and checks the text for predefined forex and macroeconomic keywords. For relevant items, sends the title and description to OpenAI (GPT-4.1-mini) to return a strict JSON risk assessment including summary, impacted currency pairs, risk level, confidence score, and recommended action. Parses the OpenAI JSON response, merges it back with the original news data, and computes a final risk score, priority level, and a normalized deduplication key. Checks an n8n Data Table for the dedupe key and only continues when the item has not been seen before. Stores the processed item in the n8n Data Table and posts a formatted Slack message when the computed priority is HIGH. Setup Add OpenAI credentials and ensure the OpenAI node is set to a model you have ac
Generate Salesforce opportunity next steps with Gemini and Slack
Quick Overview This workflow runs daily at 10:00 AM to find open Salesforce Opportunities with no Next Step, generates a recommended next action with Google Gemini, posts it to Slack, and updates the Opportunity’s Next Step field back in Salesforce. How it works Runs every day at 10:00 AM on a schedule trigger. Fetches all Salesforce Opportunities, reverses the list, and processes them in batches of 10. Retrieves key fields, filters to opportunities that are not Closed Won/Lost, have a close date on/after today, and have a blank Next Step. Builds a per-opportunity prompt containing the main deal details for an AI sales assistant. Processes opportunities one at a time and uses Google Gemini to generate a 1–2 sentence next-step recommendation. Posts the AI-generated recommendation to a specified Slack channel and updates the Opportunity’s Next Step field in Salesforce. Setup Connect Salesforce OAuth2 credentials with permission to read Opportunities and update the Opportunity Next Step field. Add Google Gemini (Google PaLM) API credentials for the Gemini chat model used by the agent. Add Slack credentials and select the channel where recommendations should be posted. Confirm your Sal
Run a hotel WhatsApp concierge using Google Gemini and Google Sheets
Quick overview Youtube Video: https://youtu.be/q2vPN9eub1o?si=lSo4c0kQMNQd_Aad This workflow acts as a WhatsApp hotel concierge that looks up guest profiles, reservations, and open service requests in Google Sheets, consults a Google Docs amenities guide, and uses Google Gemini with Redis memory to reply and optionally create or update reservations and service requests. How it works Triggers when a WhatsApp message is received and continues only if the incoming message contains text. Looks up the guest by WhatsApp number in a Google Sheets “Guest Details” spreadsheet and checks whether Do Not Disturb (DND) is enabled. If the guest is not in DND, fetches the guest’s reservations and any incomplete service requests from Google Sheets. Determines whether the guest is new, currently checked in (based on today’s date between check-in and check-out), and whether any requests are pending, then packages this context for the assistant. Uses Google Gemini with Redis chat memory to generate a WhatsApp-ready reply, calling a Google Docs amenities document when answering policy/pricing/amenity questions. When appropriate, the assistant writes back to Google Sheets to create or update guest prof
Manage gym check-ins and subscriptions with Supabase, Google Sheets, and QR codes
Quick overview Youtube Video: https://youtu.be/QyIalCCy6s8?si=Zlmde_oZz3qbDGwJ Github Repo: https://github.com/blankarrayy/automated-gym-checkin-system This workflow handles gym entry via QR codes by validating check-in requests against Supabase subscription data, logging entry attempts in Supabase, it also generates QR codes for check-in and registration and syncs new user IDs to Google Sheets. How it works Receives a POST request on the /gymcheckin webhook with header authentication and an entry_id query parameter. Looks up the entry_id in the Supabase entry_logs table to detect whether the QR code was already used. If the entry_id is unused, extracts the user ID from the request body and fetches subscription records from the Supabase gym_sub table. Validates that the user exists and has an active subscription, then writes an entry attempt record to the Supabase entry_logs table. Returns a webhook response granting entry (200), rejecting unknown users (401), rejecting inactive subscriptions (401), or rejecting reused QR codes (409). On the /qr-for-gym-checkin webhook, generates a new check-in QR code (pointing to the /gymcheckin URL with a random entry_id) and returns it as a bin
Send multi-carrier shipping quotes via WhatsApp with Gemini and ShipEngine
Quick overview Youtube Video: https://youtu.be/jIGBUW_1Sx0?si=BNXzk95soO0Nefan This workflow responds to incoming WhatsApp messages, validates the sender in HighLevel, uses Google Gemini with Redis memory to collect shipment details, fetches multi-carrier rates from ShipEngine, applies a commission markup, logs the quote to Google Sheets, and sends the best options back via WhatsApp. How it works Triggers when a new WhatsApp message is received. Looks up the sender’s phone number in HighLevel and stops outreach if the contact is marked Do Not Disturb. Uses a Google Gemini-powered agent with Redis chat memory to collect and confirm shipment details, creating the contact in HighLevel if needed or marking them DND if they opt out. If shipment data collection is complete, requests shipping rates from the ShipEngine Rates API for the configured carriers. Calculates a commission markup, filters for valid rates, and selects the cheapest and fastest options to format a quote message. Appends the quote text and metadata to a Google Sheets spreadsheet and sends the quote back to the customer via WhatsApp. Setup Connect WhatsApp Business credentials for both the WhatsApp trigger and send acti
Send SAP Business One low stock alerts via WhatsApp and email
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. Setup Configure SAP Business One Service Layer access by updating the server URL in the SAP login, item qu