Google Gemini workflows
1,419 results — 128 downloadable workflow files, 1,291 source-linked n8n references
Qualify WhatsApp real estate leads with Gemini and Supabase
Quick overview This workflow triggers on incoming WhatsApp messages, uses Google Gemini to extract and score real estate lead details, stores each lead in Supabase, and sends a WhatsApp alert to the agent only for high-intent inquiries based on configurable score thresholds. How it works Triggers when a new WhatsApp message is received via the WhatsApp Business Cloud API. Pulls the sender name, phone number, and message text and applies your configured scoring thresholds and agent contact number. Sends the message to Google Gemini to extract structured lead details (budget range, property type, location preference, timeline, and intent score). Inserts the extracted lead data into a Supabase leads table for tracking. Routes the lead based on the intent score and sends a formatted WhatsApp message to the agent for high-intent leads. Leaves medium- and low-intent leads logged in Supabase without sending an agent alert. Setup Connect WhatsApp Business Cloud API credentials for both the incoming-message trigger and the WhatsApp send action, and activate the workflow to generate the webhook for your WhatsApp app. Add a Google Gemini (PaLM) API credential for the Gemini chat model. Add a
CDHandle LinkedIn inbox RAG replies with Unipile, Claude, Pinecone, and Airtable
Quick overview Automatically ingest your knowledge base, monitor your LinkedIn company page inbox, and reply to leads and customers with AI-drafted, source-grounded answers. Classifies every message, checks for spam, drafts replies using Claude and Pinecone RAG, and lets you auto-send or review each reply in Airtable. How it works A Google Drive trigger watches a folder for new or updated documents, downloading each file automatically as it's added. Each document is split into chunks, embedded, and upserted into a Pinecone vector index, building a searchable company knowledge base. A webhook receives every new LinkedIn message sent to your company page via Unipile, filtering out messages you sent yourself. The last few messages in the conversation are fetched and formatted into a chronological transcript for context. An AI agent classifies the message's intent (lead, support, partnership, recruiting, spam, or other) using shared conversation memory. A second AI agent drafts a reply, searching the Pinecone knowledge base for relevant facts before answering, and saves the draft to Airtable. Depending on a configurable auto-send toggle, the reply is sent immediately via Unipile, or he
Protect Gmail AI email workflows from prompt injection with Gemini and Sheets
Quick overview This workflow monitors Gmail for new support-style emails, scans them for prompt-injection signals, and only then sends safe messages to Google Gemini for structured triage. It logs outcomes to Google Sheets and creates Gmail drafts either for a safe reply or for manual human review. How it works Triggers every 5 minutes when a new Gmail message matches the configured query filter. Normalizes the email metadata and cleans the body text to create a consistent input for safety checks. Scores the email for prompt-injection risk using keyword and pattern matching and labels it as safe, review, or high risk. If the email is high risk, it skips Google Gemini, logs the event to Google Sheets, and creates a Gmail draft to request manual review. If the email is safe or review-level, it sends the email (wrapped as untrusted content) to Google Gemini to return a strict JSON triage including summary, intent, requested action, and a safe reply draft. Logs the Gemini results and final safety status to Google Sheets, then creates either a Gmail reply draft to the sender or a Gmail draft for the reviewer when human review is required. Setup Add credentials for Gmail, Google Gemini,
Triage Japanese freelance gig emails with Gmail, Gemini, Sheets, Drive, and Calendar
Quick overview This workflow monitors Gmail for Japanese side-gig inquiries, flags risky wording, and uses Google Gemini to extract details and score each request. It logs every opportunity to Google Sheets, then drafts an accept/clarify/decline reply and, for accepted work, creates a Drive folder, Docs templates, and a Calendar block. How it works Triggers every minute when a new Gmail message matching the configured Japanese inquiry search query arrives. Cleans and normalizes the email content, detects the likely source platform, and checks the subject/body for Japanese red-flag keywords to produce an initial risk score. Sends the normalized email plus freelancer settings to Google Gemini to extract structured project details, scores, red flags, and Japanese draft replies. Combines Gemini’s scores with keyword-based risk signals to decide accept/hold/decline, calculates a recommended minimum price from your hourly rate and minimum fee, and generates a project ID and safe project title. Appends the opportunity (scores, decision, red flags, and draft text) to a Google Sheets tracking spreadsheet. Routes by decision to create a Gmail draft for clarification questions (hold) or a pol
Schedule YouTube Shorts to Pinterest with Apify, Gemini, and an OpenAI model
Quick overview This workflow receives YouTube Shorts webhook events, downloads the video via Apify, uses Google Gemini and an OpenAI-compatible chat model to generate Pinterest SEO metadata and choose a board, then schedules a Pinterest video pin through Zernio (Late) for publishing. How it works Receives a webhook request for YouTube PubSubHubBub verification and responds with the provided hub challenge. Receives a POST webhook event for a new YouTube video and extracts the title, video ID, channel ID, and video URL from the feed payload. Uses Apify to fetch and process the YouTube Short and returns a downloadable MP4 URL. Sends the video to the Google Generative Language (Gemini) API to generate an analysis used for Pinterest-focused metadata. Uses a LangChain LLM chain (with structured output validation) to produce a Pinterest-ready title, description, hashtags, and a board selection from a fixed list. Maps the selected board name to a Pinterest board ID and schedules the video post to Pinterest via the Zernio (Late) API. Setup Create the YouTube webhook/PubSubHubbub subscription and configure it to call this workflow’s webhook URL at the manga-monarch-webhook path for both veri
Extract and validate invoice data with Google Gemini and Google Sheets
Quick overview This workflow accepts an invoice file via an n8n chat trigger, uses Google Gemini to extract structured invoice data, validates it against an existing Google Sheets log, appends valid line items to the sheet, and sends a formatted confirmation or failure alert via Gmail. How it works Receives a chat message with an uploaded invoice document. Uses Google Gemini to extract the vendor, invoice number, date, total amount, and all line items as a clean JSON object. Converts the extracted JSON into per-line-item records, builds an HTML invoice summary for email, and loads existing rows from Google Sheets for comparison. Validates each item by checking for missing critical fields and whether the invoice number already exists in Google Sheets. If validation passes, appends each line item as a new row in Google Sheets and then prepares a summary of the inserted data. Sends a Gmail message with the formatted HTML invoice breakdown when processing succeeds, or sends a Gmail alert email explaining the validation failure. Setup Add Google Gemini (PaLM) API credentials and ensure the chat trigger allows file uploads so the invoice is available as binary input. Connect Google Sheet
Handle real estate SMS inquiries with Twilio, Google Sheets, Gemini, and Calendar
Quick overview Youtube Explanation: https://youtu.be/e_07nGFmVs0 This workflow replies to inbound Twilio SMS messages with property details and viewing scheduling help by looking up leads and properties in Google Sheets, using a Google Gemini agent with Redis chat memory, and checking/booking appointments in Google Calendar. How it works Receives an inbound SMS via Twilio. Looks up the sender’s mobile number in a Google Sheets “leads_info” spreadsheet and appends/updates the lead record if it does not exist, extracting a 4-digit property code from the message when available. Splits any saved semicolon-separated property IDs into individual lookups, fetches matching property rows from a Google Sheets “Property details” spreadsheet, and compiles a summary of found vs. missing property codes. Sends the user message, lead context (saved property IDs and email), current time, and the property-lookup results to a Google Gemini chat agent with Redis-backed conversation memory. Lets the agent optionally use tools to fetch additional property info from Google Sheets, update the lead’s email or interested property IDs in Google Sheets, and check or create viewing events in Google Calendar. S
Vet community membership applications with Google Gemini, Telegram, and Sheets
Quick overview This workflow collects community membership applications via an n8n Form, vets each candidate with Google Gemini using Tavily web search and an Apify LinkedIn lookup, requests human approval in Telegram when needed, sends invite or rejection emails via Gmail, and logs outcomes to Google Sheets. How it works Receives a submission from an n8n Form that captures applicant details such as name, email, company, role, birthday, and additional notes. Normalizes the submitted fields and passes the candidate profile to a Google Gemini-powered AI Agent that can use Tavily web search, an Apify LinkedIn search actor, a calculator, and short-term memory. Produces a structured vetting result (including summary, decision status, and a community-fit score) using a structured output schema. If the AI decision is “Immediate approval”, sends the candidate summary to Telegram and waits for a response before continuing. If the AI decision is not “Immediate approval”, sends the summary to Telegram and asks the reviewer to reply with 1 (approve), 2 (reject), or 3 (do nothing). Sends an approval/invite email or a rejection email via Gmail based on the Telegram response, or stops without act
Run Bunker Guard NPC chat and RAG lore checks with Google Gemini and Google Drive
Quick overview This workflow powers dynamic character interactions for investigative games. It ingests lore from Google Drive into a vector database, using Google Gemini agents to generate daily briefings, spawn NPCs, and roleplay interrogations via a webhook. How it works Runs on a manual trigger to download a lore PDF from Google Drive, split it into chunks, create Google Gemini embeddings, and store them in an in-memory vector store for retrieval. Receives a POST webhook request from the game client containing game state and an action value (briefing, init, or chat). Routes the request based on action to either generate a morale-based daily intel briefing, create a new NPC profile for the day, or generate an in-character reply to the player’s interrogation message. When factual lore is needed (routes, locations, prices, rules, professions), the Gemini agent queries the Database_Bunker vector-search tool to ground the response in the ingested PDF. Maintains short conversation context per player using a buffer memory keyed by playerId for ongoing chat and NPC interactions. Returns the agent output to the caller as clean JSON via the webhook response. Optionally, triggers on an n8n
Track meal nutrition from photos with LINE, Google Gemini and Google Sheets
Quick Overview This workflow receives meal photos via LINE, uses Google Gemini to estimate nutrition facts and generate advice, stores the photo in Google Drive, logs the results to Google Sheets, and replies to the user in LINE with a formatted analysis. How it works Receives a POST webhook event from LINE when a user sends a message. Checks whether the incoming LINE message contains an image and stops processing if it does not. Downloads the image content from the LINE Messaging API and sends it to Google Gemini to identify foods, estimate nutrition values, and generate health guidance. If the AI response indicates the image is not food, sends a LINE push message asking the user to submit a clearer meal photo. If the AI response is valid, parses the returned text into structured fields (food items, macros, calories, score, and advice) and calculates remaining calories based on a daily goal. Uploads the meal photo to Google Drive, appends the nutrition log (including the Drive image URL) to Google Sheets, and sends the formatted nutrition summary back to the user via LINE. Setup Create a LINE Messaging API channel, enable the webhook, and add the workflow’s webhook URL (the /MealT
Re-engage dormant real estate leads with Google Sheets, Gemini and Gmail
Quick Overview This workflow runs daily to find dormant real estate leads in Google Sheets, uses Google Gemini to draft personalized winback emails, sends them via Gmail, updates the lead records, and then posts a run summary digest to Gmail and optionally to Slack. How it works Runs every day at 8am on a schedule. Pulls all lead records from a Google Sheets spreadsheet. Filters to leads that have an email address, are not marked “Do Not Contact,” and have not been contacted in at least 30 days. Processes each dormant lead in turn by prompting Google Gemini to generate a short re-engagement email subject and body based on the lead’s name, property interest, and days since last contact. Sends the generated message to the lead via Gmail and updates the corresponding row in Google Sheets (for example, tracking status and re-engagement attempt count). Aggregates the run results and sends a summary digest to a specified Gmail address and to a Slack channel. Setup Connect credentials for Google Sheets, Gmail, and Google Gemini (PaLM) API. Select the Google Sheets document and sheet name for both the lead fetch and lead update steps, and ensure your sheet includes fields like Email, Statu
Summarize Zoom meeting recordings in Notion with Smallest.ai and Gemini
Quick Overview This workflow receives Zoom recording webhooks, downloads the meeting recording, transcribes it with Smallest.ai, summarizes it with a Google Gemini-powered AI Agent, and saves the summary and action items as a new page in a Notion database. How it works Receives a POST webhook from Zoom and checks whether the event is Zoom’s endpoint URL validation challenge. For URL validation events, computes the Zoom CRC HMAC SHA-256 token and responds with the plain and encrypted tokens to verify the endpoint. For recording events, immediately acknowledges Zoom with a 200 OK response, then extracts the meeting topic, metadata, and an audio recording download URL from the webhook payload. Downloads the recording file from Zoom using the provided download token for authorization. Sends the downloaded audio to Smallest.ai to generate a full transcription. Uses a LangChain AI Agent with Google Gemini to produce a short meeting summary and a list of action items from the transcript. Creates a new page in a Notion database using the meeting topic as the title and the generated summary as the page content. Setup Create and configure a Zoom Event Notifications webhook (for a recording-c
Reply to Telegram voice messages with Smallest.ai and Google Gemini
Quick Overview This workflow listens for Telegram bot messages, detects voice audio, downloads the audio file, transcribes it with Smallest.ai, and uses a Google Gemini–powered AI agent to draft a helpful reply that is sent back to the same Telegram chat. How it works Triggers when a new message is received by your Telegram bot. Checks whether the incoming message contains a voice/audio attachment. Downloads the audio file from Telegram using the message’s file ID. Sends the audio to Smallest.ai Speech-to-Text to generate a transcription. Passes the transcription and chat ID to a LangChain AI agent backed by Google Gemini to generate a suggested reply. Sends the formatted response back to the originating Telegram chat. Setup Create a Telegram bot with BotFather, then add your Telegram credentials/token to the Telegram Trigger, file download, and Telegram reply tool nodes. Add your Smallest.ai API credentials to the transcription step. Add your Google Gemini (Google AI) credentials to the chat model used by the AI agent. Start the workflow and message your Telegram bot with a voice note to test the end-to-end transcription and reply.
Triage PubMed clinical literature with Gemini and Google Sheets and Docs
Quick overview Automatically retrieve recent PubMed articles, identify the three papers most worth reading first using AI, and generate structured clinical literature triage reports in Google Sheets and Google Docs. How it works Reads the first pending literature request from the Google Sheets "Search Requests" tab. Marks the request as “processing” in Google Sheets and builds the PubMed query parameters (keyword, max results, specialty, clinical question, and output language). Searches PubMed via the NCBI E-utilities API (esearch) and fetches the corresponding article abstracts and metadata as XML (efetch). Parses and normalizes the XML into a structured list of candidate articles including title, abstract, journal, publication year, DOI, and PubMed URL. Sends the aggregated candidate articles to Google Gemini to select and rank the best three papers and generate a structured clinical evaluation for each. Appends the three ranked papers with summaries and triage fields to a Google Sheets “Triage Results” tab. Generates a formatted triage report in Google Docs and updates the original request status to “completed” in Google Sheets. Setup Create a Google Sheets OAuth connection and
Process prescription orders and refills with Telegram, Google Gemini and Sheets
Quick overview This workflow lets customers order and refill prescriptions via Telegram by extracting medicines from prescription images with Google Gemini, checking and updating inventory in Google Sheets, and sending order summaries and status updates, with delivery updates handled by a webhook and error alerts posted to Slack. How it works Triggers when a Telegram message is received, normalizes it, and routes it based on whether it contains a prescription image/document or the REFILL, STATUS, or CONFIRM command. For prescription images/documents, it downloads the file from Telegram and uses Google Gemini vision to extract medicines, dosages, and quantities from the prescription. It looks up each extracted medicine in a Google Sheets Inventory tab, deducts stock for items that are available, and aggregates the priced order lines. It creates a new pending order in a Google Sheets Orders tab and sends the customer a Telegram order summary with the total and a prompt to reply CONFIRM. For STATUS/REFILL/CONFIRM messages, it reads the relevant order from Google Sheets, sends the current status via Telegram, creates a new pending refill order, or updates the pending order status to co
CResearch Reddit trends and publish LinkedIn posts with Gemini and PostPeer
Quick overview This workflow runs daily, scrapes a selected subreddit with Apify, researches sources via Brave Search and Jina Reader, and uses Eden AI (DeepSeek) plus Google Gemini to draft a LinkedIn post with an image. It logs state in Google Sheets/Drive, sends approval emails, and publishes via PostPeer. How it works Runs daily on a schedule, loads Global Constants, and picks an ACTIVE subreddit row from Google Sheets using a random ID. Scrapes recent posts from that subreddit using an Apify Reddit scraper, then normalizes, scores, and deduplicates candidates. Uses an Eden AI (DeepSeek) agent to vet the candidates and either selects one post idea or stops and records a NO_VIABLE_IDEA entry in Google Sheets and emails the rationale. For a selected idea, a second Eden AI (DeepSeek) agent generates a research brief and up to five Brave Search queries, then Brave Search and Jina Reader collect and extract a small set of non-social sources. A third Eden AI (DeepSeek) agent writes the LinkedIn draft and an accompanying image prompt, then Google Gemini generates the image. Uploads the image to Google Drive, writes the draft and metadata to a Google Sheets post log, and emails a two-s
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
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
Schedule and manage pet clinic visits with WhatsApp, Gemini, and HighLevel
Quick overview Youtube Video: https://youtu.be/81QSPEr5Yio?si=4EeaBFVofW0dK2Z_ This workflow handles pet clinic appointment conversations over WhatsApp, using Google Gemini for replies, Redis for chat memory, and GoHighLevel (LeadConnector) to look up or create contacts, save visit notes, and book, cancel, or reschedule calendar appointments. How it works Triggers when a new WhatsApp message is received. Validates the sender and ignores unsupported message types. Searches GoHighLevel for an existing contact that matches the sender’s WhatsApp phone number. Uses Google Gemini with Redis chat history and the contact context to chat with the owner, capture the pet’s issue, and save it as notes in GoHighLevel. Fetches available GoHighLevel calendar free slots for the requested weekday date range and presents times to the user. Creates or updates the GoHighLevel contact if required, then books the selected appointment, or fetches upcoming appointments to cancel or reschedule when explicitly confirmed. Sends the assistant’s formatted response back to the owner via WhatsApp. Setup Connect WhatsApp Cloud API credentials for both the WhatsApp Trigger and WhatsApp send action, and set your Wh
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
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
Cv Tailor + Cover Letter (Easybits)
On a form submission, extracts the uploaded CV with Easybits, tailors it and drafts a cover letter via Google Gemini, then saves to Google Docs.
Product Content Creation (WF3)
When called by a parent workflow, reads product rows from Google Sheets and generates marketing content with Google Gemini via an LLM chain.
AI News Agent - SaaS
On a schedule, a Google Gemini agent compiles RSS news into Postgres and S3, then distributes digests via Gmail, Slack, Telegram, and Twilio.