← Tools

Google Sheets

Online spreadsheets for organizing data and collaborating.

Official source ↗ · Source checked 2026-10-23

Check official pricing and availability. Model versions must be checked in each case.

Models, versions and aliases in cases

These labels share this page. Original identifiers are preserved; versions may differ in capability or availability.

Find a workflow with this tool →

Tasks covered in this library

121 tag-associated cases; tool roles have not all been reviewed. This is not the product’s full capability range.

Latest case update:2026-10-31

Workflows, prerequisites & evidence

Content & Creative

Auto-Summarize New Google Drive Documents into Google Sheets

Google Drive trigger → Google Docs content extraction → OpenAI summarization → Google Sheets append

Read the case’s method and prerequisites

Prerequisites: accessible n8n instance; configured Google Drive OAuth2, Google Docs OAuth2, and Google Sheets OAuth2 credentials. After importing the template, specify the Google Drive folder to watch and the target Google Sheet document. The workflow polls the folder every minute.

n8n · google-drive · google-docs · google-sheets

Associated by case tags. Verify costs, permissions and actual results in the case.

Sales, Marketing & Support

Auto-triage support tickets in n8n: OpenAI classification + HubSpot enrichment + Linear/Slack escalation

Webhook intake → normalize & dedupe → HubSpot contact enrichment → GPT-4o-mini classification & reply draft → route by urgency to Linear escalation, human review, or Gmail draft → Google Sheets audit log

Read the case’s method and prerequisites

Prerequisites: n8n instance (cloud or self-hosted); Slack OAuth2, Google Sheets OAuth2, Gmail OAuth2 credentials; HubSpot private app token, OpenAI API key, Linear API key. Create a Google Sheets 'Support Audit Log' sheet with a dedupeKey column. Import the template into n8n, replace all REPLACE_WITH_* placeholders, configure the webhook endpoint /ai-support-triage, and test with a single payload before activating.

n8n · slack · google-sheets · gmail

Associated by case tags. Verify costs, permissions and actual results in the case.

Sales, Marketing & Support

Scrape Competitor Reviews & Generate Ad Creatives with Bright Data & OpenAI

Input Amazon product URL → Bright Data scrapes reviews → OpenAI summarizes pain points & generates 1080×1080 image → Gmail sends to media buyers

Read the case’s method and prerequisites

Prerequisites: n8n instance; Bright Data account and API key; OpenAI API key; Google Sheets OAuth2; Gmail OAuth2. Copy the author's Google Sheets template first, then import the workflow JSON into n8n and update credentials. Runtime cost depends on Bright Data scraping volume and OpenAI usage.

n8n · Bright Data · Google Sheets · Gmail

Associated by case tags. Verify costs, permissions and actual results in the case.

Work & Operations

Daily Automated Executive Financial Briefing: Google Sheets + GPT-4o-mini + Notion + Telegram

Weekday 7 AM trigger → parallel fetch from 5 Google Sheets tabs → KPI calculation → GPT-4o-mini generates Telegram-formatted briefing → Notion archive + Telegram delivery → critical alert if revenue drops >10% → Slack error notification

Read the case’s method and prerequisites

Prerequisites: n8n instance (self-hosted or cloud); Google Sheets OAuth2 credential and 5 tabs (CashFlow, Revenue, Payroll, Subscriptions, Expenses); OpenAI API key; Notion integration and CFO Report database; Telegram Bot and target Chat ID; Slack OAuth2 and alert channel. Costs: OpenAI GPT-4o-mini billed by token; other services per their platforms. Not tested by this site; first run should be triggered manually for verification.

n8n · google-sheets · notion · telegram · slack

Associated by case tags. Verify costs, permissions and actual results in the case.

Software & DevOps

n8n Engineering Daily Digest: Jira + GitHub to Slack

Scheduled trigger → parallel Jira and GitHub fetch → OpenAI summary → Slack Block Kit post → optional Google Sheets log

Read the case’s method and prerequisites

Prerequisites: n8n instance; credentials for Jira Cloud, GitHub, OpenAI, and Slack; Google Sheets credential only if logging is enabled. Requires access to the Jira project, GitHub repo read scope (fine-grained token needs repo + pull-request read), and Slack channel post permission. Uses gpt-4o-mini with temperature 0.2 and maxTokens 2000.

n8n · google-sheets · github · slack

Associated by case tags. Verify costs, permissions and actual results in the case.

Life Admin & Home

Auto-send weekly personalized pet health tips with n8n, GPT-4o-mini, Gmail and Google Sheets

Google Sheets pet data → filter and age calculation → GPT-4o-mini climate-aware tips → Gmail delivery with logging

Read the case’s method and prerequisites

Requires: n8n instance; Google Sheets OAuth2 credentials; Gmail OAuth2 credentials; OpenAI API key. Two Google Sheets: Pets (master data) and Email_Log (send tracking). Default trigger: Mondays at 9am. Add 2-3 test rows and run manually before enabling schedule.

n8n · gmail · google-sheets

Associated by case tags. Verify costs, permissions and actual results in the case.

Sales, Marketing & Support

Auto-generate UGC product videos from Google Sheets with DALL·E, GPT-4 Vision, and Sora in n8n

Input: Google Sheets product list. Processing: DALL·E 3 image → GPT-4 Vision style analysis → Sora video generation → Google Drive upload. Output: completed rows with public links.

Read the case’s method and prerequisites

Prerequisites: n8n instance; Google Sheets OAuth2, Google Drive OAuth2, and OpenAI API credentials; a Google Sheet with columns Product Name / Description / Target Audience / Status / Image URL / Video URL / Error Message; Sora API access may be restricted. Costs: DALL·E 3 and Sora are usage-based.

n8n · google-sheets · google-drive · dalle-3

Associated by case tags. Verify costs, permissions and actual results in the case.

Sales, Marketing & Support

Poll Google Sheets leads, generate GPT-4o-mini summary, and draft Gmail outreach in n8n

Input: new or updated rows in Google Sheets; Process: OpenAI generates company summary and automation value prop, Gmail creates draft; Output: Gmail draft + status written back to Sheets

Read the case’s method and prerequisites

Prerequisites: an n8n instance (self-hosted or Cloud); valid credentials for Google Sheets, OpenAI, and Gmail; a sheet with columns FirstName, Company, Industry, Status, and AI Summary. Costs: OpenAI API usage billed by token; Gmail/Sheets typically within free tiers.

n8n · gmail · google-sheets

Associated by case tags. Verify costs, permissions and actual results in the case.

Sales, Marketing & Support

Auto-Generate TikTok / Reels / Shorts from Shopify Products

New Shopify product → Gemini reads image and builds Veo prompt → Veo 3.1 renders 8s 9:16 video → PostWire publishes to multiple platforms → Sheets logging + Gmail alerts

Read the case’s method and prerequisites

Prerequisites: accessible n8n instance; Shopify store with Admin API access token; Google AI Studio billing enabled for Gemini and Veo 3.1; PostWire account and API key; Google Sheets document with columns date, product, network, status, link, note; Gmail account. Import the workflow JSON into n8n, then configure credentials and variables per node instructions.

n8n · google-gemini · google-sheets · gmail

Associated by case tags. Verify costs, permissions and actual results in the case.

Sales, Marketing & Support

Generate UGC Ads from Google Sheets with Fal.ai Models (nano-banana, WAN2.2, Veo3) in n8n

Read a Google Sheet row → generate ad image (Gemini / nano-banana) → analyze image and expand scene → generate 5–8s video (Veo3 / WAN2.2) → upload to Drive and write link back

Read the case’s method and prerequisites

Prerequisites: n8n instance; Google Sheets / Google Drive OAuth2 credentials; Fal.ai API key (env var FAL_KEY); OpenAI / OpenRouter credentials. The Google Sheet needs columns: product | presenter | prompt | img_url | video_url. Drive files must be set to Anyone with link → Viewer. Start with Zone 0 to verify the image-only flow, then test Zone 1 + Zone 2 for the full image-to-video pipeline.

n8n · google-sheets · google-drive

Associated by case tags. Verify costs, permissions and actual results in the case.

Sales, Marketing & Support

Auto-Generate Lead Research Report After Booking

Cal.com trigger → Google Sheets LinkedIn lookup → Relevance AI scrape + Perplexity research → OpenAI profile & pain points → HTML report → Gmail delivery

Read the case’s method and prerequisites

Requires an n8n instance; configure Cal.com (or alternative booking tool) trigger, Google Sheets OAuth2, Relevance AI HTTP Header Auth, Perplexity API, OpenAI API, and Gmail OAuth2 credentials. Multiple Google Sheets nodes in the template should be merged into your actual database. The Filter node's default condition needs replacement.

n8n · gmail · google-sheets · perplexity · relevance-ai

Associated by case tags. Verify costs, permissions and actual results in the case.

Content & Creative

n8n Meal Assistant: Ingredient Cost Tracking, Leftover Recipes & Nutrition Diary

Receive a dish name via Webhook → AI Agents analyze ingredients, leftovers, and nutrition → Write to Google Sheets → Generate diary entry and push Twitter DM

Read the case’s method and prerequisites

Requires an n8n instance, a Google account with Sheets enabled, an OpenRouter API key, and a Twitter/X developer account able to send DMs. Import the workflow JSON into n8n, then configure the Webhook, Google Sheets document (with three sheets), OpenRouter credentials, and Twitter credentials. Adjust Agent prompts as needed.

n8n · google-sheets · twitter

Associated by case tags. Verify costs, permissions and actual results in the case.

Content & Creative

Auto-Repurpose Long-Form Content into Multi-Platform Social Drafts with n8n

Long text → webhook/RSS trigger → AI Agent generates multi-format content → code-level rule enforcement → Google Sheets queue → JSON response or Slack notification

Read the case’s method and prerequisites

Prerequisites: n8n instance (self-hosted or cloud); OpenAI API credential (openAiApi); Google Gemini API credential (googlePalmApi) as fallback; Google Sheets credential; Slack credential. Pre-create a Google Sheet with a Brand Voice tab (columns: Brand Name, Audience, Tone, Call To Action, Hashtags, Banned Words, Max Hashtags) and a Content Queue tab (columns: Draft ID, Created At, Source Title, Source URL, Channel, Draft, Characters, Status). Cost depends on chosen OpenAI model usage and n8n execution volume.

n8n · google-sheets · gemini · slack

Associated by case tags. Verify costs, permissions and actual results in the case.

Content & Creative

Auto-repurpose RSS blog posts into multi-platform social content with n8n

RSS feed → AI rewrite (SEO blog / LinkedIn / X thread) → Google Sheets calendar + Gmail draft + Slack notification

Read the case’s method and prerequisites

Prerequisites: n8n instance; OpenAI API key; OAuth credentials for Google Sheets, Gmail, and Slack. A Google Sheet with columns Date, Status, SEO Title, Source Link, Source Title, LinkedIn Post, Twitter Thread must be created beforehand. Each run consumes ~1 OpenAI call; output is saved as drafts and requires human review before publishing.

n8n · google-sheets · gmail · slack

Associated by case tags. Verify costs, permissions and actual results in the case.

Content & Creative

n8n Resume Screening & Behavioral Interviews with Gemini, ElevenLabs & Notion ATS

Applicant submits via Notion page → n8n extracts and parses resume → Gemini scores and creates ATS record → ElevenLabs AI voice interview → auto-writes assessment and audio back to Notion

Read the case’s method and prerequisites

Prerequisites: n8n instance (hosted or self-hosted), Notion account with free recruiting template, Google Drive/Sheets OAuth2 credentials, Google Gemini (googlePalmApi) credentials, ElevenLabs account with API key, Gmail and Calendly accounts for follow-up emails and scheduling. Template supports 3 requisitions in parallel by default; expandable.

n8n · google-drive · google-sheets · notion · gemini · elevenlabs

Associated by case tags. Verify costs, permissions and actual results in the case.