Which kind of form filling do you mean?
How to automate form filling, step by step
Step 1: Put the data in one list
One row per form to fill, one column per field, plus an ID and a Status (To do, Filled, Submitted, Failed). A single list is the fix for most failures.
Step 2: Map columns to fields by label
Write the map once: the "Company name" column goes to the "Business name" field. Labels change less than page layouts.
Step 3: Check before submit
Required fields filled, dates in the site's format, nothing cut off. A tool that fills and then shows you the form is worth more than one that is fast.
Step 4: Submit only on approval
A submitted form usually cannot be taken back. Approve each one, at least until a few dozen have gone through clean.
Tip. In 50agents, a browser agent alone does not read your Google Sheet. Hold the list in an app, and a browser agent in its crew works through the rows.
Do this step in 50agents
Set up a browser agent that registers each espresso machine I tell it about on the warranty form at maker.example, and asks me before it submits
Build itCaptain sets up a browser agent that fills the warranty form, stops, and asks you. Approve, and it submits exactly what you saw.
Step 5: Save proof
The confirmation number, a reference, or the page title after submit, written back to the row with Status Submitted.
Step 6: Never resubmit without checking
If a run fails after submit, look for the confirmation before trying again, or you will send it twice.
What can go wrong
Submitted twice
A retry after a slow page. Check for the confirmation before any retry, and keep the Status column true.
Fields shifted
The site added a field and everything moved down one. Map by label, and check a filled form before the first submit after any site change.
The wrong row
Two rows share a name. Give each row an ID and show it in the approval.
A form on a look-alike site
Personal data went to the wrong address. Fill forms only on the exact address in your list.
A CAPTCHA appears
The site does not want automated submits. Do not use CAPTCHA bypass; ask the site for a bulk upload or an API instead.
Questions people ask
How do I fill the same web form many times automatically?
Keep the data in a sheet with one row per form, and use a browser automation tool or browser agent to fill one row at a time. Submit only after a check, and save the confirmation to the row.
Can I fill a web form from a spreadsheet?
Yes. That is the most reliable setup: the sheet is the source, the tool fills from it and writes the result back.
What about forms with a CAPTCHA?
Stop there. A CAPTCHA is the site asking for a person. Do those by hand, or ask the site for a bulk option.
What if the form changes?
Map columns to fields by their label, not their position, because labels change less than layouts. When a field is not found, the run should stop and tell you, not guess.
Can it upload files too?
Many tools can attach a file to an upload field if the file is reachable, for example a link in the row. Test it on one row and check the confirmation before running the rest.
How do I avoid submitting twice?
Give each row an ID and a Status, and save the confirmation number back to the row. If a run fails after submit, look for that confirmation before you try again.