OpenAI workflows
630 results — all source-linked n8n references
Transcribe WhatsApp voice notes and auto-reply with OpenAI Whisper and GPT-4o
Quick overview This workflow receives WhatsApp Cloud API webhook events, transcribes incoming voice notes with OpenAI Whisper, generates a reply with OpenAI GPT-4o, and sends the response back to the sender via the WhatsApp Graph API while also handling plain text messages. How it works Receives WhatsApp webhook requests for verification (GET) and incoming messages (POST) from the Meta WhatsApp Cloud API. Validates the webhook verify token and returns the hub challenge to complete Meta webhook verification. Parses the inbound webhook payload to extract the sender number, phone number ID, message type, and either text content or an audio media ID. For voice notes, calls the WhatsApp Graph API to resolve the media ID to a temporary download URL, downloads the audio file, and transcribes it to text with OpenAI Whisper. For text messages, uses the incoming text directly as the user prompt. Sends the message text to OpenAI GPT-4o with a system prompt to generate a concise reply in the same language. Posts the generated reply back to the user using the WhatsApp Graph API messages endpoint and returns an OK response to the webhook. Setup Create a Meta app with WhatsApp Cloud API enabled,
Extend videos with audio using Fal, OpenAI, and Upload-Post for TikTok
Quick overview This workflow accepts a video URL and prompt, uses Fal.ai (ltx-2.3-quality) to extend the video forward with generated audio, generates an SEO-friendly title with OpenAI, downloads the finished video, and uploads it to TikTok via the Upload-Post API. How it works Triggers from either an n8n Form submission or an incoming Webhook request containing video_url and prompt. Sends the video URL and prompt to Fal.ai’s ltx-2.3-quality extend-video endpoint to start an asynchronous high-quality render with audio generation enabled. Waits 60 seconds and repeatedly polls Fal.ai’s queue status endpoint until the job status returns COMPLETED. Fetches the completed Fal.ai request details to retrieve the final generated video URL. Sends the original prompt to OpenAI (GPT-5) to generate a short, clickable, SEO-oriented video title. Downloads the generated video file and uploads it to Upload-Post with the generated title, targeting the TikTok platform. Setup Add a Fal.run API credential (HTTP Header Auth) and confirm the extend-video and status/request URLs match your Fal.ai account and model. Add an OpenAI API credential and, if needed, change the model in the title-generation step.
Draft Google review reply emails with Gmail, OpenAI, and Google Sheets
Quick Overview This workflow monitors Gmail for Google Business Profile “new review” alert emails, uses OpenAI to extract the rating and review text and draft a policy-safe reply, then emails the draft to you and logs the review and reply draft to Google Sheets. How it works Triggers when a new Google Business Profile review notification email arrives in Gmail. Looks up the email’s message ID in a Google Sheets ledger to prevent drafting duplicate replies. Sends the email content and your configured business details to OpenAI to extract the rating, reviewer first name, and review text and generate a reply draft as structured JSON. Emails you a formatted message containing the review excerpt, the suggested reply, and a link to your Google reviews page. Appends a new row to Google Sheets with the message ID, extracted review details, the reply draft, a timestamp, and a “draft-sent-to-owner” status. Setup Connect your Gmail account and ensure Google review alerts are delivered from [email protected]. Add an OpenAI API key/credential and select the chat model in the OpenAI node. Create a Google Sheets “reply ledger” with columns like processed_at, gmail_message_id, rat
Assist hospital doctors via Telegram with OpenAI, Google Sheets, Gmail and Slack
Quick overview This workflow combines a Telegram doctor bot, OpenAI, Google Sheets, Gmail, Slack, and a webhook to summarize PDF reports, generate and email discharge summaries, analyze lab values, report bed availability, send daily patient follow-ups, and post error alerts. How it works Runs every day at 9:00 AM to read patient records from Google Sheets, filter those due for follow-up today with a Pending status, send each patient a Telegram check-in, and mark the follow-up as Sent. Triggers when a doctor sends a Telegram message and routes it based on whether it includes a document or a supported command. If a PDF is attached, downloads it from Telegram, extracts the text, uses OpenAI (gpt-4o-mini) to create a short clinical summary, logs the result to a Google Sheets Reports tab, and replies to the doctor on Telegram. If the message starts with "/discharge PATIENTID", extracts the patient ID, looks up the patient in the Google Sheets Patients tab, uses OpenAI (gpt-4o-mini) to generate a discharge summary, saves it back to Google Sheets, emails it to the patient via Gmail, and confirms completion on Telegram. If the message starts with "/labs", sends the provided lab values to
Verify customs shipping documents with GPT-4o-mini, Gmail and Slack
Quick overview This workflow receives shipment document text via a webhook, uses OpenAI (GPT-4o-mini) to extract key fields from the Bill of Lading, cross-checks the extracted data against Invoice and Packing List fields, then emails a compliance verdict via Gmail and sends failure alerts to Slack. How it works Receives a POST request via webhook containing submitterEmail, shipmentRef, and the plain-text Commercial Invoice, Packing List, and Bill of Lading. Uses OpenAI (GPT-4o-mini) to extract structured Bill of Lading fields into JSON, and posts a Slack alert if the extraction fails. Compares key fields across the Invoice, Packing List, and Bill of Lading (for example consignee/shipper names, ports, package counts, gross weight, HS codes, quantities, and shipping marks) and calculates a verdict and discrepancy list. Emails a “READY_TO_FILE” report via Gmail when all checks pass. Emails a “NEEDS_CORRECTION” report via Gmail with detailed mismatch explanations and check IDs when discrepancies are found. Sends a Slack message when any workflow-level error occurs so issues are visible even if the run fails early. Setup Add an OpenAI credential and ensure the OpenAI node is configured
WSend ranked freight quote PDFs with GPT-4o, Google Sheets, Gmail and PDFShift
Quick overview This workflow receives shipment requests via webhook, pulls carrier rate data from Google Sheets, uses OpenAI GPT-4o to generate a ranked HTML freight quote, converts it to a PDF with PDFShift, and emails the PDF to the customer via Gmail, with Slack alerts on workflow errors. How it works Receives a POST webhook request containing shipment details like origin, destination, weight, mode, and customer contact information. Reads rate information in parallel from three carrier tabs in a Google Sheets spreadsheet (BlueDart, DTDC, and Delhivery). Combines the carrier results and calculates per-carrier total cost based on the shipment weight. Sends the shipment and carrier data to OpenAI GPT-4o to generate a complete HTML quote page with a ranked comparison table. Converts the generated HTML into an A4 PDF file using the PDFShift API. Emails the PDF quote to the customer using Gmail with a prefilled subject and message. If the workflow fails, posts an error alert message to a Slack channel. Setup Configure the webhook path in n8n and copy the production webhook URL into the system that submits shipment requests. Add Google Sheets OAuth2 credentials and ensure the reference
Mask PII in hosted chat with OpenAI, Claude, and Saklam Bridge
Quick overview This workflow provides a public hosted chat that routes messages through the Saklam Bridge to mask PII on-premises before calling models like Claude, GPT, or Mistral, then restores the original values in the response. How it works Exposes a public hosted chat interface and receives each user message. Sends the message to an AI agent that uses an OpenAI-compatible chat model endpoint. Routes the model request through the self-hosted Saklam Bridge, which masks PII locally before forwarding the prompt to your chosen LLM provider. Receives the provider’s response back through Saklam Bridge, which unmasks the placeholders to restore the original PII. Returns the final unmasked answer to the hosted chat user. Setup Deploy the Saklam Bridge container in the same network as n8n and configure it with your Saklam license and your LLM provider API key. Create an OpenAI API credential in n8n that points its Base URL to your Saklam Bridge endpoint (for example, http://saklam-bridge:4000/v1) and uses the Bridge master key as the API key. Select that OpenAI credential in the chat model node and set the model name to the provider model you want to use (for example, claude-haiku-4-5,
Send daily brand mention digests to Slack with ScraperAPI and OpenAI
Quick Overview This workflow runs every morning at 8am, searches Google News for configured brand terms using ScraperAPI, stores previously seen article URLs in an n8n Data Table, summarizes the new coverage with OpenAI, and posts a daily brand-mention digest to a Slack channel. How it works Runs every day at 8am on a schedule. Sets the search terms, Google News country and time-period filters, and the target Slack channel. Creates (if needed) and reads an n8n Data Table of previously seen article URLs. Queries Google News via ScraperAPI for each search term and extracts article details from the responses. Deduplicates results against the seen-articles table and the current run, then stores new article URLs back into the Data Table. Groups new articles by brand, asks OpenAI to write a per-brand Slack-formatted summary, and posts the final digest message to Slack. Setup Add ScraperAPI credentials and ensure your ScraperAPI plan supports the Google News SDE endpoint used by the workflow. Add an OpenAI credential that can access the configured chat model (gpt-5-mini) or change the model selection to one available in your account. Add a Slack credential with permission to post messages
Schedule weekly social media posts with OpenAI and PostFast
Quick overview This workflow runs every Monday to generate a week of social media posts with OpenAI, then schedules them at preselected high-reach time slots through PostFast for the social accounts you choose. How it works Runs every Monday morning on a schedule trigger. Loads your brand name, voice, topics, number of posts, and a platform filter for which networks to target. Fetches all connected social accounts from PostFast and keeps only accounts that are connected and match the chosen platforms. Uses OpenAI to write the requested number of posts in the defined brand voice and returns them as structured JSON. Assigns each post to the next available “best time” slot (UTC) and expands the plan so each post is scheduled for each selected PostFast account. Creates scheduled posts in PostFast with APPROVED status so they publish automatically at the assigned times. Setup Install and enable the PostFast community node (n8n-nodes-postfast) if your n8n instance does not already allow verified community nodes. Add a PostFast API key credential and connect the social accounts you want to schedule to in your PostFast dashboard. Add an OpenAI credential for the OpenAI node. Update the con
Analyze LinkedIn profiles and posts with Apify and OpenAI GPT-4
Quick overview This workflow collects a LinkedIn profile URL via an n8n form, scrapes the profile’s recent posts with Apify, analyzes the profile and each post using OpenAI models, and stores the resulting profile summary and per-post insights in n8n Data Tables. How it works Receives a LinkedIn profile URL when a user submits the built-in n8n form. Extracts the LinkedIn username from the URL and runs an Apify actor to scrape the profile’s posts into a dataset. Generates an overall competitive-intelligence style profile analysis from the scraped posts using an OpenAI chat model and parses the result into structured JSON. Saves the structured profile summary, themes, messaging patterns, and content ideas to an n8n Data Table. Loops through each scraped post, stores the raw post text and engagement metrics in an n8n Data Table, and marks it as unprocessed. Analyzes each post with an OpenAI chat model to extract structured insights (topic, takeaway, engagement insight, and suggested use) and updates the corresponding Data Table row as processed. Setup Configure the n8n Form Trigger and share the form URL with users who will submit LinkedIn profile links. Add an Apify API token in n8n
Review stale Notion docs with Gmail alerts, Slack reports, and OpenAI
Quick overview This workflow runs every Friday to scan a Notion documentation database for pages not edited in 90+ days, marks them as “Needs review,” emails owners of critical stale docs via Gmail, and uses OpenAI to generate a prioritized weekly review plan that it posts to a Slack channel. How it works Runs every Friday at 10:00 on a schedule. Retrieves all pages from a selected Notion database and calculates how many days it has been since each page was last edited, along with its title, URL, owner email, and importance. Filters the list to only documentation pages that have been untouched for 90 days or more. Updates each stale page in Notion by setting its Status to “Needs review.” Sends a Gmail email to the page owner when the stale document is marked as Critical and an owner email is present. Aggregates all stale documents and sends them to OpenAI to draft a short, risk-ranked weekly docs review plan. Posts the generated review plan to a specified Slack channel. Setup Connect credentials for Notion, Gmail, OpenAI (Chat Model), and Slack. Select your target Notion database in the Notion “getAll” step and ensure it contains properties for Owner Email, Importance (Critical/Nor
WTriage and reply to email threads with GPT-5.2, IMAP, Gmail, and ESP suppression
Quick overview Automatically read inbound email replies, use AI to detect intent and sentiment, and send natural in-thread responses. Opt-out requests are confirmed, pushed to your ESP suppression list, and logged. A hands-off reply layer that keeps your sender reputation clean while every conversation gets fast, human-sounding answer. How it works An IMAP trigger watches your inbox and picks up new reply emails as they arrive. A filter keeps only genuine replies, and a code node strips quoted history and signatures, then parses the sender name, email, and threading headers. A code node builds a strict AI prompt with the cleaned message and your trigger-word hints. The OpenAI node classifies intent and sentiment and drafts a reply, returning strict JSON. A code node normalizes the response, enforces a clean email structure, and adds your CTA once. A switch routes on the unsubscribe flag: normal replies go back in-thread through Gmail, opt-outs get a neutral confirmation. Opt-outs are posted to your ESP suppression list, every action is logged to a data table, and Gmail labels are updated to mark the thread handled. Setup (5 steps): Add your IMAP credentials to the email trigger and
WGenerate sales call proposals with GPT-4o, Google Slides, PandaDoc, and Gmail
Quick overview This workflow captures details via an n8n form, uses OpenAI to generate structured proposal copy, and then produces a client-ready proposal either by filling a Google Slides template or by creating a PandaDoc document with pricing, before emailing the proposal to the prospect via Gmail. How it works Triggers when a sales rep submits the built-in n8n “Sales Call Logging Form” with the prospect and deal details. Sends the submitted company, problem, solution, scope, timeline, and cost to OpenAI (GPT‑4o) to generate proposal fields as a single JSON object. For the PandaDoc path, creates a PandaDoc document from a template via the PandaDoc API and injects the OpenAI-generated text plus a pricing table based on the form’s Cost value. Emails the PandaDoc proposal to the prospect using Gmail. For the Google Slides path, copies a proposal template in Google Drive and names it using the OpenAI-generated proposal title. Replaces placeholder tokens in the copied Google Slides presentation with the OpenAI-generated proposal sections. Emails the Google Slides proposal link to the prospect using Gmail. Setup Add an OpenAI API credential and confirm the selected GPT‑4o model is ava
Edit and post TikTok videos with Gemini Omni Flash and OpenAI
Quick overview This workflow receives a webhook request with a video URL and edit prompt, sends the job to Fal.run’s Gemini Omni Flash for video editing, generates a title with OpenAI, downloads the rendered file, and uploads it to TikTok via the Upload-Post API. How it works Receives a webhook request containing a video_url and an editing prompt. Submits the video edit job to Fal.run’s Gemini Omni Flash queue API. Polls Fal.run every 60 seconds to check the job status until it returns COMPLETED. Fetches the completed job details from Fal.run to obtain the final rendered video URL. Uses OpenAI (GPT-5) to generate an SEO-friendly title from the original prompt. Downloads the rendered video file from the provided URL and uploads it to TikTok using the Upload-Post.com upload API. Returns the Upload-Post.com API response to the original webhook caller. Setup Create and add Fal.run API header-auth credentials, and ensure the Gemini Omni Flash endpoints are accessible from your n8n instance. Add an OpenAI API credential for the title generation step and select the model you want to use. Create an Upload-Post.com account, add its API header-auth credentials, and replace YOUR_USERNAME with
Generate and publish AI short videos from Telegram using Blotato and OpenAI
Quick overview This workflow accepts a content idea via Telegram, uses OpenAI to write a short cross-platform caption, generates a vertical AI video with Blotato, and publishes it to TikTok, Instagram, Facebook, and X (Twitter), then confirms the result back in Telegram. How it works Receives a message (your content idea) via a Telegram bot trigger. Uses the incoming text to set the video prompt and posting options like TikTok privacy and the AI-generated flag. Sends the prompt to OpenAI to generate a single short caption (max 280 characters) to reuse across all platforms. Creates a 9:16 AI video in Blotato using a selected template and predefined template inputs (for example profile name and image). Waits and repeatedly checks Blotato until the video render status is marked as done. Publishes the rendered video and the generated caption to TikTok, Instagram Reels, Facebook Reels, and X (Twitter) via Blotato. Sends a Telegram message confirming the video has been published. Setup Install and enable the Blotato community node in your n8n instance (or enable Verified Community Nodes on n8n Cloud) and add a Blotato API credential. Connect your Blotato account to TikTok, Instagram, Fac
Manage restaurant orders, upsells, and payments with Telegram, OpenAI, Razorpay, and Google Sheets
Quick overview This workflow runs a Telegram restaurant ordering flow that uses OpenAI to parse orders and suggest an upsell, sends a Razorpay payment link, confirms paid orders via a Razorpay webhook, logs orders and feedback in Google Sheets, notifies the kitchen, sends delivery updates, and posts error alerts to Slack. How it works Receives a customer’s order message in Telegram and sends it to OpenAI to extract items, quantities, subtotal, and a suggested upsell. Replies in Telegram with an order summary and upsell prompt, then waits for the customer to respond. When the customer replies, calculates the final total (including the upsell when accepted) and sends a Razorpay payment link in Telegram. Receives the Razorpay payment.captured webhook, extracts payment details, confirms payment to the customer in Telegram, and posts a kitchen ticket to a dedicated Telegram chat. Appends the paid order to an Orders tab in Google Sheets and calculates ingredient deductions to update the same sheet against the order. Waits through prep and delivery windows and then sends delivery tracking followed by a Telegram feedback request. Captures the customer’s rating in Telegram, calculates loyal
WGenerate SEO-friendly robots.txt with OpenAI and Google Drive
Quick overview This workflow runs manually to check a website’s existing robots.txt, detect the site’s CMS from the homepage HTML using OpenAI, and generate an optimized robots.txt (including the provided sitemap URL) that is saved as a file and uploaded to Google Drive. How it works Starts when you click “Execute workflow” and sets the target website URL and sitemap URL. Requests the site’s existing robots.txt via HTTP and checks whether the response returns status code 200. If robots.txt exists, the workflow stops without making changes. If robots.txt is missing, it fetches the website homepage HTML via HTTP. Sends the HTML to OpenAI to detect the CMS and parses the model output into structured JSON. Uses OpenAI again to generate a production-ready robots.txt tailored to the detected CMS and including the sitemap directive. Converts the generated text into a robots.txt file and uploads it to a chosen folder in Google Drive. Setup Add an OpenAI API credential and ensure the selected chat model is available for both CMS detection and robots.txt generation. Add a Google Drive OAuth2 credential and choose the target Drive and folder for the uploaded robots.txt file. Update the websit
Route patients to the best nearby hospital using Google Maps, GPT-4.1 and Twilio
Quick overview This workflow accepts emergency location requests (or runs on a 5-minute schedule), finds and ranks nearby hospitals/clinics using Google Places, capacity data, and Google Distance Matrix, generates a routing message with OpenAI, sends the recommendation via Twilio SMS, logs the event to Google Sheets, and returns a JSON response. How it works Receives an emergency request via a webhook POST (or runs every 5 minutes on a schedule) and normalizes latitude, longitude, severity, phone number, and a request ID. Validates the GPS coordinates, maps severity to a numeric score, and sets a search radius, returning an error response if the location is invalid. Queries the Google Places API for nearby hospitals and clinics, then merges and deduplicates the results into a single facility list. Looks up each facility’s ED capacity metrics from a capacity API and calculates real-time driving time to each facility with the Google Distance Matrix API. Scores and ranks facilities using a severity-adjusted composite score (travel time, available beds, wait time, and ED diversion penalties) and selects the best match plus two alternatives. Uses OpenAI to generate a calm routing messag
Triage Typeform survey feedback with GPT-4o-mini, Slack, Gmail, and Sheets
Quick overview This workflow triggers on new Typeform survey responses, uses OpenAI GPT-4o-mini to classify sentiment and draft reply emails, routes negative feedback through a Slack human-approval loop with revisions, sends emails via Gmail, and logs outcomes to a Google Sheets CRM. How it works Triggers when a new Typeform survey response is submitted. Extracts the respondent’s name, email, rating, and free-text feedback and sends it to OpenAI GPT-4o-mini to classify the response as positive or negative. If the response is negative, OpenAI GPT-4o-mini drafts an empathetic follow-up email, posts a Slack alert to the team, and sends the draft to a Slack review channel that waits for a reply. If the reviewer replies with “approved”, the workflow sends the approved draft to the respondent via Gmail and appends a “Sent” record to Google Sheets. If the reviewer requests changes, OpenAI GPT-4o-mini revises the email based on the Slack feedback and the workflow loops back to Slack for another review. If the response is not negative, OpenAI GPT-4o-mini drafts a thank-you email, sends it automatically via Gmail, and logs the sent email to Google Sheets. Setup Connect credentials for Typefo
Draft personalized cold emails from Google Sheets with Apify and GPT-4o mini
Quick overview This workflow reads pending medical or dental practice leads from Google Sheets, scrapes each practice website with Apify, uses OpenAI (gpt-4o-mini) to identify conversion gaps, and drafts a short personalized cold email, then writes the analysis and draft back to the sheet. How it works Manually starts the workflow and reads leads from a Google Sheets worksheet. Filters the rows to only those with Status set to "pending" and processes them one at a time. Uses Apify Website Content Crawler to scrape up to a few pages of each lead’s WebsiteURL and compiles the extracted text into a trimmed site summary. If enough website text is available, sends it to OpenAI (gpt-4o-mini) to produce a strict-JSON analysis of 2–3 concrete booking/chatbot/after-hours/intake gaps and a best outreach angle. Alternates between “soft” and “direct” framing and asks OpenAI (gpt-4o-mini) to generate a short JSON email draft (subject and body) tailored to the selected gap. Updates the matching row in Google Sheets with ScrapedNotes, WeakPoints, DraftEmail, and sets Status to "drafted", then waits briefly before moving to the next lead. If the scrape returns insufficient content, updates the lea
Send AI market briefings to email and Discord with AlphaAI and GPT-4
Quick Overview This workflow runs every 15 minutes to fetch AlphaAI’s trending market news, filter for new high-relevance, ticker-linked stories, and post them to a Discord channel via webhook as rich embed cards with sentiment and impact details. How it works Runs every 15 minutes on a schedule trigger. Requests the current trending news feed from the AlphaAI API using Bearer authentication. Filters out already-posted articles, keeps only stories with relevance score ≥ 8 and at least one ticker, and formats up to 10 items into Discord embed cards with AlphaAI sentiment, confidence, actionability, and likely price impact. Posts a single Discord webhook message containing a header and the generated embeds, and stores the posted article IDs to prevent duplicates in future runs. Setup Create an AlphaAI API key and add it as an n8n HTTP Bearer Auth credential used by the AlphaAI request. Create a Discord channel webhook and paste its URL into the Discord webhook HTTP request node. Activate the workflow and keep it running on the same n8n instance so its stored posted-article IDs can be reused across executions.
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
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