E-commerce

How to track your competitors with 3 Google Sheets functions?

How to track your competitors with 3 Google Sheets functions?

October 28, 2026

Wondering how to keep an eye on competitors' prices, new products, and announcements without dedicating all day to it? The answer lies in three Google Sheets functions: IMPORTXML, IMPORTFEED, and IMPORTDATA. When properly configured, they automatically pull public data into a spreadsheet, allowing you to see market movements without checking pages one by one.

This is useful for a merchant because a price gap or a competitor's new product is often spotted too late. The nuance: these functions depend on the structure of the target sites, require some practice, and do not replace a strategic reading of your own figures.

So how to track your competitors with 3 Google Sheets functions? On the agenda:

  • Why automate competitive intelligence in a spreadsheet?

  • How does IMPORTXML work to scrape a product page?

  • How to find the right xpath without becoming a developer?

  • Why does IMPORTFEED monitor news in your sector?

  • How to link this data to your merchant decisions?

Let's go.

Summary

Why automate competitive intelligence in a spreadsheet?

Google Sheets is not just a tool for making financial statements readable. This online spreadsheet service, edited by the search giant, includes functions capable of monitoring competitor prices, capturing news headlines, and absorbing data from sites, CSV files, and more. For a merchant, this is a concrete competitive advantage.

The idea is simple: instead of opening your rivals' pages every day, you let a spreadsheet do the collection. You set the structure once, then review the gaps. This frees up time for what matters: adjusting your prices, product listings, and sales pitch.

What competitive intelligence changes for you

  • Responsiveness : you see a price drop on the day it appears.

  • Traceability : the history remains in the spreadsheet, not in your memory.

  • Cost : no additional license, just a well-constructed sheet.

With this foundation laid, you still need to know which functions to use. Three are sufficient to cover the essentials.

Convert over 2,000 customers on average per month with Qstomy.

The world’s 1st Shopify AI dedicated to customer conversion

Empowering 200+ e-commerce merchants

How does IMPORTXML work to scrape a product page?

IMPORTXML is the most powerful of the three functions. Its name suggests it only handles XML, but it actually ingests several structured data formats: XML, HTML, CSV, TSV, and RSS feeds. It is the one that retrieves the precise information you are targeting directly from a web page.

Let's take an example. You are competing with a popular retailer on women's twill jogger pants. You want to check that your price remains competitive. You create a new sheet with a title, for example 'Pants to follow', and then some column headers: product name, price, URL. You are ready to start.

The formula structure

The function takes two parameters: the URL of the resource to analyze, followed by an XPath query. In a cell, you type the equals sign, the function name, and then the parentheses enclosing the parameters. The URL goes between quotes, followed by the query. You confirm, and Sheets extracts the requested element.

Repeat the operation for the price, and you begin tracking this competitor automatically.

How to find the right xpath without becoming a developer?

XPath, or XML Path Language, is a query language that selects specific nodes in structured data. It tells Sheets what to capture. For many merchants, this part is not immediately obvious, but it is quickly learned.

Let's break down a typical query. The two forward slashes open the search: they instruct Sheets to traverse the document from top to bottom until it finds a node matching the description that follows. In the example, this description is 'h1', so a level-one title tag.

Next, you don't want just any h1, but an h1 that contains a specific attribute, for example 'itemprop' equal to 'name'. The query reads like a sentence: find a title whose name attribute equals name.

The fastest method

The simplest approach is to use the built-in developer tools in your browser. In Google Chrome, right-click on the product name and choose 'Inspect element'. The tools open on the relevant node, and you copy the path. Repeat for each product to monitor.

Why does IMPORTFEED monitor news in your sector?

IMPORTFEED is designed to parse an RSS or ATOM feed. Where IMPORTXML targets a specific page, IMPORTFEED captures a stream of news, making it a sector radar rather than a price spy.

The function has one required parameter, the URL of the feed to ingest, and three optional parameters. In a cell, you type the function, then the feed address between quotes. Upon confirmation, Sheets retrieves all articles published in that feed.

Refining the result

The second parameter, optional, is used to obtain a feed description, an attribute, or a specific node. By specifying it on the item titles, Sheets returns only article titles, making the reading much clearer.

The third parameter adds column headers: simply indicate 'true'. Note that the second parameter is then left empty, as it is its default value. The fourth limits the number of returned elements: if you only want the last five articles, you specify this in the formula. Your editorial monitoring becomes a simple dated table.

How does IMPORTDATA absorb CSV and TSV files?

IMPORTDATA retrieves information from a CSV or TSV file. It is the most straightforward of the three functions, but it provides a valuable service: it connects your sheet to data published by other tools or public services.

Usage is direct. You specify the file URL between quotes, and Sheets imports its content into the sheet. For example, to view census data published as a CSV, you simply call the function with the file address.

What you can connect

  • Exports from tools : product lists, catalogs, repositories.

  • Public data : statistics, administrative tables, numerical series.

  • Your own extractions : a file uploaded online and re-read at every opening.

This function does not replace a native integration, but it avoids manual copy-pasting and keeps your figures up to date. It complements the previous two well.

How to organize a readable competitive monitoring spreadsheet?

A useful monitoring process starts with a clear spreadsheet. If you stack formulas without structure, you will get accurate but unreadable data that you won't be able to exploit.

Start with a title block that describes the scope: which competitor, which category, which period. Then set your columns once and for all: product name, price, URL, date of collection. Each new competitor adds rows, not columns.

Three formatting habits

  • One line per product, to compare at a glance.

  • One tab per competitor, when the list becomes long.

  • A date column, to spot movements over time.

This discipline aligns with what you already apply to your own metrics: measuring without structuring is useless. The same principle applies to your broader analyses.

Why these competitive data are not enough?

Tracking a competitor's price is instructive, but it tells you nothing about why a customer buys. Two stores can display the same price and convert very differently depending on the product page, reassurance, delivery, or service quality.

In other words, external monitoring illuminates the context, not your actual performance. If you want to understand what blocks your purchase journey, you must listen to your own visitors: the questions they ask often say more than any price list. This is the whole point of analyzing customer conversations to spot recurring objections.

The right balance

Use external data as a signal, not a directive. A competitor lowering prices informs you; it does not dictate your strategy. Your margin, positioning, and acquisition cost must remain the true arbiters.

This clarity avoids the classic mistake: chasing every market movement and weakening your business model.

How to link monitoring to your own performance metrics?

Monitoring truly gains value when it sits alongside your internal figures. A price drop by a rival means something different if your conversion rate drops at the same time or remains stable.

So cross three data families: the observed price, your conversion rate, and your average order value. You will see correlations that a simple table reading does not show. This is an analytical approach, not a collection one: you are looking for causes, not just figures.

Questions to ask yourself

  • Is the movement isolated or followed by several competitors?

  • Do my sales react in the days following?

  • Mes marges me permettent-elles to follow, or should we differentiate differently?

This critical reading aligns with the principles of e-commerce SEO designed to sell, where the real effect of a change is measured before generalizing.

What technical limitations to anticipate with these functions?

These functions are powerful, but they depend on the external environment. A competitor site changing its HTML structure can break your query overnight, without warning. That is why you must regularly verify that your columns are still filling up.

Another point of vigilance: feeds and remote files evolve. An address that worked yesterday may disappear, a format may change. A monitoring spreadsheet is not a static system; it is a living tool that requires minimal maintenance.

Control habits

  • Control occasionally check a value manually.

  • Documentez your queries to know what to fix.

  • Plan an update after every redesign of a tracked site.

Accepting these limits prevents mistaking an empty cell for good news. Missing data is never reassuring data.

How to integrate this monitoring into your merchant routine?

Monitoring is only valuable if it becomes a habit. Set aside a fixed time, once a week, to review the sheet and note what has changed. Fifteen minutes suffice when the structure is solid.

During this slot, do not try to comment on everything. Identify two or three signals, then decide on a concrete action: adjust a price, enrich a product page, strengthen a sales argument.

A simple rhythm

On Monday, you read the discrepancies. On Tuesday, you modify what needs to be changed. The rest of the week, you let the spreadsheet work. This tempo avoids anxiety-inducing surveillance and keeps monitoring serving decision-making.

It is the same logic as for an e-commerce chatbot trained with the right data: the tool is only useful if someone exploits its results with discernment.

How does Qstomy help exploit this data without spying on your rivals?

Competitive monitoring tells you what is happening outside. Qstomy, a Shopify AI agent, acts inside: it guides your visitors toward purchase, manages product recommendations, upsell and cross-sell, monitors the cart, tracks packages, and handles after-sales service. Over 100 merchants already use it.

The difference is clear. A spreadsheet like Google Sheets observes the market; Qstomy converts the traffic you already have. One collects information, the other accompanies the customer at the decisive moment. The two do not oppose each other: monitoring feeds your strategy, Qstomy executes the customer relationship.

What this changes concretely

  • Recommandations : the right product offered at the right time.

  • Cart and package tracking : less abandonment, fewer repetitive questions.

  • SAV : answers to common requests without mobilizing your team.

If you compare tools, know that intelligent product recommendation is judged by the sales it generates, not by its technical specs.

What checklist before launching your competitor tracking sheet?

Before creating your first formula, review a few points. This is what separates a sheet abandoned after a week from a tool that serves you all year.

In short

  • IMPORTXML extracts a specific element from a web page.

  • IMPORTFEED retrieves an RSS or ATOM feed.

  • IMPORTDATA imports a CSV or TSV file.

Your checklist

  • I defined a scope: which competitors, which products.

  • I set my columns before entering the first formula.

  • I tested a value manually to verify the collection.

  • I scheduled a weekly review slot.

Frequently Asked Questions

Faut-il savoir coder ? No, but understanding a minimum of HTML helps write a correct xpath.

Are these functions sufficient? They cover collection; interpretation remains your work.

And for conversion? This is where an agent like Qstomy takes over your store.

To go further: How does SEO work for e-commerce sites? - Qstomy, SEO for e-commerce sites: strategies that really work - Qstomy, E-commerce conversation analysis: understanding real customer questions - Qstomy, E-commerce SEO strategy for category pages - Qstomy, Training an e-commerce chatbot with Shopify: using the right data without creating bad responses - Qstomy, Why does an e-commerce business fail in the first 12 months? - Qstomy, How to use an AI chatbot to compare two products in your store? - Qstomy.

Enzo

October 28, 2026

Convert over 2,000 customers on average per month with Qstomy.

The world’s 1st Shopify AI dedicated to customer conversion

Empowering 200+ e-commerce merchants

Subscribe to the newsletter and get a personalized e-book!

No-code solution, no technical knowledge required. AI trained on your e-shop and non-intrusive.

*Unsubscribe at any time. We do not send spam.

Subscribe to the newsletter and get a personalized e-book!

No-code solution, no technical knowledge required. AI trained on your e-shop and non-intrusive.

*Unsubscribe at any time. We do not send spam.