Overview
Microsoft Forms is the default survey and quiz tool for Microsoft 365 organizations, with tight integration into Power Automate, Excel, and Teams. However, many teams need form responses in Google Sheets for cross-platform reporting, agency collaboration, or integration with Google-based tools. LeadToSheet captures attribution data from the embed page and pairs it with submission data via Power Automate's webhook connector, giving you a unified Google Sheets view of Microsoft Forms responses with marketing context.
Implementation checklist
- 1
Add the LeadToSheet SDK to your embed page
Place the script tag on the web page hosting your Microsoft Forms iframe. The SDK captures page-level attribution data including UTMs, referrer, and device context.
LeadToSheet snippet
<script src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script> - 2
Create a Power Automate flow to relay submissions
Microsoft Forms embeds in a cross-origin iframe that LeadToSheet cannot read directly. Create a Power Automate flow that triggers on new form responses and sends the data to your LeadToSheet webhook endpoint via an HTTP POST action.
Tip: In Power Automate, use the 'When a new response is submitted' trigger for Microsoft Forms, then add 'Get response details' and 'HTTP' actions to POST the fields to your LeadToSheet webhook URL.
- 3
Verify attribution merging with a test submission
Visit your embed page with UTM parameters appended, submit the form, and confirm that both the form field values (via Power Automate) and the attribution data (via SDK) appear in your Google Sheet row.
Customization ideas
Consolidate Microsoft and Google form data
If your organization uses both Microsoft Forms and Google Forms, LeadToSheet provides a single Google Sheet with consistent column formatting, eliminating the need to reconcile two separate response sheets.
Add branching logic context to Sheets
Microsoft Forms supports branching. Power Automate captures the branch path taken by each respondent, and LeadToSheet records it in the sheet so you can analyze which paths lead to higher-quality submissions.
Trigger Google Workspace automations from Microsoft Forms
Once responses land in Google Sheets via LeadToSheet, use Apps Script to trigger Gmail follow-ups, Google Chat alerts, or Calendar invites based on form answers.
Troubleshooting
Microsoft Forms iframe is fully cross-origin locked
Microsoft Forms embeds do not emit postMessage events and enforce strict cross-origin isolation. There is no browser-side workaround. Use Power Automate to POST form data to your LeadToSheet webhook endpoint as the reliable capture method.
Power Automate flow not triggering
Confirm the flow uses the correct Microsoft Forms form ID and that the flow is turned on. Test the HTTP action independently by sending a manual POST to the webhook URL to verify connectivity.
Anonymous responses missing respondent identity
If your Microsoft Form allows anonymous responses, the Power Automate flow cannot retrieve the respondent's email. LeadToSheet will still capture page-level attribution, but the respondent identity column will be blank.
Resources
Frequently asked questions
- Why would I send Microsoft Forms data to Google Sheets?
- Many teams work across both ecosystems. Google Sheets is often the preferred analytics and collaboration layer, especially for agencies or cross-functional teams that do not have Microsoft 365 licenses. LeadToSheet gets the data from one into the other automatically.
- Does this replace Power Automate's Excel connector?
- You can use both. Keep the Excel output for Microsoft-native workflows and use LeadToSheet for Google Sheets-based reporting, attribution analysis, and integration with Google-ecosystem tools.
- Can I capture Microsoft Forms quiz scores?
- Yes. The Power Automate flow can extract quiz scores and correct/incorrect flags from the response details and include them in the webhook payload to LeadToSheet.