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.
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.
- Read the sign-ups from my Google Sheet
- Open the form and enter each row's name and email
- Tick the newsletter box if the row says yes
- Choose the team the row names
- Submit the form
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 SheetSpreadsheet: your sheetSheet name: the sign-ups tab
- 2.0
Loop through data- repeats for every row in
[google-sheet-data]
- 2.1
Go to pageURL: the form's address
- 2.2
Enter textSelect text field: the name fieldText: the Name column of[google-sheet-data]
- 2.3
Enter textSelect text field: the email fieldText: the Email column of[google-sheet-data]
- 2.4
If conditionData to check: the Newsletter column of[google-sheet-data]Condition to check: yes
- 2.4.1
Click elementSelect: the newsletter checkbox
- 2.5
If conditionData to check: the Team column of[google-sheet-data]Condition to check: Spurs
- 2.5.1
Click elementSelect: the Spurs radio button
- 2.6
If conditionData to check: the Team column of[google-sheet-data]Condition to check: Arsenal
- 2.6.1
Click elementSelect: the Arsenal radio button
- 2.7
Click elementSelect: the form's submit button
- repeats for every row in
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:
| Control | Column | Value in the cell |
|---|---|---|
| A checkbox, ticked or not | one column per checkbox | yes to tick it, anything else to leave it |
| A group of checkboxes where several can be ticked | one column per checkbox in the group | yes or blank, per box |
| Radio buttons, where one is chosen | one column for the group | the label of the option to choose, as it reads on the page |
A sheet laid out for the sign-up form:
| Name | Newsletter | Team | |
|---|---|---|---|
| Alex Barlow | alex@example.com | yes | Spurs |
| Sophia Chen | sophia@example.com | no | Arsenal |
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
Automate data entry into a web form from Zapier
- Take the rows Zapier sends me
- Open the contact form on my site
- Fill in each row's name, email and message
- Submit the form and go to the next row
Send Instagram DMs and like each user's latest post
- Read the profile links and messages from my sheet
- Skip any rows already marked Sent and liked
- Open each profile link
- Check the profile header for the word Message
- If it is there, click Message and send the message
- Then open their newest post and like it
- Write Sent and liked back into the row, column C
Automate data entry from a Google Sheet into a web form
- Read the rows from my Google Sheet
- Open the contact form on my site
- Fill in the name, email and message from each row
- Submit, then delete the row from the sheet