Transform Your Content Calendar with AI in Minutes

Installation & Setup

1. Install the Add-on

1. Open any Google Sheet
2. Click Extensions → Add-ons → Get add-ons
3. Search for "Freak In The Sheets"
4. Click Install
5. Grant the requested permissions

2. Open the FITS Sidebar

There are two ways to access your FITS controls:

Method 1: Extensions Menu

1. Click Extensions in your Google Sheets menu
2. Hover over Freak In The Sheets
3. Click "Show Sidebar"

Method 2: FITS Menu

1. Look for FITS in your navigation (right side)
2. Click it to toggle the sidebar, or run batch processing

The sidebar is your control center for:

• API key management
• Batch processing
• Cell locking/unlocking
• Processing status
• Recent activity

3. Configure Your API Keys

Start with our free tier using Gemini:

1. Visit Google AI Studio
2. Create a new API key
3. In your spreadsheet, click Extensions → Freak In The Sheets → Settings
4. Paste your API key in the Gemini configuration section
5. Click Save

Basic Syntax

=FITS(prompt, model, temperature)

Your First AI Formula

Understanding Parameters

The =FITS() formula takes three parameters:

=FITS(prompt, model, temperature)

• prompt: Your instruction or text (can be a cell reference)
• model: AI model to use (default: "gemini-2.0-flash")
• temperature: Creativity level from 0.0 to 1.0 (default: 0.7)

Example Use Cases

Content Brief Generation

=FITS("Create a detailed content brief for the topic: " & A2 & " including target audience: " & B2 & " and primary keyword: " & C2, "gpt-4", 0.7)

Bulk Meta Description Creation

=FITS("Write a compelling 155-character meta description for: " & A2 & " focusing on the keyword: " & B2, "gpt-4", 0.3)

Social Media Variations

=FITS("Create 5 Twitter posts promoting this article: " & A2 & " with different angles and CTAs", "claude-3", 0.8)

Content Outline Generation

=FITS("Create a detailed outline with H2s and H3s for a 2000-word article about: " & A2 & " targeting " & B2 & " audience", "gpt-4", 0.5)

Text Summarization & Analysis

=FITS("Summarize this customer feedback: " & A2, "gemini-2.0-flash", 0.3)

Using the Freak In The Sheets Sidebar

Sidebar Sections

Content Calendar Batch Processing

Transform Your Entire Content Calendar

The real power of FITS comes from processing your entire content calendar at once:

1. Set up your content calendar with topics, keywords, and target audiences
2. Add FITS formulas for briefs, outlines, titles, and meta descriptions
3. Select your content range and click "Start Processing"
4. Watch as your entire month's content gets generated in minutes
5. Review, edit, and approve without leaving your spreadsheet

Content Production Best Practices

• Group similar content types together (blogs, social posts, emails)
• Start with a small batch to test your prompts
• Use cell locking to preserve approved content
• Monitor costs for large content batches
• Keep brand voice consistent across prompts

Advanced Features

Cell Locking

Preserve important results:

1. Select processed cells
2. Click "Lock Cells" in the sidebar
3. Cells will maintain their results during future batch operations
4. Unlock anytime to reprocess

Formula Management

Track your AI formulas:

// Basic formula
=FITS("Your prompt", "gemini-2.0-flash", 0.7)

// With cell references
=FITS(A1, B1, C1)

// Complex prompts
=FITS("Analyze this data: " & A1 & " considering " & B1, "gemini-2.0-flash", 0.5)

Metadata Tracking

Every AI-processed cell includes:

• Processing timestamp
• Used model and temperature
• Prompt history
• Response versions

Troubleshooting

Common Issues

Formula Not Processing

• Check API key configuration
• Verify internet connection
• Ensure formula syntax is correct
• Check for rate limiting

Batch Processing Stopped

• Look for error messages in the sidebar
• Check remaining API quota
• Verify selected range contains valid formulas

Results Not Saving

• Ensure you have edit permissions
• Check if cell is locked
• Verify sheet protection settings

Getting Help

1. Check the error message in the sidebar
2. Join our community for support and feedback

Next Steps

Build Your Content Production System

• Create a content calendar template with FITS formulas
• Test different AI models for different content types
• Build a library of proven prompts for your brand
• Set up approval workflows with cell locking
• Scale from 10 to 100+ pieces per month

Stay Updated

• Join our community for tips and updates
• Connect with other users in our community