Getting Started

How to Use

Transform your ideas into powerful spreadsheets and data analysis tools. Sparkco AI understands your business goals and creates exactly what you need to succeed.

What kind of spreadsheets can you create?

Financial Models

Revenue forecasts, budget planning, cash flow analysis, investment calculators, loan amortization schedules

Business Dashboards

KPI tracking, sales performance, customer analytics, inventory management, project timelines

HR & Operations

Employee schedules, payroll calculators, performance reviews, training trackers, compliance checklists

Data Analysis

Survey analysis, market research, trend identification, statistical modeling, comparative studies

Project Management

Gantt charts, resource allocation, milestone tracking, risk assessment, team coordination

Healthcare Analytics

Patient outcomes, staffing optimization, compliance tracking, quality metrics, cost analysis

Research Tools

Literature reviews, data collection forms, experiment tracking, citation management, hypothesis testing

Custom Solutions

Inventory systems, CRM tools, educational gradebooks, event planning, personal finance trackers

How to achieve your goals

Be Specific

"Create a monthly budget tracker with categories for housing, food, transportation, and entertainment"

Include Context

"I'm a small business owner tracking 50 employees across 3 locations with different pay rates"

Set Expectations

"Make it visually appealing with charts and conditional formatting for easy reading"

Real examples that work

"Create a comprehensive financial model for a SaaS startup with monthly recurring revenue, churn analysis, and 3-year projections"
"Build a patient care dashboard that tracks medication schedules, vital signs, and generates compliance reports for our nursing facility"
"Design an inventory management system with automatic reorder points, supplier tracking, and cost analysis for our retail business"
"Make a research data collection sheet for our clinical trial with participant demographics, outcome measures, and statistical analysis"

Upload PDFs

Upload any PDF document and our AI will automatically extract all the text content for you to work with. Perfect for analyzing contracts, reports, invoices, or any document.

1Look for the attachment icon in the bottom toolbar
2Click it to open your file browser
3Select any PDF file from your computer
4Wait a few seconds while we extract the text
5The PDF content is now automatically included in your conversation
You can upload multiple PDFs at once. Each one gets a badge showing how many files you've attached.

What you can do with PDFs

Expense Analysis:Upload invoices and receipts to automatically compile spending charts, categorize expenses, and track budget performance
Contract Review:Analyze legal documents, extract key terms, compare clauses across multiple contracts, and identify potential risks
Financial Reports:Process bank statements, financial reports, and tax documents to create comprehensive financial dashboards
Medical Records:Extract patient data, lab results, and treatment histories to build HIPAA-compliant tracking systems
Research Analysis:Upload research papers, reports, and studies to synthesize findings and create literature reviews
Project Documentation:Process technical specs, blueprints, and project plans to create organized project management systems

Connect Your Database

Connect your PostgreSQL, MySQL, or SQLite database so the AI can query your data directly. Perfect for generating reports, analyzing trends, and answering questions about your business data.

1Click the database icon in the top toolbar
2Click "New" to create a connection
3Enter your connection name and select database type (PostgreSQL, MySQL, or SQLite)
4Paste your connection string (for Supabase, use the Session Pooler connection string)
5Click "Test Connection" to verify it works
6Click "Fetch Schema" to let the AI understand your database structure
7Toggle "Execute SQL" if you want the AI to run queries (SELECT only by default)
8Click "Save Connection" to store it for future use
Keep "Allow Writes" disabled unless you explicitly want INSERT/UPDATE/DELETE operations. The AI can analyze your data safely with read-only access.

What you can do with database connections

Business Intelligence:Ask questions like "What were our top selling products last month?" and get instant charts and analysis
Customer Analysis:Analyze customer behavior, segment users, and identify trends in your user data
Financial Reporting:Generate revenue reports, track expenses, and create financial dashboards from your transaction data
Performance Metrics:Monitor KPIs, track growth metrics, and identify performance bottlenecks across your operations
Data Exploration:Explore your database structure, find relationships between tables, and discover insights in your data

Excel Operations

Our AI agents can perform sophisticated Excel operations on your spreadsheets. Just describe what you want, and the AI will execute the formatting, styling, and structural changes automatically.

Formatting & Styling

Font Styling: Change font family, size, make text bold, italic, underlined, or strikethrough
Cell Alignment: Align text left, center, right, or justify horizontally and vertically
Text Wrapping: Enable or disable text wrapping in cells
Colors: Apply font colors and background colors to any range
Borders: Add borders (all, outside, inside, specific sides) with different styles
Text Rotation: Rotate text at any angle from -90 to 90 degrees

Number Formatting

Currency: Format numbers as currency ($1,234.56)
Percentages: Display numbers as percentages (12.34%)
Dates & Times: Format dates (yyyy-mm-dd) and times (hh:mm:ss)
Custom Patterns: Apply any custom number format pattern

Structure Operations

Merge Cells: Merge cells across ranges, rows, or columns
Insert Rows/Columns: Add new rows or columns at any position
Delete Rows/Columns: Remove rows or columns from the sheet
Hide/Show: Hide or unhide rows and columns
Resize: Set custom row heights and column widths
Copy Ranges: Copy cells with values and formatting to new locations

Advanced Features

Rich Text: Apply different formatting to different parts of text within a single cell
Batch Operations: Execute multiple formatting operations in a single command
Multi-Sheet Support: Work across different sheets in the same workbook

Example commands you can use

"Make the header row bold and add borders to the entire table"
"Format column C as currency with 2 decimal places"
"Center align all the data and make the background light gray"
"Insert 3 new rows above row 5 for additional data"
"Hide columns D through F and resize column A to be wider"

Smart Memory & Context

The AI automatically remembers your conversations, tracks your work progress, and maintains context across sessions. Your work is always saved and can be resumed exactly where you left off.

Automatic Saving

Every conversation is automatically saved as you work - no need to manually save
Your spreadsheet changes, database queries, and uploaded files are all preserved
Click the dropdown arrow next to the workspace title to load previous conversations

Context Awareness

The AI tracks your session goals, completed tasks, and current focus area
Click the server icon in the toolbar to view your session context summary
Context is automatically compressed to keep conversations efficient

Progress Tracking

See your token usage and costs in real-time at the top of the interface
Track which external data sources have been used in your session
View key insights and suggested next steps based on your work

How it helps you work better

Resume Anywhere:Start a financial model on your laptop, continue on your phone, finish on your desktop
Stay Focused:The AI remembers your goals and keeps you on track, even in long sessions
Learn Patterns:The system learns your work patterns and suggests relevant next steps
Smart Suggestions:Get contextual recommendations based on your current work and past sessions

Auto-Approve Mode

Enable autopilot mode to let the AI execute operations automatically without asking for permission each time. Perfect for complex workflows where you want the AI to work autonomously.

How to Enable

Look for the toggle switch in the top-left of the chat interface
When OFF (gray), you'll be asked to approve each operation
When ON (orange with lightning bolt), the AI works autonomously

Smart Automation

The AI can chain multiple operations together seamlessly
Handles recursive approvals when one operation leads to another
Automatically continues with follow-up actions after completing tasks

Safety Features

Database writes are still controlled by your connection settings
You can cancel any operation at any time using the Cancel button
All operations are logged and can be reviewed in your conversation history

When to use auto-approve

Complex Builds:Building comprehensive financial models or dashboards with many formatting steps
Data Analysis:Processing large datasets where the AI needs to fetch data, analyze, and create visualizations
Iterative Work:Refining and improving existing spreadsheets with multiple rounds of adjustments
Time-Sensitive:When you need results quickly and trust the AI to make good decisions

Choose Your AI Model

Switch between different AI models depending on your needs. Each model has different strengths, costs, and context limits. The system tracks your usage and costs automatically.

How to Switch Models

Look for the model selector in the bottom-right of the chat interface
Click the dropdown to see all available models
Use the search bar to quickly find specific models
Models are organized by provider (OpenAI, Anthropic, Google, etc.)

Cost Tracking

See real-time costs in the dollar counter at the top of the interface
Double-click the cost counter to reset it to zero
Each model has different pricing for input and output tokens
Costs are calculated based on actual token usage, not estimates

Context Management

The context bar shows how much of the model's memory you're using
Different models have different context limits (shown as X/YK tokens)
When you switch models, the context limit updates automatically
Green = plenty of space, Orange = getting full, Red = near limit

External Data Sources

The AI can automatically fetch data from the internet, financial markets, and economic databases to enrich your analysis. Just ask for the data you need, and it will be retrieved and formatted for you.

Web Search & Research

Tavily Search: Search the web for current information and news
Content Extraction: Extract full text content from any webpage or article

Financial Data

Stock Quotes: Real-time stock prices, market cap, and trading volume
Financial Statements: Company earnings, revenue, and balance sheet data
Yahoo Finance: Historical stock data and financial metrics

Economic Indicators

Economic Data: GDP, inflation rates, unemployment, and other economic indicators
Market Trends: Economic trends and forecasts for analysis

Example requests

"Get the latest stock price for Apple and create a chart"
"Search for recent news about AI startups and summarize the trends"
"Fetch Tesla's financial statements and build a revenue analysis"
"Get current inflation data and compare it to last year"

Version Control

Work in progress - Advanced version control and collaboration features for your spreadsheets and projects.

• Save and restore different versions of your work
• Collaborate with team members on shared projects
• Track changes and see who made what modifications
• Branch and merge different approaches to the same problem

Current API Documentation

Blog Posts API

Search and retrieve blog content with pagination support. Access our full blog database programmatically.

GET/api/blog/searchSearch blog posts with pagination

Query Parameters

qSearch term to filter posts by title and content
categoryFilter by category (Technology, Healthcare, Finance, etc.)
pagePage number for pagination (default: 1)
limitNumber of posts per page (default: 12, max: 50)

Example Request

GET /api/blog/search?q=AI&category=Technology&page=1&limit=10

Response Format

Blog Search Responsejson
{
  "posts": [
    {
      "id": "uuid",
      "slug": "post-slug",
      "title": "Post Title",
      "description": "Brief description",
      "content": "Full HTML content",
      "image_url": "https://...",
      "category": "Technology",
      "reading_time": 10,
      "created_at": "2025-10-22T...",
      "meta_title": "SEO optimized title",
      "meta_description": "SEO description"
    }
  ],
  "totalCount": 150,
  "hasMore": true,
  "currentPage": 1
}
GET/blog/:slugGet single blog post by slug

Get a single blog post by slug. Returns a server-side rendered page with full SEO optimization.

Example: /blog/enterprise-service-communication-best-practices-2025

💬 Comments API

Manage blog post comments with nested tree structure support. Anonymous commenting with rate limiting.

GET/api/blog/comments

Query Parameters

post_slugRequired. The slug of the blog post to get comments for

Response Format

{
  "comments": [
    {
      "id": "uuid",
      "blog_post_id": "uuid",
      "author_name": "John Doe",
      "author_email": "john@example.com",
      "content": "Great article!",
      "parent_comment_id": null,
      "created_at": "2025-10-22T...",
      "replies": [
        {
          "id": "uuid",
          "author_name": "Jane Smith",
          "content": "I agree!",
          "parent_comment_id": "parent-uuid",
          "created_at": "2025-10-22T...",
          "replies": []
        }
      ]
    }
  ],
  "totalCount": 15,
  "success": true
}

Cache Policy: Responses are cached for 5 minutes to improve performance

POST/api/blog/comments

Submit a new comment. No authentication required - anonymous commenting is supported.

Request Body

{
  "post_slug": "post-slug-here",
  "author_name": "John Doe",
  "author_email": "john@example.com",  // optional
  "content": "Your comment here",
  "parent_comment_id": "uuid"  // optional, for replies
}

Success Response (201)

{
  "success": true,
  "comment": {
    "id": "uuid",
    "blog_post_id": "uuid",
    "author_name": "John Doe",
    "content": "Your comment here",
    "created_at": "2025-10-22T..."
  },
  "message": "Comment posted successfully!"
}

Rate Limit: 50 comments per hour per IP address

Validation: Name (1-100 chars), Content (1-2000 chars), Email (valid format if provided)

Agent MCP Access

🔌 Model Context Protocol

Integration with MCP servers for extended agent capabilities. Connect external tools and resources to enhance AI functionality.

Status:Coming Soon
Planned Features:
• Tool registry and management
• External resource access
• Server integration protocols
• Custom agent extensions

For AI Agents

Quick Reference

# Fetch blog posts
curl "https://sparkco.ai/api/blog/search?q=AI&category=Technology&page=1&limit=10"

# Get comments for a post
curl "https://sparkco.ai/api/blog/comments?post_slug=your-post-slug"

# Submit a comment
curl -X POST "https://sparkco.ai/api/blog/comments" \
  -H "Content-Type: application/json" \
  -d '{
    "post_slug": "your-post-slug",
    "author_name": "AI Agent",
    "content": "Insightful article!",
    "parent_comment_id": null
  }'

Note for Agents: All endpoints are public and require no authentication. Comments are posted immediately without moderation. Rate limits apply to prevent abuse.

Base URL

https://sparkco.ai

All API endpoints are relative to this base URL

Developer Documentation - API Reference & Platform Features | Sparkco AI