Add products to Merchant Center using Google Sheets

With this method, you'll maintain a spreadsheet with all your product data. Any changes you make to the information in the spreadsheet will automatically be reflected in Merchant Center.

On this page


Get started

Step 1 In your Merchant center account, go to Products An icon for the Products in Merchant Center..

Step 2 Under “All products” click Add Products (if there is a drop down list of options select Add another product source).

Step 3 Select the option Use a Google Sheets Template and click the Use template button.

Step 4 Add your product details to the template, be sure to delete rows 2 to 5 as they contain instructions and examples. Learn more about the product details that need to be added.

Step 5 Return to the Merchant Center set the schedule for syncing your Merchant Center product data with your spreadsheet. The default syncing schedule is every 24 hours.

Step 5 Click Continue.


Next steps

  • We review your products for completeness and compliance with our policies, and inform you of any issues with products that sync to your account.
  • You can check the publishing status of each product from the “Products” page (under the “Status” column). If you don’t want to show some products, you can also change the visibility of the products. Learn more about checking product visibility and status in Merchant Center.

Fix an issue

Issues with your products need to be fixed before customers can view them on Google. All issues with your product data can be found in the "Needs attention" tab of the “Products” section in Merchant Center.

Each product-level issue also contains a “Learn more” link that directs you to specific instructions for fixing the issue. Learn more about Issues in Merchant Center.

Note: Removing a data source that uses a Google Sheet from your Merchant Center doesn’t delete the Google sheet itself. Furthermore users of your Merchant Center account that had access to the Google Sheet will retain access. Learn more about deleting Google Sheets or changing sharing settings.

Was this helpful?

How can we improve it?
true
Search
Clear search
Close search
Google apps
Main menu
13042878047669693443
true
Search Help Center
true
true
true
true
true
71525
false
false