Google Merchant Center tools
Import Google Merchant Center™ data into Google Sheets™.
This Google Sheets add-on helps you view and edit Google Merchant Center™ data more easily in Google Sheets™. You can also use the add-on to set custom alerts for disapproved products.
- Easy to use report configurator
- Schedule your reports to run and update automatically
- Receive an email when your report is ready
- Set custom alerts for disapproved products
Get your subscription
You can use this Google Merchant Center add-on for Google Sheets for free for 14 days. If you wish to continue using the add-on after the free trial period, please subscribe. Each subscription includes:
- Unlimited Google Merchant Center accounts
- Unlimited reports (Google's quotas and Sheets limits apply.)
- Up to hourly automated refreshes
- Email support
Install the Google Sheets add-on
To use the Reporting for Google Analytics 4 add-on, you must first add it to your spreadsheet. The following instructions will guide you through the process:
- Create a new Google spreadsheet (or open an existing one).
- In the menu bar choose: Extensions > Add-ons > Get add-ons
- Find the “Reporting for Google Analytics 4” add-on in the add-on gallery and select it.
- On the add-on description page, click install in the top right corner to add this add-on to your spreadsheet.
- A dialog should appear asking for permission for the add-on to access your Google Analytics 4 data. Click on "Allow".
- The add-on is now installed. The "Reporting for Google Analytics 4" submenu should now appear in the Extensions menu.
You can also go directly to the add-on in the Google Workspace Marketplace. Here you can install the add-on. The add-on is then available in every Google Spreadsheet under "Extensions".
Create Google Merchant Center™ reports
Reports can be created manually in the configuration sheet or using the add-on's sidebar. To use the sidebar, select "Extensions" > "Merchant Center tools" > "Create report" in the menu bar.
This will display a sidebar on the right side with which you can easily create a report configuration. The sidebar helps with the following:
- Look up Google Merchant Center™ account information.
- Selecting columns.
- Apply filters.
- Determine the sorting of the report.
When you are done, click on the button "Add report to sheet" and your report configuration will appear in the sheet called “Merchant Center report configuration” (if this sheet does not already exist, it will be created).
You can go through these steps again to add another report. You can also copy the information in the sheet to a new column and edit it in the sheet.
Not all cells are filled by the sidebar. The fields that are not filled by the sidebar can be entered in the sheet.
Edit Google Merchant Center™ reports
There are two ways to edit reports after you create them:
- In the add-on menu you can select "Edit report". A sidebar will open with a list of the report names currently in your configuration sheet. You can select one and the sidebar will load your report configuration in the sidebar. You can make changes in the sidebar and save the new configuration to the configuration sheet.
- Another option is to edit the report configuration directly in the sheet.
Run Merchant Center reports
Go to "Extensions" > "Merchant Center tools" > "Run reports" in the menu to run all the reports you have created.
Schedule reports to run automatically
Reports can be scheduled to run automatically. To do this, go to "Extensions" > "Merchant Center tools" > "Schedule Reports".
A dialog will open in which you can indicate three things:
- Turning a schedule on and off.
- Choose the frequency, day and time.
- Set whether you want to receive an email if the execution of a report fails.
The schedule uses the time zone of the spreadsheet. To update the time zone got to: "File" > "Settings" in the Google Sheets menu. If no time zone is set the schedule uses Coordinated Universal Time (UTC). If you change the time zone, you will have to set the schedule again to use the new time zone.
Report configuration options
| Option | Required | Description |
|---|---|---|
| Report name | Yes | The name you give to the report. The name must be unique. If the name is not unique, a sequence number is automatically added to make it unique. The report name is also the name of the sheet to which the data is written. |
| Merchant ID | Yes | The ID of the Google Merchant account you want to retrieve the data from. You can use the sidebar to find out the id. |
| Merchantname | The name of the Google Merchant account. The account name is filled in by the sidebar. This will show at the top of the report for your convenience. | |
| Start date | For some reports | The start date for retrieving Analytics data. You can specify a specific start date formatted as YYYY-MM-DD or as a relative date. Options for specifying a relative date:
You can also use the date functions of Google Sheets to specify this value programmatically. For example, the following expression returns the last day of the previous month: =EOMONTH(TODAY(), -1) |
| End date | For some reports | The end date for retrieving Google Analytics 4 data. You can specify a specific end date formatted as YYYY-MM-DD or as a relative date. Options for specifying a relative date:
You can also use the date functions of Google Sheets to specify this value programmatically. For example, the following expression returns the last day of the previous month: =EOMONTH(TODAY(), -1) |
| Report type | Yes | This is the report type. This is the 'FROM' part of the query. You can choose from these reports: View all report types. |
| Columns | Yes | The columns that should be in your report. This is the 'SELECT' part of the query. |
| Filters | The filter allows you to limit the data returned from Google Merchant Center by conditions. This is the 'WHERE' part of the query. | |
| Sort | The sort option allows you to determine in which order the rows are returned. This is the 'ORDER BY' part of the query | |
| Limit | The limit option allows you to determine the maximum number of rows returned from Google Ads. This is the 'LIMIT' part of the query. If left empty all rows are returned. | |
| Email addresses | The email addresses to which this report should be sent. The report is only sent if the report contains at least 1 row of data. Leave this field blank to not send the report. | |
| Hide report Header | By default, extra information is shown above the report. Set the value to "TRUE" to hide this report header. The report then starts at row 1. | |
| Skip report | If TRUE, the report in the corresponding column is not executed. | |
| Last update on | This field is filled by the add-on, so you can easily see when a report was last updated. |
Available relative dates
Relative dates:
- XdaysAgo (X is a positive integer, for example 7daysAgo)
- today
- yesterday
- mondayThisWeek
- lastSunday
- sundayLastWeek
- mondayLastWeek
- fridayLastWeek
- saturdayLastWeek
- sunday2WeekAgo
- monday2WeekAgo
- friday2WeekAgo
- saturday2WeekAgo
- firstDayThisMonth
- firstDayLastMonth
- lastDayLastMonth
- firstDay2MonthsAgo
- lastDay2MonthsAgo
- firstDayThisYear
Available report types
You can use the add-on to create custom reports tailored to your specific needs. For example, you could create a report that shows the top-selling products in a specific category.
This add-on will let you pull the following data in the Google Sheet™:
- Product view: This report provides a comprehensive overview of your product catalogue, including information such as product ID, title, description, price, category, availability and status.
- Price insights product view: This report provides suggested sale prices for your products and predicts the impact of price changes. Using this report can help you set product prices more effectively.
- Price competitiveness product view: This report displays how other retailers price products you also sell. It provides an average price for each product, helping you see the price others use to attract clicks and overall trends on benchmark prices.
- Merchant performance view: This report provides insights on your performance on Google Shopping and how your products and programs (Shopping ads, free listings, and Buy on Google) are performing. You get insights into impressions, clicks and transaction data (Buy on Google only). (You need the “Reporting manager role” to retrieve this report)
- Competitive visibility top merchant view: This report shows which businesses get the most impressions in a specific category and country on Google, and how your business compares.
- Competitive visibility benchmark view: This report provides insights into your competitive visibility within a specific product category and country based on impressions from your Shopping ads and free listings. It helps you understand the competitive landscape and take action to improve your standing.
- Competitive visibility competitor view: This report provides insights into your competitive visibility, compared to other domains, within a specific product category and country, based on impressions from your Shopping ads and free listings.
- Best sellers product cluster view: This report provides insights into the top-performing products in Shopping ads and free listings, indicating whether they're in your product feed, grouped by category and country.
- Best sellers brand view: This report provides insights into the most popular brands in Shopping ads and free listings, grouped by category and country, to guide your brand stocking decisions.
More information about creating reports based on the Google Content API: https://developers.google.com/shopping-content/reference/rest/v2.1/reports/search
A list of all Google product categories. The ids are needed for some of the reports: https://www.google.com/basepages/producttype/taxonomy-with-ids.en-US.txt
Easily track changes in active and disapproved products in the Google Merchant Center. This add-on for Google Sheets helps you keep control over your products in Google Merchant Center. Whether you manage one account or over 50.
- Set custom alerts
- All accounts in one overview
- Integrates with Google Data Studio
Alerts
Set custom rules for alerts based on:
- Increase in disapproved products
- Disapproved products compared to all products
- Decrease in active products
You can schedule at which time the data is updated and when the alerts are sent.
Dashboard
A dashboard is created which displays the changes in all your accounts per country per destination (e.g. Google Shopping in NL).
Looker Studio
The daily data is saved to a separate sheet in your spreadsheet for every day this add-on runs. Preferably you schedule this add-on to run every day. The data in the sheet is structured to be easily connected to Google Data Studio. This allows you to create a chart with the changes in the statuses over time (or for the last day) in Google Data Studio.
Setup
The add-on includes an easy setup sidebar to get you started in minutes.
Free trial - 14 days
By using the Merchant Center tools add-on for Google Sheets you automatically enter a 14 days free trial. If you wish to continue using the add-on after the free trial, please subscribe.
Terms
For more information please visit our terms and conditions and privacy policy.
