Automated Microsoft Forms to Airtable Sync
Every hour, WebRun checks Microsoft Forms for new responses, matches each one against existing Airtable records by respondent and timestamp to catch duplicates, adds the genuinely new rows, and mirrors the clean list into Notion so your team always has one shared view.
How do I sync Microsoft Forms responses into Airtable and Notion without duplicates?
WebRun checks Microsoft Forms every hour for new responses, matches each against existing Airtable records to catch duplicates, and adds only the genuinely new ones. It then mirrors that reconciled list into Notion, so sales, ops, or HR teams always have one accurate, shared view of form responses instead of two drifting spreadsheets.
- Duplicate responses are caught before they clutter your records
- Airtable and Notion stay within an hour of the live form
- Teams get one shared view instead of exporting CSVs by hand
Built for Operations teams · HR coordinators · IT admins · Microsoft 365 power users
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
forms.office.comin a real browser with your saved login - no setup, no API keys. -
1
Microsoft Forms - read new responses
forms.office.com
WebRun opens Microsoft Forms to read new responses. - Open Microsoft Forms and check each form's response list
- Read every answer submitted since the last check
- Capture the respondent, timestamp, and answers for each
Done when Every response since the last run has been read.
-
2
Airtable - reconcile against existing records
airtable.com
WebRun opens Airtable to reconcile against existing records. - Open the responses base and compare new entries against what's already recorded
- Skip any response already matched by respondent and timestamp
- Add a new record for every response that isn't a duplicate
Done when Airtable holds exactly one record per genuine response, no duplicates.
-
3
Notion - mirror the clean list
notion.so
WebRun opens Notion to mirror the clean list. - Open the shared Notion database
- Mirror each new, deduplicated Airtable record into Notion
- Keep the same fields so both views stay in sync
Done when Notion reflects the same reconciled list as Airtable.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
How does it avoid creating duplicate records?
It matches each Microsoft Forms response against existing Airtable records by respondent and timestamp before adding anything, so the same answer never gets recorded twice.
Why keep both Airtable and Notion updated?
Airtable holds the reconciled source of truth, and Notion mirrors it so teammates who live in Notion see the same clean list without touching Airtable.
How current is the data?
WebRun checks Microsoft Forms every hour, so both Airtable and Notion stay within an hour of what respondents actually submitted.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.