Changelog

Agents: Better Semantic Layer

Agents now build a richer semantic layer over your spreadsheet data, understanding column intent, units, and relationships so they can answer questions more accurately without extra prompting.

• Automatic column-type inference (dates, currencies, IDs, categories)
• Cross-sheet relationship detection for multi-tab workbooks
• Improved natural-language query accuracy on ambiguous headers

Agents: Automatic Data Cleaning

Agents now detect and clean common data quality issues before processing — so messy real-world spreadsheets just work without manual pre-processing.

• Trims whitespace, normalizes casing, and standardizes date formats
• Flags and handles blank rows, merged cells, and irregular headers
• Cleaning report returned alongside agent results for auditability

Analysis Endpoint

New /analysis endpoint returns a structured AI-generated analysis of any file — summaries, trends, outliers, and key statistics in a single call.

• Returns narrative summary + structured JSON stats
• Configurable focus areas: trends, anomalies, distributions
• Works across all supported file types (Excel, CSV, Google Sheets)

Account Keys: Access All Files

Account-level API keys can now read and write any file in your account, removing the need to generate per-file keys for multi-spreadsheet workflows.

• Single key works across all files under an account
• Per-file keys still supported for scoped access
• Key management dashboard updated to show scope clearly

Webhooks in the Calculate Endpoint

The /calculate endpoint now supports webhooks — long-running formula chains can push results to your URL when complete rather than requiring a polling loop.

• Pass a webhook_url to receive async results
• Signed payloads with HMAC for verification
• Retry logic with exponential backoff on delivery failures

JavaScript / TypeScript Library

Official JavaScript and TypeScript SDK published to npm — typed wrappers around every endpoint so you can integrate API Spreadsheets without writing raw HTTP calls.

npm install apispreadsheets
import { APISpreadsheets } from "apispreadsheets"
const client = new APISpreadsheets({ key: "YOUR_KEY" })

Python Library

Official Python SDK published to PyPI — makes it easy to read, write, calculate, and run AI queries against your spreadsheets from any Python environment.

pip install apispreadsheets
from apispreadsheets import APISpreadsheets
client = APISpreadsheets(key="YOUR_KEY")

Custom APIs: Scheduled Runs

Custom APIs can now be triggered on a cron schedule — run your spreadsheet logic automatically at any interval without external orchestration.

• Set a cron expression directly in the API builder
• Execution logs and last-run status in the dashboard
• Combine with webhooks to push results downstream on each run

Custom APIs

Build and publish your own named API endpoints backed by spreadsheet logic — wrap any combination of data, calculate, or AI calls behind a clean, shareable URL.

• Visual builder: define inputs, pick spreadsheet operations, map outputs
• Auto-generated documentation and OpenAPI spec per endpoint
• Access control: public, key-gated, or account-only

Agent Builder

New in-app Agent Builder lets you configure, test, and deploy spreadsheet agents without writing code — connect a spreadsheet, define its purpose, and get a ready-to-use agent endpoint.

• Point-and-click spreadsheet selection and column mapping
• Built-in test console to ask questions before deploying
• One-click deploy generates a shareable agent URL

Agents Endpoint

New /agents endpoint lets you deploy a conversational agent over any spreadsheet and query it with plain English — no prompt engineering required.

• Ask questions, filter rows, and summarize data in natural language
• Stateful conversation context across multi-turn queries
• Returns structured JSON or narrative responses depending on the query

MCP Server: Multi-Spreadsheet

Upgraded MCP server supports entire accounts — connect your AI assistant to all your spreadsheets at once and query across files in a single conversation.

• Account-key authentication grants access to all files
• AI can discover available sheets and switch context mid-conversation
• Cross-file joins and comparisons supported via the /data endpoint

MCP Server: Single Spreadsheet

Released an MCP server so you can connect Claude, Cursor, or any MCP-compatible AI assistant directly to a spreadsheet and talk to your data in plain English.

• Read, filter, and write rows through natural-language commands
• Zero-config setup: point at a file key, start chatting
• Works with Claude Desktop, Cursor, and other MCP clients

/AI Route: Broader Input Support

The /AI endpoint now handles a much wider range of natural-language inputs — ambiguous phrasing, mixed-language queries, and multi-step instructions all resolve correctly.

• Improved intent parsing for vague or compound requests
• Handles partial column names, typos, and synonym matching
• Better error messages when a query can't be resolved

Analytics Use Case + Polish

Renamed and expanded “Dashboards” to Analytics with clearer reporting language, better examples, and row-based visuals.

• New “Analytics” use case page with visual steps & iconography
• Refined hero illustrations across use cases and industries
• Misc fixes to spacing, contrast, and keyboard focus outlines

Feature Template: Responsive Content Fit

Tightened content layout so rich visuals (icons, mini diagrams) stay within their containers on all breakpoints.

• Max widths + overflow handling for detail panels
• Consistent padding on small screens; improved sticky nav behavior
• Vector arrows between request → sheet → response in showcases

Changelog Page

Introduced a left-rail vertical timeline with dates and milestones. Everything is driven by this constants file.

Header Revamp: Solutions Menu

Abstracted the Solutions dropdown into a shared component, added a mobile accordion mode, and reduced desktop spacing.

• Mobile: collapsible groups (Features / Use Cases / Industries)
• Desktop: denser grid, less padding, clearer separators
• A11y: focus trap, keyboard navigation, ARIA attributes

Dev Proof & GitHub Usage Fixes

Normalized card borders & avatar selection in the “Dev Proof” section.

• Consistent border rendering across browsers
• Randomized avatar subset without repeats
• Improved error handling for GitHub 403s; robust rate limit retry

Industry Pages: Visual Use-Case Rows

Finance, Insurance, Mortgage Brokers, Dev Agencies, E-commerce, and SaaS now feature vertical, visualized use-case rows with icons.

• Each row shows a concise visual of inputs → spreadsheet → outputs
• Case studies + ROI cards updated with consistent iconography
• Expanded FAQs tailored to industry concerns

Use Case Pages: Row-Based “How it Works”

AI Chatbots, Web Calculators, Web Forms, Excel Importer, Rules Engine, Build Apps, and Analytics use cases moved to row-based steps with visuals.

• Inline mini-illustrations and icon-first content
• Consistent three-step pattern with CTA hooks
• Bigger, more helpful FAQ sections

Feature Pages Overhaul

Upgraded /AI, /data, /calculate, /import, and /utilities pages with richer visuals and detail panels.

• Icon-led “details” with spreadsheet mini-scenes
• Arrows between API request ⇄ sheet ⇄ JSON
• Expanded feature FAQs (10–15 per page)

Documentation Refresh

Reorganized the docs for faster onboarding with new quickstarts and copy-paste examples.

• Guides for /data, /calculate, /AI, /import, and utilities
• Environment setup + key management walkthroughs
• FAQ playbooks and troubleshooting trees

OpenAPI + Chatbot Function Calling

Published an OpenAPI spec and added assistant/chatbot integration examples with function calls.

GET /openapi.json
# Use with your chatbot framework to auto-wire function calls to /data and /AI

Pricing Page + Feature Matrix

Redesigned pricing with a JSON-driven feature matrix and an enterprise banner/CTA.

• Per-cell states: supported / not supported / text
• Optional info tooltips for edge-case notes
• Contact card for custom/enterprise needs

Version 3 (Beta)

Major site and product refresh with clearer navigation by features, use cases, and industries.

• New templates for Features, Use Cases, and Industries
• Visual showcases: API request → spreadsheet → JSON result
• Performance and accessibility improvements across the app

Version 2

Expanded the platform with /calculate (run formulas & macros) and /AI (prompt-based CRUD).

• /calculate: specify input/output cells, named ranges, macros, sequences
• /AI: natural-language create/read/update/delete across sheets

Version 1

Initial launch with /data (CRUD & queries) and /import (file intake & metadata).

• /data: RESTful read/write with filters and pagination
• /import: upload spreadsheets, return structured metadata