130+ Ready-to-Use Templates
Copy-paste AI and scraper formulas for every use case. E-commerce, SEO, lead gen, reviews, recruiting, real estate, ads, and more. Every one of our 63 custom functions has a template here.
Multi-step task? Just ask.
Every template below is a formula you can drag down a column. For one-off jobs, “clean this up, highlight outliers, and chart it”, the AI Chat Agent does it from one sentence.
Use Case Categories
Click on a category to explore available templates
E-commerce Templates
Amazon and eBay research, price checks, listings, and catalog copy
Amazon Product Research
Spill a table of matching Amazon products for any keyword
=AMAZONSEARCH("wireless earbuds", "US", "10001", 20)Amazon Price and Rating Lookup
Title, price, rating, and review count for a column of ASINs
=AMAZONPRODUCT(A2, "US", "10001")Amazon Buy Box Competition
Every third-party offer on an ASIN so you can see who you are pricing against
=AMAZONOFFERS(A2, "US", "10001")Google Shopping Price Check
Listings, prices, and merchants for a product across Google Shopping
=GSHOPPING(A2, "us")eBay Sold-Price Research
See what items actually sold for before you price yours. Background scraper.
=EBAYSOLD(A2, "EBAY-US", , 50)Trading Card Market Prices
Current TCGplayer market prices for cards and sealed product
=TCGPRICE("Charizard VMAX", "pokemon")Product Description Writer
Generate compelling product descriptions from basic info
=AITEXT("Write a compelling product description for an e-commerce listing. Product: " & A2)Product Categorization
Automatically classify products into categories
=AITEXT("Classify this product into one category: Electronics, Clothing, Home, Beauty, Sports, Toys. Product: " & A2)Amazon Title Optimizer
Rewrite titles with keywords buyers actually search
=AITEXT("Rewrite this product title to be SEO-optimized for Amazon. Keep under 200 characters. Title: " & A2)Bullet Point Generator
Create feature and benefit bullets for listings
=AITEXT("Create 5 compelling bullet points highlighting key features and benefits for: " & A2)Product Tag Generator
Generate search tags for better discoverability
=AITEXT("Generate 10 relevant search tags for this product. Product: " & A2)Product Comparison Writer
Highlight the differences between two products in a sentence or two
=AITEXT("Write a brief comparison highlighting differences between these two products: " & A2 & " vs " & B2)SEO & Content Templates
Bulk page audits, rank tracking, SERP snapshots, and on-page copy
Bulk Meta Title Audit
Pull the live title tag for every URL in a column
=GETMETATITLE(A2)Bulk Meta Description Audit
Pull the live meta description so you can spot missing or duplicate ones
=GETMETADESCRIPTION(A2)H1 Checker
Confirm every page has one clear H1
=GETH1(A2)H2 Outline Extractor
List the H2s on a competitor page to see how they structure the topic
=GETH2(A2)Full Heading Structure
Every heading on a page, in order, for a quick outline audit
=GETHEADINGS(A2)Page Audit in One Call
Title, description, and headings for a whole range of URLs at once
=PAGEDATA(A2:A20)Rank Tracking
Organic Google results for a keyword: title, URL, snippet
=GSEARCH(A2, "us")SERP Snapshot
Top web results for a query, one per row
=SERP(A2, 10)Keyword List SERPs
Top results in one row per keyword so you can drag it down a keyword column
=BULKSERP(A2, 5)Competitor Page Reader
Clean page text (up to 50K characters) you can feed into other formulas. Background scraper.
=VISIT(A2)Meta Title Generator
Create SEO-optimized page titles
=AITEXT("Write an SEO-optimized meta title (50-60 characters) for this page: " & A2)Meta Description Writer
Write compelling meta descriptions that drive clicks
=AITEXT("Write a compelling meta description (150-160 characters) with a call-to-action for: " & A2)Blog Idea List
Ten post ideas spilled down the column, one per row
=AILIST("10 blog post ideas about " & A2)FAQ Generator
Create FAQ sections for better search visibility
=AITEXT("Generate 5 frequently asked questions with concise answers about: " & A2)Sales & Lead Gen Templates
Find leads, enrich companies, verify emails, and write outreach
B2B Lead Finder
Contacts by job title, location, and industry. Background scraper.
=FINDLEADS({"VP of Sales"}, "New York", , "SaaS", 100)LinkedIn Company Enrichment
Industry, headcount, HQ, and specialties for a column of company URLs. Background scraper.
=LINKEDINCOMPANY(A2:A50)Website Contact Extraction
Crawl a site for emails, phone numbers, and social links. Background scraper.
=CONTACTINFO(A2:A50)Email List Validation
Deliverable, disposable, and role-based flags for every email. Background scraper.
=VALIDATEEMAIL(B2:B500)Local Business Prospecting
Name, rating, address, and phone for every match on Google Maps
=GMAPS("dentists in Austin TX")Company Fact Check with Web Search
Let the model search the web before answering
=AITEXT("What does this company sell and who is their CEO? Company: " & A2, , TRUE)Lead Qualification Scorer
Score leads based on your criteria
=AITEXT("Score this lead 1-10 based on: company size, industry fit, and engagement level. Lead info: " & A2)Email Signature Parser
Pull structured contact fields out of a pasted signature
=AITEXT("Extract name, email, phone, company, and title from this email signature: " & A2)Personalized First Line
Write a specific opening line from what you know about the lead
=AITEXT("Write a personalized, non-generic first line for a cold email based on: " & A2)Follow-up Email Writer
Draft follow-ups that reference the last conversation
=AITEXT("Write a brief follow-up email referencing our previous conversation about: " & A2)Objection Handler
Draft a response to a common objection
=AITEXT("Provide a professional, empathetic response to this sales objection: " & A2)Meeting Notes Summarizer
Turn raw notes into decisions and action items
=AITEXT("Summarize these meeting notes into key decisions and action items with owners: " & A2)Data Processing Templates
Classify, extract, clean, split, and normalize messy columns
Multi-Category Classifier
Sort text into predefined categories
=AITEXT("Classify into exactly one category (Billing, Technical, Account, Feature Request, General): " & A2)Entity Extractor
Pull names, companies, dates, and amounts out of free text
=AITEXT("Extract Person, Company, Date, and Amount from this text. Use N/A if not found: " & A2)Split Into Columns
Spill the pieces of a messy cell across the row
=AILISTH("Split into first name, last name, company: " & A2)Phone Number Normalizer
Standardize formats across a column
=AITEXT("Normalize this phone number to format (XXX) XXX-XXXX. Return INVALID if not possible: " & A2)Address Parser
Break addresses into street, city, state, and ZIP
=AITEXT("Parse this address into Street, City, State, ZIP. Use | as separator: " & A2)Sentiment Analyzer
Positive, negative, or neutral for every row
=AITEXT("Analyze the sentiment of this text. Return: Positive, Negative, or Neutral: " & A2)Duplicate Detector
Flag entries that are probably the same record
=AITEXT("Are these two entries likely duplicates? Return Yes, Likely, or No: " & A2 & " vs " & B2)Text Cleaner
Fix typos, spacing, and capitalization
=AITEXT("Clean this text: fix typos, remove extra spaces, standardize capitalization: " & A2)Language Detector
Identify the language of each row
=AITEXT("Identify the language of this text. Return only the language name: " & A2)Grab One Element From a Page
Pull whatever matches a CSS selector, like a price or a stock badge
=GETSELECTOR(A2, ".price")Paragraph Extractor
Every paragraph on a page, one per row, ready for further processing
=GETP(A2)Translation Templates
Translate columns, build multi-language tables, and adapt tone
Translate a Column
Source language is detected automatically
=AITRANSLATE(A2, "Spanish")Translate With a Known Source
Pin the source language when the text is short or ambiguous
=AITRANSLATE(A2, "German", "English")Locale-Specific Translation
Locale codes work too, so Brazilian Portuguese stays Brazilian
=AITRANSLATE(A2, "pt-BR")Multi-Language Table
Put language names in row 1, source text in column A, and drag one formula across and down
=AITRANSLATE($A2, B$1)Marketing Translation
Adapt idioms and tone for the target market
=AITEXT("Translate this marketing copy to German. Adapt idioms for the German market: " & A2)UI/UX Translation
Keep strings short enough to fit the button
=AITEXT("Translate this UI text to French. Keep it concise (similar length to original): " & A2)Formal/Informal Adapter
Choose the register for business or casual contexts
=AITEXT("Translate to Spanish using formal (usted) form for business context: " & A2)Translation Quality Checker
Review an existing translation against its source
=AITEXT("Review this translation for accuracy. Original: " & A2 & " Translation: " & B2)Glossary-Aware Translation
Force specific terms to stay consistent
=AITEXT("Translate to German. Use these terms: Dashboard=Dashboard, Settings=Einstellungen: " & A2)Product Listing Translation
Translate listings while keeping SEO keywords intact
=AITEXT("Translate this product listing to Japanese. Keep SEO keywords relevant: " & A2)Image, Audio & Video Templates
Generate images, describe photos, read text aloud, and make short videos
Product Image Generator
Generate a product shot from a description. Returns an image URL.
=AIIMAGE("Professional product photo on white background, studio lighting: " & A2)Social Media Image Generator
Create on-brand visuals for posts
=AIIMAGE("Vibrant Instagram-style image, modern aesthetic, no text overlay: " & A2)Logo Concept Generator
Draft logo directions to react to
=AIIMAGE("Minimalist logo design, vector style, for a company called: " & A2)Alt Text Generator
Accessible alt text for a column of image URLs
=GPTV(A2, "Write descriptive alt text under 125 characters. Do not start with Image of")Image Content Analyzer
List what the model sees in the image
=GPTV(A2, "List the main objects, colors, and text visible in this image")Product Photo Descriptor
Write listing copy straight from the photo
=GPTV(A2, "Describe this product for an e-commerce listing. Include color, material, features")Brand Consistency Checker
Check images against brand guidelines
=GPTV(A2, "Does this image match these brand guidelines? Colors: blue/white, Style: professional")Image Caption Writer
Captions and hashtags from the image itself
=GPTV(A2, "Write an engaging Instagram caption with 3 relevant hashtags for this image")Text to Speech
Turn a column of scripts into audio. Voices include alloy, nova, onyx, and shimmer.
=AISPEECH(A2, "nova")Product Video Generator
A short clip from a text description
=AIVIDEO("5-second 360 spin of " & A2)Pull Every Image From a Page
Every image URL on a page, one per row
=GETIMG(A2)Social Media Templates
Monitor Instagram, TikTok, Reddit, X, Facebook, and YouTube, then write posts
Instagram Post Monitoring
Recent posts for a list of usernames, no @ needed. Background scraper.
=INSTAGRAM({"nasa","natgeo"}, , 20)TikTok Hashtag Tracking
Recent videos for a hashtag. Profiles are blocked upstream, so use hashtags. Background scraper.
=TIKTOK(, {"fitness"}, 20)Reddit Listening
Top posts for a search inside a subreddit. Background scraper.
=REDDIT({"google sheets"}, "spreadsheets", "top", 50)X / Twitter Search
Latest posts for a term or hashtag. Background scraper.
=TWITTERSEARCH({"#sheets"}, "Latest", "en", 50)Facebook Page Posts
Recent posts from pages, groups, or profiles. Background scraper.
=FACEBOOKPOSTS({"https://facebook.com/nasa"}, 20)Facebook Comment Pull
Comments and replies under a list of post URLs. Background scraper.
=FACEBOOKCOMMENTS(A2:A5, 100, TRUE)YouTube Content Research
Videos, channels, views, and URLs for a search
=YTSEARCH(A2)YouTube Transcript
Full transcript of a video URL, ready to summarize. Background scraper.
=YTTRANSCRIPT(A2)LinkedIn Post Generator
Create engaging LinkedIn content
=AITEXT("Write a LinkedIn post with a hook, insight, and call-to-action about: " & A2)Twitter/X Thread Creator
Turn one idea into a numbered thread
=AITEXT("Create a 5-tweet thread with numbered tweets (1/, 2/, etc.) about: " & A2)Viral Hook Generator
Five scroll-stopping openers per topic
=AITEXT("Generate 5 scroll-stopping hooks (contrarian, curiosity, story) for: " & A2)Content Repurposer
Turn a blog post into a short LinkedIn post
=AITEXT("Repurpose this blog post into a LinkedIn post under 300 words: " & A2)Engagement Reply Writer
Reply to comments without sounding canned
=AITEXT("Write a helpful, friendly reply to this comment (not generic): " & A2)Video Summary From Transcript
Pair with YouTube Transcript: point it at the transcript cell
=AITEXT("Summarize this video transcript into 5 key takeaways: " & B2)Research & Analysis Templates
Trends, news, traffic estimates, encyclopedic lookups, and analysis
Google Trends Tracking
Interest over time for a term. Use "today 3-m", "today 12-m", or "today 5-y".
=GTRENDS(A2, "US", "today 12-m")What Is Trending Now
The trending searches in a country over the last 24 hours
=GTRENDING("US", 24)News Monitoring
Latest Google News articles for a topic, newest first
=GNEWS(A2, "us", "en", TRUE)Website Traffic Estimates
Traffic and engagement estimates for a column of domains. Background scraper.
=SIMILARWEB(A2:A50)Wikipedia Lookup
Article summaries and structured facts for a list of terms. Background scraper.
=WIKIPEDIA(A2:A20)Site Crawl
Crawl a site two levels deep and collect readable page content. Background scraper.
=CRAWL({"https://example.com"}, 50, 2)Flight Price Tracking
Flight options for a route and date
=GFLIGHTS("JFK", "LHR", "2026-10-01")Web-Searched Answer
Let the model search the web before answering
=AITEXT("What was the most recent funding round for " & A2 & "?", , TRUE)Competitor Analysis
Strengths, weaknesses, and market position
=AITEXT("Analyze this competitor: list 3 strengths, 3 weaknesses, and market position: " & A2)SWOT Generator
Structured SWOT from a short brief
=AITEXT("Generate a SWOT analysis (Strengths, Weaknesses, Opportunities, Threats) for: " & A2)Survey Response Analyzer
Sentiment, theme, and insight from open-ended answers
=AITEXT("Analyze this survey response. Extract: sentiment, main theme, actionable insight: " & A2)Interview Notes Synthesizer
Findings and notable quotes from raw notes
=AITEXT("Synthesize these interview notes into key findings and notable quotes: " & A2)User Persona Generator
Goals, pain points, and behaviors from research data
=AITEXT("Create a user persona with goals, pain points, and behaviors based on: " & A2)Reviews & Reputation Templates
Pull reviews from six platforms, then find themes and draft replies
Trustpilot Reviews
Reviews plus TrustScore, filtered to 1 and 2 stars from the last 3 months. Background scraper.
=TRUSTPILOT({"monday.com"}, {1,2}, "last3months", 200)Google Maps Reviews
Newest reviews for a list of Maps place URLs. Background scraper.
=GMAPSREVIEWS(A2:A5, 50, "newest")TripAdvisor Reviews
Hotel, restaurant, and attraction reviews with owner replies since a date. Background scraper.
=TRIPADVISOR(A2, 100, "2026-01-01")Booking.com Reviews
Guest reviews for a list of property URLs. Background scraper.
=BOOKINGREVIEWS(A2:A5, "newest", 100)App Store Reviews
iOS reviews by numeric app ID. Background scraper.
=APPSTOREREVIEWS({"389801252"}, "us", 200)Google Play Reviews
Android reviews by package name
=GPLAYREVIEWS("com.spotify.music")Review Theme Extractor
Top positive and negative themes across a batch of reviews
=AITEXT("Extract the top 3 positive and 3 negative themes from these reviews: " & A2)Review Summarizer
Three pros and three cons from a pile of reviews
=AITEXT("Summarize these customer reviews into 3 pros and 3 cons. Reviews: " & A2)Review Reply Writer
A reply that addresses the specific complaint or thanks the specific praise
=AITEXT("Write a short, sincere public reply from the business owner to this review: " & A2)Complaint Categorizer
Route complaints to the right team
=AITEXT("Classify this review complaint into: Product Quality, Shipping, Customer Service, Pricing, Other: " & A2)Recruiting & Jobs Templates
Scan job boards, enrich candidates, and draft descriptions and screens
Multi-Board Job Search
Indeed, LinkedIn, Glassdoor, and ZipRecruiter in one table, remote only. Background scraper.
=JOBSEARCH("Product Manager", "US", , , TRUE, 100)Indeed Listings
Indeed postings for a role and location. Background scraper.
=INDEEDJOBS("Data Analyst", "Austin, TX", "US", 50)Candidate Profile Enrichment
Public LinkedIn profile data for a column of profile URLs. Background scraper.
=LINKEDINPROFILE(A2:A50)Hiring Signal Posts
LinkedIn posts that match a phrase, like companies announcing openings. Background scraper.
=LINKEDINPOSTS({"we are hiring"}, 50)Job Description Writer
A full posting from a title and a few requirements
=AITEXT("Write a job description with responsibilities, requirements, and benefits for: " & A2)Resume Summarizer
Three-line summary of a pasted resume
=AITEXT("Summarize this resume in 3 lines: current role, years of experience, standout skills: " & A2)Skills Extractor
Comma-separated skills from a resume or job post
=AITEXT("Extract the technical and soft skills from this text as a comma-separated list: " & A2)Candidate Screening Score
Score fit against a job description in another cell
=AITEXT("Score this candidate 1-10 for the role. Job: " & $B$1 & " Candidate: " & A2)Salary Range Extractor
Pull the pay range out of a scraped posting
=AITEXT("Extract the salary range from this job posting. Return Not listed if absent: " & A2)Interview Question Generator
Role-specific questions from the job description
=AITEXT("Write 5 interview questions that test the key requirements in this job description: " & A2)Real Estate Templates
Zillow listings and comps, rental rate checks, and listing copy
Zillow Listing Search
Listings from a Zillow search URL. Run the search on zillow.com and paste the address bar URL. Background scraper.
=ZILLOWSEARCH(A2, , 200)Property Details and Zestimate
Full property detail, Zestimate, and last sold price from street addresses. Background scraper.
=ZILLOWHOME(, A2:A50)Local Agent and Vendor Map
Agents, inspectors, or contractors near a location with ratings and phones
=GMAPS("home inspectors in Denver CO")Short-Term Rental Rate Comps
Nightly hotel rates for a location and dates to benchmark a rental
=GHOTELS("Austin TX", "2026-10-01", "2026-10-05", "lowest_price")Listing Description Writer
Warm, specific listing copy from the facts
=AITEXT("Write a 120-word listing description for this property. Facts: " & A2)Neighborhood Summary
Let the model search the web for schools, transit, and amenities
=AITEXT("Summarize the neighborhood around this address: schools, transit, dining, parks. Address: " & A2, , TRUE)Comp Analysis
Compare a property against scraped comps
=AITEXT("Given these comparable sales, suggest a list price and explain briefly. Subject: " & A2 & " Comps: " & B2)Property Feature Extractor
Beds, baths, square feet, and year built from messy text
=AITEXT("Extract beds, baths, square feet, lot size, and year built. Use | as separator: " & A2)Listing Photo Descriptor
Describe a listing photo for the MLS or for alt text
=GPTV(A2, "Describe this property photo for a real estate listing in one sentence")Buyer Follow-up Email
A follow-up after a showing
=AITEXT("Write a short follow-up email to a buyer after a showing of: " & A2)Ad Intelligence Templates
Watch competitor ads on Meta and Google, then write and test your own
Meta Ad Library Monitor
Active ads for a page or keyword from the Meta Ad Library. Background scraper.
=FACEBOOKADS({"Nike"}, , "US", "active", 50)Google Ads Transparency
A company's ads from the Google Ads Transparency Center, from advertiser URLs. Background scraper.
=GOOGLEADS(A2:A5)Campaign Domain Availability
Check if a campaign domain is free to register
=DOMAINCHECK(A2 & ".com")Ad Angle Extractor
Name the angle a competitor ad is using
=AITEXT("What persuasion angle does this ad use (price, urgency, social proof, fear, aspiration)? Ad: " & A2)Headline Variants
Ten Google Ads headlines spilled down the column
=AILIST("10 Google Ads headlines under 30 characters for " & A2)Ad Copy Generator
Primary text for a Meta ad from a product and audience
=AITEXT("Write Meta ad primary text under 125 characters for " & A2 & " targeting " & B2)Description Line Writer
Google Ads descriptions that fit the 90-character limit
=AITEXT("Write 2 Google Ads descriptions under 90 characters each for: " & A2)Audience Persona From Ads
Infer who a competitor is targeting from their ad copy
=AITEXT("Based on this ad copy, describe the target audience: age, role, pain point. Ad: " & A2)Landing Page Message Match
Check the ad promise against the landing page headline
=AITEXT("Does this landing page headline match the ad promise? Return Match or Mismatch and why. Ad: " & A2 & " Headline: " & B2)A/B Variant Generator
Three variations of a winning ad to test next
=AITEXT("Write 3 variations of this ad that keep the offer but change the hook: " & A2)How It Works
Copy the Formula
Find a template that matches your use case and copy the formula.
Paste & Adjust
Paste into Google Sheets and change A2 to your data column. Scrapers spill a table below the cell, so leave that space empty.
Drag to Fill
Drag the formula down to process every row. Background scrapers show a loading placeholder for up to a minute, then fill in.
Why Use Templates?
Save Hours of Prompt Engineering
Every prompt and scraper call here has been tested against the live function signatures, so you can paste it and go.
Consistent Results at Scale
Process thousands of rows with the same quality. No more inconsistent outputs from ad-hoc prompts.
No Coding Required
Just copy, paste, and adjust the cell reference. If you can use a spreadsheet, you can use SheetMagic.
Works with Any AI Model
Use GPT-4o, Claude, Gemini, or any model you prefer. Our templates work across all providers.
Ready to supercharge your spreadsheets?
Join 6,400+ users who are automating their workflows with AI in Google Sheets. Install SheetMagic and start using these templates today.
Try SheetMagic Free