How to automate data entry from a google sheet

This data entry bot template automates data input through a web browser, bypassing the need for an API. The bot extracts data from a Google Sheet, launches Chrome, and mimics human actions by entering the data into a web form, followed by clicking the submit button. After each iteration, the processed row is removed from the Google Sheet.

# Get started: Set up your Google Sheet

Create a new Google Sheet. You can do this in your Chrome browser by entering the shortcut 'sheet.new', assuming you already have an account. Name your sheet something like 'Data entry bot’ and set up a tab called 'Data'.

# Install the data entry bot

To install this data entry bot click 'Install template'. If you’re a new user, you’ll have to click 'Install Chrome extension' and create a free Axiom.ai account before you can edit the template.

Once installed, click 'Start'.

Axiom.ai will guide you through the steps you need to configure in the app.

# Configure your data entry bot in just a few steps

We've provided a set of example steps within Step 2.0 - Loop through data. You can further customize this bot by adding additional steps within this loop to suit your specific needs.

  • Step 1.0 - Read data from Google Sheet
    • Spreadsheet - Search for the Google Sheet you created. Once found, click to select
    • Sheet name - Choose the sheet tab with the data to be input
  • Step 2.0 - Loop through data: Add sub-steps to customize
    • Step 2.1 - Enter text
      • Select - An input field to enter data into
      • Text - Click 'Insert Data' select '[google-sheet-data]'
    • Step 2.2 - Enter text
      • Select - An input field to enter data into
      • Text - Click 'Insert Data' select '[google-sheet-data]'
    • Step 2.3 - Click element
      • Select - The submit form button
    • Step 2.4 - Delete rows from a Google Sheet
      • Spreadsheet - Search for the Google Sheet you created. Once found, click to select
      • Sheet name - Choose the tab you created for links
      • First row - Set to 1
      • Last row - Set to 1

# Run your data entry bot

We suggest running a test first; watch the bot as it inputs data into the form, then stop the bot after a few loops.

# Customize your template

Like all Axiom templates, you can use our no-code bot builder to customize any bot according to your requirements.

# Tips

We recommend you watch the video to troubleshoot.

  • Step 2.1 +
    • Element not found? Reselect the element perhaps
    • Data entered into the wrong input? Add wait steps between inputs

We offer excellent customer support. If you need help, get in touch.

To learn more, read this full in-depth guide on automating data entry from a google sheet.

# More Templates