Screen Automation Tutorial 1 - Extract Amazon Product Reviews

This tutorial includes a video and written guide to walk you through building an automation Flow from start to finish.


The Problem to Solve

You want to automatically pull product reviews from Amazon into a Google Form.

Required Materials

To follow along with this tutorial, you will need:

Chrome browser

Custom JavaScript to copy and paste:

// Please Specify Name: Wait
UIService.pauseForInterval(1);

Video - Set Up: Authenticating the Hero_Go Chrome Extension

Video - Capture Amazon Product Reviews

Guide Outline

The steps to complete for this guide are as follows:

  1. Add and Authenticate Hero_Go Chrome Extension.

  2. Set Up Google Form.

  3. Open Amazon Product Review Page.

  4. Record Screen Automation.

  5. Play Screen Automation.

  6. Play Another Screen Automation.

  7. Confirm Success.

  8. Stop or Delete the Environment.

Add and Authenticate Hero_Go Extension

  1. Sign in to Hero_Cloud.

  2. Click on your previously created Hero_Flow environment. If you have not set up an environment, go to the First Flow Tutorial - Filter Customer Information in Dropbox.

  3. Copy the Flow Server URL of your specific instance.

    1. Note: Do not copy the forward slash or tab name after “automationhero.ai” in the URL.

  4. Click on the information icon in top right of Hero_Flow and click on Hero_Go.

  5. You will be routed to the Chrome Web Store. Click Add to Chrome. The extension will be automatically added to your Chrome menu.

  6. Navigate back to Hero_Flow. Click on Hero_Go Chrome Extension icon to open Hero_Go.

  7. Fill in the Username and Password you used to sign up for Hero_Cloud.

  8. Paste the previously copied Flow Server URL.

    1. Note: If needed, delete the forward slash and tab name following “automationhero.ai” in the URL.

Set up Google Form

  1. Go to https://docs.google.com/forms/

  2. Click the Add icon to Start a New Form and add a title. In this example, Product Reviews.

  3. Select Short Answer from the question type drop-down list and title your first question Product Name.

  4. Click the Add icon to add another question.Select Short Answer from the question type drop-down list and title your second question Review Title.

  5. Click the Add icon to add another question. Select Short Answer from the question type drop-down list and title your third question Stars.

  6. Click the eye icon to preview the form and keep it open in a separate tab.

Open Amazon Product Review Page

  1. Open Amazon.

  2. Choose a product. In this example, Apple Airpods with Charging Case (Latest Model).

  3. Click on the hyperlinked number of product ratings.

  4. Scroll down and click on See all customer reviews.

Record Screen Automation

Prepare

  1. Click on Hero_Go Extension in Chrome bar.

  2. Click Create New on Hero_Go.

  3. Name the Screen Automation.

  4. Click Edit on Hero_Go.

  5. Click Record on Hero_Go.

  6. Refresh Amazon product review page and the Google Form page.

  7. Right click on page and select Make reference from the drop-down list.

  8. In the reference field, type Please click on the product review page.

Extract Data

  1. Right click on the review title of the first review and select Loop over similar from drop-down list.

  2. You will be prompted to paginate. Scroll down and click Next page.

  3. You will be prompted to select what action you want Hero_Go to do with the information. Select extract from drop-down list and then click Add.

  4. Fill in Field name with Review Title and click Add.

  5. Right click on product title in the first product review and select Extract data from drop-down list.

  6. Fill in Field name with Product Title and click Add.

  7. Right click on the stars by the first product review and select Extract data from drop-down list.

  8. Fill in Field name with Stars and click Add.

Fill in Data

  1. Switch to Google Form.

  2. Right click on the blank field under Product Name and select Fill Form Input from drop-down list.

  3. Select field name Product Name from drop-down list.

  4. Right click on the blank field under Review Title and select Fill Form Input from drop-down list.

  5. Select field name Review Title from drop-down list.

  6. Right click on the blank field under Stars and select Fill Form Input from drop-down list.

  7. Select field name Stars from drop-down list.

  8. Click on Submit in the Google Form

Custom JavaScript

  1. Scroll down the steps in the recording and select the kebab menu on the next step and select Custom JavaScript.

  2. Paste the following piece of code to create a pause in the Screen Automation:


    1. // Please Specify Name: Wait
      UIService.pauseForInterval(1);
  3. Click Save to add custom JavaScript.

  4. Click Save on Hero_Go to save the recorded Screen Automation.

Prepare Google Form

  1. Click on Responses

  2. Click on kebab menu and select Delete all responses then click OK.

Play Screen Automation

  1. Navigate to Amazon product review page.

  2. Click Play on Hero_Go.

  3. Click anywhere on the Amazon product review page.

  4. Watch Hero_Go automatically pull Amazon product reviews.

  5. Click Pause on Hero_Go to pause the Screen Automation.

Play Another Screen Automation

  1. Navigate to another Amazon product. In this example, Apple Magic Mouse 2 (Wireless, Rechargable) - Space Gray.

  2. Click on the hyperlinked number of product ratings.

  3. Scroll down and click on See all customer reviews.

  4. Click Go Back icon on Hero_Go to reset the Screen Automation.

  5. Click Play on Hero_Go.

  6. Click anywhere on the new product page.

  7. Watch Hero_Go automatically pull Amazon product reviews.

  8. Click Pause on Hero_Go to pause the Screen Automation.

Confirm Success of Screen Automation

  1. Go to Google Form and view responses generated by Hero_Go.

  2. Click kebab menu and select Download responses (.csv).

  3. Open the downloaded .csv to see the product reviews captured by Hero_Go.

Stop or Delete the Environment 

Running an environment costs money by the hour. Reduce costs by stopping or deleting an environment you are not actively using.

  1. Navigate back to your cloud home screen.
  2. Click the settings icon next to the name of your environment.
  3. Choose Stop or Delete to stop or delete the environment.