Google Sheets Workflows
4.090 Ergebnisse — 488 herunterladbare Workflow-Dateien, 3.602 quellenverknüpfte n8n-Referenzen
Telegram Court Agent
On a Telegram message, a Gemini agent logs to Google Sheets, sends Gmail, and replies on Telegram.
[MW] AI Customer Support Assistant - Cloud Version
On a new Gmail email, an OpenAI agent pulls context from Google Sheets and Drive and sends an automated Gmail reply.
Multi-language Customer Support Automation
On a WhatsApp or IMAP email message, translates it with Google Translate, logs to Google Sheets, and replies via WhatsApp or SMTP.
AI Powered Patient Pre Op Reminder & Nurse Alert System
On a schedule, pulls Google Calendar pre-op appointments, drafts AI reminders via Azure OpenAI, emails patients through Gmail, logs to Google Sheets, and alerts nurses in Slack.
Send weekly overdue invoice reminders with Google Sheets and Gmail
Quick Overview This workflow runs every Monday at 08:00, reads invoices from Google Sheets, filters for unpaid invoices with no prior follow-up and more than 7 days overdue, sends an HTML reminder email via Gmail, and updates the sheet to mark the invoice as followed up. How it works Runs every Monday at 08:00 on a schedule. Reads all invoice rows from a Google Sheets spreadsheet. Keeps only invoices where the status is “Impayé” and the “Date de relance” field is empty, then calculates the number of days overdue from the invoice date. Filters to invoices that are more than 7 days overdue. Sends a formatted HTML payment reminder email via Gmail with the invoice date, amount, and days overdue. Updates the matching Google Sheets row to set the status to “Relancé” and writes today’s follow-up date. Setup Add Google Sheets credentials and ensure the target spreadsheet contains columns like Statut, Date de relance, Date_Facture, Client, and Montant. Add Gmail credentials for the mailbox that sends reminders. Update the Google Sheets document URL/sheet selection and set the recipient address in the Gmail “sendTo” field (and optionally adapt the subject/body text).
Route real estate buyer and seller leads with Claude and Google Sheets
Quick Overview This workflow hosts an n8n lead-capture form, uses Anthropic Claude to score and classify real estate inquiries, then routes ready leads to Gmail and Google Sheets while logging early-stage leads to a separate Google Sheets tab. How it works Receives a new submission from an n8n Form trigger with contact details, intent, area, budget, timeline, financing status, and notes. Normalizes the submitted fields (for example trimming strings, lowercasing email, and adding a timestamp) for consistent downstream processing. Sends the normalized lead details to the Anthropic Messages API (Claude) to return a strict JSON classification, summary, timeline band, financing readiness, recommended agent role, and score. Parses the Claude JSON response, clamps the score to a 1–10 range, and calculates whether the lead is “ready” (score 7). If the lead is ready, sends a formatted Gmail alert to the agent and appends the lead to the “Active Leads” tab in Google Sheets. If the lead is not ready, appends the lead to the “Nurture Leads” tab in Google Sheets. Returns a confirmation message to the form submitter after the lead is routed. Setup Create an Anthropic HTTP Header Auth credential
Route law firm client intakes with Claude and Google Sheets
Quick Overview This workflow hosts an n8n intake form for a law firm, sends each submission to Anthropic Claude for classification and qualification, logs the result to Google Sheets, emails the intake team for qualified matters via Gmail, and returns a neutral confirmation page to the submitter. How it works Receives a client intake submission through an n8n hosted form. Normalizes the submission into consistent fields (contact details, matter type, incident date, and narrative). Sends the normalized intake to Anthropic Claude to classify practice area, assess urgency and time sensitivity, flag conflict-check needs, and decide whether the matter is qualified. Parses Claude’s JSON response and merges the analysis back into the intake record. If the matter is qualified, sends an HTML alert email via Gmail to the intake team and appends the intake details to the “Qualified Intakes” tab in Google Sheets. If the matter is not qualified, appends the submission and decline reason to the “Declined Intakes” tab in Google Sheets. Returns a confirmation message to the submitter stating the intake was received and that no attorney-client relationship has been formed. Setup Create an Anthropic
Analyze skill gaps for target jobs with BrowserAct, LinkedIn and GPT-4o-mini
Quick Overview This workflow collects a student’s skills and target role via an n8n Form, scrapes top LinkedIn job postings with BrowserAct, and uses OpenAI GPT-4o-mini to generate a skill gap report with courses and a 90-day plan, saving results to Google Sheets and emailing them via Gmail. How it works Receives a student submission from an n8n Form with name, email, target role, current skills, experience level, location, and weekly learning hours. Validates the inputs, converts the skills list into an array, and builds a LinkedIn job search URL for the chosen role and location. Uses BrowserAct to open the LinkedIn job search in a real browser and extract text from up to 20 job postings. Cleans and normalizes the scraped job text and combines it with the student profile data. Sends the student profile and job-posting text to OpenAI GPT-4o-mini to extract in-demand skills, identify missing skills with priority, recommend three free courses, and generate a 13-week learning plan. Parses the model output into labeled sections, calculates matched and missing skill counts, and appends the full report as a new row in Google Sheets. Sends a formatted HTML email via Gmail to the student w
Reconcile Google Drive invoice PDFs with OpenAI, Sheets, Slack and Gmail
How it works Watches a Google Drive folder and triggers automatically when a new invoice PDF is uploaded Extracts raw text from the PDF and passes each invoice through an OpenAI powered agent that returns structured fields like vendor, amount, due date, and line items Fans the enriched data to three parallel outputs: a Google Sheets log, a Slack alert for overdue invoices, and a weekly summary email to Finance via Gmail Set up steps Connect Google Drive, Google Sheets, Gmail, Slack, and OpenAI credentials (~15 minutes total) Works best with text based PDFs; scanned invoices need OCR upstream of the extraction step Keep full setup details and prompt tuning tips in the sticky notes inside the workflow
Fetch live commodity quotes with Octagon, OpenAI (GPT-5.4 Mini) and Google Sheets
Quick overview Automatically fetches live commodity quotes (gold, silver, crude oil, natural gas, and more) using an Octagon AI Agent, then writes prices, changes, ranges, volume, and moving averages back to a Google Sheet. How it works Reads commodity symbols (GCUSD, SIUSD, CLUSD, NGUSD, etc.) from a Google Sheet. Fetches the live commodities-quote Skill from GitHub and builds an Octagon Agent prompt for each symbol. Calls the Octagon Agent for real-time quotes and parses the response. Writes the price, change, ranges, volume, and moving averages back to the sheet. Setup Set aside about 5 minutes to complete the configuration. Connect your Google Sheets, OpenAI, and Octagon credentials. Point the Sheets nodes at your commodities sheet, making sure it has a Symbol or Ticker column. Ensure date ranges are in the Sheet. Review the sticky notes inside the workflow for detailed configuration notes. Requirements Google Sheets account and credentials OpenAI credentials (GPT-5.4 Mini) Octagon Agent credentials A Google Sheet with a Symbol or Ticker column Customization Add or remove commodity symbols in the sheet to track different markets Adjust which data fields (price, change, ranges,
Turn videos into Twitter threads, LinkedIn posts, and blogs with WayinVideo and GPT-4o-mini
Description Submit any video URL — podcast, webinar, interview, or YouTube video — along with the title, creator name, niche, target audience, and tone and the workflow transcribes the full recording automatically. WayinVideo's Transcription API returns a speaker-labeled, timestamped transcript which is sent to GPT-4o-mini in one call to produce all three content pieces simultaneously: a 10-tweet Twitter thread, a 200–300 word LinkedIn post, and a 600–800 word SEO blog post with HTML structure, meta description, and focus keyword. Word counts are tracked for all three pieces and everything is saved as one row in Google Sheets with Status set to Draft. Built for content marketers, solo creators, agencies, and social media managers who want to repurpose every video into three platform-specific pieces without writing anything manually. What This Workflow Does Transcribes the full video with speaker labels and timestamps** — WayinVideo's Transcription API returns every word spoken in the video with the speaker name and timestamp so GPT has full context to work from Generates all three content pieces in one GPT call** — The Twitter thread, LinkedIn post, and blog post are all produced t
Monitor SaaS contract renewals from Google Sheets and send Slack alerts
Your automated SaaS contract renewal monitor that sends multi-stage Slack alerts 45, 30, 14, and 7 days before each contract expires. Stop missing renewal deadlines and overpaying on auto-renewals. This workflow monitors your contract calendar in Google Sheets, sends progressive Slack notifications with manual research checklists, and tracks alert history to prevent duplicate notifications. You manage the vendors; it manages the reminders. This is not a generic reminder bot. It is a production-ready procurement intelligence system designed to give finance and operations teams the advance notice needed to research alternatives, negotiate better terms, and avoid costly auto-renewals. How the workflow works The workflow executes in four stages: 1. TRIGGER & SCHEDULE The workflow runs daily at 9:00 AM using a cron trigger (0 9 * * *). The schedule runs in your configured timezone (default: UTC). A single daily check scans your entire contract portfolio and identifies which renewals are entering their alert windows. 2. LOAD & VALIDATE Using Google Sheets' native integration, the workflow reads your contract tracking spreadsheet (columns A-F: Contract Name, Vendor Name, Renewal Date, Ann
Turn webinars into a 5-day email course using WayinVideo, GPT-4o-mini, and Google Sheets
Description Submit any webinar recording URL using a simple form along with your course name, target audience, brand name, and preferred email tone and the workflow builds a complete 5-day drip email course automatically. WayinVideo AI Clipping extracts the top 5 most engaging teaching moments from the recording, ranked by engagement score so the best content becomes Day 1. GPT-4o-mini then writes a complete email lesson for each clip — with subject line, preview text, email body, key takeaway, CTA text, and a CTA URL placeholder — where Day 1 is welcoming, the final day wraps up, and middle days flow naturally between them. All 5 emails are saved to Google Sheets as a ready-to-use drip course with Status set to Draft. Built for course creators, coaches, educators, and marketing teams who want to turn any webinar into a ready-to-send email sequence without writing a single word manually. What This Workflow Does Extracts the top 5 teaching moments by engagement score** — WayinVideo AI Clipping ranks moments by engagement and the workflow sorts them highest first so your best content always becomes Day 1 Assigns each clip to a day number automatically** — Clips are sorted and labeled
Automate employee onboarding with Groq, Gmail, Slack and Google Workspace
How it works New hire submits an onboarding form with their details Groq AI generates personalised welcome content, Slack messages, and IT access request Welcome email sent to the new hire via Gmail Automated emails sent to HR, the manager, and IT team Company Policy and Employee Handbook PDFs downloaded from Drive and attached Slack messages posted to #general and #hr-team channels Onboarding record appended to Google Sheets tracker Set up steps Estimated time: ~15 minutes Connect Groq API, Gmail, Slack, Google Drive, and Google Sheets credentials Upload your Policy and Handbook PDFs to Drive and link them in the Download nodes Select your Slack channels in the two Slack nodes Select your onboarding Google Sheet in the Append row node Activate the workflow and share the form link with new hires
Turn TikTok videos into Facebook posts using WayinVideo and GPT-4o-mini
Description Paste any TikTok, YouTube, or short-form video URL into a simple form along with your brand name, target audience, and preferred tone and the workflow automatically transcribes the content and writes a ready-to-publish Facebook caption. GPT-4o-mini follows ten Facebook engagement rules to write a hook, short paragraphs, a call to action, and up to 8 hashtags — then posts the caption directly to your Facebook Page feed via the Graph API. Every post is logged to Google Sheets with the Post ID, Post URL, character count, and Posted status. Built for social media managers, content creators, and brands who produce short-form video and want Facebook posts published automatically without rewriting captions manually. What This Workflow Does Transcribes any video into plain text** — WayinVideo processes the video and returns a clean spoken text version that GPT uses as the source for caption writing Writes a Facebook caption following 10 engagement rules** — GPT-4o-mini produces a hook, short paragraphs, a tone-matched body, a CTA, optional video link, and up to 8 hashtags Optionally includes the video link in the post** — If you choose Yes at form submission, the video URL is a
Convert podcasts to LinkedIn articles with WayinVideo and GPT-4o-mini
Description Submit your podcast or video URL using a simple form and the workflow automatically transcribes the full episode with speaker labels and timestamps. GPT-4o-mini then reads the transcript and writes a complete LinkedIn newsletter article — headline, 400–600 word body, five key takeaways, and hashtags — following seven LinkedIn readability rules. The finished draft is saved to Google Sheets with a Status of "Draft" so you can review and publish when ready. Built for podcast hosts, content marketers, and personal brand builders who want to turn every episode into a LinkedIn article without writing from scratch. What This Workflow Does Transcribes your podcast with speaker labels** — WayinVideo processes the full episode and returns each segment attributed to the correct speaker with timestamps Polls automatically until transcription is complete** — Waits 60 seconds then checks the status repeatedly every 30 seconds until the transcript is ready, with no manual monitoring needed Formats the transcript for AI analysis** — Structures every segment as speaker name with timestamp so GPT understands who said what and when Writes a complete LinkedIn article** — GPT-4o-mini produc
Audit multi-page CRO with GPT-4o-mini, Google Sheets, and Gmail alerts
Description Submit up to 3 landing page URLs using a simple form and the workflow audits each one automatically. For every page, GPT-4o-mini scrapes the content, scores it across five dimensions, identifies the top conversion issue, and generates five specific page fixes. Every result is logged to Google Sheets and pages that score below your alert threshold trigger an automatic Gmail alert with the full breakdown. Built for marketing managers, agency owners, and growth teams who need structured, repeatable conversion audits without spending hours reviewing pages manually. What This Workflow Does Scrapes and cleans each page automatically** — Fetches the raw HTML for every URL submitted, strips all scripts and styles, and prepares clean text for AI analysis Scores pages across five CRO dimensions** — GPT-4o-mini rates each page on overall conversion potential, CTA strength, trust score, and message clarity on a 1–10 scale Generates a letter grade per page** — Assigns A+ through F based on the overall score so you can rank pages at a glance Produces five page-specific fixes** — Every fix references actual content from the page and is scoped to be doable within 1–2 days — no generic
Pull bulk domain backlink profiles into Google Sheets with DataForSEO
This workflow helps you retrieve backlink profile data for a large list of domains without running separate audits for each one. On each manual run, the workflow reads your target domains from a Google Sheet and sends them as a batch request to the DataForSEO Bulk Pages Summary endpoint, which returns a comprehensive backlink overview for up to 1000 domains in a single call. For each domain, the workflow retrieves key backlink metrics, including the total number of backlinks, referring domains, domain rank, spam score, and more. After that, the results are mapped directly back to your spreadsheet. The result is a fast, scalable backlink analysis system that lets you analyze entire domain lists in seconds and keep your data organized without manual exports. Who's it for This workflow is perfect for SEO experts, link-building specialists, and digital agencies who need to quickly and at scale audit and compare backlink profiles across multiple domains. What it does This workflow automatically retrieves a full backlink summary for a list of domains specified in a Google Sheet and writes the results back to the spreadsheet. The retrieved backlink data includes backlink count, referring
Check job apply URLs and deactivate dead links in Postgres and Google Sheets
Keep your job listings database clean without manual checks. Every three days, this workflow fetches all active jobs from your Postgres database, runs each application URL through a validation check, identifies dead links via HTTP status codes and soft-404 redirect detection, then marks failed entries as inactive in both Supabase and Google Sheets simultaneously. Who it's for Teams running a job aggregator, career platform, or internal hiring tracker who store job listings in Postgres and want stale or broken apply links removed automatically — without waiting for user reports. How it works A Schedule Trigger fires every 3 days All active jobs are fetched from your Postgres (Supabase) database via a SQL query A Prepare URLs node filters out any rows with missing, malformed, or non-HTTP URLs before they're checked An HTTP Request node sends a HEAD request to each apply_url A Find Dead Jobs code node analyzes each response and flags a job as dead if: Status code is 404 or 410 DNS resolution fails (ENOTFOUND) Connection is refused (ECONNREFUSED) A 301/302/307 redirect points to a different path — indicating the job was removed and the ATS is silently redirecting (soft-404 detection) I
Aggregate multi-source job boards into Supabase and Google Sheets
Stop manually checking dozens of career pages. This workflow runs every morning, hits the public APIs of 8+ ATS platforms and job boards, normalizes every listing into a single clean schema, and syncs everything to Supabase and Google Sheets deduplicated and ready to query. Who it's for Job seekers, recruiters, or career platforms that want a consolidated, up-to-date feed of openings from specific companies without scraping, without API keys, and without paying for a jobs aggregator. How it works A Schedule Trigger fires daily at 8 AM IST A Company List code node defines all sources grouped by ATS type (Greenhouse, Lever, Ashby, Workable, SmartRecruiters, RemoteOK, and board APIs like Remotive, Himalayas, Arbeitnow, Jobicy) A Prepare Request node builds the correct API URL and headers for each source, including multi-page pagination for SmartRecruiters (up to 500 jobs via offset) and Himalayas (up to 500 via page param) An HTTP Request node fetches all sources in batches of 5 A Parse + Enrich + Filter node normalizes all divergent JSON structures into a unified schema — resolving ISO country codes, Indian city detection, salary parsing across all formats, and domain-based filtering
Generate 7 new LinkedIn posts from top Apify posts using OpenAI and save to Google Sheets
This workflow helps you turn your best-performing LinkedIn posts into a repeatable content creation system. It pulls LinkedIn post data from Apify, normalizes and ranks the posts by impressions, identifies the strongest-performing content, and sends the top posts to OpenAI for pattern analysis. Based on those insights, it generates 7 new LinkedIn post ideas, then saves both the insights and generated posts to Google Sheets for easy review and planning. It is ideal for founders, creators, consultants, marketers, and social media teams who want to use real LinkedIn performance data to guide new content creation with a faster and more structured workflow.
Monitor and optimize carbon emissions for ESG reporting with GPT-4o, Slack and Sheets
How It Works This workflow automates end-to-end carbon emissions monitoring, strategy optimisation, and ESG reporting using a multi-agent AI supervisor architecture in n8n. Designed for sustainability managers, ESG teams, and operations leads, it eliminates the manual effort of tracking emissions, evaluating reduction strategies, and producing compliance reports. Data enters via scheduled pulls and real-time webhooks, then merges into a unified feed processed by a Carbon Supervisor Agent. Sub-agents handle monitoring, optimisation, policy enforcement, and ESG reporting. Approved strategies are auto-executed or routed for human sign-off. Outputs are consolidated and pushed to Slack, Google Sheets, and email, keeping all stakeholders informed. The workflow closes the loop from raw sensor data to actionable ESG dashboards with minimal human intervention. Setup Steps Connect scheduled trigger and webhook nodes to your emissions data sources. Add credentials for Slack (bot token), Gmail (OAuth2), and Google Sheets (service account). Configure the Carbon Supervisor Agent with your preferred LLM (OpenAI or compatible). Set approval thresholds in the Check Approval Required node. Map Googl
Monitor and optimize carbon emissions for ESG with GPT‑4o, Slack and Google Sheets
How It Works This workflow automates end-to-end carbon emissions monitoring, strategy optimisation, and ESG reporting using a multi-agent AI supervisor architecture in n8n. Designed for sustainability managers, ESG teams, and operations leads, it eliminates the manual effort of tracking emissions, evaluating reduction strategies, and producing compliance reports. Data enters via scheduled pulls and real-time webhooks, then merges into a unified feed processed by a Carbon Supervisor Agent. Sub-agents handle monitoring, optimisation, policy enforcement, and ESG reporting. Approved strategies are auto-executed or routed for human sign-off. Outputs are consolidated and pushed to Slack, Google Sheets, and email, keeping all stakeholders informed. The workflow closes the loop from raw sensor data to actionable ESG dashboards with minimal human intervention. Setup Steps Connect scheduled trigger and webhook nodes to your emissions data sources. Add credentials for Slack (bot token), Gmail (OAuth2), and Google Sheets (service account). Configure the Carbon Supervisor Agent with your preferred LLM (OpenAI or compatible). Set approval thresholds in the Check Approval Required node. Map Googl
Send personalized LinkedIn connection requests with Google Sheets and Unipile
Send personalized LinkedIn connection requests automatically using n8n, Google Sheets, and Unipile — with built-in safety limits, duplicate prevention, and full invitation tracking. Scale your LinkedIn outreach without manually sending a single connection request. This workflow reads your leads from a Google Sheet, filters out already-contacted prospects, and sends each one a personalized connection note via LinkedIn — automatically, on a schedule, and safely within LinkedIn's limits. Built for founders, sales teams, and recruiters who want consistent LinkedIn outreach without repetitive manual work. Every request is tracked back to your sheet with its invitation ID and status, making follow-up workflows easy to build on top. Good to know Unipile pricing is based on the number of connected accounts, not per API call or per message sent. The base plan starts at €49/$55 per month and includes up to 10 linked accounts For this workflow, connecting one LinkedIn account counts as one account Unipile does not enforce usage limits — you can send as many requests as you need. However, LinkedIn itself applies its own rate limits and usage policies A 7-day free trial is available with all fe