Fill a form from a spreadsheet

A good starting point for automating any web form. The basic structure loops through rows of data and enters each one into the form. The agent asks for the form's URL, scans the page to work out which fields need filling, and asks you if it is unsure. It then works out the selectors, maps the Google Sheet columns to the fields, and test-runs the automation, fixing issues as it goes. To use Excel, a CSV or another data source instead, change the first line of the description in the extension before you start the agent.

  1. Read data from a Google Sheet
  2. Loop through data
  3. Fill out a contact form
Click to launch the Chrome extension. Not installed? You can create an account and try it free.Opens the Chrome extension. Free account to try.

Start building opens the Chrome extension with these lines filled in. Click Try agent there and the agent opens the site, builds the steps, test-runs them and hands you the automation in the Builder. It stops and asks if it needs a login or a choice from you.

What the agent builds


An automation built around a loop:

  • Read data from a Google Sheet: pulls in the rows, one per submission.
  • Loop through data: repeats the steps inside it once per row.
  • Inside the loop, Go to page, one Enter text per field, and Click element: open the form, fill it from the current row, submit.

Giving Loop through data its own line is what tells the agent to wrap the form steps in a loop, so the automation repeats for every row instead of running once. Name the fields, for example Fill in name, email and company from the row, and the agent maps each sheet column to its field.

Build it manually


Prefer to add the steps yourself? These are, loosely, the steps the agent builds. The agent scans the page for the form's fields and adds whatever steps it takes to complete the form, so its version may have more Enter text steps than this, plus a dropdown or checkbox step where the form has one.

Step 1: Read the rows

  1. Click Add step and search for Google Sheet.
  2. Select Read data from a Google Sheet to add it.
  3. Connect your Google account if you have not already.
  4. In Spreadsheet, pick the sheet with your form data, one row per submission, and in Sheet name, pick the tab.

Step 2: Loop once per row

  1. Click Add step and search for Loop.
  2. Select Loop through data to add it.
  3. In Loop through data, click Insert Data and choose the sheet data from step 1. Every step you place inside this loop now runs once per row.

Step 3: Open the form

  1. Inside the loop, click Add step and search for Go to page.
  2. Select Go to page to add it.
  3. In Enter URL, enter the form's URL.

Step 4: Fill in each field

  1. Inside the loop, click Add step and search for Enter text.
  2. Select Enter text to add it.
  3. Click Select text field and click the first field on the form.
  4. In Text, click Insert Data and choose the column for that field from the current loop row.
  5. Repeat for each field on the form.

Step 5: Submit

  1. Inside the loop, click Add step and search for Click element.
  2. Select Click element to add it.
  3. Click Select and click the form's submit button.

Step 6: Run it

  1. Click Run and check the submissions.
  2. If they are right, click Save.

The shape: read rows, loop once per row, fill the form, submit, repeat.

Things worth knowing


  • If the agent cannot tell which sheet column goes in which field, it asks. Column headings that match the form's labels save the question.
  • Inside the loop, the sheet data refers to the current row, not all rows. Always use Insert Data to reference the current value, never paste a hard-coded one.
  • Everything you want repeated must sit inside the Loop through data step. A step placed after the loop runs only once, at the end.
  • Sites often rate-limit or block automated traffic when forms are submitted in quick succession. A Wait step inside the loop is usually a good idea.
  • If any single row fails, the whole loop stops. Wrap the form steps in a Try / Catch step if you'd rather skip bad rows and keep going.
  • Forms with CAPTCHAs, dynamically loaded dropdowns, or multi-page wizards need extra steps. See Browser actions.

Next steps


Quick starts: build from description with one click


Form filling from a sheet: checkboxes, date pickers, file uploads and resuming where a run stopped. Each guide carries a Build from description button: one click opens the extension with the lines filled in and the agent builds it, or follow the steps yourself.