Google Gemini Workflows
1.419 Ergebnisse — 128 herunterladbare Workflow-Dateien, 1.291 quellenverknüpfte n8n-Referenzen
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
Label incoming Gmail messages with Google Gemini and Telegram alerts
Quick overview This workflow polls Gmail for new emails, uses Google Gemini via an n8n AI text classifier to categorize each message by subject and snippet, and automatically applies the matching Gmail label, sending a Telegram alert if classification errors occur. How it works Checks Gmail every minute for new emails using the Gmail Trigger. Sends the email subject and snippet to a Google Gemini-powered text classifier to assign a category (Personal, Job, Study Related, Bank, Social, OTP, or Misc). Adds the corresponding Gmail label to the message in Gmail based on the predicted category. Sends a Telegram message to the configured chat ID if the classifier step produces an error. Setup Connect your Gmail account using Gmail OAuth2 and ensure the trigger has access to the mailbox you want to label. Add a Google Gemini (PaLM) API key credential for the AI classification step. Create (or choose) the target Gmail labels and replace the label IDs in each “addLabels” action with your own. Add Telegram bot credentials and set the correct chat ID in the Telegram message step (or disable it if you don’t want error alerts).
Post daily motivational quote images to Telegram with Gemini and HTML to Image
Quick overview This workflow runs daily on a schedule, uses Google Gemini to generate a short motivational quote and author, renders it into an image via htmlcsstoimg.com, and posts the resulting photo to a Telegram channel. How it works Runs once per day at the configured hour using a schedule trigger. Sends a prompt to Google Gemini to generate an original motivational quote and an author name in a strict two-line format. Extracts the quote and author from the Gemini response and falls back to default values if parsing fails. Calls the htmlcsstoimg.com API to render the quote and author into a styled 1080×1080 image using an HTML/CSS template. Sends the generated image URL to Telegram and posts it as a photo to the configured channel. Setup Add Google Gemini (PaLM) API credentials in n8n for the quote generation step. Create a Telegram bot with @BotFather, add it as an admin to your target channel, and connect the bot token as a Telegram credential in n8n. Sign up for an htmlcsstoimg.com API key and set it in the HTTP request header as CLIENT-API-KEY. Replace @your_channel_username with your Telegram channel username and adjust the schedule time and quote prompt as needed.
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
Convert Telegram messages to to-do lists with Gemini and Notion
Quick overview This workflow turns incoming Telegram bot text messages into a numbered to-do list using Google Gemini, saves the result as a new page in a Notion database, and replies to the user in Telegram with the same extracted task list. How it works Triggers whenever your Telegram bot receives a new message. Checks whether the incoming message contains text and ignores non-text updates. Sends the message text to Google Gemini to extract a clean, numbered to-do list (or returns “No tasks found.”). Creates a new page in a Notion database and stores the extracted to-do list. Sends the extracted to-do list back to the user in the original Telegram chat. Setup Create a Telegram bot with @BotFather, add your Telegram credentials in n8n, and use the trigger’s webhook/connection to start receiving updates. Add a Google Gemini (PaLM) API credential for the AI extraction step. Add a Notion credential, select the target database, and ensure it has suitable properties to store the page title and extracted to-do content.
Transcribe and analyze sales meetings with Deepgram, Gemini, GHL, Slack & Gmail
Quick overview Youtube Video: https://youtu.be/GNAplBWdCDE?si=TjojVTZX7ViiRUiG This workflow receives meeting voice recording via webhook, transcribes it with Deepgram, and uses Gemini to extract client details and next-step tasks. It then updates GoHighLevel, posts a task summary to Slack, emails the client their action items via Gmail, and logs the meeting to Sheets. How it works Receives a POST webhook request containing a meeting ID, attendee email, meeting date/time, and an audio file. Looks up the contact in GoHighLevel by email and creates/updates the contact if it does not already exist. Checks Google Sheets for the meeting ID and only continues if no existing row is found. Sends the audio binary to Deepgram to transcribe the recording with speaker diarization and utterances enabled. Formats the transcript and sends it to a Google Gemini–powered agent that returns structured JSON with client identification and task lists. Creates a GoHighLevel task with the extracted service-provider tasks, posts the task summary to Slack, and emails the client their tasks via Gmail. Appends the meeting details, extracted company name, and action items to Google Sheets and returns a webhook
Generate personalized financial plans with Google Gemini, Sheets, Drive and Gmail
Quick overview This workflow receives income and financial-goal data via webhook, stores enriched metrics in Google Sheets, generates a tailored plan with Google Gemini, converts it to a PDF via PDFShift, uploads it to Google Drive, and emails the result using Gmail. How it works Receives a POST webhook request containing an Income value and a Goal string. Normalizes the incoming fields and validates that income is non-negative and the goal is not empty, returning a webhook error response if validation fails. Calculates a timestamp, a recommended monthly saving amount (20% of income), and an income category (Low/Mid/High), then appends the record to Google Sheets. Routes the request by income category and uses Google Gemini (PaLM) to generate a personalized financial plan with category-specific guidance. Builds an HTML report that includes the user’s inputs and the Gemini-generated plan, then converts the HTML to a PDF using the PDFShift API and fetches the generated file. If the PDF is created successfully, uploads it to Google Drive, emails the PDF and Drive link via Gmail, and returns the HTML report in the webhook response. If PDF generation fails, returns a JSON error response
Draft Gmail reply drafts automatically with Google Gemini
Quick overview This workflow watches for new Gmail messages, uses Google Gemini to draft a concise reply based on the email content, and saves the response as a Gmail draft in the original thread for you to review before sending. How it works Triggers every minute when a new email is received in Gmail. Sends the email subject, sender, and snippet to Google Gemini with instructions to write a professional reply under 100 words matching the sender’s tone. Creates a Gmail draft containing the generated reply and sets the subject to “Re:” while attaching it to the original email thread. Setup Connect a Gmail OAuth2 credential and ensure the trigger has access to the inbox you want to monitor. Add a Google Gemini (PaLM) API credential for the Gemini chat model. Review the reply prompt and the Gmail trigger polling interval, then activate the workflow. No additional setup is required the workflow is ready to run as soon as both credentials are connected.
Generate dividend income reports via Telegram with Google Gemini
Quick overview This workflow listens for Telegram messages, validates the sender, parses an investment amount and risk strategy, builds a predefined dividend ETF/stock allocation, calculates estimated yield and income, and uses Google Gemini to format a concise portfolio report that it sends back in Telegram. How it works Triggers when a new Telegram message is received. Checks the Telegram chat ID against an allowlist to ensure only an approved user can run the workflow. Parses the message text into investment capital and a strategy (conservative, moderate, or aggressive) and sends a Telegram “typing” action while processing. Builds a strategy-based portfolio from predefined tickers and allocations, enriches each holding with preset dividend yield and risk values, and calculates invested amount plus monthly and annual income per holding. Aggregates the holdings into a single portfolio summary with total income and overall portfolio yield. Uses Google Gemini via an AI Agent prompt to generate a Telegram-ready report based strictly on the calculated portfolio data. Sends the formatted DividendIQ report back to the configured Telegram chat. Setup Create a Telegram bot with @BotFather
Track expenses from phone notifications with Google Gemini and Google Sheets
Quick overview This workflow receives phone push notification through FlowTrigger mobile app, extracts the transaction amount and date, uses Google Gemini to categorize the expense and adds it to a Google Sheets transactions log. How it works Receives a POST webhook request containing a captured notification payload from FlowTrigger mobile app. Parses the notification data and skips the flow if no amount is detected in the notification payload. Sends the notification title and body to Google Gemini and parses a structured response with cleaned merchant name, expense category, reasoning, and ISO currency code. Appends the date, amount, category, currency, and merchant to a selected Google Sheets tab. Returns a success response with the saved fields, or an error response if the AI categorization or Google Sheets write fails. Setup Create and connect a Google Gemini API key credential for the Google Gemini Chat Model. Create and connect a Google Sheets OAuth2 credential, then set the Google Sheets Document ID and Sheet Tab Name in the Google Sheets append step. Activate the workflow, copy the Webhook production URL from the Webhook trigger, and paste it into FlowTrigger’s Notification
Qualify Product Hunt leads with Google Gemini, Apify, and Google Sheets
Quick overview Youtube Video: https://youtu.be/h47YeiivZvs?si=V-S1X-ME5V24Tuch This workflow runs daily to pull the latest Product Hunt posts, qualifies them with Google Gemini, scrapes ICP-matching product websites with Apify to find emails, then writes the lead data to Google Sheets and creates contacts in GoHighLevel. How it works Runs every day on a schedule trigger. Queries the Product Hunt GraphQL API for the latest posts and iterates through each result. Resolves each product’s website redirect target, extracts a clean domain, and filters out blocked domains like app stores, social networks, and link aggregators. Sends the product name, tagline, and description to a Google Gemini–powered agent to score ICP fit and keeps only matches. Uses Apify to crawl each matched website and extract email addresses from the site content. Groups scraped results by domain, keeps only products with at least one email, and appends or updates a matching row in Google Sheets. Creates a GoHighLevel contact using the first email and stores any additional emails in a custom field. Setup Add Product Hunt OAuth2 credentials and ensure the GraphQL query in the Product Hunt request returns the fields
Track Slack EOD updates and post executive summaries with Google Sheets and Gemini
Quick overview Youtube Video: https://youtu.be/AbkX2splTTg?si=LTHqLFIWQD4hAYsO This workflow collects end-of-day updates from team members in Slack, stores them in Google Sheets, and posts a concise executive summary back to Slack using Google Gemini. How it works Runs daily at 3pm, reads the team roster from Google Sheets, filters out people marked as on leave, and sends each active member an EOD update form in Slack. Receives Slack button/form submissions via a webhook, parses the interactive payload, and replaces the original message with a confirmation. Checks whether the submitted EOD date matches today’s date, and sends a private Slack alert to the owner if someone submits late. For on-time submissions, reads today’s entries from the EOD submissions Google Sheet, deduplicates by user and date, and appends the new submission to Google Sheets. Runs daily at 5pm, reads today’s submissions and yesterday’s “tomorrow plan” entries from Google Sheets and merges them per user. Aggregates the merged data, calculates attendance and expected submission counts from the team roster, and sends the dataset to Google Gemini to generate an executive summary. Posts the generated Slack-formatte
Grade system prompts in Google Sheets with a Gemini LLM judge
Quick overview This workflow manually grades a system prompt by running it against a sample user task with Google Gemini, then has a second Gemini judge score the prompt (1–10) and write the grade and reason back to Google Sheets. How it works Starts when you run the workflow manually. Reads the prompt list from a Google Sheets spreadsheet and keeps only the last row as the system prompt under test. Sets a fixed sample customer-support task and sends it to a Google Gemini-powered agent using the sheet prompt as its system instructions. Sends the original prompt, the sample task, and the agent’s response to a second Google Gemini judge that returns a structured grade and short justification. Updates the same Google Sheets row with the returned grade and reason. Setup Connect a Google Sheets OAuth2 credential with access to the target spreadsheet. Connect a Google AI Studio (Gemini) credential for the candidate model, grader model, and parser-fixer model. Ensure your sheet has columns for at least prompt, grade, and reason, and that the workflow can match rows using the row_number field. Update the spreadsheet ID/sheet and edit the sample task text if you want to test prompts against
WPublish weekly SMB blog posts with Perplexity, Claude, Gemini, Supabase, and Gmail
Quick overview This workflow runs weekly to generate, research, write, illustrate, and publish a new blog post by combining Supabase (content + storage), Perplexity (topic + research), Anthropic Claude (writing), Google Gemini (cover image), and Gmail (notification). How it works Runs every Friday at 10:00 (cron: 0 0 10 * * 5). Fetches titles of already published posts from Supabase and builds a rotating topic focus that avoids repeating prior angles. Uses Perplexity to propose one fresh, SEO-relevant blog topic and then research it with trends, examples, and SMB-focused insights. Sends the topic and research notes to Anthropic Claude to write a complete post with title, excerpt, meta description, category, read time, and HTML body. Parses the generated text into structured fields, generates a slug, and prepares a published blog post record. Uses Google Gemini to generate a 16:9 cover image, uploads it to Supabase Storage, and attaches the public cover image URL to the post. Inserts the finished post into the Supabase blog_posts table with status set to published and emails the team via Gmail with the publication details. Setup Create a Supabase project with a blog_posts table and
Extract ecommerce product data with Google Sheets, ScrapingBee and Gemini
Quick Overview This workflow manually runs to read a list of webpage URLs from Google Sheets, scrape each page with ScrapingBee, and use Google Gemini to extract structured product data from screenshots with an HTML fallback, then append the results back into a Google Sheets sheet. How it works Runs when you manually trigger the workflow. Reads the list of URLs to scrape from a Google Sheets spreadsheet. Fetches a full-page screenshot for each URL using the ScrapingBee API. Sends the screenshot (and the URL for context) to a Google Gemini model to extract product details into a structured JSON format, calling a ScrapingBee HTML fetch tool when screenshot extraction is incomplete. Converts any fetched HTML to Markdown and returns it to the Gemini agent to complete the extraction. Splits the extracted product array into individual items and appends them as new rows in the Google Sheets “Results” sheet. Setup Create a Google Sheets service account connection in n8n and set the target spreadsheet and the “List of URLs” and “Results” sheet selections. Add a Google Gemini (PaLM) API credential in n8n and ensure the selected model (gemini-1.5-pro-latest) is available for your account. Add
AI Lead Machine Agent
On a form submission, extracts lead details with Google Gemini and OpenAI, saves to Google Sheets, and sends emails via Gmail.
Gemini Data-Table Agent
On manual trigger, runs a Google Gemini agent over batched data-table rows, calling HTTP APIs and sub-workflows with structured output.
Postgres, Google Gemini & OpenAI Automation
On a form submission, an AI agent using Gemini and OpenAI enriches data via Bright Data and stores it in Postgres.
Google Maps Business Scraper & Lead Enricher with Bright Data & Google Gemini
On manual run, scrapes Google Maps businesses via HTTP, enriches leads with Google Gemini, and saves structured results to Google Sheets.
Telegram Sales Agent For Business
On a Telegram message, runs a Gemini sales agent that classifies intent, queries Google Sheets, and replies via Telegram.
AI Powered Automated Outreach Scheduling Using Gemini, Gmail & Spreadsheets
On a schedule, fetches data via HTTP, reads Google Sheets, and sends Gemini-generated outreach emails through Gmail.
Zoho CRM - Smart Meeting Scheduler
On a Zoho CRM trigger, checks Google Calendar availability and emails a Gemini-drafted meeting confirmation via Gmail.