How to import data to use in your automation

You can import data into Axiom.ai for your browser automation through various methods, such as web scraping, reading data from Google Sheets or posting data via apps like Zapier, Make, or Airtable.

# Import data from Google Sheets or Microsoft Excel

To import data from a spreadsheet, use the Step Finder to add one of the following steps:

How
  1. First, select a sheet to read from.
  2. Next, specify the sheet name to read from.
  3. Lastly, if you wish to set a cell range, enter values in "First cell" and "Last cell".

Once set up, you will see a preview output of the first three rows, and a token will be available to pass that data into any other step. If you wish to loop through your data, see here.

# Import using "Import CSV file"

To import data from a CSV, use the Step Finder to search for "CSV" and add the step.

How
  1. First, select CSV file to upload.
  2. Next, if you wish to set a cell range, enter values in "First cell" and "Last cell".

Once set up, you will see a preview output of the first three rows, and a token will be available to pass that data into any other step. This step only works with the desktop runner.

# Import data using "Get data from a URL"

To scrape data from a webpage, use the Step Finder to search for "Get data from a URL" and add the step.

How
  1. First, set the URL to scrape.
  2. Second, select the data to scrape.
  3. Lastly, set the number of results to scrape.

Once set up, you will see a preview output of the first three rows, and a token will be available to pass that data into any other step. To learn more about scraping data, click here.

# Import data from other web apps

To import data from other apps such as Zapier, Make, Retool, and Airtable, use the "Receive data from another app" feature and the Axiom.ai API. Use the Step Finder to search for "Receive data" and add the step.

For examples and to learn more about passing data from other apps, click here.

If you need help or want to suggest an alternative way of importing data into Axiom.ai, please let support know (opens new window).

Prev: How to use the Multi-selector tool
Next: How to pass data between steps in y...