Google Sheets

Build internal apps on your Google Sheets

Your team already runs on spreadsheets: the order tracker, the price list, the roster. Now the tools you build with AI can read and add rows in those sheets, behind your company login, and the sheet stays the place people already know.

Quick answer

An admin connects Google Sheets once. Your company gets its own Google address. Share a sheet with that address, the way you share with a coworker, and add "services": ["sheets"] to the app. In the code, ctx.sheet(link).rows() reads the rows. Nothing to install, no Google keys. On every plan, and in the free trial.

Every plan, and the free 14-day trialLast updated

01Step by step

How to use a sheet in an app

An admin does step 1 once. After that, anyone who can edit a sheet can share it with the company address.

  1. Connect Google Sheets (admins, once)

    In the dashboard, Company page, “Connect Google Sheets”. Or npx teamonly services add sheets. Your company gets its own address, like t-acme-x7k2@teamonly-sheets.iam.gserviceaccount.com. The dashboard shows it with a copy button.

  2. Share the sheet with that address

    In Google Sheets, Share, paste the address. Viewer lets apps read the sheet; Editor lets them add and change rows. Google may say the address is outside your organization: that is expected, choose “Share anyway”.

  3. Turn it on for an app

    Add "services": ["sheets"] to the app’s teamonly.json and run npx teamonly deploy. Apps that don’t list it can’t get a Google token.

  4. Use it in the code

    In the app’s API, c.var.ctx.sheet(link).rows('Orders') returns the rows as objects named by the header row. append adds rows and update changes cells. On your computer, run npx teamonly services dev once and the app reads the same sheets.

Terminal~/supply-requests
npx teamonly services add sheetsGoogle Sheets is connected as "sheets".  Share each sheet with t-acme-x7k2@teamonly-sheets.iam.gserviceaccount.com (Viewer to read it, Editor to change it), like sharing with a coworker.npx teamonly deployUses Google Sheets ("sheets")Live at https://supply-requests.acme.teamonly.appOnly @acme.com accounts can sign in

02The code

What it looks like in the app

One line in the app’s settings, and a few lines in its API. Your AI tool writes this part.

teamonly.json
{
  "name": "supply-requests",
  "services": ["sheets"]
}

Values come back as text, the way the sheet shows them. The header is the first row with anything in it, and empty rows are skipped. Rows you add are typed in like a person would, so dates and formulas work.

src/worker/index.ts
import { Hono } from 'hono';
import { teamonly, type TeamOnly } from 'teamonly/server';

const app = new Hono<TeamOnly>();
app.use('*', teamonly());

const SHEET = 'https://docs.google.com/spreadsheets/d/1AbC.../edit';

// [{ Item: 'Chair', Qty: '2', Status: 'Open' }, ...]
app.get('/api/requests', async (c) => {
  const rows = await c.var.ctx.sheet(SHEET).rows('Requests');
  return c.json(rows.filter((r) => r.Status !== 'Done'));
});

app.post('/api/requests', async (c) => {
  const { item, qty } = await c.req.json();
  await c.var.ctx.sheet(SHEET).append('Requests', [
    {
      Item: item,
      Qty: qty,
      Status: 'Open',
      'Asked by': c.var.ctx.user.email,
    },
  ]);
  return c.json({ ok: true });
});

export default app;

03Ask your AI tool

What to type

Paste the sheet’s link and name the tab. Your AI tool does the rest.

  • A form that adds rows

    “Build a supply request form. Each request adds a row to the Requests tab of this sheet: [link]. Fill in who asked from the signed-in person.”

  • A nicer view of a big sheet

    “Make a searchable price list from the Prices tab of this Google Sheet: [link]. Filters for category and supplier. Read only.”

  • Approvals next to the sheet

    “Read open orders from our tracker sheet: [link]. Let managers approve or reject each one, keep the approvals in the app’s own database, and write “Approved” into the Status column.”

04For IT

What IT sees and controls

  • Apps see only what people share

    The company address can open a sheet only after someone shares it, like any coworker. Remove the share and apps lose it at once. Viewer means read-only, whatever the code says.

  • One Google account per company

    Each company gets its own address. One company’s apps can never open another company’s sheets, even with the link.

  • Short tokens, Sheets only

    Apps get a one-hour token that works only for the Google Sheets API, and only if they list the service. No app holds a Google key or a password.

  • Only admins connect it

    Only company admins can connect or disconnect Google Sheets. It can’t be disconnected while an app still uses it.

  • Which apps use it

    The dashboard shows the address and the apps that use it. Each app page lists the services it uses.

  • Your Workspace rules still apply

    If your Google Workspace blocks sharing outside the company, your Workspace admin decides whether to allow the address. Nothing changes in Google until someone shares a sheet.

05Compared

How is this different from AppSheet?

AppSheet is Google’s own way to build apps on sheets, in its no-code editor. It charges for each person who uses the apps: Starter is $5 a user a month and Core is $10, though Core is included in most paid Google Workspace plans. On TeamOnly the app is ordinary code your AI tool writes, so it can do whatever React and an API can do, and people who only use apps are free.

Checked 27 October 2026. Source: AppSheet pricing. More options compared: Retool alternatives.

06FAQ

Questions people ask

All questions and answers

Does TeamOnly see our sheets?

Only the sheets you share with your company’s address, and only when one of your apps asks. TeamOnly doesn’t copy or store the sheet. Requests go from the app straight to Google.

Do people need a Google account to use the app?

No. They sign in to the app with your company login, Google or Microsoft or an email code. The app reads the sheet with the company address, so people never sign in to Google for it.

Our Google Workspace blocks sharing outside the company. What now?

Your Workspace admin decides that in the Google Admin console, in the sharing settings for Drive. Once sharing outside the company is allowed for the people who own the sheets, they can share with the company address.

Is a sheet a good database?

For lists people also edit by hand, yes, up to a few thousand rows. For data only the app writes, like approvals, comments or history, use the app’s own database, which every app has. Many apps use both.

Does it work with Excel or Microsoft 365?

No, it works with Google Sheets. An app can take Excel or CSV uploads and keep the rows in its own database.

What does it cost?

Nothing extra. Google Sheets works on every plan, from Builder at $19 a month, and in the free 14-day trial. There is no charge per sheet or per person who uses the apps.

Early access

Put your first tool online this week.

TeamOnly is in early access, and every plan is open now. Share one app with up to 5 people for free, try Builder free for 14 days, or subscribe. Either way, your company is ready right away, and three commands put your first app online.

Start freeOr subscribe now

No card for the Free plan or the trial. Paid plans from $19 a month, cancel any time.

Not ready? Get updates

Use your work email. We write rarely, and only when there is news worth sending.

Questions go to hello@teamonly.dev, and a person answers.