Back

Submit every record in my list through a web form

Each record submitted one at a time with a per-row status and blockers flagged

OpsEAsEveryone
Prompt

Submit each of these records through this form: [form URL]. Here are the records: [paste them, or link the sheet]. Work through them one at a time. Map my fields to the form's fields exactly — names, emails, phone numbers, dates — copying values precisely rather than retyping from memory. If the form has dropdowns, pick the option that matches the record; if no option fits or a required field is missing from my data, skip that record and log it rather than improvising. Confirm each submission actually went through (a success message or confirmation page) before starting the next. If the same validation error appears twice in a row, stop and show me. At the end, report a per-record status list: submitted, skipped (why), or failed (the error).

Works withdocs.google.comsheets.google.com