Google Sheets Integration

Manually copying form submissions into a spreadsheet is tedious. Lucid Forms provides a direct, native integration with Google Sheets, allowing new form submissions to be instantly appended as neat rows in a selected spreadsheet. No middleware (like Zapier or Make) or code required.

---

Setting Up Google Sheets Integration

Follow these steps to connect your form to a Google Sheet:

1. Open your Lucid Forms Dashboard and select your form.
2. Click on the Integrations tab in the sidebar.
3. Locate Google Sheets and click Connect Account.
4. Log in to your Google Account and grant permissions to access your spreadsheets.
5. Once authorized, select the Spreadsheet and the specific Sheet (Tab) where you want to write submissions.
6. Click Save Integration.

---

How Field Mapping Works

Lucid Forms makes data organization simple by mapping your form input fields to sheet column headers.

Automatic Header Creation

If your Google Sheet is empty:

• On the first form submission, Lucid Forms will automatically create column headers in Row 1 based on your input name attributes (e.g., name, email, message, submitted_at).
• All subsequent submissions will be cleanly appended as new rows matching these column headers.

Existing Header Mapping

If you already have headers in Row 1:

• Lucid Forms will search for columns that match your input name attributes (case-insensitive).
• If a match is found, the value is written to that column.
• If no match is found, a new column header is added at the end of Row 1.

---

Managing Multiple Integration Accounts

If you manage forms for multiple clients or departments:

• Pro Feature: The Pro Plan allows you to connect Multiple Integration Accounts (e.g., syncing Form A to one client’s Google Account and Form B to a different client’s Google Account).
• You can manage, add, or remove linked Google accounts directly under the Connected Accounts section in your dashboard settings.