Read data from a Google Sheet step

# What to use the Read data from a Google Sheet step for

The read from a Google sheet step is most commonly used to loop through a list of URLS scraping content and passing data to web forms. It's a common starting point for most bots made with Axiom. When used in combination with the 'Interact with the page interface' step, data can be passed without code from the sheet to any website or web application.

If you are looking to create a process with thousands of rows, we recommend a design pattern called 'batch scraping'. 😊 You will also find a batch template here. If you just want to scrape links, use this 'scraper'.

You can use this step to:

If you have an Excel sheet, don't worry. They can be imported into Google Sheets and converted with a couple of clicks.

# How to configure the Read data from a Google Sheet step

# Spreadsheet

Search in the box for a Google Sheet or just cut and paste a URL into the field.

# Sheet name

Optionally specify a sheet name to read from. Sheets are different tabs visible at the bottom of your google doc; enter the name that appears on the tab to specify the sheet. Leaving this blank will use the first sheet in the document.

# First cell

Enter a column and row number if you wish to start your read operation from a particular cell in your Google Sheet. For example, 'B10' will mean your bot will start reading data from the second column on the 10th row.

# Last Cell

Enter a column and row number combination if you wish to stop the read operation at a particular cell in your Google Sheet. For example, 'B100' will mean your bot will stop reading data at the 100th-row in the second column.

# Continue when empty

If this is turned on, the automation will proceed even if the input sheet is empty.

Configuration settings

    Step type

    Spreadsheet