E-commerce
November 1, 2026
Wondering how to automate keyword selection with the AdWords API? Thanks to a free Excel plugin, you can quickly extract keyword search data directly from the API without manual copy-pasting.
This method frees up valuable time and gives you precise insights into local volume, match type, and trends, which are essential for high-performing e-commerce SEO.
So how do you automate keyword selection with the AdWords API? Here is the agenda:
What is the AdWords API and why use it for SEO?
What prerequisites must be installed before launching the plugin?
How to retrieve local search volumes for each keyword?
What real time savings do we achieve through automation?
How does Qstomy leverage this data to increase your conversions?
Let's go.
By integrating this process into your weekly routine, you will gain agility, be able to react quickly to demand fluctuations, and sustainably improve your store's ranking on search engines.
Summary
What is the AdWords API and why use it for SEO?
The Google AdWords API (now called Google Ads API) allows programmatic querying of the search engine to obtain precise metrics: monthly volume, competition, average cost per click, etc. Unlike the web tool, it accepts massive queries and returns results in a structured format, ideal for spreadsheets. For e-commerce, this data forms the foundation of an SEO strategy: it indicates which products are searched for, where users click, and which phrases deserve to be integrated into product pages or blog posts. By leveraging the API, you avoid tedious copy-pasting and gain access to local volumes, crucial for precise geographic targeting.
For example, for an online shoe store, the API might reveal that the term 'men's running sneakers' generates 12,000 monthly searches in Île-de-France, guiding the creation of dedicated category pages.

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
What prerequisites are needed to install the AdWords Excel plugin?
Before launching the extension, ensure you have:
Excel : versions 2003, 2007 ou 2010, en 32 ou 64 bits.
A Google Ads account with API access (you must request an access key via the developer console).
A client ID and API secret : these will be entered into the plugin.
Once these elements are in place, download the ZIP file from the SEOgadget blog, unzip it, and open the example workbook which will guide you step by step. If you have already configured your Shopify store, you can link product URLs to the keyword list for automated mapping.
Do not forget to enable OAuth access in the Google Cloud console and verify that the account has read permissions on the Ads account, otherwise the calls will be rejected.
How to install and configure the Google AdWords API extension for Excel?
Installation boils down to two steps: copy the file AdWordsAPI.xlam into the Excel add-ins directory, then activate it via File → Options → Add-ins. Once active, the ribbon AdWords appears with functions Report Keyword Ideas, Report Local Monthly Searches and other analysis tools. In the configuration panel, enter your ID client, your secret key and select the pays cible (e.g., FR for France). You can now select a keyword column and click Run : the extension sends the query to the API, retrieves the data, and inserts it directly into your sheet.
If your business uses a proxy or firewall, configure Excel's network settings so that HTTPS requests can go out, otherwise API calls will be blocked.
How to generate a list of keyword ideas from a product table?
Start by exporting your product references from Shopify (you can do this via the dashboard or by using the tool Optimizing an e-commerce product page: UX best practices). Place the titles or attributes (brand, color, category) in an Excel column. Select them, choose Report Keyword Ideas and specify the desired match type (wildcard, phrase, or exact). The plugin returns a single cell containing a comma-separated list: you can then “split” these values into columns via Data → Text to Columns. This method automatically generates variants like « black women's shoe », « blue men's sneakers », etc., ready to be leveraged for SEO.
Before feeding the plugin, ensure you normalize the titles (remove special characters, standardize casing) to obtain more relevant keyword suggestions.
How to retrieve local search volumes for each keyword?
After obtaining your ideas, select the same column and click on Report Local Monthly Searches. In the settings, choose the pays (France, Belgium, Switzerland) and the type d’appareil (web or mobile). The extension queries the API and returns the average monthly search volume as well as local trends. These figures are placed in adjacent columns, facilitating sorting: high-volume keywords are immediately identifiable for prioritization in tags <title> or product descriptions. You can also activate the option Local Search Trends to visualize seasonal trends, useful for planning promotional campaigns.
The displayed volumes incorporate seasonal variations; thus, a term related to 'swimsuits' will show a peak in July, helping you plan your promotional campaigns.
How to combine multiple match types in a single table?
The extension accepts Excel 'array' functions, allowing you to run multiple queries simultaneously. For example, create three columns: one for the keyword 'black shoe', one for 'blue shoe', and one for 'red shoe'. Select the three columns, choose Report Keyword Ideas and specify the match type as 'exact'. In a single action, the plugin generates 50 ideas for each color, retrieves local volumes and trends. This approach saves valuable minutes: instead of running 150 separate queries, you get everything in three clicks, for both competitor tracking and category page creation.
You can automate this process with a small VBA script that iterates through all columns in your table, launches the queries, and logs the results in a summary sheet.
What real time savings do we achieve through automation?
Without automation, collecting 4,000 keywords requires at least 40 copy-paste, search, download, and formatting cycles, taking about an hour of tedious work. With the plugin, the same amount of keywords is retrieved in three to five minutes, and data processing continues automatically via Excel formulas. In terms of productivity, this represents a 90% time saving on keyword research. This freed-up time can be reinvested in semantic analysis, content creation, or product page optimization, as recommended in our guide How to increase organic traffic for an e‑commerce site?.
An e‑commerce merchant was thus able to increase their organic traffic by 25% in one month, translating these time gains into a 12% increase in revenue.
What are the costs associated with API calls and how to control them?
The extension itself is free, but each AdWords API call is charged: $0.25 per 1,000 queries (one 'unit'). If you query 4,000 keywords, the cost amounts to $1. Compared to manual work hours, this expense is negligible. To limit costs, group your keywords in batches of 500 to 1,000, use the mode offline (run the query overnight) and disable unnecessary columns. You can also track your usage via the Google Ads dashboard to adjust query volume according to your marketing budget.
Regularly monitor your usage via the 'API Usage' report in Google Ads to adjust your batches and avoid unexpected overages.
What technical limits should be anticipated (memory, processing time)?
When processing tens of thousands of keywords, Excel can become slow or even crash, as each query consumes RAM and CPU time. It is recommended to work with limited data ranges (max 10,000 rows) and switch the calculation mode to manuel (Formulas → Calculation Options → Manual) to avoid automatic recalculation with every change. You can also split your lists into multiple sheets or save intermediate results as CSV files, then reimport them. These best practices ensure workbook stability and allow queries to run overnight without interruption.
Using the 64-bit version of Excel increases memory management capacity, reducing the risk of crashes when processing very large keyword sets.
How to optimize Excel settings for large keyword volumes?
In addition to switching to manual calculation, enable automatic filters (Data → Filter) to quickly isolate high-volume keywords. Use the function CONCATENER ou TEXTJOIN to group variants, then apply conditional formatting to highlight values above a threshold (e.g., > 1,000 monthly searches). Finally, create a simple VBA macro that re-runs the function Report Keyword Ideas for each sheet, which automates the end-to-end process and saves you from manually clicking the 'Run' button. This advanced automation is ideal for merchants managing multiple catalogs.
Power Query can also be used to import generated CSV results, offering smooth transformation and the ability to refresh data with a single click.
How does Qstomy leverage this data to boost your conversions on Shopify?
Qstomy integrates search volumes and match types directly into its product recommendation engine. When you import your Shopify catalog, Qstomy associates each SKU with the most relevant keywords, then adjusts titles, meta-descriptions, and image tags alt based on data from the AdWords API. In parallel, Qstomy offers personalized upsells and cross-sells based on high-volume queries, thereby increasing conversion rates. To learn more, consult our article E‑commerce CRO: how to turn traffic into sales. This synergy between SEO and cart optimization simplifies the overall strategy and generates a better return on investment.
In a test, Qstomy boosted the conversion rate from 3.8% to 5.2% by enriching product pages with the most searched keywords, demonstrating the direct impact of automated SEO.
What checklist to follow before launching an automated keyword campaign?
Before starting your automation, verify the following points:
API Access : confirm that your Google Ads key is active and that the daily quota has not been exceeded.
Product List Quality : export titles and descriptions from Shopify (see E-commerce CRM and customer support: use the right data).
Excel Settings : switch to manual calculation mode, enable filtering, and save a copy of the workbook.
Budget API : estimate the number of required calls and calculate the total cost.
Qstomy integration : import results into the Qstomy dashboard to automate product recommendations.
By following this checklist, you ensure smooth data collection, controlled budget tracking, and optimal use of SEO insights for your Shopify store.
To go further: How to build an e-commerce Facebook Ads strategy? - Qstomy, Training an e-commerce chatbot with Shopify: using the right data without creating bad responses - Qstomy, Can you create an e-commerce site for free? - Qstomy.
After deployment, remember to run A/B tests on optimized titles and meta-descriptions to concretely measure the effect on click-through rate (CTR) and conversion rate.

Enzo
November 1, 2026


