Supercharge Your Spreadsheets
Transform your data in seconds, not hours. CoreGPT for Google Sheets handles the heavy lifting — from generating formulas to making sense of complex data.Key Features
GPT Classify
Automatically tag and categorize rows of spreadsheet data — whether it’s sales leads, survey responses, or expense entries. What you can do:- Categorize data automatically
- Tag sales leads by priority
- Classify survey responses
- Organize expense entries
- Create custom categories
Smart Summarize
Generate concise summaries of long ranges or cell groups — ideal for meeting notes, project updates, or data reports. What you can do:- Summarize data ranges
- Extract key insights
- Create executive summaries
- Condense meeting notes
- Generate data reports
Formula Generator
Explain the calculation you need in plain English and get the exact Google Sheets formula — no manual formula crafting required. What you can do:- Generate formulas from descriptions
- Create complex calculations
- Understand existing formulas
- Automate data processing
- Build dynamic spreadsheets
Data Analysis
Analyze your spreadsheet data and get insights without manual review. What you can do:- Analyze trends
- Find patterns
- Generate insights
- Create reports
- Identify outliers
Common Use Cases
Sales Pipeline Management
- Import sales leads
- Use Classify to tag by priority
- Summarize pipeline status
- Generate reports for management
Survey Analysis
- Collect survey responses
- Use Classify to categorize answers
- Summarize key findings
- Generate insights report
Financial Tracking
- Create expense spreadsheet
- Use Classify to categorize expenses
- Generate SUM formulas automatically
- Summarize spending by category
Project Management
- Track project tasks
- Use Classify to organize by status
- Generate formulas for progress tracking
- Summarize project status
How to Use
1
Select your data
Highlight the cells or column you want to work with.
2
Open CoreGPT
Click Extensions → CoreGPT → 🚀 Launch GPT
3
Choose an action
Pick from:
- Classify - Categorize data automatically
- Summarize - Get key points from data
- Generate Formula - Create formulas from descriptions
- Analyze - Get insights from your data
4
Click Generate
Click 🚀 Generate and wait for results (usually 5-10 seconds).
5
Review and use
Review the results and click Insert to add to your sheet, or Regenerate to try again.
Tips & Best Practices
Be Clear with Categories
When classifying, specify categories clearly: “Classify as: High Priority, Medium Priority, Low Priority”
Provide Context
For formulas, describe what you want: “Sum all sales over $1000 from the last quarter”
Use Summarize for Insights
Summarize large data ranges to quickly understand trends and patterns.
Test Formulas First
Always test generated formulas on a small data set before applying to your whole sheet.
Common Formulas You Can Generate
- SUM - Add up values
- AVERAGE - Calculate average
- COUNT - Count items
- IF - Conditional logic
- VLOOKUP - Find values
- FILTER - Filter data
- QUERY - Complex queries
- IMPORTRANGE - Link sheets
Troubleshooting
The classification doesn't match my data
The classification doesn't match my data
Be more specific with your categories. Instead of “Classify,” try:
- “Classify as: Hot Lead, Warm Lead, Cold Lead based on engagement level”
- “Categorize by: Urgent, Important, Can Wait”
The formula isn't working
The formula isn't working
Check that:
- Your cell references are correct
- You’re using the right column letters
- The data types match (numbers, text, dates)
I want to undo a change
I want to undo a change
Use Ctrl+Z (or Cmd+Z on Mac) to undo. CoreGPT results aren’t automatically inserted — you control what gets added.
The summary is too brief/too long
The summary is too brief/too long
Try being more specific:
- “Summarize in 2-3 sentences”
- “Create a detailed summary with all key points”
- “Extract only the most important insights”
Privacy & Security
Your spreadsheets are safe:- We never store your data or spreadsheets
- All processing is encrypted
- Your data stays in your Google account
- We don’t use your data to train models