Formcrest
Log inGet started

Google Sheets

Append every non-spam submission as a new row in a spreadsheet you choose. Google Sheets is a Pro+ integration.

How it works

Once connected, Formcrest appends one row to your spreadsheet per non-spam submission. The first cell is the submission timestamp; the remaining cells contain your form's fields as name: value pairs, ordered alphabetically by field name so columns stay stable as long as your form's fields don't change.

Your Google tokens are stored encrypted at rest and are only used to append rows — the integration requests the spreadsheets scope and nothing else.

Step 1 — Connect your Google account

  1. Open your form in the dashboard and go to the Integrations tab.
  2. Click Connect Google Sheets and approve the consent screen. You'll be returned to the dashboard with the connection active.

Step 2 — Tell us which spreadsheet

  1. Create (or open) the Google Sheet that should receive submissions.
  2. Copy the spreadsheet ID from its URL — the long token between /d/ and /edit:
    docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit
  3. Paste it into the Spreadsheet ID field on the integration and save. Deliveries start with the next submission.

Failures and auto-disable

If appends fail repeatedly (for example, the sheet was deleted or access was revoked), the integration is disabled automatically after 10 consecutive failures. Reconnect from the Integrations tab to resume. Submissions are always stored in Formcrest regardless, so nothing is lost while the integration is down.