Google Sheets AI Templates

40+ free AI templates for Google Sheets: product descriptions, translation, lead enrichment, SEO briefs, ad copy, data cleaning and more. Copy the formulas and go.

Ready-made recipes for GPT for Sheets: copy the formulas, drag them down your rows, done. Every template uses built-in AI functions — =GPT(), =CLAUDE(), =GEMINI(), =PERPLEXITY(), =SERP() — with no API keys required.

E-commerce & content

• Bulk Product Descriptions — unique descriptions for 1,000 products with tone and keyword control.
• Amazon Product Listings — titles, bullets and descriptions built from product attributes.
• Product Titles Optimization — normalize messy titles to marketplace length and style rules.
• Bulk Translation — localize a catalog into 100+ languages with a two-formula matrix.
• Review Responses — on-brand replies to customer reviews, matched to sentiment.
• FAQ Generator — FAQ blocks for product and service pages at scale.
• Blog Post Outlines — H2/H3 outlines and intros from a keyword list.
• Content Repurposing — turn one post into tweets, LinkedIn posts and newsletter blurbs.
• Rewrite & Humanize Text — bulk rewriting and paraphrasing with tone control.
• Press Release Drafts — announcement drafts from launch facts.

Social media

• Social Media Content Calendar — a month of platform-specific posts from one =GPT_TABLE() call.
• Instagram Captions — captions with hashtags from a topic or product column.
• YouTube Titles & Descriptions — titles, descriptions and tags from topics or transcripts.
• Hashtag Research — platform-specific hashtag sets per topic.

SEO

• SEO Meta Titles & Descriptions — length-safe metas for hundreds of pages.
• SEO Content Briefs — intent, outline, entities and FAQs from one keyword.
• Keyword Clustering & Intent — turn a raw keyword export into a content plan.
• Keyword Intent Mapping — map keywords to intent and funnel stage, SERP-validated.
• SERP Competitor Analysis — analyze top-10 titles and angles per keyword with =SERP().
• Programmatic SEO Pages — one row = one landing page; export to Webflow, WordPress and others.
• Bulk Image Alt Text — descriptive alt text from image context and product data.
• Internal Linking Suggestions — anchor texts and targets from your own URL list.
• FAQ Schema Markup — FAQPage JSON-LD blocks generated from Q&A columns.

Ads & email

• Google Ads Copy — RSA headlines (30 chars) and descriptions (90 chars) that fit.
• Email Subject Lines — A/B subject variants from the email body or offer.
• Landing Page Copy Variants — headline, subhead and CTA variants for A/B tests.
• UTM Campaign Builder — consistent UTM naming and final URLs from campaign attributes.
• Cold Email Personalization — personalized first lines from research columns.

Sales & data

• Lead Enrichment — company research, classification and emails; the spreadsheet-native Clay alternative.
• Lead Scoring — score leads 1–10 against your ICP with a reasoning column.
• Company Research — firmographics per company with web-aware =PERPLEXITY().
• LinkedIn Outreach Lines — personalized connection notes and InMail openers.
• CRM Notes Summarization — messy call notes into next-step summaries.
• Data Cleaning — extract, normalize and classify messy imports without regex.
• Contact Data Cleaning — normalize names, titles and phones; split full names.
• Deduplication & Normalization — flag near-duplicates and normalize company names.
• Sentiment Analysis — classify reviews and NPS comments by sentiment and theme.
• Support Ticket Classification — route tickets by category and urgency.
• Competitor Monitoring — summarize competitor pages and changelogs into a tracker.
• Web Scraping & SERP — pull top Google results per keyword and extract facts.
• Survey Coding for Market Research — code open-ended answers into themes.
• Candidate Screening — screen CVs against job requirements with score and rationale.

How these work

1. Install GPT for Sheets from the Google Workspace Marketplace — the free tier is enough to try every recipe.
2. Open a template page, paste the formulas, adjust prompts to your data.
3. Generation runs at up to 10,000 results per hour; when done, use Replace all GPT formulas with results.

Want step-by-step workflows? See the playbooks. Need the full function list? See the function reference in the docs.