How google-marketing-solutions/feedgen works
FeedGen optimizes merchant product feeds through a Google Sheets sidebar: users configure generation, submit feed rows, and review scored suggestions before exporting approved content as a supplemental feed. The Apps Script app coordinates title and description generation, optional landing-page and image context, attribute filling, scoring, and sheet-based validation. The repository also documents a BigQuery processing alternative and includes a separate Cloud Function for batch attribute enrichment. The main workflow is evidenced by the README and partial app excerpt; links for unsampled BigQuery behavior are limited to documented capabilities.
Main entry points: app.ts Workflow coordinator · vertex.ts Model client · main.py Batch enrichment · index.html Sidebar UI
Components 22
Sheets application
- Workflow coordinator
src/app.ts - Sidebar UI
src/static/index.html - Feed configuration
src/config.ts - Google Sheets
- Page cache
- Run logging
src/helpers/logger.ts
Content generation
- Prompt assembly
src/app.ts - Page context fetch
src/helpers/util.ts - Image understanding
src/helpers/vertex.ts - Model client
src/helpers/vertex.ts - Content scoring
src/app.ts - Attribute filling
src/app.ts
Feed outputs
- Human validation
src/app.ts - Supplemental feed
src/app.ts
Batch alternatives
- BigQuery processing
bigquery - Batch enrichment
enrichment/src/main.py - Cloud Storage
- Gemini batch
Other components
- Merchant
- Product web page
- Vertex AI
- Merchant Center
Connections 26
- Merchant → Sidebar UI: launches
- Sidebar UI → Workflow coordinator: invokes
- Workflow coordinator → Feed configuration: reads settings
- Workflow coordinator → Google Sheets: reads feed
- Workflow coordinator → Prompt assembly: builds prompts
- Prompt assembly → Page context fetch: adds page context
- Page context fetch → Product web page: fetches content
- Workflow coordinator → Page cache: caches page data
- Workflow coordinator → Image understanding: uses image context
- Workflow coordinator → Model client: requests generation
- Model client → Vertex AI: calls model API
- Model client → Image understanding: downloads image
- Workflow coordinator → Content scoring: scores content
- Workflow coordinator → Attribute filling: fills attributes
- Workflow coordinator → Human validation: writes suggestions
- Human validation → Google Sheets: stores review rows
- Merchant → Google Sheets: reviews suggestions
- Workflow coordinator → Google Sheets: writes approved feed
- Workflow coordinator → Run logging: logs activity
- Google Sheets → Supplemental feed: provides export data
- Supplemental feed → Merchant Center: supplements catalog
- Merchant → BigQuery processing: processes feed
- Merchant → Batch enrichment: submits batch request
- Batch enrichment → Cloud Storage: reads and writes CSV
- Batch enrichment → Gemini batch: creates batch job
- Gemini batch → Cloud Storage: stores predictions