How to Connect DropForm to Google Sheets

What you'll achieve

• Connect your Google account to DropForm.
• Select a spreadsheet from Google Drive.
• Automatically create (or reuse) a submissions tab named Contact Form Submissions.
• Append each new submission as a new row.

Before you start

• You have a DropForm form created (any form works - schema is optional).
• You have a Google account with access to a spreadsheet in Google Drive.
• You can open the spreadsheet in your browser to verify rows are being added.

Step-by-step: Connect Google Sheets

Step 1 - Open your form integrations

1. Open DropForm dashboard.
2. Select your form.
3. Go to Integrations.
4. Find Google Sheets and click Connect (or Enable).

Step 2 - Connect your Google account

1. Click Sign in with Google.
2. Select the Google account that owns (or has access to) your spreadsheet.
3. Approve the permissions prompt.

After connecting, DropForm stores your authorization securely and uses it only to write into the spreadsheet you select.

Step 3 - Choose a spreadsheet

1. In the Google Sheets integration settings, click Select spreadsheet.
2. Pick an existing spreadsheet from your Drive.
3. Save the integration.

Step 4 - DropForm creates (or reuses) the submissions tab

DropForm will create a sheet tab named Contact Form Submissions inside the selected spreadsheet. If a tab with the same name already exists, DropForm will reuse it.

Step 5 - Send a test submission

1. Open your website form (or submit via API/test submit).
2. Submit at least one test entry.
3. Open the spreadsheet and click the tab Contact Form Submissions.
4. Confirm a new row appeared at the bottom.

How rows and columns work

When a new submission arrives, DropForm appends it to the first empty row (append behavior). This is the most reliable way to avoid overwriting your data.

• Header creation: DropForm writes headers when it has fields to write. If your form has a schema, headers are known up front. If not, headers evolve as new keys appear.
• Arbitrary fields: If a submission contains a new field key that hasn't been seen before, DropForm can add a new column and continue writing without failing.
• Newest first: Google Sheets “append” writes to the bottom. If you want newest-first, create a separate view tab and sort/filter there.

Troubleshooting

No rows are appearing

• Make sure the integration is enabled for the correct form.
• Confirm you selected the right spreadsheet.
• Ensure the connected Google account still has access to the spreadsheet.

Columns are shifted or incorrect

• Don't rename headers or move columns in Contact Form Submissions.
• If it was modified, the fastest fix is: create a fresh spreadsheet → reconnect → re-test.

Next steps

Once your submissions flow into Google Sheets, you can share the sheet with teammates, build lightweight reports, or export data into other tools - without Zapier.