Sending Data to Google Sheets (PRO)

Prefer video? Watch the Fillin Forge tutorials 9 short guides covering every feature Watch

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. Your site sends the row to our API (api.avakode.com), and our API adds it to your spreadsheet.

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 Fillin Forge

Go to Fillin Forge > Settings (the Google (Sheets + Calendar) card).
Click Connect Google Account to start the Google OAuth flow.
Google’s sign-in page opens in the same browser tab (the card says “Opens Google consent in this tab”). Sign in with your Google account.
Review the permissions Google lists and allow them. For spreadsheets Fillin Forge asks for the drive.file scope, which gives it access only to the spreadsheets you pick or create in the form builder, not to the rest of your Google Drive. The sign-in is shared by the Avakode products, so the list also holds the calendar permissions used by Google Calendar bookings and permissions that belong to other Avakode tools, such as Search Console for Rank Forge.
After authorization, the card shows “Connected as” with your Google account (or “Google account connected”) and a Disconnect button. Your credentials are stored on the Forge API server, not in your WordPress installation.

Step 2 — Prepare Your Spreadsheet

Open Google Sheets and create a new spreadsheet (or open an existing one).
If you like, add a header row for your own reference. Fillin Forge does not read it and there is nothing to map: each row it adds starts with the submission ID and the date and time, followed by one cell for each field of the form that takes an answer, in the order of the form (see How It Works below).
You do not need to copy the spreadsheet ID or the tab name. In the next step you pick the spreadsheet in the form builder, and Fillin Forge uses its first tab.

Step 3 — Enable Google Sheets on a Form

Open your form in the builder.
Find the Google Sheets card in the builder.
Toggle on Append submission row to Google Sheet.
Under Spreadsheet, click Choose spreadsheet and pick the sheet, or click Create new to make a new one. The card shows the tab that will be used: the first tab of the sheet.
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 row starts with the submission ID and the date and time, followed by one cell for each field of the form that takes an answer, in the order of the fields in the form. Layout fields such as Heading, HTML Block, Divider and Page Break have no cell. When a field was hidden by conditional logic for a visitor, its cell stays empty in that row, so the answers after it stay in their columns. A form with a Payment (Stripe) field has one more cell, always empty, right after that field’s cell.
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

Real-world example: You organize community workshops. Your registration form feeds into a Google Sheet shared with your entire volunteer team. As registrations come in, volunteers can see in real time how many people are signed up, who they are, and what dietary needs to accommodate — all without anyone logging into WordPress.

> Tip: Use a separate spreadsheet for each form rather than mixing multiple forms in one. Fillin Forge writes to the first tab of the spreadsheet you pick, so two forms in one spreadsheet end up in the same tab. A separate spreadsheet 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

Picking the wrong spreadsheet. Check that the spreadsheet named in the Google Sheets card is the one you want.
Renaming or reordering tabs after setup. Fillin Forge saves the first tab when you pick the spreadsheet, so pick the spreadsheet again if the tab that should receive the rows has changed.
Moving or deleting columns in the spreadsheet after setup. Fillin Forge keeps adding each row in the same order (submission ID, date and time, then one cell for each field of the form that takes an answer, in the order of the form), so the values no longer line up with your headers. Adding, removing or reordering form fields changes the columns of the rows sent after the change in the same way. Rows already in the spreadsheet are not changed.

[Screenshot: A Google Spreadsheet with a header row and several rows of form submission data, each row starting with the submission ID and the date]

—