Search
Clear search
Close search
Google apps
Main menu

Register a Google Sheet on Merchant Center

This article contains information on how to register and set up a Google Sheet based feed with Merchant Center. Use Google Sheets to quickly submit your product data to Google Merchant Center. Google Sheets and Merchant Center offer simple templates and add-ons to help you create and manage your feeds. 

Once you have a Sheets-powered feed registered in your Merchant Center account, you can install the Google Merchant Center add-on from your spreadsheet to create, validate, and upload your feed.

How to register a new Google Sheets feed

A feed registered through Google Sheets can be sourced through an existing Google Sheet or through an generated Merchant Center template (recommended).

  1. Sign into your Google Merchant Center account
  2. Go to the Feeds page under Products
  3. Click the plus button Add button (plus button  FAB).png to create a new feed
  4. Provide the mode, feed type, target country, content language and feed name for your feed
  5. Select Google Sheets as the input method for your data feed. 
  6. Choose to generate a new Sheet from the template (recommended) or select an existing Google Sheet to connect to your account
  7. Follow the prompts for the option that you selected
  8. Click Save

Your Google spreadsheets will be shared with an email address that ends in the domain @partnercontent.gserviceaccount.com, which is the account we use to access and process your Sheet. The email address is unique to your Merchant Center account. If other members of your organization need to edit the feed, you can share it with them .

Generate a new template Google Sheet

The Google Sheet template contains an auto-filled row of required and recommended attributes, descriptions of attributes and value requirements, and a step by step guide on how to upload your product data to Merchant Center.  If this is your first time creating a feed, the template is a useful tool to determine what information is needed for your product data.

  1. When prompted, select the option to Generate a new Google spreadsheet from a template. This option will appear after you select to upload your product data with Google Sheets. 
  2. Click Save 
  3. Grant Merchant Center temporary permission to view and manage your spreadsheets and your documents in the popup that appears. These permissions are temporary and are only used to add the spreadsheet template in Drive at the time of creation. Note: Permissions will need to be granted every time new spreadsheet template is created.
  4. Click on the newly created feed in the Feeds page
  5. Select Edit spreadsheet
  6. Add your product data to the template
  7. Click the Fetch now button under the feed name to upload your product data

You can edit the header row or update the template with a new header if needed, such as to add any optional attributes. Make sure you have all of the required attributes according to the product data specification before uploading your product data. Learn more about setting up your product data in Google Sheets.


The template generated will be specific to the target country you selected and the data you upload must meet our target country requirements and product data specification


Note: If you’re unable to edit the new template, it may be because you aren’t recognized as being signed in. Click “Sign In” on the top right of the screen and try again.

How to select an existing Google Sheet

Make sure your product data is in a language that is supported by the feed target country. Learn more about the Language and currency requirements for target countries.
  1. When prompted, choose the option to Select an existing Google Sheet. This option will appear after you select to upload your product data with Google Sheets. 
  2. In the popup that appears, select the Google Sheet that you want to link to your Merchant Center account
  3. Click Save
  4. Grant Merchant Center permission to view and manage your spreadsheets and your documents in the popup that appears. These permissions are temporary and are only used to add the spreadsheet template in Drive at the time of creation. Note:  Permissions will need to be granted every time new spreadsheet template is created.
  5. Select Upload now to upload your product data to Merchant Center

How to install the Merchant Center add-on

The add-on is automatically enabled on any newly created Google Sheets template, and a one-time installation in the Sheets add-on store is required when getting started. If the add-on is missing or you’ve created your own sheet, you can install the add-on to your existing sheet by following these steps:
  1. Select Get add-on in the Add-ons menu of any open document or spreadsheet.
  2. Search for the Google Merchant Center add-on.
  3. Click Add-ons Install Button to install the add-on.
  4. A message will appear requesting access to specific data that the add-on needs to work. Read this message and click Accept.
  5. The add-on will appear as a sidebar on your spreadsheet.
  6. Once you’ve installed the add-on, you can access it anytime by selecting Merchant Center from the Add-ons menu.
     
Note: If you use the same Google Sheet for more than one feed in Merchant Center, you’ll need to select the feed you want to use with the add-on the first time you use the tool. You can change this at any time from Add-ons > Google Merchant Center > Select feed.

After you have registered your Google Sheets-powered feed in Merchant Center, you can begin to set up and submit your product data


Related links:

About the Merchant Center add-on for Google Sheets
Set up your product data in Google Sheets
Set up structured data for Merchant Center

Was this article helpful?
How can we improve it?
2 minutes to improve Merchant Center

Please help us make your Merchant Center experience better by completing this short survey!

START YOUR SURVEY