In this article we will explain how to easily submit you product data in Google Merchant Center using Google Sheets.
Step 1 : Go to Google Merchant Center > Cog Icon (top right) > Data Sources > click on the supplemental sources tab > add supplemental feed
If you can not add a supplemental feed enable it first.
Step 2 : Choose Use a Google Sheets Template and click on Use Template (make sure to allow popups)
Step 3 : You can now edit or remove the template data, for example if you only want to update the color, than have an ID column, and a color column. I also have a guide on how to add all your existing data, so that you can edit it.
If you need to add any other columns, then add the column header and its values. To know what attributes are supported and what you can add please read: https://support.google.com/merchants/answer/7052112?hl=en
Step 4 : Once you are ready with the file, go back to Google merchant center and click on continue.
Step 5 : Select your primary feed
Step 6 : click on create data source, and now you are done.
The data will apply to your products within 30 minutes.