Connect Google Forms to Sage

How it works

Google Forms does not support native outbound webhooks, but it does support Apps Script — a lightweight JavaScript runtime built into every Google Form. You paste a small script that runs automatically on every form submission and posts the response to your Appalix webhook URL.

• The script fires on the On form submit trigger — no polling, instant delivery.
• It sends every field label and value, plus the form title, directly to Appalix.
• Appalix normalises the fields (name, email, phone, company, message) and runs AI analysis automatically.
• The script and webhook URL are unique to your workspace — nothing is shared.

What you'll need

• An Appalix account on the Pro plan or above
• A Google Form — any form in your Google account
• Access to the form's Apps Script editor (available in all free Google accounts)

No API keys, no OAuth setup, and no paid Google Workspace plan is required — a free Google account works perfectly.

Step 1 — Connect Google Forms in Sage Integrations

1. In Appalix, navigate to Sage → Integrations in the left sidebar.
2. Scroll to the Forms section and find the Google Forms card.
3. Click Connect to expand the configuration panel.
4. Webhook Secret (optional): You can enter any string here (e.g. a long random password). If provided, the secret is appended to your webhook URL as a query parameter — Appalix will reject any request that doesn't include it. Leave this blank if you prefer a simpler setup.
5. Click Save & Connect. The card will show a green Connected badge.

Step 2 — Copy the pre-filled Apps Script

1. In the connected Google Forms card, expand the setup panel. You'll see a Set up in 3 steps section.
2. Click the Copy script button. The entire Apps Script (including your unique webhook URL) is copied to your clipboard.

The script looks like this:

function sendToAppalix(e) {
  var form = FormApp.getActiveForm();
  var fields = {};
  e.response.getItemResponses().forEach(function(r) {
    fields[r.getItem().getTitle()] = String(r.getResponse());
  });
  UrlFetchApp.fetch('https://appalix.ai/api/webhooks/google-forms/YOUR_ID', {
    method: 'post',
    contentType: 'application/json',
    payload: JSON.stringify({ form_title: form.getTitle(), responses: fields }),
    muteHttpExceptions: true
  });
}

When you copy from the Appalix card, YOUR_ID is replaced with your real workspace ID (and your secret, if you set one).

Step 3 — Open Apps Script in your Google Form

1. Open your Google Form in Google Forms (forms.google.com).
2. Click the 3-dot menu (⋮) in the top-right corner of the form editor.
3. Select Extensions → Apps Script. The Apps Script editor opens in a new tab.

Step 4 — Paste and save the script

1. In the Apps Script editor, you'll see a Code.gs file with a default function. Select all existing code and delete it.
2. Paste the script you copied from Appalix (⌘V on Mac, Ctrl+V on Windows).
3. Click the Save icon (floppy disk 💾) or press ⌘S / Ctrl+S.
4. If prompted to name the project, enter something like Appalix Webhook and click OK.

Step 5 — Add the On form submit trigger

The script won't run automatically until you attach it to a trigger. This is a one-time setup per form.

1. In the Apps Script editor, click the Triggers icon — it looks like a clock or alarm bell (⏰) in the left sidebar.
2. Click Add Trigger (bottom-right of the page).
3. In the trigger dialog, set:
   • Choose which function to run: sendToAppalix
   • Which deployment should run: Head
   • Select event source: From form
   • Select event type: On form submit
4. Click Save.
5. Google will ask you to authorise the script. Sign in with your Google account and click Allow. This lets the script access form responses and make external HTTP requests.

Step 6 — Test the connection

1. Go back to Sage → Integrations in Appalix.
2. Expand the connected Google Forms card and click Send test submission.
3. You should see "Test sent — check your Forms tab." within a few seconds.
4. Navigate to Sage → Forms to see the test entry. It will appear as a submission from "Test Form (Google Forms)".

Alternatively, submit your actual Google Form. The response will appear in Sage → Forms within seconds.

What gets captured

Every field in your Google Form is sent to Appalix exactly as labelled. Appalix then automatically maps common field names to standard contact fields:

All other fields are stored in the raw payload and are visible when you open a submission in Sage → Forms. Nothing is lost — unmapped fields are just not extracted into the standard contact columns.

Connecting multiple Google Forms

You only connect Google Forms once in Sage Integrations — the same webhook URL works for every form. For each additional Google Form, simply repeat steps 3–5: open the form, go to Apps Script, paste the same script, and add the same trigger.

Submissions from different forms are distinguished in Appalix by their form title (the name of the Google Form). If two forms share the same title, their responses will be grouped under one form in Sage.

Frequently asked questions

Related tutorials