Data & API Usage Guidelines

How FITS Handles Your Data

Spreadsheet Processing

Processes data only during active formula execution
Never stores cell contents on external servers
Maintains formula history in cell metadata
Preserves locked cell states locally

API Communication

Encrypts all API calls using industry standards
Sends only necessary data to AI providers
Removes sensitive data from error logs
Cleans memory after processing

Metadata Storage

Stores processing history in cell notes
Tracks formula versions and changes
Maintains lock states and configurations
Records basic usage statistics

Best Practices for Users

API Key Security

Store keys securely in FITS settings
Never share API keys in spreadsheets
Rotate keys periodically
Monitor usage through provider dashboards

Batch Processing Optimization

// Good: Similar prompts grouped together
=AI("Summarize: " & A1, "gemini-1.5-pro", 0.7)
=AI("Summarize: " & A2, "gemini-1.5-pro", 0.7)

// Better: Use consistent model parameters
=AI("Analyze: " & B1, "claude-3", 0.5)
=AI("Analyze: " & B2, "claude-3", 0.5)

Model Selection Guide

Gemini Pro (Free Tier)

Best for:

General text processing
Basic analysis
Quick responses
High-volume tasks

Claude (Premium)

Best for:

Complex analysis
Technical content
Code understanding
Detailed explanations

OpenAI (Premium)

Best for:

Creative writing
Structured outputs
Format consistency
Specific instructions

Deepseek (Premium - COMING SOON)

Best for:

Advanced code generation
Technical documentation
Data analysis
Complex problem-solving

Data Management Tips

Lock important results after processing
Use cell metadata to track changes
Save API costs by batching similar requests
Test prompts before batch processing

Support Resources

Need help optimizing your usage?

Check our documentation
Join our community newsletter
Submit feature requests