AI-assisted internal tools for non-tech firms
Describe what you need to track and get a ready-to-import tracker for Google Sheets, Airtable or Excel, with forms, views and counts.
Ready to use. Buy it in your account: a one-time licence fee and a monthly fee, plus the AI it uses.
What it does
Say what you need to track or manage, who uses it and how, the things to record and the stages, and tick where you will build it. The AI designs the tables (each column with a type, dropdown choices and whether it is required), sample rows with placeholders, a form, views for each person, counts worth seeing and automations. We check the design, build an import file for each table, write the counting formulas ourselves so they work, and give the set-up steps for each product you chose. You import it and set it up.
Who it is for
- Small teams running things on paper or email
- Owners who need a tracker but not software
- Offices, garages, shops and clinics
Quick start
- 01Say what you need to trackIn a sentence or two, with who uses it.
- 02Add what to record and the stagesSuch as Item, Borrowed by, Due back; and Requested, Out, Returned.
- 03Run itIt takes a minute. You can leave the page: the result waits in your run history.
- 04Import and set upDownload the import files and follow the steps for your product.
What you give it
- What you need to track or manageRequired, up to 1,000 characters
- What you need to track or manage.
- Who uses it, and howRequired, up to 6 lines
- Who uses it and how, a line each.
- Things to recordOptional, up to 20 lines
- The things to record, which become columns. Optional.
- Stages or statusesOptional, up to 10 lines
- Stages or statuses, used as a dropdown. Optional.
- Build it in Google SheetsOptional
- Tick to get import files and steps for Google Sheets.
- Build it in AirtableOptional
- Tick to get import files and steps for Airtable.
- Build it in ExcelOptional
- Tick to get import files and steps for Excel.
- Anything elseOptional, up to 1,500 characters
- Anything else, such as how many items or how often reports are needed. Optional.
What you get
- Tables and columns
- Each column's type, choices and what goes in it. Downloadable as a spreadsheet.
- Import files
- One CSV per table with sample rows, ready to import.
- Form, views and counts
- A form, views for each person, and formulas for the counts.
- Set-up and rollout
- Step-by-step set-up for each product you chose, automations and a rollout checklist.
You can edit the result, then copy it, print it or download it as Word, Markdown, plain text or data. Every run is kept in your run history until you delete it.
An example
Hartley & Co Accountants is a made-up business. Below is what was entered, then the tool's real result, unedited, made on 12 November 2026. Subscribe to run it with your own details.
What was entered
From Hartley & Co Accountants’s Business profile
- What you sell
- Accounts, tax and payroll for small businesses in Leeds
- What you need to track or manage
Laptops, headsets and keys we lend to staff: who has what, since when, when it is due back, and what is overdue.
- Who uses it, and how
- Office manager: adds and updates loans
- Staff: ask to borrow something through a form
- Partners: see what is out
- Things to record
- Item
- Borrowed by
- Date out
- Due back
- Stages or statuses
- Requested
- Out
- Returned
- Build it in Google Sheets
Yes
3 optional details were left empty.
In your account this is a form you fill in, and the tool runs once you subscribe.
What the tool returned
Simple tool builder
In short
A simple loans tracker for the laptops, headsets and keys that the firm lends to staff. It shows who has what, since when and when it is due back, and makes overdue items easy to spot. Staff ask to borrow through a form and the office manager keeps the record up to date.
Tables
1. Loans
Purpose: One row for each request to borrow an item, followed through from request to return.
Columns
1. Item
Type: Text
Required: Yes
What goes in it: What is being lent, for example a laptop, headset or set of keys, with any tag or label.
2. Item type
Type: Single choice
Choices: Laptop; Headset; Keys; Other
Required: Yes
What goes in it: The kind of item, so loans can be grouped.
3. Borrowed by
Type: Text
Required: Yes
What goes in it: The member of staff who has asked to borrow it.
4. Stage
Type: Single choice
Choices: Requested; Out; Returned
Required: Yes
What goes in it: Where the loan has got to.
5. Date out
Type: Date
Required: No
What goes in it: The day the item was handed over; filled in by the office manager.
6. Due back
Type: Date
Required: No
What goes in it: The day the item should be returned.
7. Date returned
Type: Date
Required: No
What goes in it: The day the item actually came back.
8. Notes
Type: Long text
Required: No
What goes in it: Any extra detail, such as condition or the reason for the loan.
Form
Title: Request to borrow an item
Who fills it in: Staff who want to borrow a laptop, headset or keys
Fields
- Item
- Item type
- Borrowed by
- Due back
- Notes
Views
1. Open requests
Shows: Rows where Stage is Requested, sorted by Due back with the soonest first
For: Office manager: adds and updates loans
2. Currently out
Shows: Rows where Stage is Out, sorted by Due back with the soonest first
For: Partners: see what is out
3. Overdue
Shows: Rows where Stage is Out and Due back is before today, sorted by Due back with the oldest first
For: Office manager: adds and updates loans
Counts to show
Count 1
Label: Requests waiting
Sheets or Excel formula: =COUNTIF('Loans'!D:D,"Requested")
In Airtable: Not needed: you did not choose Airtable
Count 2
Label: Items out
Sheets or Excel formula: =COUNTIF('Loans'!D:D,"Out")
In Airtable: Not needed: you did not choose Airtable
Count 3
Label: Items returned
Sheets or Excel formula: =COUNTIF('Loans'!D:D,"Returned")
In Airtable: Not needed: you did not choose Airtable
Count 4
Label: All loans recorded
Sheets or Excel formula: =COUNTA('Loans'!A:A)-1
In Airtable: Not needed: you did not choose Airtable
Automations
- Set a notification rule so the office manager gets an email whenever the linked form receives a new request.
- Use conditional formatting to highlight in colour any row where Stage is Out and Due back has passed, so overdue items stand out.
- Use dropdowns for Stage and Item type so entries stay consistent.
Setting it up
Product 1
Product: Google Sheets
Steps
- Create a new spreadsheet. For each table (Loans), use File > Import > Upload with its CSV file and choose "Insert new sheet"; name the sheet after the table.
- Delete the sample rows once you have seen how it works.
- For each choice column, select the column and use Data > Data validation, with the choices listed as a dropdown.
- Format date columns with Format > Number > Date, and money columns as currency.
- For a linked record column, add a dropdown from the linked sheet's first column (Data validation > Dropdown (from a range)).
- Add a sheet called Summary and paste in the formulas from "Counts to show".
- For the form, create a Google Form with the form's fields, then link it to the spreadsheet from the form's Responses tab.
- Share the spreadsheet with the people who use it, as editors or viewers.
Rollout checklist
- Create the Loans sheet with the columns listed and add the dropdown choices for Stage and Item type.
- Paste in the sample rows to check the layout, then delete them.
- Add conditional formatting to highlight overdue rows.
- Create the linked form with the fields listed and share the link with staff.
- Set the notification rule so the office manager is emailed on each form response.
- Create the filter views for open requests, items out and overdue, and share the sheet with the partners as view only.
- Enter the items currently lent out so the record starts accurate.
- Hold a first review after a few weeks with the office manager and partners to adjust columns, views and the form.
Only for you: not included when you copy, print or download
Check before using
- Try it for a week with the people who use it before relying on it, and keep a copy before big changes.
What the AI does
It does
- Designs the tables, form, views and counts
- Writes sample rows with placeholders
- Suggests automations and a rollout checklist
- Never adds sensitive columns you did not need
It does not
- Build it in your account for you
- Connect to your other systems
- Write complex formulas or scripts
- Move your existing data
Please check itCheck the columns fit how you work, delete the sample rows after importing, and limit who can see any personal details.
Limits
- What you need to track or manage: up to 1,000 characters.
- Who uses it, and how: up to 6 lines.
- Things to record: up to 20 lines.
- Stages or statuses: up to 10 lines.
- Anything else: up to 1,500 characters.
- Up to three tables and 15 columns per table a run.
- Your workspace's monthly cap: a run that would take you over it pauses, and carries on where it stopped when you raise the cap.
Your data
- What you enter, the files you choose and the result are stored encrypted with your workspace's own key. Only people in your workspace can open them.
- To produce the result, what you give the tool (and the parts of your Business profile it uses) is sent to our AI provider, Anthropic. It uses it only to answer, and its terms do not allow it to train its models on it. We do not train on it either.
- Files you upload are deleted after 30 days unless you choose to keep them. You can delete a run at any time: what you entered, the result and the progress notes go; only the usage record stays, because it is part of your billing.
- Our service is hosted in the United States.
The full details are in our privacy notice.
Questions
How are runs charged?
A one-time licence fee of $800 (£800 in the UK), then $200 a month (£150 in the UK), including any tax that applies. On top, you pay for the AI each run uses, billed each month with your invoice and never more than the monthly cap you set. From your fourth tool there is no licence fee.
Can I change the result?
Yes. Choose Edit this result to change any wording or figure, and Restore the original result to go back. Copy, print and downloads use your edited version.
Is it ready to use now?
Yes. Sign in, open Tools in your account and choose Get started for this tool.
Do the formulas work?
We write the counting formulas ourselves from the columns of each table, so they point at the right column.
Can I build it in more than one product?
Yes: tick each one and you get the set-up steps for each.
If something goes wrong
- A column I wanted is missing.
- Add it to the things to record and run it again, or add it yourself after importing.
- The dropdown is missing a stage.
- Add every stage to the stages and run it again.
Still stuck? Use the enquiry form and say which tool and what you saw.