Formula Cookbook

50 copy-paste recipes for real business problems. Each formula is ready to use. Just replace A1 with your data cell.

50
Recipes
6
Categories
0
Code Required

Text Processing

10 recipes
1. Summarize to One Sentence
Condense any text to a single sentence.
=AI("Summarize in exactly one sentence: " & A1)
Input
Long product review (200 words)
Output
"The product works well but shipping was slow."
2. Bullet Point Summary
Turn long text into 3-5 bullet points.
=AI("Summarize as 3-5 bullet points: " & A1)
Input
Meeting transcript or article
Output
- Key point 1\n- Key point 2\n- Key point 3
3. Translate to Any Language
Translate cell content while preserving meaning.
=AI("Translate to French, keep the tone: " & A1)
Input
"Welcome to our store!"
Output
"Bienvenue dans notre boutique !"
4. Professional Rewrite
Rewrite casual text in a professional tone.
=AI("Rewrite in a professional business tone: " & A1)
Input
"hey can u send me that thing asap"
Output
"Could you please send me that document at your earliest convenience?"
5. Grammar and Spelling Fix
Fix errors without changing meaning.
=AI("Fix grammar and spelling only, keep meaning: " & A1)
Input
"Their going to the store to by there supplys"
Output
"They're going to the store to buy their supplies."
6. Simplify Complex Text
Rewrite for a general audience (grade 8 level).
=AI("Rewrite at an 8th-grade reading level: " & A1)
Input
Technical jargon or legal text
Output
Plain English explanation
7. Expand Short Notes
Turn brief notes into full paragraphs.
=AI("Expand these notes into a clear paragraph: " & A1)
Input
"Q4 revenue up 15%, new product launch Dec"
Output
"Revenue grew 15% in Q4, driven by..."
8. Extract Key Quotes
Pull the most important quotes from text.
=AI("Extract the 2 most important quotes from: " & A1)
Input
Interview transcript or article
Output
"We plan to double revenue..." and "The market is ready..."
9. Tone Detector
Identify the tone of any text.
=AI("Describe the tone in 2-3 words: " & A1)
Input
"We're extremely disappointed with the delay."
Output
"Frustrated, formal, direct"
10. Word Count Reducer
Cut text to a target word count.
=AI("Rewrite in under 50 words, keep key info: " & A1)
Input
200-word paragraph
Output
Concise 40-50 word version

Analysis

9 recipes
11. Sentiment Score (1-5)
Numeric sentiment for charting and filtering.
=AI("Rate sentiment 1-5 (1=very negative, 5=very positive), number only: " & A1)
Input
"Absolutely love this product!"
Output
5
12. Sentiment Label
Categorize as Positive, Negative, or Neutral.
=AI("One word only - Positive, Negative, or Neutral: " & A1)
Input
"The service was okay, nothing special"
Output
Neutral
13. Topic Identifier
Determine the main topic of text.
=AI("What is the main topic in 3 words or fewer: " & A1)
Input
Article about remote work trends
Output
"Remote work trends"
14. Keyword Extractor
Pull top keywords from any content.
=AI("List 5 keywords, comma-separated: " & A1)
Input
Blog post about AI tools
Output
"AI tools, automation, productivity, SaaS, machine learning"
15. Custom Categorizer
Sort items into your custom categories.
=AI("Categorize as Bug, Feature Request, Question, or Praise: " & A1)
Input
"Can you add dark mode?"
Output
Feature Request
16. Urgency Scorer
Rate urgency for support ticket triage.
=AI("Rate urgency 1-5 (5=critical), number only: " & A1)
Input
"Our entire team is locked out of the system"
Output
5
17. Intent Detector
Classify user intent from messages.
=AI("Classify intent as: Purchase, Support, Inquiry, Complaint, Cancel. One word: " & A1)
Input
"I'd like to cancel my subscription"
Output
Cancel
18. Readability Scorer
Estimate reading level of text.
=AI("Estimate the grade reading level (e.g., 'Grade 8'), answer only: " & A1)
Input
Marketing copy or documentation
Output
Grade 10
19. Competitor Mention Detector
Check if text mentions competitor brands.
=AI("Does this mention any of these competitors: Slack, Teams, Zoom? Yes or No: " & A1)
Input
"We switched from Slack to your platform"
Output
Yes

Data Cleaning

8 recipes
20. Standardize Addresses
Normalize messy address formats.
=AI("Standardize to format: Street, City, State ZIP: " & A1)
Input
"123 main st nyc ny 10001"
Output
"123 Main Street, New York, NY 10001"
21. Extract Email from Text
Pull email address from unstructured data.
=AI("Extract only the email address, nothing else: " & A1)
Input
"Contact John at john@example.com or call 555-1234"
Output
john@example.com
22. Standardize Phone Numbers
Convert any phone format to (XXX) XXX-XXXX.
=AI("Format this phone number as (XXX) XXX-XXXX: " & A1)
Input
"555.123.4567" or "5551234567"
Output
(555) 123-4567
23. Name Standardizer
Fix capitalization and format of names.
=AI("Standardize this name to 'First Last' format: " & A1)
Input
"JOHN SMITH" or "smith, john a."
Output
"John Smith"
24. Company Name Normalizer
Convert abbreviations to official names.
=AI("Convert to the official company name (e.g., 'msft' = 'Microsoft'): " & A1)
Input
"GOOG" or "google llc"
Output
"Google LLC"
25. Date Format Standardizer
Convert any date format to YYYY-MM-DD.
=AI("Convert this date to YYYY-MM-DD format: " & A1)
Input
"March 15th, 2026" or "15/3/26"
Output
2026-03-15
26. Duplicate Checker
Determine if two entries are the same entity.
=AI("Are these the same company? Answer Yes or No: " & A1 & " vs " & B1)
Input
"IBM" vs "International Business Machines"
Output
Yes
27. Industry Classifier
Classify companies into standard industries.
=AI("Classify industry: Technology, Healthcare, Finance, Retail, Manufacturing, Other. One word: " & A1)
Input
"Stripe" or "payment processing platform"
Output
Technology

Business

9 recipes
28. Cold Email Generator
Personalized outreach emails from context.
=AI("Write a 3-sentence cold email to " & A1 & " at " & B1 & " about " & C1)
Input
Name + Company + Product
Output
Personalized 3-sentence email
29. Follow-Up Email
Generate polite follow-up after no response.
=AI("Write a brief follow-up email. Original topic: " & A1 & ". Days since sent: " & B1)
Input
Topic + days elapsed
Output
"Just wanted to check in regarding..."
30. Review Response Writer
Draft empathetic replies to customer reviews.
=AI("Write a helpful, empathetic response to this review in 2-3 sentences: " & A1)
Input
"Terrible experience, package arrived damaged"
Output
"We're truly sorry about the damaged package..."
31. Product Description
Marketing copy from features list.
=AI("Write a compelling 2-sentence product description from: " & A1)
Input
"Wireless, 40hr battery, noise cancelling"
Output
"Experience pure sound with 40 hours of..."
32. Meeting Summary
Structured summary from raw notes.
=AI("Create a meeting summary with: Attendees, Key Decisions, Action Items: " & A1)
Input
Raw meeting notes or transcript
Output
Structured summary with sections
33. Lead Score
Score sales leads from company info.
=AI("Score this sales lead 1-10, number only. Company: " & A1 & " Role: " & B1 & " Size: " & C1)
Input
Company + Role + Size
Output
8
34. SWOT Analysis
Quick competitive analysis for any company.
=AI("SWOT analysis in 4 bullet points for: " & A1)
Input
"Tesla"
Output
S: Brand strength... W: Delivery issues...
35. Job Description Writer
Generate JD from role and requirements.
=AI("Write a concise job description for: " & A1 & ". Requirements: " & B1)
Input
"Senior Engineer" + "Python, AWS, 5yrs"
Output
Formatted job description
36. Elevator Pitch
Create a one-paragraph pitch from details.
=AI("Write a 3-sentence elevator pitch. Product: " & A1 & " Audience: " & B1 & " Differentiator: " & C1)
Input
Product + Audience + Differentiator
Output
Compelling 3-sentence pitch

Creative

7 recipes
37. Blog Headline Generator
Three compelling headline options.
=AI("Write 3 blog headlines for the topic: " & A1)
Input
"productivity tools for remote teams"
Output
1. "7 Tools That..." 2. "Why Remote Teams..." 3. "The Ultimate..."
38. Social Media Post
Platform-optimized social content.
=AI("Write a LinkedIn post under 150 words about: " & A1)
Input
Article title or topic
Output
Engaging LinkedIn post with hook
39. Hashtag Generator
10 relevant hashtags for any content.
=AI("Generate 10 hashtags starting with #, comma-separated: " & A1)
Input
"New AI feature for spreadsheets"
Output
#AI, #GoogleSheets, #Productivity, ...
40. Email Subject Lines
A/B test-ready subject line options.
=AI("Write 3 email subject lines under 50 characters for: " & A1)
Input
"Product launch announcement"
Output
1. "It's here." 2. "Meet your new..." 3. "We built something..."
41. SEO Meta Description
Search-engine-optimized page descriptions.
=AI("Write a meta description under 155 characters for: " & A1)
Input
Page title or blog post
Output
155-character SEO snippet
42. Ad Copy Generator
Short ad copy for Google/Facebook ads.
=AI("Write Google Ads copy (headline under 30 chars, description under 90 chars) for: " & A1)
Input
Product or service name
Output
Headline: "AI in Sheets" Desc: "Add 20 AI functions..."
43. Product Tag Generator
E-commerce tags from product descriptions.
=AI("Generate 5 e-commerce search tags, comma-separated: " & A1)
Input
"Blue wool sweater, size M, v-neck"
Output
"blue sweater, wool sweater, v-neck, medium, knitwear"

Advanced

7 recipes
44. Multi-Cell Prompt
Combine multiple columns into one prompt.
=AI("Write a pitch for " & A1 & " targeting " & B1 & " highlighting " & C1)
Input
Product + Audience + Benefit
Output
Customized pitch using all 3 inputs
45. Conditional AI (Skip Empty Rows)
Only process rows that have data.
=IF(A1="","",AI("Summarize: " & A1))
Input
Sparse data with empty rows
Output
Results only where data exists
46. Role-Based Prompt
Add expert persona for better results.
=AI("Act as a senior data analyst. Interpret this data trend: " & A1)
Input
"Revenue up 20%, expenses up 35%"
Output
Expert analysis with insights
47. JSON Output Format
Get structured JSON for programmatic use.
=AI("Return as JSON with keys name, email, phone: " & A1)
Input
Unstructured contact text
Output
{"name":"John","email":"j@..."}
48. Comparison Table
Compare two items across dimensions.
=AI("Compare " & A1 & " vs " & B1 & " on: price, features, ease of use. Table format.")
Input
"Slack" vs "Teams"
Output
Formatted comparison table
49. Chain: Classify then Act
Use AI output to conditionally trigger more AI.
=IF(VALUE(B1)>=4, AI("Write urgent response to: " & A1), "Low priority")
Input
B1 = urgency score from recipe #16
Output
Response only for urgent items
50. Self-Review Chain
AI checks its own output quality.
=AI("Score this text 1-10 for clarity, number only: " & B1)
Input
B1 = AI-generated text from another column
Output
Quality score to filter/reprocess
Step-by-Step Tutorials Resources & Templates Documentation & FAQ Pricing Plans
WellerDeveler Home ToolStack CalcHub SheetSense PromptVault WriterTools ResumeKit AI Directory Mega Bundle