{"uid":"cap_2Mh1Q3owSibFmKb9_zIQ7","slug":"sheets-api-xlsx-workbook-builder-73af3980","name":"Sheets API XLSX Workbook Builder","description":"Create styled XLSX workbooks with typed cells, multiple worksheets, filters, frozen headers, numeric formats and cached formula totals. Input strings remain text, including strings beginning with =.","url":"https://sheets-api-production-636c.up.railway.app/v1/workbooks/build?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"title":{"type":"string","maxLength":150,"minLength":1},"accent":{"type":"string","default":"#237b65","pattern":"^#[0-9a-fA-F]{6}$"},"sheets":{"type":"array","items":{"type":"object","required":["name","columns","rows"],"properties":{"name":{"type":"string","maxLength":31,"minLength":1},"rows":{"type":"array","items":{"type":"object","propertyNames":{"type":"string"},"additionalProperties":{"anyOf":[{"type":"string","maxLength":1000},{"type":"number"},{"type":"boolean"},{"type":"null"}]}},"maxItems":1000},"totals":{"type":"array","items":{"type":"string","maxLength":40,"minLength":1},"default":[],"maxItems":30},"columns":{"type":"array","items":{"type":"object","required":["key","label"],"properties":{"key":{"type":"string","maxLength":40,"minLength":1},"label":{"type":"string","maxLength":100,"minLength":1},"format":{"enum":["general","integer","decimal","currency","percent"],"type":"string","default":"general"}},"additionalProperties":false},"maxItems":30,"minItems":1}},"additionalProperties":false},"maxItems":5,"minItems":1},"currency":{"enum":["USD","EUR","GBP","CAD","AUD","JPY","INR"],"type":"string","default":"USD"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.05","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.05/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_N9h73hGyOEECC_iPtdX39","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.05","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Generates styled, multi-sheet XLSX workbooks with typed cells, numeric formats, frozen headers, auto-filters, and cached formula totals from structured JSON input.","exampleAgentPrompt":"Build me a styled XLSX workbook titled 'Q2 Sales Report' with a green accent color, one sheet called 'Revenue' with columns for Product (text), Units (integer), Price (currency in USD), and Margin (percent), include a totals row for Units and Price, and use this sales data I'm pasting in.","exampleUseCases":[{"title":"Monthly expense report spreadsheet","prompt":"Generate an Excel workbook called 'October Expenses' with one sheet named 'Expenses' — columns for Vendor (text), Category (text), Amount (currency, USD), and Approved (text). Add a totals row for Amount and use a blue accent color (#1a56db). Here's the list of expenses to fill in."},{"title":"Multi-sheet sales dashboard export","prompt":"Create a styled XLSX workbook titled 'Sales Dashboard' with two sheets: one called 'By Region' with Region, Q1, Q2, Q3, Q4 columns (all decimal format) and totals on all quarters, and another called 'Summary' with Product and Revenue (currency) columns. Use the default green accent and USD currency."},{"title":"Inventory tracker with formatted columns","prompt":"Build me an Excel file called 'Warehouse Inventory' with a sheet named 'Stock' — columns for SKU (text), Item Name (text), Quantity (integer), Unit Cost (currency), and Total Value (currency). Put totals on Quantity, Unit Cost, and Total Value. Accent color #8b2fc9, currency in GBP."}],"resultDescription":"Returns a downloadable XLSX binary file — a fully styled Excel workbook with the requested sheets, typed and formatted cells, frozen header rows, auto-filters on each sheet, and SUM formula totals cached as numeric values for the specified columns. The file is ready to open in Excel, Google Sheets, or any compatible spreadsheet application.","failureModes":["Invalid accent hex color returns validation error","Sheet name exceeds 31 characters causes rejection","More than 5 sheets or 30 columns per sheet exceeds limits","More than 1000 rows per sheet triggers limit error","String values starting with '=' are kept as text (not evaluated as formulas)","Missing required fields (name, columns, rows) per sheet causes 400 error","Unsupported currency code returns enum validation error"],"whenToPreferThis":"Choose this endpoint when you need to programmatically generate a polished, formatted XLSX file — especially when you require multiple worksheets, typed numeric formats (currency, percent, integer, decimal), frozen headers, auto-filters, and SUM totals in a single API call. Prefer this over generic CSV export when presentation and spreadsheet structure matter, or over Google Sheets API when you want a self-contained file without cloud storage dependencies.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-11T18:31:23.957Z","isFirstParty":false,"canonicalSlug":"sheets-api-xlsx-workbook-builder-73af3980"}