The Google Sheets integration automatically adds a new row to a Google Spreadsheet every time someone submits your form. This is perfect for teams that already work in Google Sheets, want real-time collaborative access to form data, or need to feed submissions into existing spreadsheet workflows like sales tracking, event management, or inventory.
The power of this integration is real-time collaboration. The moment someone submits your form, every team member who has access to the spreadsheet sees the new data without refreshing, without exporting, and without logging into WordPress.
What You Need Before Starting
- A Google account
- A Google Spreadsheet created and ready to receive data (or you can create one during setup)
Setup Walkthrough
Step 1 — Connect Google in Form Forge- Go to Form Forge > Settings > Google.
- Click Connect to start the Google OAuth flow.
- A new window opens asking you to sign in with your Google account.
- Grant Form Forge permission to edit your spreadsheets.
- After authorization, you will see a “Connected” status. Your credentials are stored securely on the Forge API server.
- Open Google Sheets and create a new spreadsheet (or open an existing one).
- In the first row, add column headers that correspond to your form fields. For example: “Name” in A1, “Email” in B1, “Phone” in C1, “Message” in D1. These do not need to match your form labels exactly — you will map them in the next step.
- Copy the Spreadsheet ID from the URL. In a URL like
https://docs.google.com/spreadsheets/d/1aBcDeFgHiJkLmNoPqRsTuVwXyZ/edit, the ID is the long string between/d/and/edit. - Note the sheet name (the tab name at the bottom of the spreadsheet, usually “Sheet1”).
- Open your form in the builder.
- Go to the form’s Integrations settings tab.
- Toggle on Google Sheets.
- Paste the Spreadsheet ID into the field.
- Enter the Sheet Name (for example, “Sheet1” or whatever your tab is named).
- Save the form.
How It Works
- Every time someone submits the form, a new row is appended to the bottom of the specified sheet.
- Each form field value goes into its own column, matching the order of your column headers.
- The row appears in real time. Refresh your spreadsheet and the new data is there.
- Existing rows are never modified. Only new rows are added.
Real-World Use Cases
| Use case | How it helps |
|---|---|
| Sales leads | Feed leads into a shared spreadsheet your sales team monitors in real time |
| Event registrations | Build a live attendee list that updates automatically |
| Survey responses | Collect responses in a spreadsheet ready for charting and analysis |
| Order tracking | Maintain a running list of orders your fulfillment team works from |
| Content submissions | Collect guest blog posts or testimonials in a spreadsheet for editorial review |
| Support requests | Log tickets in a spreadsheet your support team triages |
> Tip: Create a separate sheet (tab) for each form rather than mixing multiple forms in one sheet. This keeps the data clean, the column headers consistent, and avoids confusion when different forms have different fields.
> Good to know: Without PRO, the Google Sheets integration is not available. You can export submissions to CSV (free) and manually import them into Google Sheets, but this is a manual process that does not happen in real time.
Common Mistakes to Avoid
- Pasting the entire spreadsheet URL instead of just the Spreadsheet ID. Only paste the ID string, not the full URL.
- Forgetting the sheet name. If your tab is named “Registrations” but you enter “Sheet1,” the integration will fail.
- Deleting or renaming columns in the spreadsheet after setup. This can cause data to land in the wrong columns. If you need to reorganize, update the form’s integration settings too.
[Screenshot: A Google Spreadsheet with column headers matching form fields and several rows of form submission data, with the Spreadsheet ID highlighted in the browser’s URL bar]
—