Amazon Product Rank Fetcher

What problem this workflow solves?

This workflow solves a very practical Amazon research problem: checking where products appear in search results for a list of keywords and saving that ranking data in a structured Excel file. Doing this by hand takes a lot of time. A person would need to open Amazon, search one keyword at a time, move across several pages, inspect each product card, and then copy details into a spreadsheet. That work becomes even harder when the keyword list is long or when the template has multiple sheets.

This bot turns that repeated work into one steady process. Based on the package, it reads keywords from an uploaded Excel template, opens the selected Amazon site, applies the delivery ZIP code, handles page-by-page keyword search, and collects product rank details. It also supports two Excel template styles, which helps teams keep using their existing files instead of rebuilding everything from scratch. That makes Amazon ranking checks easier, more consistent, and less likely to break because of manual copy-paste mistakes.

Key problems it addresses include:

• Repeating the same Amazon keyword search many times
• Tracking ASIN, price, and rank position across pages
• Keeping Excel output organized
• Handling both natural and sponsored placement signals
• Reducing manual effort in keyword ranking work

What does this workflow do?

This workflow is built to fetch Amazon product rank data from search result pages and write the results into Excel. From the bot package, the flow starts with a setup dialog where the user provides the Excel template file, the Amazon site URL, the number of pages to scan, the ZIP code, and optional browser settings such as incognito mode and cache clearing. After that, the bot checks the uploaded workbook and decides whether it matches Template 1 or Template 2.

Then the workflow initializes data, collects keywords, opens Amazon in Chrome, sets the shipping ZIP code, and begins running searches keyword by keyword. For each keyword, it loops through the requested number of search result pages and extracts product details from the current page. The captured fields include Date, ASIN, Title, Price, Keyword, PageRank, Page, NatureRank, AdIndex, Sponsored, SponsoreId, Feautrued_brand, Recommended_by_Amazon, AdId, and CampaignId. It also stores keyword results in SQLite during processing. At the end, it writes the final Amazon ranking output back into Excel using the matching template logic.

Main actions in the workflow include:

• Read template data and identify the correct format
• Extract keywords from one or more Excel sheets
• Search Amazon for each keyword
• Capture ASIN, price, title, and rank-related fields
• Save data into Excel in the correct layout

Who is this for?

This workflow is for people who need repeatable Amazon keyword ranking checks without doing manual browser work every day. Based on the structure of the bot, it is a good fit for marketplace operators, e-commerce assistants, catalog teams, advertising analysts, and sellers who want a simple way to monitor product placement in Amazon search results. It is also useful for agencies or service teams that manage multiple keyword lists in Excel and need output that can be handed back to clients in a familiar format.

Because the bot supports two template types, it is especially helpful for teams that already work from prepared spreadsheets. One template appears to use a dedicated "Keywords" sheet, while the other uses a "Judgement" structure with keyword rows starting deeper in the workbook. That means the workflow is not just for technical users. It is for people who want a reliable keyword ranking process that respects their current Excel habits. If someone needs ASIN-level search result tracking, sponsored placement clues, and page-by-page Amazon rank capture, this workflow is designed for that use case.

This is most useful for:

• Amazon sellers tracking keyword visibility
• VA teams preparing ranking reports
• Analysts reviewing sponsored and natural placement
• Operations teams using Excel-based templates
• Anyone who needs repeatable product rank collection

How does it work?

The workflow runs in a clear sequence. First, it opens a custom dialog and asks the user for five main inputs: the Excel template file, the Amazon site URL, the number of pages to collect, the ZIP code, and optional browser behavior. After that, it checks the workbook sheet names. If the file contains a sheet named "Keywords", it treats it as Template 1. If it contains "Judgement", it treats it as Template 2. If neither format is found, the workflow stops and shows an error.

Next, it prepares the keyword list and output structure. For Template 1, it reads keywords from column A of the "Keywords" sheet and creates a new dated ranking sheet. For Template 2, it loops through workbook sheets, gathers task rows beginning at row 6, and builds a keyword list plus task mapping by sheet. Then the bot opens Amazon, may use incognito mode, sets the delivery ZIP cod

e, and can attempt a captcha step if needed. For each keyword, it runs a search, loops through each requested results page, and extracts ASIN, title, price, page position, natural rank, and sponsored-related fields. Finally, it writes the Amazon keyword ranking results back into Excel using the correct template-specific writing flow.

The high-level process is:

• Collect user inputs
• Detect template type
• Read keywords
• Open Amazon and set location
• Search each keyword across pages
• Extract ASIN and rank data
• Write results back to Excel

The Environment Checklist

Before running this Amazon product rank workflow, make sure the setup is ready. The package shows that the workflow depends on browser automation, Excel file handling, and local SQLite storage during execution. It launches Chrome, opens existing Excel files, checks sheet names, writes output sheets, and closes browser and database connections at the end. Because of that, the environment needs to be stable before the first run. A small setup issue can stop keyword ranking, ASIN capture, or Excel output later in the process.

Use this checklist before launch:

• You have downloaded and installed the latest version of Automa
• You are logged into the same account on both the web version and the desktop client
• The application has been successfully obtained and launched
• Google Chrome is available for Amazon browser automation
• Your Excel template file is ready in .xls or .xlsx format
• The template matches one of the two supported workbook patterns
• You know the Amazon site URL you want to use, such as the US site
• You have a valid ZIP code for the delivery location setting
• The machine can open, edit, and save Excel files locally
• The run environment allows the workflow to access Amazon pages normally
• These checks help the workflow move cleanly from keyword input to product rank output.

Input Mapping

The bot package includes a custom dialog that defines the main user inputs. That means the workflow is designed to be filled out by a person before the run begins, rather than requiring edits inside the flow logic. Each field connects to a named variable, and those variables are then used during template detection, Amazon navigation, keyword search, and Excel writing. This makes the workflow easier to hand off because the important controls are exposed at the start.

Here is how the input mapping works based on the package:

• Template File → maps to the uploaded Excel workbook used for reading keywords and writing output
• Amazon Site URL → maps to the target Amazon domain, with a default value of https://www.amazon.com/
• Page Count → maps to the number of search result pages to scan for each keyword
• ZIP Code → maps to the delivery location used before keyword ranking collection, defaulting to 90001
• Incognito Mode → maps to whether the browser opens in private mode
• Clear Cache Data → maps to whether temporary browser data should be cleared for the run
• Behind the scenes, these values feed variables used throughout the Amazon ranking flow, including template selection, search execution, page loops, ASIN extraction, and final Excel output.

Need help customizing?

This workflow already includes helpful structure, but some users may still want changes. For example, you may want to adjust which Amazon fields are captured, change how the Excel template is read, increase or reduce the page loop, or rewrite the output format for a different reporting style. Since the package supports two template types and writes ranking data in different ways, customization can be very useful when your team has its own workbook rules or reporting labels.

Good customization areas include:

• Changing the template layout
• Adding or removing Amazon output fields
• Updating how keyword rows are read
• Adjusting sponsored or natural rank handling
• Modifying sheet names or output headers
• For help with customization, please reach out through Discord or submit feedback through the Feedback channel. That is the best path if you want this Amazon keyword ranking workflow adapted to your own Excel process, ASIN reporting format, or product rank tracking needs.