Spreadsheet Data Entry

Connect Spreadsheet Data Entry to Claude

Use Claude to create or configure a Spreadsheet Data Entry Form, list forms, and submit rows to Google Sheets (Airtable if that form is already linked).

Download on the App Store Get it on Google Play

Before you start

  • An iPhone with the Spreadsheet Data Entry (SSA) app.
  • Claude Code (recommended) or Claude Desktop with a custom remote MCP connector that can send a static Bearer PAT header. Not the Claude.ai connector directory — that path needs OAuth later and is out of scope here.
  • A Google account that can edit the destination spreadsheet (for Sheets submits).

MCP URL: https://sheetentry.com/mcp — Bearer PAT on every request.

Steps

  1. Open the SSA iOS app. On Authorization, tap Don't have an account?
  2. On Registration, enter email and password, then tap Sign up. (If you already have an account, tap Log in on Authorization instead.)
  3. On My forms, tap the gear icon (top left) → Settings.
  4. Tap Storage providers → under Google account, tap Log in and finish Google sign-in.
  5. Go back to Settings, then tap Connect AI.
  6. Before creating a token, enable the Write scope (create and configure forms) — Read and Submit are on by default; Write is off unless you check it. Tap Create token, enter a name (for example Claude), and confirm Create token.
  7. In the Token created alert, tap Copy to clipboard. Paste the token somewhere safe for the next steps — you will not see the full pat_… value again.
  8. Open Claude Code (preferred) or Claude Desktop.
  9. Add the SSA remote MCP connector (Streamable HTTP — no local install). Auth is a static Bearer PAT on every request (not OAuth):
    • Claude Code (verified path):
      claude mcp add --transport http ssa https://sheetentry.com/mcp --header "Authorization: Bearer pat_…"
      Replace only the pat_… placeholder with your full token value (keep the single Bearer already in the command).
    • Claude Desktop: add a custom remote MCP connector to the same URL with a static Authorization: Bearer pat_… header. Exact menu labels vary by Desktop build — if your build has no place to set a static Bearer header, use Claude Code.
  10. Confirm the connector shows as connected (reload MCP in Claude Code, or restart Claude Desktop if the client asks).
  11. Ask Claude to list your forms (for example: “List my forms”). Confirm it returns your SSA forms.

Done. After the PAT is connected you can ask the assistant to:

  • Create or configure a Form — the Spreadsheet Data Entry app entity (name, fields, types, mapping, settings, backend binding). This is the same Form you edit under My forms in the app. When creating a Form, the assistant can also have it create a new Google Spreadsheet or a new table inside an existing Airtable base as that Form's destination — it does not create a new Airtable base.
  • Get a form schema or submit a row to a Google Sheets form (Airtable submits only when that form’s Airtable account is already linked in the app).

Troubleshooting

Symptom What to do
Error code provider_auth_required for google In the SSA iOS app: Settings → Storage providers → Google account → Log in. Connect AI tokens alone do not link Google.
Error code provider_auth_required for airtable Open the Airtable form in the SSA iOS app and complete Airtable sign-in when prompted (Airtable is not under Storage providers).
Error code quota_exceeded (HTTP 402, “Free send limit exceeded”) Free tier allows 30 sends/month. Wait for the next month or upgrade to a paid plan in the app.
Token alert dismissed without copying Create a new token in Connect AI (Create token → Copy to clipboard). Old full values are never shown again.
HTTP 401 / connector unauthorized Confirm the header value is exactly Bearer pat_… (scheme + space + full token). Missing or truncated PAT is rejected before tools run. If the token was revoked in Connect AI or has expired, create a new token — fixing the header format will not help.
Error code rate_limit_exceeded (HTTP 429) Too many requests in a short time. Wait about a minute, then retry. Limits per token: 100 read / 20 submit / 20 write requests per minute.
Tool error insufficient_scope Create a new Connect AI token that includes the scopes you need (agent:read, agent:submit, and agent:write for create/configure Form).
Connector cannot reach the MCP URL Confirm you use https://sheetentry.com/mcp.

Notes

  • Create, copy, and revoke tokens only in the iOS Connect AI screen.
  • Auth is Bearer PAT on every MCP request — not a process-wide env token and not OAuth (Claude.ai directory listing is a later task).
  • Form = app object (all backends for create/configure). Submit via Claude = Google Sheets or Airtable only (not Local / OnlyOffice / Grist).
  • Do not use a local Node / stdio MCP install for this path; the product path is the hosted remote endpoint.

Contact the developers

bytepace.sitgsa@gmail.com Telegram