# Build internal apps on your Google Sheets

> Canonical: https://teamonly.dev/google-sheets

Last updated 27 October 2026. Every plan, and the free 14-day trial.

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.

## 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.

```
npx teamonly services add sheets
✔ Google 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 deploy
✔ Uses Google Sheets ("sheets")
✔ Live at https://supply-requests.acme.teamonly.app
```

## 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:

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

src/worker/index.ts:

```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;
```

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.

## 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."

## 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.

## 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](https://about.appsheet.com/pricing/). More options compared: [Retool alternatives](https://teamonly.dev/compare/retool-alternatives).

## FAQ

### 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.

## Keep reading

- [All features](https://teamonly.dev/features): Everything each app gets, on one page.
- [Company databases](https://teamonly.dev/databases): Connect apps to your Postgres or MySQL database.
- [Internal tools](https://teamonly.dev/internal-tools): Build internal tools with AI and share them safely.
- [Security](https://teamonly.dev/security): Sign-in, isolation, cookies and secrets, in detail.
- [Pricing](https://teamonly.dev/pricing): Free for 14 days. Builder $19, Team $249. App users are free.
