Google Sheets for forms
Google Sheets integration lets form submissions append new rows to a spreadsheet you control—ideal for lightweight reporting, agency QA sheets, or bridging data into other tools via Sheets formulas.
Connect a Google account​
- Open Leads → Form (the Form leads entry point).
- If your workspace shows Google Sheets in the header, choose it. (The product may limit this shortcut to administrator accounts; others ask an admin to connect first.)
- On Google Sheets management, click Add Google account.
- Complete Google OAuth in the new window. When Google finishes, you return to Atomicat with either:
oauth_success=true— You should see a success toast and the account list refreshes.oauth_error=…— You should see an error toast with the reason text; fix the Google side or retry.
The app cleans query parameters from the address bar after it reads them so bookmarks stay tidy.
Manage connected accounts​
The table lists each connected profile with:
- Account email
- Account name
- Connected at
- Remove — Deletes the connection on Atomicat’s side. You must confirm; the copy warns that forms relying on that account will stop appending until you reconnect or remap settings.
While accounts load, the page shows a loading state; the Add button shows Connecting during OAuth initiation.
Map forms to spreadsheets​
After at least one account exists:
- Open the page in the Page Builder.
- Select your form element and open form settings.
- Open the Google Sheets section.
- Choose the connected account, spreadsheet, and worksheet.
- Map each form field to a spreadsheet column.
Atomicat appends a row per submission with the mapped values. Field definitions live with the form—see Forms (elements).
Troubleshooting​
| Symptom | What to check |
|---|---|
| OAuth error toast | Google admin may block third-party apps, or the user canceled consent. |
| Rows stopped | A removed Google account, revoked Google tokens, or renamed tabs/columns. |
| Wrong data column | Re-open the mapping UI and align fields to headers again. |
Related docs​
Frequently asked questions​
Can quizzes write to Sheets through this screen?
This management page is oriented around form Google integrations. Quiz automations are configured inside quiz tooling; check Quizzes overview for the latest options.
Do I share my Google password with Atomicat?
No. OAuth grants scoped access tokens; you never paste a password into Atomicat.