Browser agents

How to automate form filling on websites

The short answer

Keep the data in one list with an ID and a status per row, fill one form at a time, and submit only after you approve. Save each confirmation back to its row.

4 min read

Which kind of form filling do you mean?

What do you want to fill?

Use your browser's autofill

Chrome fills addresses, contact details, passwords and payment methods, and each can be turned off. No automation needed.

Use a text expander

It types your saved snippets on a shortcut. You still check and click submit.

Browser agent

Use a browser agent or browser automation

It fills one row at a time and asks before each submit. Follow the steps below.

Automation

Use an automation on the form app

Typeform, Google Forms and Jotform have triggers in automation catalogs, so no browser is needed.

Read: Webhooks explained for non-developers

How to automate form filling, step by step

  1. 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.

  2. 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.

  3. 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.

  4. 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 it

    Captain sets up a browser agent that fills the warranty form, stops, and asks you. Approve, and it submits exactly what you saw.

  5. Step 5: Save proof

    The confirmation number, a reference, or the page title after submit, written back to the row with Status Submitted.

  6. 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.

Read next

Or let Captain build it

One sentence to Captain. Free to start.

Build it with Captain
How to automate form filling on websitesBuild it