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
- In your Merchant Center
account, select Products
under "Products & store"
in the left navigation menu.
- Under “All products” select Add products(there's is a drop down list of options select Add another product source).
- Select the option Use Google Sheets and select Use templatebutton.
- Add your product details to the template and be sure to delete rows 2 to 5 as they contain instructions and examples. Learn more about the Product data specifications that needs to be added.
- Return to the Merchant Center and set the schedule for syncing your Merchant Center product data with your spreadsheet. The default syncing schedule is every 24 hours.
- Select Continue.
Recommendations
A few attributes are repeated (accept multiple values) and/or are group attributes (having sub-attributes). If you add your products to Merchant Center directly using a Google Sheet, follow the guidelines below for special characters in the case of repeated and/or group attributes:
- Repeated attributes: Escape commas (,) that are part of the attribute or sub-attribute value with a backslash (\) before the comma to ensure these are used literally and are not interpreted as an attribute value separator.
- Group attributes: Escape colons (:) that are part of a sub-attribute value with a backslash (\) before the colon to ensure these are used literally and are not interpreted as a sub-attribute separator (:).
- If a value contains a backslash, you must pair it with a second backslash to ensure it is used literally. For example, instead of usb-a\usb-c, enter usb-a\\usb-c.
- Unlike TSV files (tab-separated value text data sources), don’t wrap attribute values or sub-attribute values with double quotes ("). If you add double quotes these will be interpreted as part of the attribute or sub-attribute value itself.
Example
[product_detail]
attribute for a camera you are selling, with the following content, consisting of 4 sections (1 of which doesn’t have a specific section name) and 14 values (rows) in total:| section_name |
attribute_name |
attribute_value |
| Connectivity |
Connectivity Technology |
HDMI , NFC , USB |
| Connectivity |
Wireless Technology | BuiltIn 802.11b/g/n with NFC |
| Connectivity |
Video Output |
Type C Mini HDMI |
| Connectivity |
Total Video Out Ports |
2 |
| Memory |
Flash Memory Type: |
Single Slot : SD/SDHC/SDXC (UHS-I) |
| Memory |
Recording Capacity |
30 Minutes |
| Memory |
Write Speed |
Several MB/s to over 100 MB/s |
| Memory |
Windows Directory |
C :\ camera \ defaults |
| Camera Settings |
Metering Methods |
average , multi-zone , partial , spot |
| Camera Settings |
Exposure Control |
Auto , Manual , Program , Shutter Priority |
| Camera Settings |
Crop Mode |
APS-C |
| What's in the box? |
Camera Body , Lens , Battery pack , Manual |
|
| Warranty |
1 year manufacturer |
|
| Best Sellers Rank |
#1 , 065 in Electronics , #1 in DSLR Cameras |
You’d submit this in one cell like this. Note the escaping of commas, colons, and backslashes that are part of the attribute value, indicated in red in the above table, with a backslash (\) (we’ve bolded the backslashes to make them easier to view:
| N |
O |
P |
|
|---|---|---|---|
| 1 |
… |
product_detail |
… |
| 2 |
… |
Connectivity:Connectivity Technology:HDMI \ , NFC \ , USB, Connectivity:Wireless Technology:BuiltIn 802.11b /g /n with NFC, Connectivity:Video Output:Type C Mini HDMI, Connectivity:Total Video Out Ports:2, Memory:Flash Memory Type:Single Slot \ : SD/SDHC/SDXC (UHS-I), Memory:Recording Capacity:30 Minutes, Memory:Write Speed:Several MB /s to over 100 MB /s, Memory:Windows Directory:C \ : \\ camera \\ defaults, Camera Settings:Metering Methods:average \ ,multi-zone \ ,partial \ ,spot, Camera Settings:Exposure Control:Auto \ , Manual \ , Program \ , Shutter Priority Camera Settings:Crop Mode:APS-C, :What's in the box?:Camera Body \ ,Lens \ ,Battery pack \ ,Manual, :Warranty:1 year manufacturer, :Best Sellers Rank:#1 \ ,065 in Electronics \ ,#1 in DSLR Cameras |
… |
| 3 |
… |
… |
… |
Alternatively, you can also create multiple separate columns, each containing one or more values. For example, to have one column for each section, you can submit this in 4 cells as follows:
| N |
O |
P |
Q |
|
|---|---|---|---|---|
|
1
|
product_detail |
product_detail |
product_detail |
product_detail |
|
2
|
Connectivity:Connectivity Technology:HDMI \
, NFC \
, USB, |
Memory:Flash Memory Type:Single Slot \
: SD/SDHC/SDXC (UHS-I), |
Camera Settings:Metering Methods:average \
,multi-zone \
,partial \
,spot, Camera Settings:Exposure Control:Auto \ , Manual \ , Program \ , Shutter Priority, Camera Settings:Crop Mode:APS-C |
:What's in the box?:Camera Body \
,Lens \
,Battery pack \
,Manual, :Warranty:1 year manufacturer, :Best Sellers Rank:#1 \ ,065 in Electronics \ ,#1 in DSLR Cameras |
|
3
|
… |
… |
… |
… |
Lastly, you can submit each value in its individual cell, in which case you would need 14 columns as follows (only 3 columns shown):
| N |
O |
P |
Q |
|
|---|---|---|---|---|
|
1
|
product_detail |
product_detail |
product_detail |
… |
|
2
|
Connectivity:Connectivity Technology:HDMI \ , NFC \ , USB |
Connectivity:Wireless Technology:BuiltIn 802.11b/g/n with NFC |
Connectivity:Video Output:Type C Mini HDMI |
|
|
3
|
… | … | … | … |
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 .
