Create and update apps with AI

You don't need to hand-build an App Specification workbook to get an app. Describe what you need in plain words, and an AI assistant writes the workbook for you. You review it, you approve it, Sheetward builds it.

One thing never changes: Sheetward apps are always generated from an App Specification workbook. The same workbook always produces the same app. The AI never builds the app itself — it only helps you author the workbook. Whatever it produces lands on the same review step as a workbook you wrote by hand in Excel.

Which assistant do you need?

Each draft, revision or reshape counts as one AI authoring on your plan's monthly allowance. Each additional language it drafts adds one more. The Usage meter in your workspace shows where you stand.

What makes a description work well?

These habits apply to all three assistants:

• Name the fields — "with details: A, B, C". Anything you don't name is guessed, and every guess is listed as an assumption for you to review.
• Put list values inline — "Department has list of values: Finance, HR, …" becomes a List_ sheet feeding a dropdown.
• Say what's required, what's the key, and what's auto-generated — these become Rules_ rows. Ask for "appropriate messages" to get custom error text instead of the defaults.
• Describe calculations in plain words — "Amount = Quantity × Unit Price" and "Total is the sum of line amounts" become Formula_ rows.
• Ask for dashboards when you want them — dashboards only appear when requested; say "include a dashboard with …" to get a Report_ sheet.
• Name additional languages — "support additional languages German, Japanese". Supported: German, Japanese, Arabic. Each additional language bills one extra AI authoring.
• Write in your own language — the specification itself is always authored in English (every app's base language). Write your description in German, Japanese or Arabic and that language is added automatically. The finished app then also displays in the language you wrote in.

Draft with AI — create a new app

On New app, choose Draft with AI, describe the app, and give it a name. The name is required, and it also names the downloadable workbook ("<App name> Specification.xlsx").

Nine example prompts, from simple to ambitious:

1 · Student List — a simple single-form register.

Prompt: "Create a Student List with details – Student Name, Grade, Gender, Age, State, Photo."

What to expect: one form with sensibly typed fields (Age is numeric). Photo becomes a real image-upload field — media types are recognized from field names (photo, picture, avatar → image; also video, audio, document).

2 · Budget — reference lists that feed dropdowns.

Prompt: "Create a Budget application with details – Year, Department, Budget Item, Budget Category, Budget in $, LY Actuals in $. Department has list of values – Finance, HR, Purchasing, Warehouse, Corporate. Budget Category has list of values – Capital, Marketing, Maintenance, Special Project, Operations, Corporate."

What to expect: List_Department and List_Budget Category sheets feeding dropdowns, and the two $ fields typed as money.

3 · Expense Tracker — auto-numbering and validations with messages.

Prompt: "Create an Expense Tracker with details – Expense ID, Description, Date, Expense Category, Amount. Expense ID is auto generated. Expense Category has list of values – Rent, Mortgage, Car, Insurance, Grocery, Utilities, Entertainment, Travel, Charity, Others. Add validation to check Date should not be in the future. Description, Date and Amount are required fields. All validation errors should have appropriate messages."

What to expect: an auto-numbered Expense ID (the record key), required rules with your custom messages, a no-future-dates check, and the category dropdown.

4 · Purchase Orders — a header with line items, plus calculated fields.

Prompt: "Create a Purchase Order application. Each PO has a PO Number, Supplier, Order Date and Status (Draft/Sent/Received). Lines have an Item, Quantity and Unit Price. Calculate the line Amount as Quantity times Unit Price and the PO Total as the sum of line amounts. PO Number is auto-generated starting at 1000. Supplier comes from a list: Acme Supplies, Globex Trading, Initech. Order Date defaults to today and is required."

What to expect: a two-section form (header + line-item table), live formulas for Amount and PO Total, auto-numbering from 1000, and today's date as the default Order Date.

5 · Invoices with a dashboard — dashboards on request.

Prompt: "Create an Invoicing app. Each invoice has an Invoice No, Customer, Invoice Date, Due Date and Status (Draft/Sent/Paid/Overdue). Lines have a Description, Quantity, Unit Price and Amount; calculate the line Amount and the Invoice Total. Due Date cannot be before the Invoice Date. Include a dashboard with a monthly revenue trend, revenue by customer, and an invoice-count KPI."

What to expect: everything from the Purchase Orders example plus a dashboard — a KPI, a monthly trend chart and a customer breakdown. Dashboards cost nothing extra (your plan's dashboard allowance applies).

6 · Multi-language app — named languages bill extra.

Prompt: "Create a Snack Inventory app: Item, Category (Chips/Candy/Drinks), Quantity and Unit Price. Quantity is required and at least 0. Support additional languages German, Japanese."

What to expect: a Translation_App sheet with German and Japanese labels, plus translated dropdown values. Billing: 1 AI authoring + 1 per language → 3 for this prompt.

7 · A prompt in German — write in your own language.

Prompt: "Erstelle eine Spesen-App. Formular 'Spesenabrechnung' mit den Feldern: Mitarbeiter, Datum, Kategorie (Reisen, Verpflegung, Büromaterial), Betrag, Beleg (Foto) und Bemerkungen. Der Betrag muss größer als 0 sein; Mitarbeiter und Datum sind Pflichtfelder."

What to expect: the specification is authored in English (Employee, Date, Category, Amount, Receipt, Remarks). Because the description is written in German, German is added automatically as an app language — no need to name it. Receipt (Foto) becomes an image field. Billing: 2 AI authorings (1 + 1 for the implicit German).

8 · Work Orders — rules that depend on other fields.

Prompt: "Create a Work Order tracker: Work Order No (auto-generated), Machine, Reported Date, Priority (Low/Medium/High), Status (Open/In Progress/Done), Completed Date and Notes. Completed Date is required if Status is 'Done' and cannot be before the Reported Date."

What to expect: a conditional rule (Completed Date required only when Status is Done) and a date check that compares one field against another.

9 · The vague one-liner — every guess surfaces for review.

Prompt: "I need something to manage my small bakery."

What to expect: a sensible minimal draft. The AI never asks questions back. Every guess it made (which forms, which fields, which lists) is stated in the assumptions panel. Correct it there, regenerate, or refine the workbook in Excel.

Revise with AI — change an existing app

Open your app's Change app dialog and choose Revise with AI. Short, targeted change requests work best. The AI edits the app's current specification. You approve the standard change preview — exactly which fields are added or removed — before anything is applied.

Example change requests:

• "Add a Reorder Level field (required, minimum 0) and a Supplier field to the item form."
• "Add a Discount % field to the line items and include it in the Amount calculation."
• "Add a dashboard with spend by category and a monthly total."
• "Rename the Status values to Open and Closed, and make Notes optional."
• "Also support Japanese." — adds Japanese translations and bills 1 AI authoring + 1 for the new language. Languages the app already has are free to keep: an ordinary revision on a multi-language app is still one AI authoring.

Reshape with AI — fix a blocked upload

No prompt needed. Sometimes an upload is blocked because the workbook holds working data — say, this month's actual expenses instead of a specification. When that happens, the error panel offers Reshape with AI.

This is the only assistant that sends your file's contents to the AI, so it asks for your explicit consent first. Values that look personal (email addresses, phone and card numbers) are removed before anything is sent. The reshaped draft also replaces real-looking values with generic samples. It then goes through the usual review, like any other draft.

The optional note box accepts a short steer, e.g.:

• "Track which customers owe money — the sheet lists the customer, a contact and the amount outstanding."

Good to know

• You always approve. Every draft, revision and reshape passes the same checks as an uploaded workbook and lands on the review step. Nothing is created or applied without you.
• The workbook is always yours. Download "<App name> Specification.xlsx" anytime, polish it in Excel, and upload it like any workbook.
• Billing is visible. Your plan's monthly AI authorings allowance shows on the workspace Usage meter. Each draft, revision or reshape counts as one, plus one per additional language drafted.