SHEETAI_BRAIN Function Guide
What is SHEETAI_BRAIN Function?
The SHEETAI_BRAIN function is an intelligent memory system that allows you to store and retrieve information across your spreadsheets. It acts as a persistent knowledge base, remembering important context and information that can be referenced in future AI interactions.
Basic Syntax
The basic syntax is:
=SHEETAI_BRAIN(operation, key, value)
The operation can be "store", "retrieve", or "delete". The key is a unique identifier, and value is the information to store (optional for retrieve/delete).
Examples
| Task | Operation | Formula | Example Output |
|---|---|---|---|
| Store project details | Store | =SHEETAI_BRAIN("store", "project_scope", B2) | "Information stored successfully" |
| Retrieve project details | Retrieve | =SHEETAI_BRAIN("retrieve", "project_scope") | [Retrieved project scope information] |
| Delete stored information | Delete | =SHEETAI_BRAIN("delete", "project_scope") | "Information deleted successfully" |
Key Features
- Persistent memory across sessions
- Store and retrieve complex information
- Organize data with unique keys
- Maintain context between AI interactions
Common Use Cases
- Project documentation storage
- Knowledge base management
- Context preservation for AI tasks
- Team information sharing
- Reference data management
Tips for Best Results
- Use descriptive keys for easy retrieval
- Organize related information with key prefixes
- Regularly clean up unused stored data
- Consider data structure when storing complex information