To deploy the Feed Segmenter for BigQuery using Google Spreadsheet, follow these steps:

1. Clone the repository:

   git clone https://github.com/google-marketing-solutions/feed-segmenter
   

2. Deploy the Spreadsheet:
   • Open a new spreadsheet and navigate to Spreadsheet > Extensions > Apps Script.
   • Go to Project Settings from the left menu and:
     • Check the box: Show appsscript.json manifest file in editor.
     • Optionally, set your Cloud Project number.
   • Go to the Editor from the left menu and copy both Code.gs and appsscript.json files from the repository.
3. Set your parameters in the Code.gs file:

   const SPREADSHEET_ID = 'YOUR-SPREADSHEET-ID';
   const GCP_PROJECT_ID = 'YOUR-CLOUD-PROJECT';
   const BQ_DATASET_ID = 'YOUR-BIGQUERY-DATASET';
   const BQ_TABLE = 'Products_123';
   const BQ_SUPPLEMENTAL_TABLE = 'SUPPLEMENTAL-TABLE';
   const GCS_FEED_FILE = 'gs://YOUR-BUCKET/feed.csv';
   const CUSTOM_COLUMN = 'custom_label_0';
   const CUSTOM_COLUMN_VALUE = 'Custom Value';
   const EXPORT_ID = 'offer_id';
   const FILTER_LIST_COLUMN = 'id_column';
   

4. Configure Cloud Storage feed automated transfer:
   • Enable feeds via Cloud Storage in Merchant Center following the instructions here.
   • Set up a Data Transfer within your Google Cloud Project to automatically copy the feed file from Feed Segmenter bucket to Merchant Center bucket, using the Service Account of Merchant Center user. See more instructions here.

In the Code.gs file for the Feed Segmenter, you need to set the following key parameters:

• SPREADSHEET_ID: Your Spreadsheet ID, which can be found from the Spreadsheet URL, e.g., https://docs.google.com/spreadsheets/d/**123**/edit.
• GCP_PROJECT_ID: Your Cloud Project ID.
• BQ_DATASET_ID: The BigQuery dataset ID.
• BQ_TABLE: The BigQuery table name, e.g., Merchant Center Products table.
• BQ_SUPPLEMENTAL_TABLE: A table name for the supplemental table.
• GCS_FEED_FILE: A Cloud Storage location for the CSV export, e.g., gs://YOUR-BUCKET/feed.csv.
• CUSTOM_COLUMN: Custom column to be appended to the feed, e.g., custom_label_0.
• CUSTOM_COLUMN_VALUE: Value to be assigned to the custom column, e.g., Custom Value.
• EXPORT_ID: BigQuery ID column to export to the feed, e.g., offer_id.
• FILTER_LIST_COLUMN: BigQuery column name for list filtering, e.g., id_column.

To use the Feed Segmenter solution to update your supplemental feed, follow these steps:

1. Open the Spreadsheet and go to the Feed Segmenter menu.
2. Initialize sheets by selecting Initialize sheets from the Feed Segmenter menu.
3. Load Entities by selecting Load Entities from the Feed Segmenter menu to fetch all attributes from your BigQuery table to the corresponding sheets.
4. Update the supplemental feed by selecting Update supplemental feed from the Feed Segmenter menu. This will update your supplemental feed BigQuery table and CSV file.