Google Sheets Integration

Atomicat can automatically append every form submission to a Google Sheets spreadsheet in real time — no Zapier or third-party tools required.

---

How It Works

1. You connect your Google account to Atomicat (one-time authorization).
2. In your form's settings, you select the connected Google account, spreadsheet, and worksheet.
3. You map your form fields to spreadsheet columns.
4. Every new form submission is added as a new row automatically.

---

Step 1 — Connect a Google Account

1. Go to Leads in the dashboard.
2. Click Google Sheets Management.
3. Click Add Google Account.
4. A Google OAuth window opens — select your Google account and Allow the requested permissions.
5. Your account appears in the list with:
   • Account Email
   • Account Name
   • Connected At date

You can connect multiple Google accounts if needed (e.g., one per client).

---

Step 2 — Configure in the Form Settings

1. Open the Page Builder for the page with the form.
2. Click the form element.
3. In the Right Panel, go to Form Settings → Google Sheets.
4. Select your connected Google Account.
5. Select the Spreadsheet (the file in your Google Drive).
6. Select the Worksheet (the tab inside the spreadsheet).
7. Map fields — match each form field to a spreadsheet column:

Form Field	Spreadsheet Column
Name	Column A
Email	Column B
Phone	Column C
(Custom fields)	Any column

8. Click Save.

---

Step 3 — Test It

Submit a test entry through your form. Within seconds, a new row should appear in your Google Sheet.

Create column headers first

Before connecting, add your column headers (Name, Email, Phone, etc.) in row 1 of the spreadsheet. This makes mapping clearer and keeps your data organized.

---

Managing Connected Accounts

To remove a Google account:

1. Go to Leads → Google Sheets Management.
2. Find the account.
3. Click Remove.

Forms will stop syncing

Removing an account disconnects all forms that were using it. Those forms will no longer send data to Google Sheets.

---

Troubleshooting

Problem	Solution
Submissions not appearing	Check that the form is saved and the sheet mapping is correct
Wrong spreadsheet	Reconnect and re-select the correct spreadsheet
Permission denied	Re-authorize the Google account (it may have expired)
Missing columns	Add column headers to row 1 of your spreadsheet

---

Google Sheets vs Webhooks

Feature	Google Sheets	Webhooks
Setup complexity	Easy (no code)	Requires a receiving endpoint
Real-time	✅ Yes	✅ Yes
Connects to other tools	❌ Sheets only	✅ Any HTTP endpoint
Free	✅	✅
Best for	Simple lead storage	CRM, email platform, automation

For more advanced routing, use Webhooks alongside or instead of Google Sheets.