Copy Form Responses to Your Tracker
The moment a form is submitted, WebRun reads the response from Google Sheets, maps each field to the correct column in Airtable, creates a new record with status set to Open, and pings the assigned owner in Slack.
How can I automatically copy form responses into my ops tracker?
WebRun captures every form submission the moment it arrives. It reads the response from Google Sheets, maps each field to the correct column in Airtable, creates a new record with status set to Open, and pings the assigned owner in Slack — so every submission is tracked and owned before it can be missed.
- Every submission captured and assigned the moment it arrives
- Structured Airtable records created with no manual data entry
- Owner notified in Slack so nothing waits in a spreadsheet
Built for operations teams · project coordinators · HR managers · agency ops
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
docs.google.com/spreadsheetsin a real browser with your saved login — no setup, no API keys. -
1
Google Sheets — read new form submissions
google.com
WebRun opens Google Sheets to read new form submissions. - Open the Google Form responses sheet and find rows added since the last run
- Read every field: submitter name, email, category, description, and any file references
- Mark each processed row with a timestamp in the 'Synced' column
Done when All new form responses are read and marked as processed in the sheet.
-
2
Airtable — create a structured record
airtable.com
WebRun opens Airtable to create a structured record. - Open the Operations tracker base and go to the Submissions table
- Create a new record for each response, mapping form fields to the correct Airtable columns
- Set Status to 'Open', Priority based on any urgency keywords in the description, and assign to the correct team member per routing rules
Done when Each form submission is a record in Airtable with status, priority, and owner set.
-
3
Slack — notify the assigned owner
slack.com
WebRun opens Slack to notify the assigned owner. - Post a notification to the assigned owner's DM with the submission summary and a link to the Airtable record
- For high-priority submissions, also post to #ops-alerts
Done when The owner has been notified and has a direct link to the new record.
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 if the same submission gets logged twice?
WebRun stamps each processed row in the Google Sheet, so reprocessing is blocked — every submission lands in Airtable exactly once.
Can it route submissions to different people?
Yes. You give WebRun a routing table — category maps to owner — and it assigns records accordingly. Update the table whenever your team changes.
What about form fields I add later?
Just update the field mapping in the plan and WebRun will pick them up on the next run.
Related templates
Put this on autopilot.
Turn it on in minutes — or have our team set it up for you.