Funzioni IA/ChatGPT
🤖OpenAI ChatGPTIn Google Sheets

ChatGPT nel Tuo Foglio di Calcolo

Porta l'IA più popolare al mondo direttamente in Google Sheets. Veloce, creativa e incredibilmente versatile — a una formula di distanza.

contenuto-chatgpt.gsheet
ABC
1InputFormulaRisultato
2Product launch brief
3Wireless earbuds specs=UNLIMITED_AI(A3&" - Amazon listing", "gpt4")Title + 5 bullet points
4SaaS product description=UNLIMITED_AI(A4&" - email sequence", "gpt4")3-email nurture flow
Perché ChatGPT?

L'IA che fa le cose

ChatGPT è l'IA più versatile al mondo. Risposte rapide, output creativo ed eccellente nel seguire le istruzioni.

Ultra Veloce

GPT-4o fornisce risposte in millisecondi. Elabora centinaia di righe senza aspettare.

🎨

Eccellenza Creativa

Creatività ineguagliabile per copy marketing, idee di contenuto e generazione di testo coinvolgente.

📋

Output Strutturato

Eccelle nella generazione di JSON, CSV, tabelle e dati formattati con precisione.

🌐

Maestro Multilingue

Prestazioni superiori in oltre 95 lingue per traduzione e localizzazione.

💻

Generazione Codice

Genera formule, script, pattern regex e contenuti tecnici con precisione.

💰

Economico

GPT-4o-mini offre un valore incredibile — IA potente a una frazione del costo.

Confronto

Quando scegliere ChatGPT

Caso d'UsoChatGPTAltri
Scrittura creativa e marketing⭐⭐⭐⭐⭐⭐⭐⭐
Elaborazione batch veloce⭐⭐⭐⭐⭐⭐⭐⭐
JSON e output strutturato⭐⭐⭐⭐⭐⭐⭐⭐
Traduzione multi-lingua⭐⭐⭐⭐⭐⭐⭐⭐
Generazione codice e regex⭐⭐⭐⭐⭐⭐⭐⭐
Descrizioni prodotti⭐⭐⭐⭐⭐⭐⭐⭐
Email e copy pubblicitario⭐⭐⭐⭐⭐⭐⭐⭐
Esempi

ChatGPT in azione

Formule reali, risultati reali. Scopri perché ChatGPT eccelle nelle attività creative e di marketing.

Marketing CopySocial Media Campaign
Formula
=UNLIMITED_AI("Create 5 engaging social media posts for: " & A1, "gpt4")
Input
New eco-friendly water bottle launch, made from recycled ocean plastic
Output GPT
AI
📱 SOCIAL MEDIA POSTS 1. 🌊 "Every sip makes a difference. Our new bottle is made from plastic rescued from our oceans. Drink responsibly. #OceanHero" 2. 🐢 "1 bottle = 5 plastic bottles saved from the sea. Math we can all get behind. Shop now 🔗" 3. 💧 "Plot twist: The plastic polluting our oceans? Now it's keeping you hydrated. Full circle moment ♻️" 4. 🌍 "Your new water bottle has a better backstory than most people. Just saying. #SustainableLiving" 5. 🌀 "From ocean waste to your gym bag. Some glow-ups are just *chef's kiss* 💋"
Product ContentAmazon Listing Optimization
Formula
=UNLIMITED_AI("Write an optimized Amazon product title and 5 bullet points for: " & A1, "gpt4")
Input
Bluetooth wireless earbuds, 40hr battery, ANC, IPX7 waterproof, touch controls
Output GPT
AI
🛒 AMAZON LISTING TITLE: Premium Wireless Earbuds - 40 Hour Battery, Active Noise Cancelling, IPX7 Waterproof, Touch Control Bluetooth 5.3 Earphones for iPhone & Android BULLET POINTS: • 🔋 40-HOUR PLAYTIME: 8hrs per charge + 32hrs with case. Never miss a beat during long flights, commutes, or workouts • 🔇 ADVANCED ANC: Block out 95% of ambient noise. Focus on your music, calls, or podcasts anywhere • 💧 IPX7 WATERPROOF: Sweat, rain, splash-proof. Perfect for gym, running, or outdoor adventures • 👆 INTUITIVE TOUCH: Play, pause, skip, volume, calls - all at your fingertips. No fumbling for your phone • 🎵 PREMIUM SOUND: 13mm drivers deliver deep bass and crystal highs. Hear your music the way artists intended
Data FormattingJSON Structure Generation
Formula
=UNLIMITED_AI("Convert this to a structured JSON object: " & A1, "gpt4")
Input
John Smith, CEO at TechCorp, john@techcorp.com, San Francisco, 15 years experience, Stanford MBA
Output GPT
AI
{ "name": { "first": "John", "last": "Smith" }, "professional": { "title": "CEO", "company": "TechCorp", "experience_years": 15 }, "contact": { "email": "john@techcorp.com", "location": "San Francisco" }, "education": { "degree": "MBA", "institution": "Stanford" } }
TranslationMulti-Language Translation
Formula
=UNLIMITED_AI("Translate to Spanish, French, German, and Japanese: " & A1, "gpt4")
Input
Welcome to our store! Get 20% off your first order.
Output GPT
AI
🌍 TRANSLATIONS 🇪🇸 Spanish: ¡Bienvenido a nuestra tienda! Obtén 20% de descuento en tu primer pedido. 🇫🇷 French: Bienvenue dans notre boutique ! Profitez de 20% de réduction sur votre première commande. 🇩🇪 German: Willkommen in unserem Shop! Erhalten Sie 20% Rabatt auf Ihre erste Bestellung. 🇯🇵 Japanese: ようこそ!初回注文で20%オフ。
Email MarketingEmail Sequence Generator
Formula
=UNLIMITED_AI("Create a 3-email nurture sequence for: " & A1, "gpt4")
Input
SaaS project management tool, targeting small business owners
Output GPT
AI
📧 EMAIL NURTURE SEQUENCE EMAIL 1 (Day 0) - Welcome Subject: You're in! Here's how to 10x your productivity Body: Quick win - show them the dashboard, one killer feature CTA: "Start your first project" EMAIL 2 (Day 3) - Value Subject: How [Customer] saved 10 hrs/week (you can too) Body: Case study, specific results, relatable story CTA: "See how it works" EMAIL 3 (Day 7) - Convert Subject: Your trial ends soon (don't lose your data) Body: FOMO + special offer, urgency CTA: "Upgrade now - 20% off"
TechnicalRegex Pattern Generator
Formula
=UNLIMITED_AI("Create a regex pattern with explanation to match: " & A1, "gpt4")
Input
US phone numbers in any format (xxx-xxx-xxxx, (xxx) xxx-xxxx, xxxxxxxxxx)
Output GPT
AI
🔧 REGEX PATTERN Pattern: ^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$ Explanation: • \(? - Optional opening parenthesis • ([0-9]{3}) - Capture 3 digits (area code) • \)? - Optional closing parenthesis • [-. ]? - Optional separator (dash, dot, space) • ([0-9]{3}) - Capture 3 digits • [-. ]? - Optional separator • ([0-9]{4}) - Capture 4 digits Matches: ✓ 555-123-4567 ✓ (555) 123-4567 ✓ 555.123.4567 ✓ 5551234567
Casi d'Uso Potenti

Attività complesse, risultati istantanei

ChatGPT trasforma dati grezzi in insight azionabili e contenuti creativi.

E-commerce Product Analysis

Turn product data into optimized listings and pricing insights

Formula=UNLIMITED_AI("Analyze products. Suggest pricing strategy, identify bestseller potential, write taglines", "gpt4")
INPUTI tuoi dati grezzi
SKUProductCostCurrent PriceUnits SoldReviews
A001Bamboo Cutting Board$8$24.991,2474.8 (892)
A002Silicone Spatula Set$4$14.993,8914.6 (2,103)
A003Cast Iron Skillet$22$49.995674.9 (445)
A004Knife Sharpener$6$19.992,1564.3 (1,567)
A005Spice Rack Organizer$12$34.994234.1 (234)
OUTPUT GPTRisultati istantanei
🛍️ E-COMMERCE PRODUCT ANALYSIS 💰 PRICING INSIGHTS: • Silicone Spatula: 275% margin, HIGH volume → Winner • Cast Iron Skillet: 127% margin, BEST reviews → Premium position • Knife Sharpener: 233% margin, dropping reviews → Price test down 🏆 BESTSELLER POTENTIAL: 1. Silicone Spatula Set ⭐⭐⭐⭐⭐ Volume king, good margins, solid reviews 2. Cast Iron Skillet ⭐⭐⭐⭐⭐ Premium positioning, 4.9 stars = viral potential 3. Knife Sharpener ⭐⭐⭐ High volume but 4.3 rating = quality issue? ✏️ PRODUCT TAGLINES: • Bamboo Board: "Naturally antibacterial. Naturally beautiful." • Spatula Set: "The only set you'll ever need." • Cast Iron: "100 years of flavor in every meal." • Sharpener: "Dull knives? Never again." • Spice Rack: "Finally. A place for everything." 📊 ACTIONS: 1. Bundle spatulas + cutting board (+$5 margin) 2. Lower knife sharpener to $17.99 (test) 3. Feature cast iron in premium collection

Lead Scoring & Prioritization

Automatically score and prioritize sales leads

Formula=UNLIMITED_AI("Score each lead 1-100 based on likelihood to convert. Explain scoring and prioritize for sales team", "gpt4")
INPUTI tuoi dati grezzi
CompanySizeIndustryEngagementBudgetTimeline
TechStart Inc50 employeesSaaS5 page views$10K-25K3-6 months
Global Retail Co5000 employeesRetail2 page views$100K+Researching
FinanceFirst200 employeesFinance12 page views, demo req$50K-100KThis quarter
LocalBiz LLC10 employeesServices1 page view<$10KUnknown
MedTech Solutions500 employeesHealthcare8 page views, whitepaper$25K-50K1-3 months
OUTPUT GPTRisultati istantanei
🎯 LEAD SCORING REPORT PRIORITY RANKING: 🔥 HOT LEADS (Score 80+): 1. FinanceFirst — SCORE: 92/100 ✓ Demo requested (high intent) ✓ 12 page views (very engaged) ✓ $50K-100K budget (qualified) ✓ "This quarter" timeline → ACTION: Call within 24 hours 2. MedTech Solutions — SCORE: 85/100 ✓ Downloaded whitepaper (nurturing) ✓ 8 page views (engaged) ✓ 1-3 month timeline → ACTION: Send case study, schedule call 🟡 WARM LEADS (Score 50-79): 3. Global Retail Co — SCORE: 65/100 ✓ Enterprise budget ($100K+) ✓ Large company (5000) ⚠️ Low engagement (2 views) ⚠️ "Researching" = long cycle → ACTION: Add to nurture sequence 4. TechStart Inc — SCORE: 58/100 ✓ SaaS = good fit industry ⚠️ Small budget ($10-25K) ⚠️ 3-6 month timeline → ACTION: Self-serve demo link ❄️ COLD LEADS (Score <50): 5. LocalBiz LLC — SCORE: 22/100 ✗ Minimal engagement ✗ Low budget, unknown timeline → ACTION: Marketing nurture only

Content Calendar Generator

Transform topics into a full content calendar with titles and hooks

Formula=UNLIMITED_AI("Create a 4-week content calendar with blog titles, social hooks, and content types", "gpt4")
INPUTI tuoi dati grezzi
WeekThemeTarget KeywordAudience
Week 1Productivitytime management tipsRemote workers
Week 2AI ToolsAI for small businessSMB owners
Week 3Leadershipfirst time managerNew managers
Week 4Growthscaling startupFounders
OUTPUT GPTRisultati istantanei
📅 4-WEEK CONTENT CALENDAR WEEK 1: PRODUCTIVITY 📝 Blog: "The 2-Hour Workday: How Top Remote Workers Get 8 Hours Done Before Lunch" 🐦 Twitter: "Hot take: Your to-do list is lying to you. Here's what actually works..." 📸 Instagram: Carousel - "5 Time Blocks That Changed My Life" 🎬 Video: "My Morning Routine (5AM - Why It Works)" WEEK 2: AI TOOLS 📝 Blog: "I Replaced My $3K/mo Assistant with These 5 AI Tools (No Regrets)" 🐦 Twitter: "Your competitors are using AI. You're still doing this manually? 🧵" 📸 Instagram: Reel - "AI tools I can't live without" 🎬 Video: "Full AI Setup Tour for Small Business" WEEK 3: LEADERSHIP 📝 Blog: "Everything They Don't Tell You When You Become a Manager" 🐦 Twitter: "Promoted to manager? The first 30 days will make or break you. Here's what I learned..." 📸 Instagram: Quote cards - "Leadership lessons that hurt" 🎬 Video: "First 1-on-1? Say THIS, not that" WEEK 4: GROWTH 📝 Blog: "We Hit $1M ARR. Here Are the 7 Things That Actually Mattered" 🐦 Twitter: "Scaling myth: You need to work harder. Reality: You need to work on different things." 📸 Instagram: Behind-the-scenes growth story 🎬 Video: "Startup Metrics Dashboard Tour"
Modelli

Scegli il tuo GPT

Diversi modelli GPT per diverse esigenze. Tutti disponibili in Unlimited Sheets.

Il Più Capace

GPT-4o

Il modello di punta di OpenAI. Migliore per attività complesse, creatività e qualità.

VelocitàVeloce
QualitàIl Migliore
Costo$$$
Miglior Rapporto

GPT-4o-mini

Stesse capacità, più veloce e più economico. Perfetto per la maggior parte delle attività su foglio di calcolo.

VelocitàMolto Veloce
QualitàEccellente
Costo$
Alte Prestazioni

GPT-4 Turbo

Grande finestra di contesto per elaborare documenti e set di dati di grandi dimensioni.

VelocitàVeloce
QualitàEccellente
Costo$$
Uso Illimitato

Porta la Tua Chiave OpenAI

Aggiungi la tua chiave API OpenAI per un uso illimitato di ChatGPT. Paga OpenAI direttamente alle loro tariffe.

🔑

Come Funziona BYOK

  1. 1Ottieni la tua chiave API da platform.openai.com
  2. 2Aggiungila alla tua dashboard di Unlimited Sheets
  3. 3Usa ChatGPT illimitato — paga OpenAI direttamente (~€0,15/1M token per GPT-4o-mini)

Pronto a usare ChatGPT in Google Sheets?

Inizia gratis con 10 chiamate IA/mese.

Passa a Pro per 500 chiamate + illimitate con la tua chiave OpenAI.

Nessuna carta di credito • Installa in 30 secondi • Cancella quando vuoi