Custom Commands in SheetXAI: Create Personalized SAI Formula Instructions

Overview

SheetXAI now features Custom Commands that let you create personalized system prompts for your SAI formulas. Instead of typing the same detailed instructions repeatedly, you can set up custom shortcuts that automatically apply your preferred formatting and style to every request.

Platform Availability: Custom Commands are currently available only in Google Sheets. Excel support is coming soon.

How Custom Commands Work

Custom Commands allow you to define reusable system prompts that get automatically applied to your SAI formula requests. You create a command with a specific name (like "WOO" for product descriptions), set up the system prompt once, and then use it throughout your spreadsheet with the !! prefix.

Setting Up Custom Commands

1. Access the Custom Commands Menu
   • Go to Extensions → SheetXAI → SAI Commands
   • A modal window will open with setup instructions and management options
2. Create Your Custom Command
   • Click Add New Command
   • Enter a short, memorable command name (like "WOO", "EMAIL", "SUMMARY")
   • Write your system prompt that defines how the AI should behave
   • Save your command
3. Use Your Custom Command
   • In any SAI formula, use the !! prefix followed by your command name
   • Example: =SAI("!!WOO black shoes")
   • The system will automatically apply your custom prompt to process "black shoes"

Real-World Example

Scenario: You frequently need to write product descriptions with a specific style and format.

Setup:

1. Create a custom command called WOO
2. Set the system prompt to: "Write compelling product descriptions that are exactly 50 words, highlight key benefits, use persuasive language, and end with a call-to-action. Focus on emotional appeal and practical value."

Usage:

• =SAI("!!WOO black running shoes") → Generates a 50-word product description for black running shoes
• =SAI("!!WOO wireless headphones") → Generates a 50-word product description for wireless headphones
• =SAI("!!WOW laptop backpack") → Generates a 50-word product description for laptop backpack

Result: Every product description follows your exact specifications without retyping the detailed instructions.

Using Custom Commands with Built-In SheetXAI Commands

When combining custom commands with SheetXAI's built-in commands, always put the built-in commands first:

Built-In Commands (Use These First)

• !CONTENT - Forces the AI model you chose for content generation
• !URL - Forces the AI model you chose for URL processing

Correct Usage Examples

 

=SAI("!CONTENT !!WOO premium coffee beans")
=SAI("!URL !!SUMMARY https://example.com/article")

Incorrect Usage (Don't Do This)

 

=SAI("!!WOO !CONTENT premium coffee beans")  // Wrong order

Example Use Cases for Custom Commands

Marketing Content

Command: ADCOPY

System Prompt: "Create Facebook ad copy that's under 125 characters, includes emotional triggers, and ends with a clear call-to-action."

Usage: =SAI("!!ADCOPY fitness tracker for busy professionals")

Email Communication

Command: EMAIL

System Prompt: "Write professional email content that's friendly but concise, includes next steps, and maintains a helpful tone."

Usage: =SAI("!!EMAIL follow up with client about project timeline")

Data Analysis

Command: ANALYZE

System Prompt: "Provide data analysis that includes key insights, identifies trends, and suggests actionable next steps in bullet format."

Usage: =SAI("!!ANALYZE ", A2:D2, " monthly sales performance")

Pro Tips for Effective Custom Commands

• Keep Command Names Short: Use 3-6 character commands that are easy to remember
• Be Specific in System Prompts: Include exact word counts, formatting requirements, and style preferences
• Test Your Commands: Try your custom commands with different inputs to ensure consistent results
• Create Multiple Variants: Set up different commands for different content lengths or styles
• Document Your Commands: Keep a list of your custom commands and their purposes

Need Inspiration?

Visit our Prompt Library for ready-to-use system prompts and command ideas. You'll find tested prompts for:

• Content creation and copywriting
• Data analysis and reporting
• Email and communication templates
• Product descriptions and marketing copy
• Data formatting and organization

---

Custom Commands transform your SAI formulas into powerful, personalized AI tools that work exactly how you need them. Set them up once, use them everywhere!