Submit data feeds via Google Sheets

You can use Google Sheets to provide us with product data which will be directly incorporated into your Google Merchant Center account. You can either update the existing template that we provide or submit a Google spreadsheet that you create to upload your feed information.

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.

youtube icon Watch this video

Upload your products with a data feed (small inventory)

 

Register a new Google Sheets feed:

  1. Sign into your Google Merchant Center account.
  2. Click on + Data Feed and provide the mode, feed type, target country, content language and feed name for your data feed.
  3. Select Google spreadsheets as the upload method for your data feed. Please do not check this option if you are using a tab-delimited or XML file to provide us with your items.
  4. You can use one of the following options to upload your data using a spreadsheet:

Generate a new template Google spreadsheet

  • Select this radio button to use a Google-supplied template and save changes.
  • After clicking Save, you’ll be directed to a new window for Google Drive where you’ll need to grant permissions for Merchant Center to view and manage your spreadsheets and view and manage your documents. These permissions are temporary and are only used to add the spreadsheet template into Drive at the time of creation. Since Merchant Center only has temporary access to your Drive to add this one spreadsheet, you’ll need to grant these permissions each time you create a new spreadsheet template.
  • Once you have granted permissions, we’ll create the template spreadsheet with the same name you gave your feed in the first step of the registration process.
  • You will be directed back to the Data Feeds tab, where you’ll see your newly registered data feed.
  • Click on the name of your feed and then select the Edit spreadsheet button to update the template with your product data. You can also share the spreadsheet with other people in your business just like any other Sheet. If you’d like any collaborators on your Sheet to use the Google Merchant Center add-on for the spreadsheet, they’ll also need to have access to the Merchant Center account where the spreadsheet is registered as a feed.
  • Once you finish updating the spreadsheet with the required data, return to the Data Feeds page and click on Upload now to start feed processing. If you’re using the Google Merchant Center add-on for your feed, you can upload directly from Sheets.

Select an existing Google spreadsheet

  • Select this radio button to provide us a spreadsheet created by you.
  • To use this option, you will first have to use a Google spreadsheet in your current Google account, and populate it with items.
  • A popup will appear on your screen, and from the menu, select the spreadsheet you would like to link to the feed.
  • After clicking Save, you’ll be directed to a new window for Google Drive where you’ll need to grant permissions for Merchant Center to view and manage your spreadsheets and view and manage your documents. These permissions are temporary and are only used to add the spreadsheet template into Drive at the time of creation. Since Merchant Center only has temporary access to your Drive to add this one spreadsheet, you’ll need to grant these permissions each time you create a new spreadsheet template.
  • To start feed processing, click on Upload now next to the recently registered data feed. If you’re using the Google Merchant Center add-on for your feed, you can upload directly from Sheets.
  • You can also set up a scheduled fetch much like the scheduled fetch feature of a classic feed. Click on Schedule and fetch now to process your data feed.

Note

  • If you are providing us with an existing spreadsheet, ensure that the information provided is in a language specific to the country the feed is targeted to. Please visit our target country requirements to learn more.
  • To choose another spreadsheet, click on Settings under the data feed file name. On the data feeds settings page, use the Change Spreadsheet button to select a different spreadsheet.
  • 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 like a standard Sheet.

Advantages

  • You can use the existing template that we provide to update your feed information.
  • It’s simple to create and update as content is uploaded directly from the information given in the spreadsheet.
  • Use the Google Merchant Center add-on to validate and submit your feed directly from Google Sheets.

Disadvantages

  • You cannot use this format to upload a large volume of data. The Google spreadsheets format can’t be used for files larger than 20MB and these files must contain fewer than 400,000 total cells and 256 columns per sheet.

How helpful is this article:

Feedback recorded. Thanks!
  • Not at all helpful
  • Not very helpful
  • Somewhat helpful
  • Very helpful
  • Extremely helpful