Register a Google Sheet in Manufacturer Center

Use Google Sheets to quickly submit your product data to Manufacturer Center. This article contains information on how to register a feed based on a Google Sheets template in Manufacturer Center.

Instructions

Register a new Google Sheets feed

You can submit a new feed through a generated template or your own Google spreadsheet.

1. Sign in to your Manufacturer Center account.
2. Under "Products," select Feeds.
3. To create a new feed, click the plus button.
4. Select your country of sale.
5. Select the language.
6. Under “Destinations,” check all desired destinations for your feeds (for example, Shopping ads).
7. Select Continue.
8. Input a name for your primary feed.
9. Select Google Sheets.
10. Select Continue. Your spreadsheet is shared with an email address that ends in the domain @partnercontent.gserviceaccount.com, which is the account we use to access and process the file. The email address is unique to your Manufacturer Center account. If other members of your organization need to edit the feed, you can share it with them.

Generate a new Google Sheets template

The Google Sheets 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 Manufacturer 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.
2. (Optional) Select Create an upload schedule (optional) to set a time and frequency from which this feed will fetch from your Google spreadsheet.
3. Select Continue.
4. Grant Manufacturer 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 Google Drive at the time of creation.
   Note: Permissions will need to be granted every time a new spreadsheet template is created.

After you grant permissions to Manufacturer Center, your new feed will appear under “Primary feeds”. 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. Select “Sign In” on the top right of the screen and try again.

Select an existing Google spreadsheet

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 Select an existing Google Sheet.
2. In the popup that appears, select the Google spreadsheet that you want to link to your Manufacturer Center account
3. Select Continue.
4. Grant Manufacturer 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. Permissions will need to be granted every time a new spreadsheet template is created.
5. To upload your product data to Manufacturer Center, select Upload now.

After you've registered your Google spreadsheet in Manufacturer Center, you can set up and submit your product data.