How to create a product feed file containing only products enumerated in Google Sheets file

If we want to create a product file that will only contain products from a Google Sheets file - for example, the TOP 100 selected products, we need to apply the following steps:

Step 1: Create a Google Sheets file. In the first column, in the first row, enter ID (this is how we named the column) and below, list the IDs of the products that we want to be included in the TOP 100 feed. Then, share the file with everyone who has the link. Next, select "Publish to the web" in the options. Copy the CSV link.

Step 2: Add a new source file in the import tab. Paste the copied link as the URL for the file. Set the type of data source and indicate that the file only contains one column. Save and proceed to mapping.

Step 3: In the Mapping tab, we map ID to id, add a custom variable that will add a new attribute to products from Google Sheet (top100), which we will later filter products by, and combine data by ID:

Step 4: In the import rules, we set the following rule. This way, we will append a value to the attribute so that the attribute is not empty.

Step 5: go to the import tab and click "Adjust changes".

Step 6: Create a product file (export) in the selected template or create your own custom file. This file will contain the products specified in Google Sheet.

Step 7: In the export rules of this file, we create a rule excluding and accept the changes. From this moment, by adding or removing ID numbers from the Google Sheet file, we control the content of our TOP 100 export file.