Google Sheets workflow'ları
4.090 sonuç — 488 indirilebilir workflow dosyası, 3.602 kaynağa bağlı n8n referansı
Create SEO blog posts from YouTube videos with Gemini and Google Docs
Quick overview Submit a YouTube URL and get a publish-ready SEO blog post. Three Gemini agents research the video, write the article, and score it. Articles scoring 7+ auto-publish to Google Docs. Lower scores route to Telegram for review. How it works The workflow starts when a POST request hits the webhook with a YouTube URL, optional target keyword, and tone. A Code node extracts the video ID and validates the URL format, then an HTTP Request node calls YouTube Data API v3 to pull the video title, description, channel name, and tags. Three Basic LLM Chain nodes run in sequence, each powered by a Google Gemini Flash sub-node connected via the native ai_languageModel port. The first chain (Research Agent) receives the video context and returns a structured JSON brief containing an SEO title, four H2 headings, primary keyword, secondary keywords, key insights, target audience, and a content angle. A Code node parses this output with a JSON fallback in case Gemini adds unexpected formatting. The second chain (Writer Agent) takes the research brief and writes a complete 1,000–1,400 word blog post following strict rules: flowing paragraphs over bullet lists, primary keyword used 3–5 t
Capture and deduplicate inbound leads with webhooks and Google Sheets
Quick overview Capture inbound leads via webhook, validate and sanitize the data, deduplicate against Google Sheets, and store only clean leads ready to feed an AI-powered email/SMS nurture sequence. How it works Webhook receives the lead POST request from any form builder or landing page. Validation Missing email or phone returns a 400 and stops execution. Sanitize & normalize Trims whitespace, lowercases email, normalizes phone to international format, sets lead stage to 1, fills defaults for optional fields. Dedupe check Looks up the email in Google Sheets; flags duplicates safely even when the sheet returns zero rows. Duplicate → 200 "Already Registered", execution ends. New lead → appended to Sheets, 200 "Lead Accepted" returned. Setup Import all 4 workflows they share one Google Sheet. Create a sheet with these exact headers: Name, Email, Phone, Stage, Next Followup At, Has Replied, Lead Source, Service of Interest, SMS Consent Connect Google Sheets OAuth2 in the Lookup and Append nodes; paste your Sheet ID/tab into the 🔧 CONFIG nodes. Copy the webhook URL into your form builder. Map fields to: name, email, phone, lead_source, service_of_interest, sms_consent Requirements Go
WExtract and validate invoice PDFs with OpenAI, Google Sheets, and Gmail
Quick overview This workflow collects an invoice PDF via an n8n Form, extracts text from the PDF, uses OpenAI to convert it into structured invoice JSON, logs invoice headers and line items to Google Sheets, validates totals, and emails a formatted extraction report via Gmail. How it works Receives an invoice submission through an n8n Form that includes the uploader’s name, email address, currency, notes, and a PDF file. Extracts text content from the uploaded PDF. Sends the extracted text to OpenAI (Chat Completions) to return invoice fields and all line items as a strict JSON object. Parses and validates the returned JSON, enriching it with the form metadata and stopping the run if key fields (like invoice number or line items) are missing. Appends a single invoice “header” row to the Invoices tab in Google Sheets. Splits the extracted line items, adds per-line metadata and a unique key, and appends each line item as a row to the Line Items tab in Google Sheets. Aggregates all line items, verifies that their summed totals match the invoice total within a tolerance, builds an HTML report, and emails it to the submitter via Gmail. Setup Add an OpenAI API credential and ensure the O
Generate an FAQ MP3 library from form input with OpenAI TTS, Google Drive, Sheets and Gmail
Quick overview This workflow collects up to five FAQ questions and answers from an n8n Form, converts each entry to an MP3 using OpenAI text-to-speech, uploads the files to Google Drive, logs links in Google Sheets, and emails a summary with listen and download links via Gmail. How it works Receives an n8n Form submission containing the requester’s email, a FAQ category, and up to five question-and-answer pairs. Splits the submitted FAQ pairs into individual items, generating a TTS script and a safe MP3 filename for each valid question and answer. Calls the OpenAI Audio Speech API (tts-1) to generate an MP3 file for each FAQ script. Uploads each generated MP3 to a specified Google Drive folder. Builds Google Drive view and direct-download URLs for each uploaded file and appends the FAQ details and links to a Google Sheets tab. Aggregates all processed FAQs into a single HTML summary and sends it to the submitter via Gmail with listen and download links. Setup Add an OpenAI API credential for the HTTP request to the OpenAI Audio Speech endpoint. Create (or choose) a Google Drive folder for the audio files, connect Google Drive OAuth2, and replace YOUR_AUDIO_FOLDER_ID with the target
WLog Strava zone 2 and 5K test runs to Google Sheets
Quick overview This scheduled workflow pulls your latest running activities from Strava, classifies them as Zone 2 runs or 5K tests based on pace and distance, and writes the formatted results into specific cells in a Google Sheets training log while tracking processed activity IDs. How it works Runs on a daily schedule. Fetches recent activities from the Strava API for the authenticated athlete. Processes each activity to calculate pace (min/km) and routes it into “Zone 2” or “Test Run” based on sport type, duration, pace, and distance rules. Formats the selected activities into sheet-ready fields (date, pace string, moving time, and distance) and labels them as ZONA 2 or TEST 5KM. Reads the target Google Sheets range to find the next available slots and checks an “IDs Registrados” list to avoid reprocessing activities. Updates Google Sheets with the activity details in the appropriate cycle columns and appends new Strava activity IDs to the “IDs Registrados” cell. Setup Connect your Strava OAuth2 credentials and ensure the athlete has permission to read activities. Connect your Google Sheets OAuth2 credentials and update the spreadsheet URL/ID and sheet (tab) selection used for r
Enrich CRM contacts in Google Sheets with Tomba firmographic data
Quick overview This workflow watches a Google Sheets contacts list for new rows and enriches each contact using Tomba to find a likely email address, company firmographics, and a phone number, then writes the enriched fields back to the same spreadsheet. How it works Triggers when a new row is added to a specified Google Sheets worksheet (polled every minute). Processes new contacts one at a time to control throughput. Uses Tomba to find an email address for the contact based on the provided domain, company, and name. Uses Tomba to enrich the company with firmographic details such as industry, company size, revenue, and location. Uses Tomba to look up a company phone number from the contact’s domain. Combines the enrichment results into a single contact record and sets a status like “Enriched” or “Not Found.” Updates the matching row in Google Sheets with the enriched Email, Phone, Industry, Company Size, Revenue, Country, and Status fields. Setup Connect Google Sheets credentials and select the target spreadsheet and worksheet to monitor. Add Tomba API credentials to each Tomba step used for email, company, and phone enrichment. Ensure your Google Sheet includes the destination co
Track and notify lead callbacks with Tomba, Google Sheets, and Slack
Quick overview This workflow receives new lead details via a webhook, looks up a company phone number with Tomba using the lead’s domain, updates a Google Sheets lead tracker, and sends a formatted callback alert to a Slack channel. How it works Receives lead data in a POST webhook request. Processes incoming leads in batches to handle multiple items safely. Uses Tomba to find a phone number for each lead based on the provided company domain. Formats the lead details and enrichment results into tracker fields and a Slack-ready message. Updates the matching lead row in Google Sheets (matched by Domain) with the phone, status, and “Slack Notified” flag. Posts the callback alert message to a selected Slack channel and continues until all leads in the batch are handled. Setup Configure the source system to send lead payloads to the workflow’s webhook URL (path: /GHL) with fields like Full name, Email, Company name, and Company domain. Add your Tomba API credentials to enable phone lookup by domain. Connect your Google Sheets credentials and set the target spreadsheet and sheet, ensuring columns like Domain, Phone, Status, and Slack Notified exist. Connect your Slack credentials and cho
Detect visual regressions with Apify, Google Gemini, Sheets and Linear
Quick overview This workflow generates baseline website screenshots with Apify, stores them in Google Drive, and logs the file IDs in Google Sheets, then runs scheduled visual regression checks by comparing new screenshots against the baselines with Google Gemini Vision and creating a consolidated Linear issue when changes are detected. How it works Manually starts to backfill missing baselines by reading URLs from Google Sheets that do not yet have a stored base image. For each missing baseline URL, calls Apify’s screenshot actor, downloads the rendered image, uploads it to Google Drive, and updates the matching Google Sheets row with the Drive file ID. Runs weekly on a schedule and reads the list of webpages to test from Google Sheets. For each webpage, downloads the baseline image from Google Drive and captures a fresh screenshot via Apify. Sends both images to Google Gemini (vision) to detect visual differences and returns a structured list of regressions (text, number, image, color, or position). Filters out pages with no detected changes, aggregates the remaining results, and creates a Linear issue containing the regression report. Setup Add an Apify API token as HTTP Query A
Sync Google Drive documents to Pinecone RAG with Google Gemini embeddings
Quick overview This workflow runs on a schedule to sync files from a Google Drive folder into a Pinecone vector index for RAG, extracting text from PDFs, XLSX, Google Docs, and spreadsheets, generating embeddings with Google Gemini, and tracking file state in a Google Sheets log to handle updates and deletions. How it works Runs on a schedule and fetches the current file list from a target Google Drive folder and the existing file log from Google Sheets. Compares Google Drive files with the Google Sheets log to detect new/updated files to ingest and files that were deleted from Drive. For new or updated files, deletes any existing vectors in Pinecone for the file ID, downloads the file from Google Drive, and routes it by MIME type. Extracts text from PDFs, XLSX/Google Sheets, and plain text/Google Docs files and maps the extracted content with file metadata (file ID, name, modified time, and MIME type). Chunks the document text, generates embeddings with Google Gemini, and inserts the resulting vectors and metadata into a Pinecone index. Appends or updates the Google Sheets log with the latest file metadata, and for deleted Drive files it deletes matching vectors in Pinecone and re
WSend daily SEO digest from Google Search Console to Discord with heartbeat alerts
Quick overview This workflow runs daily to pull Google Search Console performance data, log it to Google Sheets, send a daily SEO digest to Discord with day-over-day deltas, and ping an external heartbeat endpoint; if any step errors, it immediately pings the heartbeat service’s /fail endpoint. How it works Runs every day at 08:00 on a schedule trigger. Queries the Google Search Console Search Analytics API for query-level data from two days ago. Aggregates the results into totals (clicks, impressions, average position) and the top queries. Appends the day’s metrics to Google Sheets and reads the sheet to fetch the previous day’s row for comparison. Calculates percentage changes vs yesterday and sends a formatted SEO digest to Discord, including a warning when clicks drop sharply. Posts a success ping with the key metrics to an external heartbeat service (for example, checkilo or Healthchecks.io) so missing runs can be detected. If any node throws an error, an error-triggered branch posts a /fail ping to the heartbeat service with the error message and failing step. Setup Add a Google OAuth2 credential with the https://www.googleapis.com/auth/webmasters.readonly scope and replace t
Send portfolio risk reports from Google Sheets with OpenAI and Gmail
Quick overview This workflow collects a portfolio request via an n8n Form, loads holdings from Google Sheets, calculates portfolio risk and concentration metrics, generates an HTML risk narrative with OpenAI, then emails the full report via Gmail and appends an audit record back to Google Sheets. How it works Receives a portfolio analysis request from an n8n Form containing the investor details, base currency, and a Google Sheet ID. Reads all holdings from the provided Google Sheets document (Portfolio tab) and bundles the rows into a single portfolio dataset. Calculates market value, allocations, sector and asset-class breakdowns, P&L, concentration flags, and a 0–100 risk score. Sends the computed portfolio summary, breakdowns, risk flags, and holdings to OpenAI to generate a structured risk report in HTML. Builds a branded HTML email that includes the AI narrative plus sector and top-holdings tables and a concentration alert banner. Sends the HTML risk report to the investor via Gmail and appends a summary row to a Google Sheets “Analysis Log” audit sheet. Setup Create a Google Sheet with a tab named “Portfolio” and headers: ticker, company, sector, asset_class, quantity, avg_bu
Build hospitality lead lists from Booking.com using Apify and Google Sheets
Quick Overview This workflow uses Apify and Google Sheets to find accommodation leads from Booking.com, enrich them with Google Maps contact details, discover official websites via Google Search, scrape additional contacts from those sites, and then append the finalized partner list to a Google Sheets spreadsheet. How it works Manually triggers and sets the destination, maximum number of results, and property type to search. Runs the Apify Booking Scraper actor for the configured destination and retrieves the Booking.com dataset results. Maps each Booking.com result into a normalized lead record, using Booking trader details (when available) for initial email and phone fields. Runs the Apify Google Maps with Contact Details actor for leads missing email and merges any найден emails, phones, websites, and social links into the lead records. For leads still missing both email and website, runs the Apify Google Search Scraper actor to find an “official website” candidate and assigns the best non-OTA domain. Scrapes those candidate websites with the Apify Contact Info Scraper actor to extract emails/phones/socials and merges the results into the final lead rows. Appends the finalized l
Qualify inbound leads with OpenAI, Slack, and Google Sheets
Quick overview This workflow receives inbound leads via a webhook, normalizes common form fields, and uses OpenAI to score and tier each lead as HOT, WARM, or NURTURE. It logs the result to Google Sheets, sends a tier-specific email auto-reply, and alerts a Slack channel for HOT leads. How it works Receives an inbound lead submission via a POST webhook. Normalizes incoming fields (name, email, company, website, message, budget, timeline, and source) into a consistent structure. Sends the normalized lead details to OpenAI to generate JSON scores (fit, budget, urgency, overall), a tier, reasoning, next action, and red flags. Merges the AI qualification results back into the lead record and routes the lead based on the tier. For HOT leads, posts an alert to Slack, appends the lead to the “Hot Leads” tab in Google Sheets, and sends a HOT auto-reply email. For WARM and NURTURE leads, appends the lead to the matching Google Sheets tab and sends the corresponding tier-specific auto-reply email. Returns a JSON response to the webhook caller confirming success and the assigned tier. Setup Add an OpenAI credential and customize the system prompt ICP/scoring rules in the OpenAI step. Add Goog
Send weekly narrative client reports with Google Sheets, Claude, and Gmail
Quick overview This workflow runs every Friday at 9:00 AM, pulls active client status data from Google Sheets, uses Anthropic Claude to generate a narrative weekly report with structured HTML and plain text output, and sends the finished report to each client via Gmail. How it works Runs every Friday at 9:00 AM on a schedule trigger. Reads all client rows from a specified Google Sheets document. Filters out paused/inactive or incomplete rows, extracts any “Metric:” columns, and builds a reporting week label for each client. Sends each client’s normalized data to Anthropic Claude to write a 3–4 paragraph narrative report and return JSON containing an email subject plus HTML and plain-text bodies. Emails the generated HTML report to each client’s email address using Gmail. Setup Create a Google Sheet with the required columns (at minimum “Client Name” and “Client Email”) and optional “Status” plus any “Metric:” columns you want included. Add Google Sheets OAuth2 credentials in n8n and replace the placeholder Sheet ID in the Google Sheets read step. Add an Anthropic credential for the Claude chat model used to generate the structured report. Add Gmail OAuth2 credentials and confirm th
Triage chronic care vitals with Google Sheets, Gmail, Telegram and Slack
Quick overview This workflow runs daily to read chronic care vitals from Google Sheets, merge them into a per-patient record, score risk using AHA/ADA threshold rules, and notify clinicians via Telegram and Gmail when escalation is needed, while logging all results back to Google Sheets. How it works Runs every 24 hours on a schedule trigger. Reads blood pressure, glucose, activity/sleep, and patient master data from Google Sheets. Merges the sheets into a single structured record per patient for the current day. Calculates a risk score and risk level (LOW–CRITICAL) by evaluating vitals against AHA/ADA guideline thresholds and detecting anomalies. If escalation is required, generates a clinical intervention plan, sends a Telegram alert to the doctor, sends an HTML escalation email via Gmail, and appends/updates the escalated result in the Google Sheets DailyLog. If escalation is not required, writes the routine result to the Google Sheets DailyLog and sends a routine status email via Gmail. If any workflow error occurs, posts an error alert to a designated Slack channel. Setup Add Google Sheets OAuth2 credentials and update each Google Sheets node with your spreadsheet document ID
Recover overdue invoices with GPT-4o-mini, Gmail, Google Sheets and Slack
Quick overview This workflow runs every 24 hours to read overdue invoices from Google Sheets, uses OpenAI (GPT-4o-mini) to draft personalized recovery emails and determine escalation, sends emails via Gmail, logs outcomes back to Google Sheets, and posts status and error alerts to Slack. How it works Runs every 24 hours on a schedule trigger. Reads invoice rows from a Google Sheets “invoices” tab and checks whether there are any valid invoice entries to process. If no invoices are found, posts a “no overdue invoices” message to a Slack channel. For each invoice found, uses OpenAI (GPT-4o-mini) to assign an escalation level, draft a personalized HTML email (including payment plans when applicable), and recommend an escalation action. Parses the AI output into structured fields and sends the recovery email to the client via Gmail. If the AI recommends escalation, sends an internal escalation alert email to the legal team via Gmail. Updates the invoice row in Google Sheets with the new escalation level and AI summary, then appends a full audit log row to a “Recovery sheet” tab. If AI processing fails, posts an error alert to Slack and continues with the next invoice. Setup Add Google
Log clinic chatbot inquiries from a website widget with OpenAI and Google Sheets
Quick overview This workflow receives website chatbot messages via a webhook, uses OpenAI to generate an AI receptionist reply with session-based context, extracts structured inquiry details, and appends or updates a single visitor row in Google Sheets before returning a clean JSON reply to the widget. How it works Receives a POST request from the website chat widget containing the visitor message, sessionId, and timestamp. Uses an OpenAI-powered receptionist agent with per-session memory to generate a contextual reply and a hidden JSON block of extracted inquiry details. Strips the hidden data block from the reply, parses the JSON into fields (name, contact, intent, appointment details, summary, status), and flags whether any meaningful data was captured. If collectible data exists, appends or updates a Google Sheets row matched on Session ID with the latest extracted details and a Last Updated timestamp. Returns the cleaned reply to the chat widget as a JSON response with CORS headers. Setup Add an OpenAI API credential for the OpenAI chat model used by the receptionist agent. Add a Google Sheets OAuth2 credential and set the target spreadsheet document ID and sheet/tab name used
Evaluate vendor proposal PDFs with OpenAI, Gmail, and Google Sheets
Quick overview This workflow collects vendor proposal PDFs via an n8n Form, extracts text from the PDF, uses an OpenAI ChatGPT model to summarize and flag risks, logs the evaluation to Google Sheets, and sends an approval or review-needed notification through Gmail. How it works Receives a submission from an n8n Form with the submitter’s details, optional notes, and a vendor proposal PDF upload. Extracts text from the uploaded PDF and cleans/limits it to a safe length for AI evaluation. Sends the cleaned proposal text and submitter notes to an OpenAI ChatGPT model to return structured JSON with vendor details, summary, key points, and risks. Parses the AI response, formats key points and risks for readability, and flags the submission as “REVIEW NEEDED” when any risks are present. Appends the evaluation results to an “Evaluations” tab in Google Sheets with the decision, summary, and risk metadata. Sends a Gmail alert to the review team when risks are found, otherwise emails an auto-approval notification to the approver. Setup Add an OpenAI API credential and select the model for the OpenAI Chat Model used by the evaluator. Connect Google Sheets OAuth2 and replace YOUR_PROPOSAL_LOG_
Categorize emails and draft Gmail replies with Groq and Google Sheets
Quick overview This workflow monitors Gmail for new emails, uses Groq (via the LangChain Agent node) to categorize and summarize each message and draft a reply, sends an alert email for high-priority items, and logs the analysis and draft details to Google Sheets. How it works Checks Gmail every minute for new incoming emails. Skips processing if the email has no body content or snippet. Extracts the sender, subject, received date, message ID, and a truncated body (up to 3000 characters) for analysis. Sends the email content to Groq to return a JSON analysis with category, priority, summary, key asks, action items, suggested labels, and a draft reply. Parses and validates the AI JSON output, stopping if it cannot be parsed. Sends a Gmail alert to your chosen address when the email is marked HIGH priority, then continues. Appends the parsed analysis fields to a Google Sheets “Email Log” sheet and creates a Gmail draft reply only when the analysis indicates a response is required. Setup Connect a Gmail OAuth2 credential with permission to read emails and create drafts, and select it in the Gmail Trigger, Alert email, and Create Draft nodes. Add a Groq API credential and select it in
Repurpose content into 5-platform posts with Groq Llama 3.3 and Upload-Post
Quick overview This workflow receives a webhook with either a URL or raw text, uses Groq (Llama 3.3 70B) to analyze and repurpose the content into Instagram, X, LinkedIn, email, and video formats, optionally logs results to Google Sheets, and posts the LinkedIn text to multiple platforms via Upload-Post.com. How it works Receives a POST webhook request containing a single content value that is either a URL or plain text. If the input starts with http, it fetches the page content over HTTP and packages it as cleaned source text; otherwise it uses the provided text as-is. Sends the prepared content to Groq (Llama 3.3 70B) to generate a structured analysis of the core message, key points, audience, tone, and hook angles. Uses Groq again to generate platform-specific outputs (Instagram caption/hashtags, X thread, LinkedIn post, email newsletter, and a short video script) as JSON. Parses the AI JSON, validates character limits for Instagram, LinkedIn, and X, and returns an error response if the output cannot be parsed. On success, appends the generated content and validation warnings to Google Sheets, posts the LinkedIn text to selected social platforms via the Upload-Post.com API, and
Publish science newsletter posts from YouTube using Ghost and Google Sheets
Quick overview This workflow turns science keywords from Google Sheets into researched Ghost newsletter posts by discovering and screening YouTube videos with Apify, validating claims using Brave Search, storing sources in Qdrant with Cohere embeddings, drafting content with LLMs, and publishing via a custom Ghost HTTP endpoint. How it works Runs either manually to qualify “FAIR GAME” keywords from Google Sheets or on a schedule to start the automated publishing pipeline. Uses Brave Search with an LLM agent to research each keyword’s current context and writes a structured relevance, domain, and angle assessment back to the Keywords sheet. On schedule, randomly selects an eligible keyword, uses Apify’s YouTube Scraper to fetch recent videos with English transcripts, and appends normalized candidates to the Candidate Videos sheet. Scores each candidate’s virality from views, engagement, channel size, and publish age, marks rows as VIRAL or NOT VIRAL, and archives NOT VIRAL items to an Archive sheet. Reviews VIRAL candidates with an editorial LLM agent to select exactly one evidence-worthy video (or reject all), updates statuses and reasoning in Google Sheets, and archives rejected v
Monitor warehouse receiving performance with Google Sheets, Gemini, and Gmail
Quick overview This workflow runs hourly to analyze warehouse receiving logs from Google Sheets, calculates per-user performance and compliance metrics, enriches results with department data, uses Google Gemini to generate recommendations for flagged users, emails managers via Gmail when escalation is needed, and appends results to an analytics dashboard sheet. How it works Runs every hour on a schedule trigger. Reads receiving log rows from Google Sheets and normalizes key fields like duration, errors, and compliance. Aggregates the log data by user_id and computes performance status, severity score, and alert tier based on time, errors, and compliance rate. Looks up each user’s department and manager email in a Google Sheets “Departments” tab and attaches this context to the analysis. For users not rated “good,” sends the metrics to Google Gemini to generate structured root-cause and action-step recommendations. If the alert tier is not “none,” sends an info/warning or critical escalation email via Gmail (using manager_email when available). Appends the final per-user analysis (metrics, issues, recommendations, and whether an email was sent) to a Google Sheets “AnalyticsDashboard
Detect maverick spend and alert reviewers via Slack, Gmail, Sheets and Gemini
Quick Overview This workflow runs daily to compare procurement transactions in Google Sheets against an approved supplier list, flags unapproved (maverick) spend, uses Google Gemini to generate compliant alternatives, alerts reviewers via Slack and Gmail, logs violations back to Google Sheets, and escalates unresolved cases after two hours. How it works Runs every day at 11:00 AM on a schedule. Loads the approved supplier list and the latest transactions from Google Sheets and normalizes supplier names for consistent matching. Compares each transaction’s supplier against the approved list and flags transactions from unapproved suppliers as maverick spend. For approved suppliers, marks the transaction as processed in Google Sheets and ends. For maverick spend, sends the transaction details and the approved supplier list to Google Gemini to generate corrective recommendations and alternative suppliers. Formats the AI output with a timestamp, posts a Slack alert, and sends a detailed violation email through Gmail. Appends the violation details to a Google Sheets log, marks the transaction as processed, waits two hours, and then posts an escalation message to Slack. Setup Connect Googl
Monitor budget variance with Google Sheets, Gemini, Slack, and Gmail
Quick overview This workflow runs daily to compare department budgets and actual spend from Google Sheets, calculates variance, uses Google Gemini to generate root-cause insights, sends Slack alerts when variance breaches a threshold, logs results back to Google Sheets, and emails a daily report via Gmail. How it works Runs every day at 9:00 AM on a schedule. Reads budget and actual spend data from two Google Sheets tabs and matches records by Department. Calculates spend variance and variance percentage, then assigns a status label (Healthy/Warning/Critical) and run context like date and summary. Sends the variance details to Google Gemini to generate a JSON response with root cause, risk level, and recommendations. Checks whether the variance percentage is greater than 10% and sends a Slack alert with the AI insights when the threshold is exceeded. Appends the final analysis (including whether an alert was sent) to a Google Sheets log and sends the same report via Gmail. Setup Connect Google Sheets OAuth credentials and set the correct spreadsheet and sheet tabs for Budget Data, Actual spend, and the Final report log. Add a Google Gemini (PaLM) API credential for the Gemini model