Emmanuel Flossie pointed out in the past that Google Merchant Center Next couldn’t work with a pre-prepared supplemental feed in Google Sheets. It was necessary to create the sheet from scratch based on a provided template or use another method. However, Google has recently updated this functionality, so this issue is now resolved.
