How to set up your product feed using Google Sheets

This article contains information on how to set up a Google Sheet-based feed in your Merchant Center. Google Sheets and Merchant Center offer simple templates and add-ons to help you create and manage your feeds.

1. Sign in to your Merchant Center account.
2. Under "Products," click Feeds.
3. To create a new feed, click the plus button.
4. Select “Country of sale” from the drop-down menu.
5. Select “Language” from the drop-down menu.
6. Under “Destinations,” check all desired destinations.
7. Click Continue.
8. Input a name for your primary feed.
9. Select "Google Sheets."
10. Click Continue.

Generate a new Google Sheet template

The next step is either creating a feed from a template, which is handy considering the source, or uploading one you’ve created earlier yourself. For convenience, we’ll use the ‘Generate a new Google spreadsheet from a template’ option. 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'.
   
2. Click Continue.
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. 
4. Once you grant permissions to the Merchant Center, your new feed will appear under “Primary feeds.”
5. The template has a few tabs at the bottom which you should review carefully. 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.
6. Go back to your feeds list and click on the name of the file.
   
7. You can now manually transfer data from the Google Sheet to the Google Merchant Center.
   
8. It can take a while for your products to show up in the Merchant Center, but you should be able to see the overall status on the ‘Home’ tab. Wait for your products/feed to be reviewed and approved by Google before they go live (1-3 business days).