How to automate entering text into search and clicking the result

This guide shows you how to start creating a bot to input text into a search field from a Google Sheet, click return to submit the search then click on the result. After adding the initial steps, simply use the [builder](/docs/no-code-tool/the-builder/builder to customise the bot to your use case.

We also have a great data entry template to get you started.

Prepare your Google Sheet

Create a Google sheet with some test text to run your automation with.

Col ACol B
alex@testemail.comSurname
claretestemail.comSurname
sam@testemail.comSurname

Start from blank, adding the following steps

In the axiom.ai Chrome extension dashboard, click "New Automation" and then select "Add first step". Use the step finder to add the steps outlined below.

  • 1.0 Read data from a Google Sheet
    • Spreadsheet: Search for the Google Sheet you created in the Spreadsheet field. Once found, click to select.
    • Sheet name: Choose a sheet tab or leave blank to use the first tab.
  • 2.0 Loop through data
    • Loop through data: Click Insert data, select google-sheet-data.
    • 2.1 Go to page
      • Enter URL: Insert the URL of the website.
    • 2.2 Enter text
      • Select: Click Select, highlight the search field and click to select, finally press Complete.
      • Text: Click Insert data, select google-sheet-data to pass the search term from the sheet. Select column A in the preview.
    • 2.3 Press key(s)
      • Key: Press Record, then click Return, to submit the search.
    • 2.4 Click element
      • Select: Click Select, highlight the search result, and press Complete.
    • 2.5 Delete row from Google Sheet
      • Automatically removes the processed row to avoid duplicate scrapes in the next loop.

Continue adding your steps as needed

Now just use the step finder to continue adding steps and complete your search bot as required.

Wrapping up

You can quickly scaffold a bot to enter data into a search field and click the first result. This can be done with just a few steps. It is then possible to add additional steps to fully customize the bot to the use case

On this page