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
- Open the SSA iOS app. On Authorization, tap Don't have an account?
- On Registration, enter email and password, then tap Sign up. (If you already have an account, tap Log in on Authorization instead.)
- On My forms, tap the gear icon (top left) → Settings.
- Tap Storage providers → under Google account, tap Log in and finish Google sign-in.
- Go back to Settings, then tap Connect AI.
-
Tap Create token. When asked, enter a name (for example
ChatGPT) and confirm Create token. -
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. -
Open the SSA Custom GPT:
https://chatgpt.com/g/g-6a6715940eb881919c3bed2da269b393-ssa-agent -
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. - 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: 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. |
| 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).