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.
Tags
GmailOpenAISlackRelated workflows
See all AI Automation→
Qualify leads and send personalized audio follow-ups with Gemini and Smallest.ai
Quick Overview This workflow receives lead submissions via a webhook, uses Google Gemini to qualify the lead and write a personalized spoken follow-up script, and for qualified leads generates an MP3 with Smallest.ai, shares it from Google Drive, emails it via Gmail, logs outcomes to Google Sheets, and alerts sales in Slack. How it works Receives a POST webhook request containing a lead’s name, email, and message. Sends the lead details to a Google Gemini–powered AI agent to determine whether the lead is qualified and, if so, generate a short personalized audio script. Parses the agent’s JSON response and routes the workflow based on the qualified flag. If the lead is qualified, Smallest.ai synthesizes the script into an MP3 and uploads it to Google Drive. Shares the Google Drive audio file publicly and sends the lead a Gmail message with a link to listen. Appends the qualified lead record (including the audio link and timestamp) to Google Sheets and posts a notification to a Slack channel. If the lead is unqualified, appends the lead details and timestamp to Google Sheets without generating audio or sending email. Setup Enable the webhook and copy the generated /lead-capture URL i
WSend Calendly meeting prep briefs with Gmail, Notion, OpenAI and Sheets
Quick Overview This workflow monitors Gmail for Calendly “New Event” emails, extracts meeting details with OpenAI, enriches the invitee with Notion CRM data, Google Sheets STR records, and SerpApi building research, then generates and schedules a meeting-prep brief email to send 30 minutes before the meeting. How it works Triggers every minute when a new Gmail message arrives and continues only if it is a Calendly notification for a new event. Uses OpenAI to extract the invitee email and meeting date/time from the email and calculates a send time 30 minutes before the meeting. Looks up the lead in a Notion database by invitee email and pulls building research via SerpApi, then uses OpenAI to extract building details from the AI Overview results. Loads STR registration data from Google Sheets and matches it to the building address to flag whether the property appears in STR records. Searches recent Gmail history in two accounts for messages involving the lead’s email address and checks whether any history exists. If email history exists, uses OpenAI to summarize the relationship and generate a concise meeting brief, then formats it as an HTML email. If no email history exists, uses
Triage supplier capacity risk with Groq, Gmail, Slack, and Google Sheets
Quick overview This workflow runs daily to pull supplier performance data from an HTTP endpoint, calculate fulfillment and delay risk metrics, use Groq (Llama 3.3) to classify supplier risk and generate mitigation actions, then notify via Gmail and Slack and log outcomes to Google Sheets. How it works Runs every day at the scheduled time. Fetches supplier performance data from an HTTP API and stops if the supplier has no orders. Normalizes the supplier fields and calculates fulfillment rate, delay, rule-based flags, and a risk score. Sends the metrics to Groq (Llama 3.3) to classify risk (Low/Medium/High) with a reason and confidence, then merges the AI result with the computed metrics (falling back to the rule-based classification if parsing fails). If the AI risk is Medium, Groq generates three mitigation actions and the workflow fetches backup supplier options from an HTTP API, then combines both into a single alert payload. Sends the mitigation actions by Gmail email and Slack message, then appends a “high risk” audit row to Google Sheets. If the AI risk is not Medium, appends a “no alert sent” audit row to Google Sheets with the assessed risk details. Setup Add Groq API creden