← 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

Build Consistent AI Character Images with n8n + Google Nano Banana + Kie.ai Upscaling

Manual trigger → create timestamped Google Drive folder and tracking sheet → GPT-4 generates scene prompt → Kie.ai NanoBanana creates image → poll status → 4× upscale with face enhancement → archive to Drive and update Sheets

Read the case’s method and prerequisites

Prerequisites: n8n instance; Kie.ai account and API token; OpenAI API key; Google Drive and Google Sheets OAuth2 credentials. Costs: Kie.ai per-call, OpenAI per-token, Google services usually within free tier. Note: the template hardcodes a Google Drive folder ID and 5 reference image URLs — replace these with your own before use.

n8n · google-drive · google-sheets

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

Content & Creative

Auto-generate LinkedIn, Facebook, and Bluesky posts with images from Google Sheets topics

Input: rows marked ready in Google Sheets; Processing: Gemini writes platform-specific copy and an image prompt, generates the image, then PostWire publishes; Output: post links written back to the sheet, email alert on failure

Read the case’s method and prerequisites

Prerequisites: n8n instance; PostWire account with social profiles connected; Google Sheets with columns topic, notes, status, posted_at, links, note; Google Gemini credentials for text and image models; Gmail credentials. Cost: Gemini text fits the free tier; Nano Banana image costs about 0.04 USD. PostWire free plan posts to 2 networks per post.

n8n · google-sheets · gmail

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

Content & Creative

Build a Self-Improving TikTok Carousel Workflow in n8n: Gemini Plans, fal.ai Renders, OpenAI Writes, Auto-Publishes

Input: product info + historical data sheet; Process: daily analytics refresh → Gemini generates strategy → fal.ai renders 4× 9:16 images → OpenAI writes caption → Upload-Post publishes; Output: published TikTok carousel + updated skill log

Read the case’s method and prerequisites

Requires an n8n instance, Google Sheets OAuth2, Google Gemini credentials, OpenAI API key, fal.ai API key (HTTP Header Auth), an Upload-Post account with TikTok connected, and the n8n-nodes-upload-post community node. Copy the provided Google Sheet template and paste its ID on first setup.

n8n · google-sheets · fal.ai · upload-post

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

Content & Creative

Auto-categorize Gmail and draft replies with Groq in n8n

Gmail trigger → field extraction → Groq AI analysis → JSON parsing → priority alert + Google Sheets logging → conditional draft reply

Read the case’s method and prerequisites

Prerequisites: n8n instance (self-hosted or cloud); Gmail OAuth2 credential (read emails + create drafts); Groq API key; optional Google Sheets OAuth2 credential. Cost: Groq API billed per token; n8n and Google APIs have free-tier limits.

n8n · gmail · google-sheets

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

Content & Creative

n8n Chatbot Appointment Scheduler with Google Calendar for Dental Assistant

Chat trigger → AI Agent collects patient info → checks Google Calendar availability → books appointment and logs to Google Sheets

Read the case’s method and prerequisites

Import the template into n8n, configure OpenAI API key and Google OAuth credentials, select the target Calendar and Sheets, fill in the AI Agent systemMessage, then test the chat flow. Requires an n8n instance and three credential types: openAiApi, googleCalendarOAuth2Api, googleSheetsOAuth2Api.

n8n · google-calendar · google-sheets

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

Money, Bills & Benefits

Auto-Classify Purchase Requisitions with Google Gemini and Route for Approval

Webhook ingestion → data validation → Gemini classification with confidence scoring → auto or manual approval → Sheets logging → Gmail/Slack notifications

Read the case’s method and prerequisites

Requires an n8n instance; configure Google Gemini (googlePalmApi), Gmail OAuth2, Slack OAuth2, and Google Sheets credentials. The webhook source must send a POST request with pr_id, requester, description, and amount.

n8n · gmail · google-sheets · slack

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

Sales, Marketing & Support

Clean company names in Google Sheets with n8n + GPT-4 Mini for better cold email personalization

Input: Google Sheet URL with a Company column → Process: LLM auto-removes suffixes, taglines, and formatting issues → Output: New "Cleaned Companies" sheet with polished company names

Read the case’s method and prerequisites

Prerequisites: n8n instance (self-hosted or cloud); Google Sheets OAuth2 credentials (edit access to target sheet required); OpenAI API credentials. Input sheet must include a column named "Company". Costs: OpenAI API charged by token; n8n charged by instance plan.

n8n · google-sheets

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

Sales, Marketing & Support

n8n Template: Apify + GPT-4 Deep Multiline Icebreaker Generator

Apollo search leads → multi-page website scraping & summarization → GPT-4.1 personalized cold-email openers → Google Sheets output

Read the case’s method and prerequisites

Prerequisites: n8n instance; Apollo.io search URLs; Apify account and API key; OpenAI API key; Google Sheets OAuth credentials. Create a Google Sheet with 'Search URLs' and 'Leads' tabs per the template schema, and update the document ID in all Google Sheets nodes. Author estimates 3–4 hours build time and ~$150/month operating cost (Apollo + Apify + OpenAI + email platform).

n8n · apify · google-sheets

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

Content & Creative

n8n Competitor Intelligence Workflow: Multi-Engine SERP Monitoring with AI Summaries

Input search query → multi-engine SERP scraping → AI extraction of competitor insights and keywords → structured JSON output to Google Sheets

Read the case’s method and prerequisites

Prerequisites: n8n Cloud or self-hosted instance; Thordata Scraper API Key (HTTP Bearer Auth); OpenAI API Key; optional Google Sheets OAuth2 credentials for export. Costs: Thordata API usage-based pricing, OpenAI token-based pricing; verify current rates with each provider.

n8n · google-sheets · thordata-scraper

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

Work & Operations

Convert Meeting Recordings to Structured Notes and Action Items

Meeting recording URL → AssemblyAI transcription → AI-generated notes → extract action items → log to Google Sheets

Read the case’s method and prerequisites

Prerequisites: n8n instance; AssemblyAI API key; Google Service Account credentials (googleApi type); OpenAI API key (optional, for AI nodes). Meeting platform must support webhook push for recording-ready events. Default due date is 7 days later.

n8n · google-sheets

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

Content & Creative

Build an AI Social Media Content Factory with n8n: LinkedIn + Facebook Image Generation & Human Approval

Brand form input → Nova AI generates 6 platform-tailored posts with image prompts → Imagen-4 image gen → Slack approval → Google Drive/Sheets archive → Late API scheduled publishing

Read the case’s method and prerequisites

Prerequisites: n8n instance (self-hosted or enterprise recommended); API keys and OAuth2 credentials for OpenRouter (GPT-5 Mini), Replicate (Google Imagen-4 Ultra / NanoBanana), Slack (bot + channel permissions), Google Drive, Google Sheets, and Late API (getlate.dev); optional Perplexity API for research enhancement. Costs depend on actual usage of each service.

n8n · perplexity · slack · google-sheets · google-drive · replicate

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

Content & Creative

Trigger, Generate, and Auto-Publish Social Posts via Telegram and OpenAI

Input: Telegram text message → Process: read Google Docs brand rules, OpenAI Agent drafts per platform, Telegram approval → Output: PostWire publishes to LinkedIn/Facebook/Bluesky/Mastodon, results logged to Google Sheets

Read the case’s method and prerequisites

Prerequisites: n8n instance; Telegram Bot (created via @BotFather); Google Docs/Sheets credentials; OpenAI API credential; SerpApi key (free tier sufficient); PostWire account and API key. Cost: per OpenAI and SerpApi pricing; PostWire requires registration and plan confirmation. Boundaries: template defaults to LinkedIn, Facebook, Bluesky, Mastodon; editable in the Read the posts node; AI-generated content requires approval before publishing.

n8n · telegram · google-sheets · google-docs · serpapi · postwire

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

Content & Creative

n8n Automated LinkedIn Lead Generation & AI Personalized Outreach (Apollo + Instantly)

n8n form submission → Apollo URL generation → Apify scrape → OpenAI enrichment → Google Sheets → Tavily company research → AI cold email → Instantly.ai campaign

Read the case’s method and prerequisites

Prerequisites: n8n instance (self-hosted or cloud); API keys for Apify, OpenAI, Instantly.ai, and Tavily; Google Sheets OAuth credentials and a writable spreadsheet. Cost reference: Instantly $38/mo, Apify $39/mo, Tavily free for first 100 leads then $0.08/lead, Apollo $1.20/1000 (deducted from Apify credit), GPT API ~<$0.10/100 leads. Note: the Google Sheets documentId in workflow.json is an example and must be replaced with your own document.

n8n · google-sheets · apify · tavily · instantly.ai · apollo

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

Money, Bills & Benefits

Automated PDF Invoice Processing & Approval Flow (n8n + OpenAI + Google Sheets)

PDF invoice → text extraction → GPT structured parsing → email approval → Google Sheets logging

Read the case’s method and prerequisites

Prerequisites: n8n instance; Google Drive, Gmail, Google Sheets OAuth2 credentials; OpenAI API Key. Copy the author’s Google Sheet template first. Input is a PDF invoice file; output is a Google Sheets row with approval status. Costs depend on OpenAI API usage and n8n hosting.

n8n · google-drive · gmail · google-sheets

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

Content & Creative

n8n Automated SEO Blog Publishing: Google Sheets to WordPress

Input Google Sheets row → AI research & planning → generate inline images → write HTML article → publish to WordPress with featured image

Read the case’s method and prerequisites

Requires an n8n instance, WordPress REST API credentials, OpenAI API key, Perplexity API key, Google Sheets OAuth2 access, and a Cloudinary unsigned upload preset. Optional Pexels API key for stock header images. The workflow triggers on a schedule and processes one unpublished row per run.

n8n · perplexity · google-sheets · wordpress · cloudinary

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