Tick checkboxes and choose options from a Google Sheet


How to tick checkboxes and choose options from a Google Sheet: install the Chrome extension, click Build from description, tell the agent what you want, and follow its prompts. A working bot is built and tested in minutes.

Here is how the automation works. To tick a checkbox or choose a radio button from a Google Sheet, put an If condition step inside the loop that checks the row's column and runs a Click element step on the box only when the value says to. A text field takes its value from the sheet directly; a checkbox is clicked or it is not, so the automation has to look at the cell and decide.

Author
Alex Barlow
Published

Build ticking checkboxes from a sheet from a description


Describe it and click the button: the agent builds and tests the form filler in your Chrome extension. It opens the form, finds each field, box and option, and asks you which column drives which if it cannot tell.

  1. Read the sign-ups from my Google Sheet
  2. Open the form and enter each row's name and email
  3. Tick the newsletter box if the row says yes
  4. Choose the team the row names
  5. Submit the 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.

You need a Google Sheet with one row per submission, one column per checkbox holding yes to tick it, and one column per radio group holding the option's label as it reads on the page; the layout is in the questions below. Leave the sheet as it is while the run submits the forms.

Build ticking checkboxes from a sheet step by step


The steps the agent builds, as the Builder shows them: each step by its name, with the fields to set under it. Add them yourself in this order in the step-by-step builder, or open the agent's result there to adjust it.

  • 1.0 Read data from a Google Sheet
    • Spreadsheet: your sheet
    • Sheet name: the sign-ups tab
  • 2.0 Loop through data
    • repeats for every row in [google-sheet-data]
    • 2.1 Go to page
      • URL: the form's address
    • 2.2 Enter text
      • Select text field: the name field
      • Text: the Name column of [google-sheet-data]
    • 2.3 Enter text
      • Select text field: the email field
      • Text: the Email column of [google-sheet-data]
    • 2.4 If condition
      • Data to check: the Newsletter column of [google-sheet-data]
      • Condition to check: yes
      • 2.4.1 Click element
        • Select: the newsletter checkbox
    • 2.5 If condition
      • Data to check: the Team column of [google-sheet-data]
      • Condition to check: Spurs
      • 2.5.1 Click element
        • Select: the Spurs radio button
    • 2.6 If condition
      • Data to check: the Team column of [google-sheet-data]
      • Condition to check: Arsenal
      • 2.6.1 Click element
        • Select: the Arsenal radio button
    • 2.7 Click element
      • Select: the form's submit button

Common questions about ticking checkboxes from a sheet


How do I lay out the Google Sheet for checkboxes and radio buttons?

One row is one form submission, and each kind of control wants its own kind of column:

ControlColumnValue in the cell
A checkbox, ticked or notone column per checkboxyes to tick it, anything else to leave it
A group of checkboxes where several can be tickedone column per checkbox in the groupyes or blank, per box
Radio buttons, where one is chosenone column for the groupthe label of the option to choose, as it reads on the page

A sheet laid out for the sign-up form:

NameEmailNewsletterTeam
Alex Barlowalex@example.comyesSpurs
Sophia Chensophia@example.comnoArsenal

Keep the values exact. yes is the word the condition looks for, and Spurs and Arsenal are the labels the If conditions look for. A Google Sheets checkbox cell reads as TRUE or FALSE when the automation reads it, so if you prefer ticking boxes in the sheet to typing yes, check for the word TRUE instead.

Why does the condition match the wrong row or every row?

Data to check is probably the whole row rather than one column. Pick the column in the data preview, or the word is found in the wrong cell.

What happens when a checkbox cell in the sheet is blank?

A blank cell never matches yes, so leaving a cell empty is the same as writing no. Fill in no only if it helps you read the sheet.

How do I untick a checkbox the form ticks by default?

Turn on Reverse condition on that If condition, so the click happens when the cell does not say yes and unticks the box. For a group of checkboxes, one If condition per box, each checking its own column and clicking its own box.

How do I choose from a radio group with more than two options?

Use one If condition per option, each with its own click. For a group with exactly two options, one If condition with an Else step does it: the If branch clicks the first option, the Else branch clicks the second. An Else only covers the last of two.

Why does the click land on the label instead of the checkbox?

Some forms draw the box as a styled label, so the click lands on the label. Select the label text with the selector tool, or use a custom CSS selector for the input itself. See tick a checkbox for the fallbacks.

Can I choose a dropdown option from a Google Sheet the same way?

Yes, with a different step. A dropdown takes the row's value directly in a Select list step, no If condition needed, as long as the cell holds the option's label as it reads on the page.

Can I tick checkboxes on a web form from a Google Sheet without code?

Yes. The automation is built from the five lines above and runs in your Chrome extension; the sheet's columns drive the boxes and no script is involved. The text fields around them are covered in automate data input from a Google Sheet into a web form.

Where do I get help?

Get in touch with support, or ask in the axiom.ai community.

Related guides