> ## Documentation Index
> Fetch the complete documentation index at: https://help.coregptapps.com/llms.txt
> Use this file to discover all available pages before exploring further.

# GPT for Google Sheets - CoreGPT Apps

> Supercharge your spreadsheets with AI. Transform your data in seconds with GPT Classify, Smart Summarize, and Formula Generator. Handle heavy lifting from formulas to complex data.

## Supercharge Your Spreadsheets

Transform your data in seconds, not hours. ChatGPT for Google Workspace handles the heavy lifting — from generating formulas to making sense of complex data.

## Key Features

### GPT Chat Assistant

An AI agent that works with your selected spreadsheet content. Select any cells or data and ask the assistant to help you with custom requests or use pre-built actions.

**What you can do:**

* Ask custom questions about your data
* Classify and categorize data automatically
* Summarize data ranges and insights
* Generate formulas from descriptions
* Analyze trends and patterns
* Extract key insights
* Create reports and summaries
* Organize and structure data

<img src="https://mintcdn.com/shhapps/DWcZCtvr0uIGGRpg/images/google-workspace/sheets/sheets-chat-assistant.png?fit=max&auto=format&n=DWcZCtvr0uIGGRpg&q=85&s=05b61228cc6bfada0feaa35f46b074f1" alt="GPT Chat Assistant in action" width="302" height="755" data-path="images/google-workspace/sheets/sheets-chat-assistant.png" />

### Custom GPT Functions

Use AI-powered custom functions directly in your spreadsheet cells:

* **COREGPT()** - Ask AI anything about your data with custom prompts
* **COREGPT\_TRANSLATE()** - Translate cell content to any language
* **COREGPT\_EXTRACT()** - Extract specific information from text
* **COREGPT\_FORMAT()** - Reformat text to your desired format
* **COREGPT\_SUMMARIZE()** - Summarize cell content automatically
* **COREGPT\_CLASSIFY()** - Classify text into categories you define

<img src="https://mintcdn.com/shhapps/DWcZCtvr0uIGGRpg/images/google-workspace/sheets/gpt-formulas.png?fit=max&auto=format&n=DWcZCtvr0uIGGRpg&q=85&s=def7dcc930777134cab6b6cefd275f14" alt="Custom GPT Functions feature" width="302" height="755" data-path="images/google-workspace/sheets/gpt-formulas.png" />

## Common Use Cases

### Sales Pipeline Management

1. Import sales leads
2. Use Classify to tag by priority
3. Summarize pipeline status
4. Generate reports for management

### Survey Analysis

1. Collect survey responses
2. Use Classify to categorize answers
3. Summarize key findings
4. Generate insights report

### Financial Tracking

1. Create expense spreadsheet
2. Use Classify to categorize expenses
3. Generate SUM formulas automatically
4. Summarize spending by category

### Project Management

1. Track project tasks
2. Use Classify to organize by status
3. Generate formulas for progress tracking
4. Summarize project status

## How to Use

<Steps>
  <Step title="Select your data">
    Highlight the cells or column you want to work with.
  </Step>

  <Step title="Open ChatGPT for Google Workspace">
    Click **Extensions** → **ChatGPT for Google Workspace** → **🚀 Launch GPT**
  </Step>

  <Step title="Use pre-built actions or ask a question">
    * Click a pre-built action button (Classify, Summarize, Generate Formula, Analyze)
    * Or type a custom question in the chat box (e.g., "Categorize these by priority" or "Generate a SUM formula")
  </Step>

  <Step title="Review the result">
    The assistant will process your selected data and provide results in the chat panel.
  </Step>

  <Step title="Copy or refine">
    Click **Copy** to copy the result, or ask follow-up questions to refine it before copying.
  </Step>
</Steps>

## Tips & Best Practices

<Columns cols={2}>
  <Card title="Use Pre-built Actions First" icon="zap">
    Start with pre-built actions for common tasks. They're optimized for spreadsheet workflows.
  </Card>

  <Card title="Ask Follow-up Questions" icon="comment">
    The chat assistant remembers context. Ask follow-up questions to refine results without re-selecting data.
  </Card>

  <Card title="Be Specific in Custom Requests" icon="edit">
    Instead of "Analyze this," try "Find trends in sales by month" or "Categorize by priority level."
  </Card>

  <Card title="Test Formulas First" icon="check">
    Always test generated formulas on a small data set before applying to large datasets.
  </Card>
</Columns>

## Example Requests

**For Classification:**

* "Categorize these by priority level"
* "Tag sales leads as hot, warm, or cold"
* "Classify survey responses by sentiment"

**For Summarization:**

* "Summarize this data range in 3 key insights"
* "What are the main trends in this data?"
* "Extract key metrics from this dataset"

**For Custom Functions:**

* `=COREGPT("What is the average of this data?", A1:A10)`
* `=COREGPT_TRANSLATE(A1, "Spanish")`
* `=COREGPT_EXTRACT(A1, "email address")`
* `=COREGPT_CLASSIFY(A1, "High Priority, Medium Priority, Low Priority")`
* `=COREGPT_SUMMARIZE(A1)`
* `=COREGPT_FORMAT(A1, "Title Case")`

**For Analysis:**

* "Find trends in sales by month"
* "Identify outliers in this dataset"
* "Analyze which products have highest profit margins"

## Troubleshooting

<AccordionGroup>
  <Accordion title="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"
  </Accordion>

  <Accordion title="The custom function isn't working">
    Check that:

    * You're using the correct function name (COREGPT, COREGPT\_TRANSLATE, etc.)
    * Your cell references are in quotes or use proper range syntax
    * The function parameters match the required format
    * You have an active internet connection

    If the function returns an error, try simplifying your prompt or parameters.
  </Accordion>

  <Accordion title="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"
  </Accordion>
</AccordionGroup>

## 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

## Next Steps

<Columns cols={2}>
  <Card title="Explore Other Apps" icon="compass" href="/google-workspace/slides">
    Learn about ChatGPT for Google Workspace in Slides and Forms.
  </Card>

  <Card title="Get Help" icon="question" href="/help-support/faq">
    Find answers to common questions.
  </Card>
</Columns>