How to Integrate Microsoft Forms with Zapier

‍

‍

Microsoft Forms lacks a direct native trigger in Zapier, so use Excel Online live sync in OneDrive to capture responses as new rows automatically.

‍

1. On your Microsoft 365 main dashboard, click OneDrive.
2. Click on Create or upload button to start from scratch.
3. From the dropdown menu, select Excel workbook.
4. On the Excel tab, click on Insert and choose New Form.
5. From the right panel that appears, click on the Open Form button in green.
6. Design your survey in a new tab to automatically generate matching columns in your Excel Online sheet.
7. Return to your Excel tab to confirm the form has appeared.
8. On Zapier's main dashboard, click on Create Zap.
9. Click on the Trigger button to see the list of apps available for your automation.
10. Search for Microsoft Excel, and choose it as your Trigger app.
11. Connect your Apollo Account by clicking on the Sign In button on the right-hand options.
12. Select New Row in Table as your Trigger Event.
13. Click on the 'Continue' button to finalize your trigger.
14. Click Continue to move forward with this sample data.
15. Your trigger is ready—now add an action to complete your workflow.