Google Forms guide

Enhance Google Forms with LeadToSheet attribution

Google Forms already sends responses to Google Sheets, but it misses UTM parameters, referrer URLs, and device data. LeadToSheet adds the attribution layer that Google Forms lacks when you embed forms on your website.

CMS: Embed

Google Forms is the most widely used free form tool, and its native Google Sheets integration is a major draw. However, when you embed a Google Form on your website, you lose all marketing context: there are no UTM parameters, no referrer tracking, and no device metadata in the response sheet. LeadToSheet connects these two pieces by capturing page-level attribution data from the host page and merging it with your Google Forms responses, giving you the marketing analytics that Google Forms was never designed to provide.

Implementation checklist

  1. 1

    Add the LeadToSheet SDK to the page hosting your Google Form

    Place the script tag on the web page where you embed your Google Form. The SDK captures page-level data like UTMs, referrer, and device type. Google Forms itself runs inside a cross-origin iframe that LeadToSheet cannot read directly.

    LeadToSheet snippet

    <script src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script>
  2. 2

    Set up the Google Apps Script webhook bridge

    Since Google Forms embeds in a cross-origin iframe, LeadToSheet cannot capture form field values from the browser. Install the LeadToSheet Apps Script add-on on your Google Forms response sheet to relay submission data to your LeadToSheet-managed sheet with attribution columns appended.

    Tip: The Apps Script bridge triggers on each new form response and merges it with the attribution data the SDK captured from the host page.

  3. 3

    Submit a test entry with UTM parameters in the page URL

    Visit your embed page with ?utm_source=test&utm_medium=guide appended to the URL, submit the Google Form, and confirm that both the form responses and the UTM parameters appear in your LeadToSheet Google Sheet.

Customization ideas

  • Add marketing context to quiz results

    Google Forms quiz scores combined with LeadToSheet's UTM data let you measure which marketing channels drive the most engaged quiz completions and highest scores.

  • Unify multiple Google Forms into one sheet

    If you use different Google Forms across landing pages, LeadToSheet can consolidate all responses into a single sheet with a form identifier column, eliminating the need to check multiple response sheets.

  • Trigger Slack alerts for embedded form submissions

    Use Apps Script on your LeadToSheet-managed sheet to send a Slack notification whenever a new Google Form submission arrives, including the UTM source and respondent answers.

Troubleshooting

  • Google Forms iframe blocks direct field capture

    Google Forms enforces strict cross-origin policies on its embed iframe. LeadToSheet cannot read form field values from the iframe. Use the Apps Script webhook bridge on your response sheet to relay field data, and the SDK on the host page to capture attribution.

  • Attribution data not matching form responses

    The SDK captures attribution when the page loads, and the Apps Script bridge fires when the form is submitted. If a user opens the page, leaves, and returns later, the attribution session may have changed. Ensure your sheet merge logic uses timestamps to correlate the closest attribution event with each submission.

  • Embedded form does not resize properly

    This is a Google Forms limitation, not a LeadToSheet issue. The LeadToSheet SDK does not interfere with iframe sizing. Adjust the iframe height attribute in your embed code to fit your form.

Frequently asked questions

Google Forms already writes to Sheets. Why do I need LeadToSheet?
Google Forms records answers but nothing about how the respondent arrived at your page. LeadToSheet adds UTM source, medium, campaign, referrer URL, device type, and page URL to every row so you can measure form performance by marketing channel.
Can LeadToSheet read the Google Forms iframe directly?
No. Google enforces strict cross-origin isolation on its form embeds. LeadToSheet uses an Apps Script webhook bridge on the response sheet to access form data server-side, then merges it with page-level attribution captured by the SDK.
Does this work with Google Forms quizzes?
Yes. Quiz scores, correct/incorrect flags, and respondent answers all flow through the Apps Script bridge. LeadToSheet pairs them with attribution data so you can analyze quiz engagement by traffic source.