Google Sheets workflow'ları
4.090 sonuç — 488 indirilebilir workflow dosyası, 3.602 kaynağa bağlı n8n referansı
Mini Muhasebe with Telegram & Google Sheets — Google Gemini
On a Telegram message, Google Gemini parses the entry, saves it to Google Sheets, archives files to Google Drive, and replies in Telegram.
Mini Muhasebe with Telegram & Google Sheets
On a Telegram message, an OpenAI and Gemini agent records accounting entries in Google Sheets and replies with a summary in Telegram.
Operasyon Finans Ve Backoffice with Schedule & HTTP Request
On a schedule, fetches data over HTTP, summarizes it with Google Gemini, logs to Google Sheets, and posts alerts to Slack.
Envanter / Stok Yonetimi
On a schedule, checks inventory levels in Google Sheets and an OpenRouter agent emails low-stock alerts via Gmail.
Premium SEO with Google Sheets & Schedule
On a schedule, reads keywords from Google Sheets, drafts SEO content with OpenRouter and SerpApi, and publishes to Google Docs, WordPress, Notion, and Gmail.
Premium SEO
On a Google Sheets row change, queries DataForSEO SERP rankings, then filters, aggregates, and writes the results back to Google Sheets.
Invoice OCR Workflow & Telegram — OpenAI
On a Telegram invoice image, runs OpenAI OCR to extract the fields and appends the parsed data to Google Sheets.
Expenses Tracker (video)
On a form submission, fetches and batches expense entries, logs them to Google Sheets, archives files to Google Drive, and alerts Slack.
Invoice OCR Workflow & Telegram
When called by another workflow, extracts invoice data from a Telegram file with OpenAI and appends it to Google Sheets.
YouTube Strategist Agent
On a form submission, runs an OpenRouter and OpenAI agent that researches YouTube strategy, saves to Google Sheets and notifies Slack.
PPC Thievery & Google Drive
On manual trigger, fetches files from Google Drive, analyzes ad copy with OpenAI, and writes results to Google Sheets.
OpenAI to Google Sheets Automation
On a webhook request, runs an OpenAI agent that writes results to Google Sheets and returns a response.
AI Email Agent
On a chat message, runs an OpenAI agent that reads Google Sheets and sends emails via Gmail.
WCreate purchase orders from Google Sheets using Groq AI and Gmail
Quick overview This workflow runs every 15 minutes to read approved, new requisitions from Google Sheets, validate supplier and policy rules, call an LLM risk-assessment API via HTTP, then create a purchase order record, update requisition status, write audit logs, and notify the procurement team via Gmail. How it works Runs every 15 minutes on a schedule. Reads requisitions from Google Sheets and keeps only rows where ApprovalStatus is "Approved" and ProcessingStatus is "New". Looks up each requisition’s supplier in a Google Sheets supplier master sheet and merges the supplier details into the requisition. Stops processing for items that don’t meet the duplicate/eligibility criteria, and validates supplier status, contract status, compliance, and max spend limit. For validated requisitions, sends the requisition and supplier details to an LLM risk-assessment endpoint via HTTP and parses the JSON decision, risk score, and reason. Generates a purchase order number, appends the purchase order to a Google Sheets Purchase_Orders sheet, updates the requisition to "Processed", logs the outcome to an Audit_Logs sheet, and emails the procurement team via Gmail. For failed validations, appe
WAudit Asana task hygiene with Google Sheets and Slack scorecards
Quick overview This workflow runs every Monday at 8am to audit open tasks in an Asana project for missing assignees and due dates (optionally missing sections and descriptions), appends each flagged task to Google Sheets, and posts a weekly hygiene scorecard with key counts and top offenders to Slack. How it works Runs every Monday at 8am on a schedule trigger. Fetches tasks from the specified Asana project via the Asana API and keeps only open (incomplete) tasks. Checks each open task for missing assignee and due date (and optionally missing section and empty description) and prepares one audit row per task that fails any enabled rule. Appends the flagged task rows (including reason codes and task permalink) to a Google Sheets tab for a running audit log. Calculates weekly completeness metrics across all open tasks and formats a Slack scorecard including category counts, percent fully fielded, and top offenders. Posts the scorecard message to the configured Slack channel. Setup Add an Asana API credential and set the target Asana project GID in the configuration values. Add a Google Sheets OAuth2 credential, select the target spreadsheet and sheet/tab, and ensure the header column
Monitor procurement spend and risks with Google Sheets, Groq Llama and Gmail
Quick Overview This workflow runs every 15 minutes to pull procurement transactions and department budgets from Google Sheets, calculate spend utilization and forecasts, generate executive risk insights with Groq Llama, write dashboard records back to Google Sheets, and email critical-risk alerts via Gmail. How it works Runs every 15 minutes on a schedule. Reads procurement transactions and department budget/threshold data from Google Sheets and combines them by department. Aggregates spend per department, calculates utilization, remaining budget, projected monthly spend, vendor counts, pending transactions, and assigns SAFE/WARNING/CRITICAL risk levels. Uses Groq (Llama 3.1) to generate an executive-friendly risk analysis and recommendations for each department based on the calculated metrics. Builds organization-wide dashboard totals (spend, projections, alert counts, highest-spend and top-risk departments) and attaches workflow metadata. Formats the results into executive summary, department insight, and risk alert records and appends them into separate Google Sheets tabs. Sends a Gmail escalation email when a CRITICAL risk alert record is detected. Setup Connect Google Sheets O
Triage Gmail and draft email replies with OpenAI, Slack, and Google Sheets
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. Add an OpenAI credential and customize the two
Run AI employee onboarding with Groq, Google Workspace, and Gemini
Quick overview This workflow ingests onboarding documents from Google Drive into an in-memory vector store with Google Gemini embeddings, then runs a multi-channel onboarding chatbot powered by Groq, sends role-based welcome emails via Gmail when a new hire appears in Google Sheets, and schedules day 1/7/30 check-in emails. How it works Manually runs an ingestion flow that lists files in a specified Google Drive folder, downloads them, extracts text, and indexes them into an in-memory vector store using Google Gemini embeddings. Receives employee questions via n8n Chat (and optionally Slack or Telegram), normalizes the message into a single format, and rejects empty or overly long inputs. Uses a Groq LLM agent with per-user session memory to retrieve relevant excerpts from the in-memory company_docs knowledge base and generate a grounded answer, or directs the user to HR when no relevant content is found. Routes the assistant’s response back to the originating channel (n8n Chat, and optionally Slack or Telegram). Triggers every minute on updates to a Google Sheets “Hires” sheet, validates rows marked as Hired, and skips hires already present in the “Tracking” sheet. Builds a depart
Follow up on abandoned carts with WhatsApp and Google Sheets
Quick overview This workflow runs every hour to read abandoned cart rows from Google Sheets, sends a WhatsApp reminder (with a discount for high-value carts), and then updates the sheet to log the follow-up count and timestamp. How it works Runs every hour on a schedule trigger. Loads configuration values (sheet details, WhatsApp phone number ID, value threshold, discount settings, and follow-up rules). Fetches cart records from a Google Sheets worksheet. Filters to carts abandoned before the configured cutoff, not marked as purchased, and still under the maximum follow-up count. Sends a WhatsApp message via WhatsApp Business Cloud with a discount offer for carts above the high-value threshold, or a plain reminder for lower-value carts. Updates the matching row in Google Sheets to increment the follow_up_count and set last_follow_up_at to the current timestamp. Setup Add Google Sheets OAuth2 credentials and set the Google Sheet ID and sheet name in the configuration values. Add WhatsApp Business Cloud credentials and set your WhatsApp phone number ID in the configuration values. Ensure your Google Sheet includes the required columns: row_id, customer_name, phone_number, cart_value,
Qualify Facebook lead ads and send follow-ups with Gemini, Gmail, and Sheets
Quick overview Turn every Facebook ad lead into a qualified, followed-up prospect within seconds. AI scores their intent, sends a personalized email tailored to their score, logs campaign intelligence to Google Sheets, and alerts you instantly to hot leads before they consider a competitor. How it works Receives a lead submission via an n8n webhook (or the disabled Facebook Lead Ads trigger). Extracts and normalizes contact details, qualification answers, and Facebook campaign metadata into a consistent lead record. Sends the lead details to Google Gemini to classify the lead as Hot/Warm/Cold and generate a personalized follow-up email. Parses and formats the AI output, falling back to a default email draft if the response cannot be parsed. If an email address is present, sends the AI-written follow-up email to the lead using Gmail. Appends the lead, AI score, reasoning, and campaign fields to a Google Sheets log. If the lead is scored Hot, notifies the agent via Gmail and Slack, then updates the Google Sheets row to mark the agent as notified. Setup Credentials needed: Add credentials for Google Gemini (PaLM/Gemini API), Gmail OAuth2, Google Sheets OAuth2, Slack OAuth2 (optional),
Classify lead function and seniority in Google Sheets with Google Gemini
Quick overview This workflow reads contacts from Google Sheets, uses Google Gemini to classify each contact’s job function and seniority from their job title and company name, and writes the Function, Seniority, and Confidence Score back to the same sheet. How it works Starts manually when you click Execute workflow. Reads rows from a specified Google Sheets worksheet and maps your column headers to the workflow’s expected fields. Keeps only contacts that have a Job Title and no existing Seniority value. Normalizes job titles and company names, deduplicates identical Job Title + Company pairs, and batches the unique combinations to save LLM tokens. Waits between batches to respect rate limits, then sends each batch to Google Gemini to return Function, Seniority, and a confidence score for every original row ID. Parses Gemini’s JSON response and updates the matching rows in Google Sheets with Function, Seniority, and Confidence Score. Setup Add Google Sheets OAuth credentials and set the Google Document ID and Sheet ID in the Global Settings values. Add a Google Gemini (PaLM) API credential for the Google Gemini node. Ensure your sheet has columns for #, Job Title, Company Name (rec
Archive and index legal PDFs from Gmail with Gemini, Sheets and Google Drive
Quick Overview This workflow monitors Gmail for unread emails with PDF attachments, uses Google Gemini to extract Japan Electronic Books Preservation Act filing metadata, logs a searchable index in Google Sheets, and archives documents into Google Drive folders while notifying Slack when extraction or classification fails. How it works Polls Gmail hourly for unread emails that contain attachments and downloads the attached files. Extracts text from the first PDF attachment. Sends the extracted text to Google Gemini to pull out transaction date, counterparty, amount, and document type, and alerts Slack if the document text cannot be read. Builds an Act-compliant PDF filename from the extracted fields and checks that date, counterparty, and amount are all present. If required metadata is missing, posts a warning to a Slack channel to handle the document manually. If metadata is complete, appends a row to a Google Sheets “Document Index”, marks the Gmail message as read to prevent reprocessing, and uploads the PDF to the matching Google Drive folder (invoice/receipt/contract) or flags it in Slack if unclassified. Setup Connect credentials for Gmail, Google Gemini (PaLM) API, Google Sh
Match Japanese jGrants subsidies to your company with Gemini, Slack and Gmail
Quick Overview This workflow runs weekly to search the public jGrants API for open Japanese subsidies, scores each subsidy’s fit for your company using Google Gemini, logs results to Google Sheets, and notifies a Slack channel (and drafts a Gmail kickoff email) for strong matches. How it works Runs weekly on a schedule and loads your company profile details (industry, headcount, prefecture, investment plan, and search keyword). Calls the public jGrants subsidies API to retrieve currently accepting programs sorted by newest first, and posts to Slack if the search fails. Processes each returned subsidy individually and asks Google Gemini to produce a fit score, verdict (strong/possible/no), reasons, next steps, and a short summary. Normalizes the Gemini response into consistent fields, and posts to Slack if scoring fails for a subsidy. Upserts each scored subsidy into a Google Sheets tracker (keyed by subsidy ID) to avoid duplicates across weekly runs. Routes results by verdict: sends a detailed Slack alert and creates a Gmail draft for strong matches, posts a lightweight Slack message for possible matches, and flags unclear verdicts in Slack. Setup Add credentials for Google Gemini
Monitor Japanese business partners for registry changes with gBizINFO and Gemini
Quick Overview This workflow runs weekly to check Japanese business partners listed in Google Sheets against the gBizINFO corporate registry API, uses Google Gemini to assess the risk impact of detected changes, updates the stored partner snapshot, and escalates findings to Slack and Gmail based on materiality. How it works Runs every week on a schedule. Reads the partner list (including corporate numbers and last-known name/address) from Google Sheets. Queries the gBizINFO corporate registry API for each partner and posts a Slack message if the lookup fails. Compares the latest registry data to the stored snapshot to detect name, address, or closure/dissolution changes and continues only when changes are found. Sends the detected changes to Google Gemini to classify materiality (high/medium/low) with a short summary and recommended action, and posts a Slack message if the assessment fails. Updates the Google Sheets partner snapshot with the latest registry details so the change is recorded. Routes by materiality to notify Slack (medium/other), and for high materiality also posts a Slack alert and creates a Gmail draft requesting a credit review. Setup Create a Google Sheets spread