Automated FormAssembly Submission Logging and Checks
Every hour, WebRun opens FormAssembly, reads submissions received since the last check, flags any with a missing or malformed required field for review, logs the clean records as rows in Google Sheets, and mirrors the same list into a Notion database for the wider team.
How do I catch bad data in FormAssembly submissions before it spreads?
WebRun checks FormAssembly every hour for new submissions, flags any with a missing or malformed required field onto a review tab, and logs the clean ones as rows in Google Sheets while mirroring the same list into Notion. Data quality issues surface within the hour instead of being discovered downstream in a report.
- Bad or incomplete data gets flagged within the hour, not at reporting time
- Sheets and Notion always show the same clean submission list
- Review tabs replace manually scrolling through raw form entries
Built for Operations teams · compliance and data teams · higher education admin · nonprofit program managers
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
app.formassembly.comin a real browser with your saved login - no setup, no API keys. -
1
FormAssembly - read new submissions
formassembly.com
WebRun opens FormAssembly to read new submissions. - Open FormAssembly and check submissions since the last run
- Check each required field for a valid, non-empty answer
- Separate clean submissions from ones needing review
Done when Every submission since the last check is sorted clean or flagged.
-
2
Google Sheets - log clean records as rows
google.com
WebRun opens Google Sheets to log clean records as rows. - Open the submissions tracker sheet
- Add one row per clean submission with every field
- Add flagged submissions to a separate review tab
Done when Every clean submission has a row, and flagged ones are on the review tab.
-
3
Notion - mirror the list for the team
notion.so
WebRun opens Notion to mirror the list for the team. - Open the shared Notion database
- Mirror each clean submission as a new entry
- Tag entries by the form they came from
Done when Notion shows the same clean submissions as the sheet.
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
What counts as a flagged submission?
Any submission missing a required field or with an answer that doesn't match the expected format, such as a malformed email or phone number.
Does it fix the bad data itself?
No. It only separates flagged submissions onto a review tab so a person can decide whether to correct the record or follow up with the respondent.
Will Notion and Sheets ever show different numbers?
No. Both are updated from the same read of FormAssembly each hour, so the clean submission list matches across both.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.