Trigger n8n Workflow from MS Forms Response via OneDrive Excel

[Dino7]

I’m currently facing a challenge:
I receive data in an Excel file on OneDrive for Business, which is populated via Microsoft Forms. Whenever a new response is submitted, I would like to trigger and run my n8n workflow.

Does anyone have an idea how this can be done?
Thanks in advance for any tips!

[abc]

Hi

I see two options:

1. Use Power Automate: Since Microsoft Forms doesn’t support webhooks natively, Power Automate is the most straightforward way to react to new submissions. You can use the trigger “When a new response is submitted” and then call your n8n workflow from within the Power Automate flow using an HTTP request. See more details here
   To make HTTP requests you need a Power Automate Premium Licence … (See pricing | See reddit thread about this topic)
2. Poll the Excel file via n8n: If you prefer not to use Power Automate, another option is to regularly poll the Excel file using n8n. You can save the last processed row index using static workflow data, which makes it easy to detect whether a new response has been added - inside the workflow, simply check whether the index of the last data row in your Excel spreadsheet is greater than the one you have saved in the static workflow data. (Learn more about static workflow data here)

If you let me know which approach you want to go with, I’ll be happy to provide more detailed instructions to help you set it up.

[Dino7]

Hi @abc

Thank you for your insights.
I would like to take up your offer and go for option 2 “Poll the Excel file via n8n”