Quick overview This workflow polls your Gmail inbox every 15 minutes, uses OpenAI to classify unread emails as URGENT, STANDARD, or SPAM, drafts reply emails for non-spam messages, posts a review notification to Slack, and logs spam messages to Google Sheets. How it works Runs every 15 minutes on a schedule and fetches up to 20 unread messages from your Gmail Inbox. Marks each fetched Gmail message as read and extracts key fields (sender, subject, snippet, body text, thread ID) for processing. Sends the email content to OpenAI to return a strict JSON classification (category, action label, priority note, and suggested subject). Routes SPAM messages to Google Sheets to append a row in a “Spam Log” sheet and stops further processing for those emails. Sends URGENT and STANDARD messages to OpenAI to generate a concise, plain-text reply draft in your writing style. Saves the generated reply as a Gmail draft in the original thread and posts a Slack message with the triage details so you can review and send. Setup Connect a Gmail OAuth2 credential and ensure the workflow has access to read Inbox messages, mark them as read, and create drafts.
Tags
Gmail
Google SheetsOpenAISlackRelated workflows
See all AI Automation→
Detect revenue leakage with Salesforce, Google Sheets, Gemini, and Slack
Quick overview This workflow manually audits Closed Won Salesforce opportunities against billed amounts in Google Sheets, uses Google Gemini to analyze any revenue gap, then alerts a Slack user and writes an audit note back to the Salesforce opportunity. How it works Starts when you run the workflow manually. Fetches up to 20 Salesforce opportunities where the stage is "Closed Won" and processes them in batches with a short delay to reduce API pressure. Looks up matching billing rows in Google Sheets and totals the billed amount for the same Deal ID, then calculates the missing revenue versus the Salesforce Amount. For deals with a positive revenue gap, sends the discrepancy details to Google Gemini to classify severity and generate a root cause, recommendation, and Salesforce-ready audit note. Parses the Gemini JSON response and builds a formatted Slack message containing the deal, gap, severity, and recommended action. Sends the Slack alert and updates the Salesforce opportunity description with the audit note and the expected, billed, and missing amounts. Setup Add credentials for Salesforce OAuth2, Google Sheets OAuth2, Google Gemini (PaLM) API, and Slack OAuth2. In Salesforce,
WSend weekly blended ad performance reports with Meta, Google Ads, GA4 and OpenAI
Quick overview This workflow runs every Monday at 8am to pull the last 7 days of performance from Meta Ads, Google Ads, and GA4, calculate blended KPIs, generate an OpenAI-powered narrative summary, email an HTML report via Gmail, and post an internal update (and errors) to Slack. How it works Runs every Monday at 8am on a scheduled trigger. Fetches the last 7 days of spend and engagement metrics from the Meta Ads Insights API, campaign cost and conversion metrics from the Google Ads API, and conversions and revenue by channel from the GA4 Reporting API. Combines the three datasets and calculates blended KPIs including total spend, total conversions, total revenue, and ROAS. Sends the computed metrics to an OpenAI chat model to generate a 3–4 sentence client-friendly performance summary with one risk and one recommendation. Builds a simple HTML report containing the KPIs and AI summary. Emails the HTML report to the client via Gmail and posts a brief confirmation with spend and ROAS to a Slack channel. If the workflow fails, posts an error alert message to an ops Slack channel. Setup Configure authentication for the HTTP requests to Meta Ads (access token), Google Ads (OAuth/access
Monitor ride surge events and analyze ride errors with Sheets, Slack and Gemini
Quick overview This workflow pulls ride events and error records from Google Sheets, detects surge pricing and long waits, and notifies via Slack. For error records, it uses Google Gemini with real-time traffic and weather API lookups to diagnose the issue and send recommended actions to Slack. How it works Runs manually and reads ride records from a Google Sheets spreadsheet. Processes the rows one by one with a short delay and routes each record based on whether its type is an event or an error. For event records, checks if the ride price is more than 1.5× the normal price and the wait time is over 10 minutes. If surge conditions are met, sends a surge and delay notification to Slack and records a surge-alert log entry. If surge conditions are not met, records a normal “no alert needed” log entry. For error records, structures the ride and error context and asks Google Gemini to generate an incident summary, probable cause, and recommended actions, calling traffic and weather APIs as needed. Parses the Gemini response into JSON and posts the formatted error report to Slack. Setup Connect Google Sheets OAuth credentials and set the correct spreadsheet and sheet tab in the Google S