Connect Spreadsheet Data Entry to ChatGPT

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

Before you start

  • An iPhone with the Spreadsheet Data Entry (SSA) app.
  • A ChatGPT account that can use Custom GPTs / GPT Actions.
  • A Google account that can edit the destination spreadsheet (for Sheets submits).

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. Tap Create token. When asked, enter a name (for example ChatGPT) 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 the SSA Custom GPT:
    https://chatgpt.com/g/g-6a6715940eb881919c3bed2da269b393-ssa-agent
  9. When ChatGPT asks for an API key, paste your PAT (pat_…). You only paste the token here — Actions and server URL are already set on the published GPT.
  10. Ask the GPT 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: SettingsStorage providersGoogle accountLog 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 tokenCopy to clipboard). Old full values are never shown again.
GPT cannot call Actions / unauthorized Confirm you pasted the full pat_… value when ChatGPT asked for the API key. Revoke unused tokens in Connect AI if needed (tap a token → Revoke).

Notes

  • Create, copy, and revoke tokens only in the iOS Connect AI screen.
  • Form = app object (all backends for create/configure). Submit via ChatGPT = Google Sheets or Airtable only (not Local / OnlyOffice / Grist).