{"id":2945,"date":"2019-09-05T15:38:56","date_gmt":"2019-09-05T13:38:56","guid":{"rendered":"https:\/\/adformatic.com\/?page_id=2945"},"modified":"2026-07-08T15:16:07","modified_gmt":"2026-07-08T13:16:07","slug":"merchant-center-tools","status":"publish","type":"page","link":"https:\/\/adformatic.com\/en\/merchant-center-tools\/","title":{"rendered":"Google Merchant Center tools"},"content":{"rendered":"<p>\r\n<section class=\"sh-section sh-section-d0cb35cf95b3603d6d2fd1e6cccb32d0 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container-fluid\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-46557d1593737a3f889467b3c4a69b7f fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-f0fc064c1f219a0fd4b7e7e14db9f4f8\" class=\"sh-text-block\">\r\n\t<h1 style=\"text-align: center;\"><span style=\"color: #ffffff;\">Google Merchant Center tools<\/span><\/h1><\/div>\r\n\r\n<div id=\"text-block-f15fa6926532404663fb0792d76672a5\" class=\"sh-text-block\">\r\n\t<p style=\"text-align: center;\"><span style=\"font-size: 18px; color: #ffffff;\">Import Google Merchant Center\u2122 data into Google Sheets\u2122.<\/span><\/p><\/div>\r\n\r\n<div id=\"button-8ceb1b1e74a2d671d70e68d8b3e8a437\" class=\"sh-button-container  sh-button-style-1\">\r\n\t<div class=\"sh-element-margin\">\r\n\t\t<a href=\"https:\/\/workspace.google.com\/marketplace\/app\/merchant_center_tools\/792938201230\" target=\"_blank\" class=\"sh-button sh-button-xlarge sh-button-icon-right\">\r\n\r\n\t\t\t\t\t\t\t<span class=\"sh-button-icon\">\r\n\t\t\t\t\t<i class=\"fa fa-angle-right\"><\/i>\r\n\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\t\t\t\t<span class=\"sh-button-text\">\r\n\t\t\t\t\tINSTALL ADD-ON\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\r\n\t\t<\/a>\r\n\t\t\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-a574b5abb998461150f60ab8986c470c fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-041b0540cafc569c0c2bf1dcb0f10313 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"video-tutorial\"><\/span><\/div>\r\n\r\n<div id=\"text-block-cf8f0537398d091cc04aa09bcb623f9f\" class=\"sh-text-block\">\r\n\t<p style=\"text-align: left;\"><span style=\"font-size: 24px;\">This Google Sheets add-on helps you view and edit Google Merchant Center\u2122 data more easily in Google Sheets\u2122. You can also use the add-on to set custom alerts for disapproved products.<\/span><\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-988b432093ff13aad23f16327f5beed8 fw-col-xs-12 fw-col-sm-6\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<ul class=\"sh-list sh-list-style1\" id=\"list-1753367c6d654d1eda2110a47b1a83e2\">\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tEasy to use report configurator\t\t<\/li>\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tSchedule your reports to run and update automatically\t\t<\/li>\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tReceive an email when your report is ready\t\t<\/li>\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tSet custom alerts for disapproved products\t\t<\/li>\r\n\t<\/ul>\r\n\r\n<div id=\"button-9df356c8dd175883a06ee10468832b5b\" class=\"sh-button-container  sh-button-style-1\">\r\n\t<div class=\"sh-element-margin\">\r\n\t\t<a href=\"https:\/\/workspace.google.com\/marketplace\/app\/merchant_center_tools\/792938201230\" target=\"_blank\" class=\"sh-button sh-button-xlarge \">\r\n\r\n\t\t\t\r\n\t\t\t\t\t\t\t<span class=\"sh-button-text\">\r\n\t\t\t\t\tINSTALL THE ADD-ON\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\r\n\t\t<\/a>\r\n\t\t\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-d1b98238556239376b2679b219bbadb2 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-40fadc42245b88e4c11a9ee28ce29e41 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-8fa83f1ede9604f02e0f921fdd6b5f1c\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h3 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tGet your subscription\t\t\t<\/h3>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-0451e915841616e12e203ab5fd9d5474\" class=\"sh-text-block\">\r\n\t<p data-nosnippet=\"\">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:<\/p><\/div>\r\n\r\n<ul class=\"sh-list sh-list-style1\" id=\"list-73640ec234f6e683ad73daa8ed60b2a2\">\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tUnlimited Google Merchant Center accounts\t\t<\/li>\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tUnlimited reports (Google&#039;s quotas and Sheets limits apply.)\t\t<\/li>\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tUp to hourly automated refreshes\t\t<\/li>\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tEmail support\t\t<\/li>\r\n\t<\/ul>\r\n\r\n<div id=\"button-33a84c6b8b30f786d4140187eef4001c\" class=\"sh-button-container  sh-button-style-1\">\r\n\t<div class=\"sh-element-margin\">\r\n\t\t<a href=\"https:\/\/portal.adformatic.com\/subscribe\/merchant-center-tools\" target=\"_blank\" class=\"sh-button sh-button-xlarge \">\r\n\r\n\t\t\t\r\n\t\t\t\t\t\t\t<span class=\"sh-button-text\">\r\n\t\t\t\t\tSUBSCRIBE\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\r\n\t\t<\/a>\r\n\t\t\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-968e76a6d004102aca111c7b4172a1d7 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-76b7a8bf9969ced939f340e402985f16 fw-col-xs-12 fw-col-sm-6\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-80cacb7ccc1f52c78321a06f7d9ea96d\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h3 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tNavigate directly to\t\t\t<\/h3>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-6d0cfda71ff06aaab66f73de19da9edf\" class=\"sh-text-block\">\r\n\t<p><a href=\"#install-add-on\">Install the Google Sheets add-on<\/a><\/p><p><a href=\"#create-report\">Create reports<\/a><\/p><p><a href=\"#edit-report\">Edit reports<\/a><\/p><p><a href=\"#run-report\">Run reports<\/a><\/p><p><a href=\"#schedule-report\">Schedule reports to run automatically<\/a><\/p><p><a href=\"#report-configuration-options\">Rapport configuration options<\/a><\/p><p><a href=\"#all-report-types\">Available report types<\/a><\/p><p><a href=\"#contact\">Ask a question or request a feature<\/a><\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-764a4aa014e7a2ddae6da279bc21b673 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-4dcc9cac38ee7244ef06b771cdad08b5 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"install-add-on\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-dc9243bae3337b4f13549d0289216471 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-d3ed8b40bfdf00d573b9eced06ec9de8\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\t Install the Google Sheets add-on\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-6307753356a879793dcc121c7b38f8a5\" class=\"sh-text-block\">\r\n\t<p>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:<\/p><ol><li>Create a new Google spreadsheet (or open an existing one).<\/li><li>In the menu bar choose: Extensions > Add-ons > Get add-ons<\/li><li>Find the \u201cReporting for Google Analytics 4\u201d add-on in the add-on gallery and select it.<\/li><li>On the add-on description page, click install in the top right corner to add this add-on to your spreadsheet.<\/li><li>A dialog should appear asking for permission for the add-on to access your Google Analytics 4 data. Click on \"Allow\".<\/li><li>The add-on is now installed. The \"Reporting for Google Analytics 4\" submenu should now appear in the Extensions menu.<\/li><\/ol><p>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\".<\/p><\/div>\r\n\r\n<div id=\"button-e2079eabe33beb62749e0ebe26950cfb\" class=\"sh-button-container  sh-button-style-1 sh-animated fadeIn\"data-wow-duration=\"0.5s\">\r\n\t<div class=\"sh-element-margin\">\r\n\t\t<a href=\"https:\/\/workspace.google.com\/marketplace\/app\/merchant_center_tools\/792938201230\" target=\"_blank\" class=\"sh-button sh-button-xlarge \">\r\n\r\n\t\t\t\r\n\t\t\t\t\t\t\t<span class=\"sh-button-text\">\r\n\t\t\t\t\tINSTALL THE ADD-ON\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\r\n\t\t<\/a>\r\n\t\t\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-9d654ae909e17b7dc1fc5189632d3c40 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-0f0d1a93949db9ed58ae67161ccac4a6 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"create-report\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-8409f290157bb54996d3310c882f7109 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-6c70d0c17040ceb698fc813f05c3530a\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tCreate Google Merchant Center\u2122 reports\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-28c2acfc9a7c61ad4d9a58649e56ad4b\" class=\"sh-text-block\">\r\n\t<p>Reports can be created manually in the configuration sheet or using the add-on's sidebar. To use the sidebar, select \"Extensions\" &gt; \"Merchant Center tools\" &gt; \"Create report\" in the menu bar.<br \/>This will display a sidebar on the right side with which you can easily create a report configuration. The sidebar helps with the following:<\/p><ul><li>Look up Google Merchant Center\u2122 account information.<\/li><li> Selecting columns.<\/li><li>Apply filters.<\/li><li>Determine the sorting of the report.<\/li><\/ul><p>When you are done, click on the button \"Add report to sheet\" and your report configuration will appear in the sheet called \u201cMerchant Center report configuration\u201d (if this sheet does not already exist, it will be created).<\/p><p>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.<br \/>Not all cells are filled by the sidebar. The fields that are not filled by the sidebar can be entered in the sheet.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-54277b264c68401a7dfd3ec9067bc2b3 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-64b1d34699937876a76c168d60e13aff fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"edit-report\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-7699815d2927bad73cac4d85f915443d fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-8a99ac85ea0af1ac46c533ef5095ed03\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tEdit Google Merchant Center\u2122 reports\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-b46b29f1aaef8629ffad86692e046083\" class=\"sh-text-block\">\r\n\t<p>There are two ways to edit reports after you create them:<\/p><ul><li>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.<\/li><li>Another option is to edit the report configuration directly in the sheet.<\/li><\/ul><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-ff7cec25b842edf7f273a6735a57ec42 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-5b05f2eaf14cfc97d829150f18046a78 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"run-report\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-7246c0d07a813b9b8e804955bf0810d0 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-689dedf62560c2f452eedc1839300704\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tRun Merchant Center reports\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-92af37fc956c54f94b328f455d579267\" class=\"sh-text-block\">\r\n\t<p>Go to \"Extensions\" &gt; \"Merchant Center tools\" &gt; \"Run reports\" in the menu to run all the reports you have created.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-f9d7ef1633cea369800382fe9b050357 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-e71f6b7313774c6097f79b3040043da5 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"schedule-report\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-b289f1802352af216e14ab9e0e4fbcba fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-0a4d28fc8ed5de790acfcd4153699148\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tSchedule reports to run automatically\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-fb3efb8d1b5608b818c6f1f9f6f17c2d\" class=\"sh-text-block\">\r\n\t<p>Reports can be scheduled to run automatically. To do this, go to \"Extensions\" &gt; \"Merchant Center tools\" &gt; \"Schedule Reports\".<br \/>A dialog will open in which you can indicate three things:<\/p><ul><li>Turning a schedule on and off.<\/li><li>Choose the frequency, day and time.<\/li><li>Set whether you want to receive an email if the execution of a report fails.<\/li><\/ul><\/div>\r\n\r\n<div id=\"single-image-2427c12e7b5393acb66af447b71ac0ae\" class=\"sh-single-image  \">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\t\t\t<div class=\"sh-image-lazy-loading\" style=\"max-width: 711px;\">\r\n\t\t\r\n\t\t\t<div class=\"sh-single-image-container sh-single-image-container-lazy\">\r\n\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\/\/adformatic.com\/wp-content\/uploads\/Google-Analytics-4-set-schedule-5.png\" rel=\"lightbox\">\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"ratio-container\" style=\"padding-top: 39.803094233474%;\">\r\n\t\t\t\t\t\t\t\t\t<div class=\"ratio-content\">\r\n\t\t\t\t\t\t\t\t\t\t<img class=\"sh-image-url lazy\" data-src=\"https:\/\/adformatic.com\/wp-content\/uploads\/Google-Analytics-4-set-schedule-5.png\" alt=\"Google Analytics 4 - set schedule\" \/>\r\n\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t<\/div>\r\n\r\n\t\t\t\t\t<\/div>\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-da55bb269e84fd9efae510934a18520b\" class=\"sh-text-block\">\r\n\t<p>The schedule uses the time zone of the spreadsheet. To update the time zone got to: \"File\" &gt; \"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.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-a70dd42b7a85f424fd020f806ca4bb33 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-a9806f81228336fe03e01171d057c259 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"report-configuration-options\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-b0d906829f2cf8a7e29880d5d86dc047 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-e0cc4be05cc9576bf449af1cb207dcb5\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tReport configuration options\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div class=\"sh-table-element sh-table-element-style1 fw-table\" id=\"table-776d247d1be93049634f7f60440a2669\">\r\n\t<table>\r\n\t\t\t\t\t\t\t\t\t<thead>\r\n\t\t\t\t\t<tr class=\"heading-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<th class=\"desc-col\">\r\n\t\t\t\t\t\t\t\tOption\t\t\t\t\t\t\t<\/th>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<th class=\"default-col\">\r\n\t\t\t\t\t\t\t\tRequired\t\t\t\t\t\t\t<\/th>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<th class=\"default-col\">\r\n\t\t\t\t\t\t\t\tDescription\t\t\t\t\t\t\t<\/th>\r\n\t\t\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t<\/thead>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tReport name\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tYes\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe 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.\r\nThe report name is also the name of the sheet to which the data is written.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tMerchant ID\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tYes\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe ID of the Google Merchant account you want to retrieve the data from. You can use the sidebar to find out the id. \t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tMerchantname\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe 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.\r\n\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tStart date\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tFor some reports\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe start date for retrieving Analytics data. You can specify a specific start date formatted as YYYY-MM-DD or as a relative date.\r\n<br>\r\nOptions for specifying a relative date:\r\n<ul>\r\n<li>XdaysAgo (X is a positive integer, for example 7daysAgo)<\/li>\r\n<li>yesterday<\/li>\r\n<li>sundayLastWeek<\/li>\r\n<li>mondayLastWeek<\/li>\r\n<li>fridayLastWeek<\/li>\r\n<li>SaturdayLastWeek<\/li>\r\n<\/ul>\r\n\r\n<a href=\"#relative-dates\">View all possible options for relative dates.<\/a>\r\n<br>\r\n<br>\r\nYou 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)\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tEnd date\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tFor some reports\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe 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.\r\n<br>\r\nOptions for specifying a relative date:\r\n<ul>\r\n<li>XdaysAgo (X is a positive integer, for example 7daysAgo)<\/li>\r\n<li>yesterday<\/li>\r\n<li>sundayLastWeek<\/li>\r\n<li>mondayLastWeek<\/li>\r\n<li>fridayLastWeek<\/li>\r\n<li>SaturdayLastWeek<\/li>\r\n<\/ul>\r\n\r\n<a href=\"#relative-dates\">View all possible options for relative dates<\/a>\r\n<br>\r\n<br>\r\nYou 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)\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tReport type\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tYes\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThis is the report type. This is the 'FROM' part of the query. You can choose from these reports: <a href=\"#all-report-types\">View all report types<\/a>.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tColumns\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tYes\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe columns that should be in your report. This is the 'SELECT' part of the query.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tFilters\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe filter allows you to limit the data returned from Google Merchant Center by conditions. This is the 'WHERE' part of the query.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tSort\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe sort option allows you to determine in which order the rows are returned. This is the 'ORDER BY' part of the query\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tLimit\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe 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.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tEmail addresses\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe 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.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tHide report Header\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tBy 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.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tSkip report\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tIf TRUE, the report in the corresponding column is not executed.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tLast update on\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThis field is filled by the add-on, so you can easily see when a report was last updated.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t<\/table>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-86f4a7fa78c95663d331c784c8b543ae fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-22cbfb091b9aa1d254fd1be62105e1f0 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"relative-dates\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-83b40854bdc75ef8093b21297def82ab fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-b47e4f0887abfdf69bcb4cc7bfd44994\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tAvailable relative dates\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-533d347e79aea5612455f0755c282b4d\" class=\"sh-text-block\">\r\n\t<p>Relative dates:<\/p><ul><li>XdaysAgo (X is a positive integer, for example 7daysAgo)<\/li><li>today<\/li><li>yesterday<\/li><li><div>mondayThisWeek<\/div><\/li><li><div>lastSunday<\/div><\/li><li>sundayLastWeek<\/li><li>mondayLastWeek<\/li><li>fridayLastWeek<\/li><li>saturdayLastWeek<\/li><li>sunday2WeekAgo<\/li><li>monday2WeekAgo<\/li><li>friday2WeekAgo<\/li><li>saturday2WeekAgo<\/li><li><div><div>firstDayThisMonth<\/div><\/div><\/li><li>firstDayLastMonth<\/li><li>lastDayLastMonth<\/li><li>firstDay2MonthsAgo<\/li><li>lastDay2MonthsAgo<\/li><li><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;firstDayLastYear&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:513,&quot;3&quot;:{&quot;1&quot;:0},&quot;12&quot;:0}\">firstDayThisYear<\/span><\/li><\/ul><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-9c8a87b5db96aee95b73ebc3b21daa84 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-4893fb4874a9b63a7e25da949971056a fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"all-report-types\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-46196585458f021521a697c09801711b fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-29cce6d18443705a7241c5f0dcbca674\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tAvailable report types\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-62a55d50338d58b3ae96077180a6e005\" class=\"sh-text-block\">\r\n\t<p>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.<\/p><p>This add-on will let you pull the following data in the Google Sheet\u2122:<\/p><ul><li><strong>Product view<\/strong>: This report provides a comprehensive overview of your product catalogue, including information such as product ID, title, description, price, category, availability and status.<\/li><li><strong>Price insights product view<\/strong>: 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.<\/li><li><strong>Price competitiveness product view<\/strong>: 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.<\/li><li><strong>Merchant performance view<\/strong>: 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 \u201cReporting manager role\u201d to retrieve this report)<\/li><li><strong>Competitive visibility top merchant view<\/strong>: This report shows which businesses get the most impressions in a specific category and country on Google, and how your business compares.<\/li><li><strong>Competitive visibility benchmark view<\/strong>: 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.<\/li><li><strong>Competitive visibility competitor view<\/strong>: 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.<\/li><li><strong>Best sellers product cluster view<\/strong>: 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.<\/li><li><strong>Best sellers brand view<\/strong>: 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.<\/li><\/ul><p>More information about creating reports based on the Google Content API: https:\/\/developers.google.com\/shopping-content\/reference\/rest\/v2.1\/reports\/search<br \/>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<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-94211b724786a83a28999ed1e86e718d fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-e1555c22e425d86017fe1994857736b9 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-c1cd0ff03da7c766768091be301096ee\" class=\"sh-text-block\">\r\n\t<p>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.<\/p><\/div>\r\n\r\n<ul class=\"sh-list sh-list-style1\" id=\"list-c34923b01968248e6341cc0df8faa1b4\">\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tSet custom alerts\t\t<\/li>\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tAll accounts in one overview\t\t<\/li>\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tIntegrates with Google Data Studio\t\t<\/li>\r\n\t<\/ul>\r\n\r\n<div id=\"button-a494e37666426a07d0680db9aeab945f\" class=\"sh-button-container  sh-button-style-1 sh-animated fadeIn\"data-wow-duration=\"0.5s\">\r\n\t<div class=\"sh-element-margin\">\r\n\t\t<a href=\"https:\/\/workspace.google.com\/marketplace\/app\/merchant_center_tools\/792938201230\" target=\"_blank\" class=\"sh-button sh-button-large \">\r\n\r\n\t\t\t\r\n\t\t\t\t\t\t\t<span class=\"sh-button-text\">\r\n\t\t\t\t\tINSTALL ADD-ON\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\r\n\t\t<\/a>\r\n\t\t\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-73f5fb2d1bfd441f41f9cdb47f01edf1 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-a3c6de02f32105dfa7ab48f26024cf5a fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-2439b4e7cc2d20a92d9bde44dafdb14e\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tAlerts\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-a74263aa1604b2cd0ea8ea71276707aa fw-col-xs-12 fw-col-sm-6 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-12142575bd4a1dcb6dd0f9dd6d56d619\" class=\"sh-text-block\">\r\n\t<p><span style=\"font-weight: 400;\">Set custom rules for alerts based on:<\/span><\/p><ul><li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Increase in disapproved products<\/span><\/li><li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Disapproved products compared to all products<\/span><\/li><li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Decrease in active products<\/span><\/li><\/ul><p><span style=\"font-weight: 400;\">You can schedule at which time the data is updated and when the alerts are sent.<\/span><\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n\r\n<div class=\"sh-column sh-column-cd8c3552a577d8e59d5b52c20ca9f986 fw-col-xs-12 fw-col-sm-6\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"single-image-adabf1d776f496d6840860175f153c9c\" class=\"sh-single-image  \">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\t\t\t<div class=\"sh-image-lazy-loading\" style=\"max-width: 1024px;\">\r\n\t\t\r\n\t\t\t<div class=\"sh-single-image-container sh-single-image-container-lazy\">\r\n\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"ratio-container\" style=\"padding-top: 45.80078125%;\">\r\n\t\t\t\t\t\t\t\t\t<div class=\"ratio-content\">\r\n\t\t\t\t\t\t\t\t\t\t<img class=\"sh-image-url lazy\" data-src=\"https:\/\/adformatic.com\/wp-content\/uploads\/GMC-alerts-m-d-1024x469.png\" alt=\"GMC-alerts-m-d\" \/>\r\n\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t<\/div>\r\n\r\n\t\t\t\t\t<\/div>\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-df67fde62c912d9dc5fd45f139dff2f5 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-9256db5f8704210b5832bd48ec3fce8d fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-c9da36bc62a66a8959d01ca39ee999ae\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h3 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tDashboard\t\t\t<\/h3>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-b21153838eb381c9a91c8ef618415c8b fw-col-xs-12 fw-col-sm-6 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-f4f77f160955fa5f2d5622fddabc14b5\" class=\"sh-text-block\">\r\n\t<p><span style=\"font-weight: 400;\">A dashboard is created which displays the changes in all your accounts per country per destination (e.g. Google Shopping in NL).<\/span><\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n\r\n<div class=\"sh-column sh-column-b8c0bb2b2de37aa7fce6e9c1769aaa65 fw-col-xs-12 fw-col-sm-6\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"single-image-5480bf4d32d4f873787344b143a02cf5\" class=\"sh-single-image  \">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\t\t\t<div class=\"sh-image-lazy-loading\" style=\"max-width: 1024px;\">\r\n\t\t\r\n\t\t\t<div class=\"sh-single-image-container sh-single-image-container-lazy\">\r\n\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"ratio-container\" style=\"padding-top: 16.796875%;\">\r\n\t\t\t\t\t\t\t\t\t<div class=\"ratio-content\">\r\n\t\t\t\t\t\t\t\t\t\t<img class=\"sh-image-url lazy\" data-src=\"https:\/\/adformatic.com\/wp-content\/uploads\/GMC-add-on-sheets-dashboard-1024x172.png\" alt=\"GMC add-on sheets dashboard\" \/>\r\n\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t<\/div>\r\n\r\n\t\t\t\t\t<\/div>\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-d84c4575183de9a8abeee9c5a0b94bd4 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-d92df1af40cb7c416f5055a630443d2a fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-ff9b31903ecc223901d66c34106d28c8\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h3 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tData Studio\t\t\t<\/h3>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-8210a2c75e6c2456a5e1c91c9b1ae990 fw-col-xs-12 fw-col-sm-6 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-de266abe2c07af1e0d486bfbc7e72081\" class=\"sh-text-block\">\r\n\t<p><span style=\"font-weight: 400;\">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. <\/span><span style=\"font-weight: 400;\">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.<\/span><\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n\r\n<div class=\"sh-column sh-column-c67c490a75710a853f0ea9bf16de02fc fw-col-xs-12 fw-col-sm-6\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"single-image-e43b7c6a1e502bba5f7f18c88a80d4ed\" class=\"sh-single-image  \">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\t\t\t<div class=\"sh-image-lazy-loading\" style=\"max-width: 1024px;\">\r\n\t\t\r\n\t\t\t<div class=\"sh-single-image-container sh-single-image-container-lazy\">\r\n\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"ratio-container\" style=\"padding-top: 38.57421875%;\">\r\n\t\t\t\t\t\t\t\t\t<div class=\"ratio-content\">\r\n\t\t\t\t\t\t\t\t\t\t<img class=\"sh-image-url lazy\" data-src=\"https:\/\/adformatic.com\/wp-content\/uploads\/GMC-add-on-GDS-charts-1-1024x395.png\" alt=\"GMC add-on GDS charts\" \/>\r\n\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t<\/div>\r\n\r\n\t\t\t\t\t<\/div>\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-9f541f674ecc867de20731f046620c06 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-8771c2f8917d4528ffaede66b75b1243 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-8fc3e5c1aa216298cfaf9332fb0e33bb\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h3 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tSetup\t\t\t<\/h3>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-4c9cf07d84a01ee6f6a5f40975f464c8 fw-col-xs-12 fw-col-sm-6 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-5dfa8dc5f9ff7ce3d7f2056a537d2fe5\" class=\"sh-text-block\">\r\n\t<p><span style=\"font-weight: 400;\">The add-on includes an easy setup sidebar to get you started in minutes.<\/span><\/p><div style=\"max-width: 600px;\"><div class=\"video-container\" align=\"left\"><iframe src=\"https:\/\/www.youtube.com\/embed\/cdOlnoqZjAw?rel=0&amp;modestbranding=1&amp;autohide=1\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div><div align=\"left\"><\/div><\/div><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-401478f6667b09d46f2028fad541397e fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-3ef6933d413b8248f59795a5a9fa278a fw-col-xs-12 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-24cb4e0d74bd2b2579f5b79bd9eab5fe\" class=\"sh-text-block\">\r\n\t<h3>Free trial - 14 days<\/h3><p>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 <a href=\"https:\/\/portal.adformatic.com\/subscribe\/merchant-center-tools\" target=\"_blank\" rel=\"noopener\">subscribe<\/a>.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-3e14c10ee6a6422e94134e40d41bf02f fw-col-xs-12 fw-col-sm-4 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"button-01b02a7673ff35e5837a468f9cfda95e\" class=\"sh-button-container  sh-button-style-1 sh-animated fadeIn\"data-wow-duration=\"0.5s\">\r\n\t<div class=\"sh-element-margin\">\r\n\t\t<a href=\"https:\/\/workspace.google.com\/marketplace\/app\/merchant_center_tools\/792938201230\" target=\"_blank\" class=\"sh-button sh-button-large \">\r\n\r\n\t\t\t\r\n\t\t\t\t\t\t\t<span class=\"sh-button-text\">\r\n\t\t\t\t\tINSTALL THE ADD-ON\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\r\n\t\t<\/a>\r\n\t\t\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n\r\n<div class=\"sh-column sh-column-af5ce688fa21ea236e0a1566a773ab2a fw-col-xs-12 fw-col-sm-4 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"button-8ebab92dfc76f707361f29e50d47a415\" class=\"sh-button-container  sh-button-style-1 sh-animated fadeIn\"data-wow-duration=\"0.5s\">\r\n\t<div class=\"sh-element-margin\">\r\n\t\t<a href=\"https:\/\/portal.adformatic.com\/subscribe\/merchant-center-tools\" target=\"_self\" class=\"sh-button sh-button-large \">\r\n\r\n\t\t\t\r\n\t\t\t\t\t\t\t<span class=\"sh-button-text\">\r\n\t\t\t\t\tSEE PLANS &amp; PRICING\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\r\n\t\t<\/a>\r\n\t\t\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-461536a5384cff80e4c093bc1e230a95 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-1facad11bf048b2cad0953f2764967c9 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-1f40c1ee21890840524a46763554942b\" class=\"sh-text-block\">\r\n\t<h3>Terms<\/h3><p>For more information please visit our <a href=\"https:\/\/adformatic.com\/en\/terms-and-conditions\/\">terms and conditions<\/a> and <a href=\"https:\/\/adformatic.com\/en\/privacy\/\">privacy policy.<\/a><\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-5138ad50271b1c5050654b7d7bb8628c fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-9a21413ad3246c6d9b0e603dd0b5e1c1 fw-col-xs-12 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-ed6b0b5e0e40ffa909949310ea6c7fea\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tFeedback and questions\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-127c06ad5e41fa242552394787f49cab fw-col-xs-12 fw-col-sm-6 dark-form\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-bc47a0f021e99ab03729d2667e822c7f\" class=\"sh-text-block\">\r\n\t<p><noscript class=\"ninja-forms-noscript-message\">\n\tNotice: JavaScript is required for this content.<\/noscript>\n<div id=\"nf-form-9-cont\" class=\"nf-form-cont\" aria-live=\"polite\" aria-labelledby=\"nf-form-title-9\" aria-describedby=\"nf-form-errors-9\" role=\"form\">\n\n    <div class=\"nf-loading-spinner\"><\/div>\n\n<\/div>\n        <!-- That data is being printed as a workaround to page builders reordering the order of the scripts loaded-->\n        <script>var formDisplay=1;var nfForms=nfForms||[];var form=[];form.id='9';form.settings={\"objectType\":\"Form Setting\",\"editActive\":true,\"title\":\"Support\",\"created_at\":\"2019-08-23 11:41:34\",\"default_label_pos\":\"above\",\"show_title\":\"0\",\"clear_complete\":\"1\",\"hide_complete\":\"1\",\"logged_in\":\"\",\"key\":\"\",\"conditions\":[],\"wrapper_class\":\"\",\"element_class\":\"\",\"add_submit\":\"1\",\"not_logged_in_msg\":\"\",\"sub_limit_number\":\"\",\"sub_limit_msg\":\"\",\"calculations\":[],\"formContentData\":[\"name_1563891814361\",\"email_address_1639238883085\",\"message_1563891864044\",\"send_1563891884697\"],\"container_styles_background-color\":\"\",\"container_styles_border\":\"\",\"container_styles_border-style\":\"\",\"container_styles_border-color\":\"\",\"container_styles_color\":\"\",\"container_styles_height\":\"\",\"container_styles_width\":\"\",\"container_styles_font-size\":\"\",\"container_styles_margin\":\"\",\"container_styles_padding\":\"\",\"container_styles_display\":\"\",\"container_styles_float\":\"\",\"container_styles_show_advanced_css\":\"0\",\"container_styles_advanced\":\"\",\"title_styles_background-color\":\"\",\"title_styles_border\":\"\",\"title_styles_border-style\":\"\",\"title_styles_border-color\":\"\",\"title_styles_color\":\"\",\"title_styles_height\":\"\",\"title_styles_width\":\"\",\"title_styles_font-size\":\"\",\"title_styles_margin\":\"\",\"title_styles_padding\":\"\",\"title_styles_display\":\"\",\"title_styles_float\":\"\",\"title_styles_show_advanced_css\":\"0\",\"title_styles_advanced\":\"\",\"row_styles_background-color\":\"\",\"row_styles_border\":\"\",\"row_styles_border-style\":\"\",\"row_styles_border-color\":\"\",\"row_styles_color\":\"\",\"row_styles_height\":\"\",\"row_styles_width\":\"\",\"row_styles_font-size\":\"\",\"row_styles_margin\":\"\",\"row_styles_padding\":\"\",\"row_styles_display\":\"\",\"row_styles_show_advanced_css\":\"0\",\"row_styles_advanced\":\"\",\"row-odd_styles_background-color\":\"\",\"row-odd_styles_border\":\"\",\"row-odd_styles_border-style\":\"\",\"row-odd_styles_border-color\":\"\",\"row-odd_styles_color\":\"\",\"row-odd_styles_height\":\"\",\"row-odd_styles_width\":\"\",\"row-odd_styles_font-size\":\"\",\"row-odd_styles_margin\":\"\",\"row-odd_styles_padding\":\"\",\"row-odd_styles_display\":\"\",\"row-odd_styles_show_advanced_css\":\"0\",\"row-odd_styles_advanced\":\"\",\"success-msg_styles_background-color\":\"\",\"success-msg_styles_border\":\"\",\"success-msg_styles_border-style\":\"\",\"success-msg_styles_border-color\":\"\",\"success-msg_styles_color\":\"\",\"success-msg_styles_height\":\"\",\"success-msg_styles_width\":\"\",\"success-msg_styles_font-size\":\"\",\"success-msg_styles_margin\":\"\",\"success-msg_styles_padding\":\"\",\"success-msg_styles_display\":\"\",\"success-msg_styles_show_advanced_css\":\"0\",\"success-msg_styles_advanced\":\"\",\"error_msg_styles_background-color\":\"\",\"error_msg_styles_border\":\"\",\"error_msg_styles_border-style\":\"\",\"error_msg_styles_border-color\":\"\",\"error_msg_styles_color\":\"\",\"error_msg_styles_height\":\"\",\"error_msg_styles_width\":\"\",\"error_msg_styles_font-size\":\"\",\"error_msg_styles_margin\":\"\",\"error_msg_styles_padding\":\"\",\"error_msg_styles_display\":\"\",\"error_msg_styles_show_advanced_css\":\"0\",\"error_msg_styles_advanced\":\"\",\"changeEmailErrorMsg\":\"Vul hier een geldig e-mail adres is\",\"confirmFieldErrorMsg\":\"Deze velden moeten gelijk zijn\",\"fieldNumberNumMinError\":\"Number Min Error\",\"fieldNumberNumMaxError\":\"Number Max Error\",\"fieldNumberIncrementBy\":\"Please increment by \",\"formErrorsCorrectErrors\":\"Corrigeer de velden waar nodig\",\"validateRequiredField\":\"This field is required\",\"honeypotHoneypotError\":\"Honeypot Error\",\"fieldsMarkedRequired\":\"Fields with a * are required\",\"currency\":\"EUR\",\"unique_field_error\":\"A form with this value has already been submitted.\",\"drawerDisabled\":false,\"allow_public_link\":\"0\",\"embed_form\":\"\",\"changeDateErrorMsg\":\"Please enter a valid date!\",\"repeatable_fieldsets\":\"\",\"ninjaForms\":\"Ninja Forms\",\"fieldTextareaRTEInsertLink\":\"Insert Link\",\"fieldTextareaRTEInsertMedia\":\"Insert Media\",\"fieldTextareaRTESelectAFile\":\"Select a file\",\"formHoneypot\":\"If you are a human seeing this field, please leave it empty.\",\"fileUploadOldCodeFileUploadInProgress\":\"File Upload in Progress.\",\"fileUploadOldCodeFileUpload\":\"FILE UPLOAD\",\"currencySymbol\":\"&euro;\",\"thousands_sep\":\",\",\"decimal_point\":\".\",\"siteLocale\":\"en_US\",\"dateFormat\":\"d\\\/m\\\/Y\",\"startOfWeek\":\"1\",\"of\":\"of\",\"previousMonth\":\"Previous Month\",\"nextMonth\":\"Next Month\",\"months\":[\"January\",\"February\",\"March\",\"April\",\"May\",\"June\",\"July\",\"August\",\"September\",\"October\",\"November\",\"December\"],\"monthsShort\":[\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"May\",\"Jun\",\"Jul\",\"Aug\",\"Sep\",\"Oct\",\"Nov\",\"Dec\"],\"weekdays\":[\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\"],\"weekdaysShort\":[\"Sun\",\"Mon\",\"Tue\",\"Wed\",\"Thu\",\"Fri\",\"Sat\"],\"weekdaysMin\":[\"Su\",\"Mo\",\"Tu\",\"We\",\"Th\",\"Fr\",\"Sa\"],\"recaptchaConsentMissing\":\"reCaptcha validation couldn&#039;t load.\",\"recaptchaMissingCookie\":\"reCaptcha v3 validation couldn&#039;t load the cookie needed to submit the form.\",\"recaptchaConsentEvent\":\"Accept reCaptcha cookies before sending the form.\",\"currency_symbol\":\"&euro;\",\"beforeForm\":\"\",\"beforeFields\":\"\",\"afterFields\":\"\",\"afterForm\":\"\"};form.fields=[{\"objectType\":\"Field\",\"objectDomain\":\"fields\",\"editActive\":false,\"order\":1,\"idAttribute\":\"id\",\"label\":\"Name\",\"key\":\"name_1563891814361\",\"type\":\"textbox\",\"created_at\":\"2016-08-24 16:39:20\",\"label_pos\":\"above\",\"required\":1,\"input_limit_type\":\"characters\",\"input_limit_msg\":\"Character(s) left\",\"wrap_styles_show_advanced_css\":0,\"label_styles_show_advanced_css\":0,\"element_styles_show_advanced_css\":0,\"cellcid\":\"c3277\",\"field_label\":\"Name\",\"field_key\":\"name_1563891814361\",\"default\":\"\",\"placeholder\":\"\",\"container_class\":\"\",\"element_class\":\"\",\"input_limit\":\"\",\"manual_key\":\"\",\"admin_label\":\"\",\"help_text\":\"\",\"mask\":\"\",\"custom_mask\":\"\",\"custom_name_attribute\":\"\",\"personally_identifiable\":\"\",\"value\":\"\",\"drawerDisabled\":\"\",\"id\":45,\"beforeField\":\"\",\"afterField\":\"\",\"parentType\":\"textbox\",\"element_templates\":[\"textbox\",\"input\"],\"old_classname\":\"\",\"wrap_template\":\"wrap\"},{\"objectType\":\"Field\",\"objectDomain\":\"fields\",\"editActive\":false,\"order\":2,\"idAttribute\":\"id\",\"label\":\"Email address\",\"key\":\"email_address_1639238883085\",\"type\":\"email\",\"created_at\":\"2016-08-24 16:39:20\",\"label_pos\":\"above\",\"required\":1,\"wrap_styles_show_advanced_css\":0,\"label_styles_show_advanced_css\":0,\"element_styles_show_advanced_css\":0,\"cellcid\":\"c3281\",\"custom_name_attribute\":\"email\",\"personally_identifiable\":1,\"field_label\":\"E-mail address\",\"field_key\":\"e-mail_address_1563891858757\",\"default\":\"\",\"placeholder\":\"\",\"container_class\":\"\",\"element_class\":\"\",\"admin_label\":\"\",\"help_text\":\"\",\"value\":\"\",\"drawerDisabled\":false,\"id\":46,\"beforeField\":\"\",\"afterField\":\"\",\"parentType\":\"email\",\"element_templates\":[\"email\",\"input\"],\"old_classname\":\"\",\"wrap_template\":\"wrap\"},{\"objectType\":\"Field\",\"objectDomain\":\"fields\",\"editActive\":false,\"order\":5,\"idAttribute\":\"id\",\"label\":\"Message\",\"key\":\"message_1563891864044\",\"type\":\"textarea\",\"created_at\":\"2016-08-24 16:39:20\",\"label_pos\":\"above\",\"required\":1,\"input_limit_type\":\"characters\",\"input_limit_msg\":\"Character(s) left\",\"wrap_styles_show_advanced_css\":0,\"label_styles_show_advanced_css\":0,\"element_styles_show_advanced_css\":0,\"cellcid\":\"c3284\",\"drawerDisabled\":false,\"field_label\":\"Message\",\"field_key\":\"message_1563891864044\",\"default\":\"\",\"placeholder\":\"\",\"container_class\":\"\",\"element_class\":\"\",\"input_limit\":\"\",\"manual_key\":\"\",\"admin_label\":\"\",\"help_text\":\"\",\"textarea_rte\":\"\",\"disable_rte_mobile\":\"\",\"textarea_media\":\"\",\"value\":\"\",\"id\":47,\"beforeField\":\"\",\"afterField\":\"\",\"parentType\":\"textarea\",\"element_templates\":[\"textarea\",\"input\"],\"old_classname\":\"\",\"wrap_template\":\"wrap\"},{\"objectType\":\"Field\",\"objectDomain\":\"fields\",\"editActive\":false,\"order\":6,\"idAttribute\":\"id\",\"label\":\"Send\",\"key\":\"send_1563891884697\",\"type\":\"submit\",\"created_at\":\"2016-08-24 16:39:20\",\"processing_label\":\"SENDING\",\"element_class\":\"sh-button sh-button-xlarge \",\"wrap_styles_show_advanced_css\":0,\"label_styles_show_advanced_css\":0,\"element_styles_show_advanced_css\":0,\"submit_element_hover_styles_show_advanced_css\":0,\"cellcid\":\"c3287\",\"drawerDisabled\":false,\"field_label\":\"Send\",\"field_key\":\"send_1563891884697\",\"container_class\":\"\",\"id\":48,\"beforeField\":\"\",\"afterField\":\"\",\"value\":\"\",\"label_pos\":\"above\",\"parentType\":\"textbox\",\"element_templates\":[\"submit\",\"button\",\"input\"],\"old_classname\":\"\",\"wrap_template\":\"wrap-no-label\"}];nfForms.push(form);<\/script>\n        <\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Merchant Center tools Import Google Merchant Center\u2122 data into Google Sheets\u2122. INSTALL ADD-ON This Google Sheets add-on helps you view and edit Google Merchant Center\u2122 data more easily in&#8230;<\/p>\n","protected":false},"author":1,"featured_media":9215,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2945","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Merchant Center tools - Adformatic<\/title>\n<meta name=\"description\" content=\"Import Google Merchant Center\u2122 data into Google Sheets\u2122. Configure, edit &amp; schedule reports. And set alerts for disapproved products to stop losing revenue in Google Shopping.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/adformatic.com\/en\/merchant-center-tools\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Merchant Center tools (Google Sheets add-on)\" \/>\n<meta property=\"og:description\" content=\"Import Google Merchant Center\u2122 data into Google Sheets\u2122. Configure, edit &amp; schedule reports. And set alerts for disapproved products to stop losing revenue in Google Shopping.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adformatic.com\/en\/merchant-center-tools\/\" \/>\n<meta property=\"og:site_name\" content=\"Adformatic\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-08T13:16:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/adformatic.com\/wp-content\/uploads\/linkedin-post-Custom-alerts-Google-Merchant-center.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"627\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Google Merchant Center tools (Google Sheets add-on)\" \/>\n<meta name=\"twitter:description\" content=\"Import Google Merchant Center\u2122 data into Google Sheets\u2122. Configure, edit &amp; schedule reports. And set alerts for disapproved products to stop losing revenue in Google Shopping.\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/adformatic.com\/en\/merchant-center-tools\/\",\"url\":\"https:\/\/adformatic.com\/en\/merchant-center-tools\/\",\"name\":\"Google Merchant Center tools - Adformatic\",\"isPartOf\":{\"@id\":\"https:\/\/adformatic.com\/en\/#website\"},\"datePublished\":\"2019-09-05T13:38:56+00:00\",\"dateModified\":\"2026-07-08T13:16:07+00:00\",\"description\":\"Import Google Merchant Center\u2122 data into Google Sheets\u2122. Configure, edit & schedule reports. And set alerts for disapproved products to stop losing revenue in Google Shopping.\",\"breadcrumb\":{\"@id\":\"https:\/\/adformatic.com\/en\/merchant-center-tools\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/adformatic.com\/en\/merchant-center-tools\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/adformatic.com\/en\/merchant-center-tools\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/adformatic.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Merchant Center tools\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/adformatic.com\/en\/#website\",\"url\":\"https:\/\/adformatic.com\/en\/\",\"name\":\"Adformatic\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/adformatic.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/adformatic.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/adformatic.com\/en\/#organization\",\"name\":\"Adformatic\",\"url\":\"https:\/\/adformatic.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/adformatic.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/adformatic.com\/wp-content\/uploads\/favicon.png\",\"contentUrl\":\"https:\/\/adformatic.com\/wp-content\/uploads\/favicon.png\",\"width\":128,\"height\":128,\"caption\":\"Adformatic\"},\"image\":{\"@id\":\"https:\/\/adformatic.com\/en\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Merchant Center tools - Adformatic","description":"Import Google Merchant Center\u2122 data into Google Sheets\u2122. Configure, edit & schedule reports. And set alerts for disapproved products to stop losing revenue in Google Shopping.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/adformatic.com\/en\/merchant-center-tools\/","og_locale":"en_US","og_type":"article","og_title":"Google Merchant Center tools (Google Sheets add-on)","og_description":"Import Google Merchant Center\u2122 data into Google Sheets\u2122. Configure, edit & schedule reports. And set alerts for disapproved products to stop losing revenue in Google Shopping.","og_url":"https:\/\/adformatic.com\/en\/merchant-center-tools\/","og_site_name":"Adformatic","article_modified_time":"2026-07-08T13:16:07+00:00","og_image":[{"width":1200,"height":627,"url":"https:\/\/adformatic.com\/wp-content\/uploads\/linkedin-post-Custom-alerts-Google-Merchant-center.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_title":"Google Merchant Center tools (Google Sheets add-on)","twitter_description":"Import Google Merchant Center\u2122 data into Google Sheets\u2122. Configure, edit & schedule reports. And set alerts for disapproved products to stop losing revenue in Google Shopping.","twitter_misc":{"Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/adformatic.com\/en\/merchant-center-tools\/","url":"https:\/\/adformatic.com\/en\/merchant-center-tools\/","name":"Google Merchant Center tools - Adformatic","isPartOf":{"@id":"https:\/\/adformatic.com\/en\/#website"},"datePublished":"2019-09-05T13:38:56+00:00","dateModified":"2026-07-08T13:16:07+00:00","description":"Import Google Merchant Center\u2122 data into Google Sheets\u2122. Configure, edit & schedule reports. And set alerts for disapproved products to stop losing revenue in Google Shopping.","breadcrumb":{"@id":"https:\/\/adformatic.com\/en\/merchant-center-tools\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adformatic.com\/en\/merchant-center-tools\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/adformatic.com\/en\/merchant-center-tools\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/adformatic.com\/en\/"},{"@type":"ListItem","position":2,"name":"Google Merchant Center tools"}]},{"@type":"WebSite","@id":"https:\/\/adformatic.com\/en\/#website","url":"https:\/\/adformatic.com\/en\/","name":"Adformatic","description":"","publisher":{"@id":"https:\/\/adformatic.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/adformatic.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/adformatic.com\/en\/#organization","name":"Adformatic","url":"https:\/\/adformatic.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/adformatic.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/adformatic.com\/wp-content\/uploads\/favicon.png","contentUrl":"https:\/\/adformatic.com\/wp-content\/uploads\/favicon.png","width":128,"height":128,"caption":"Adformatic"},"image":{"@id":"https:\/\/adformatic.com\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/pages\/2945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/comments?post=2945"}],"version-history":[{"count":15,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/pages\/2945\/revisions"}],"predecessor-version":[{"id":9971,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/pages\/2945\/revisions\/9971"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/media\/9215"}],"wp:attachment":[{"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/media?parent=2945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}