How google-marketing-solutions/giga works
Project type and purpose
• This is a Google Apps Script-based web application (“webApp.html” + server-side .js files) that plugs into a Google Sheets spreadsheet.
• Purpose: Collect input keywords in the sheet, call Google’s Vertex AI (Gemini) to cluster & analyze keyword data, then write insights and campaign recommendations back into the sheet or display them via a web UI.
File structure
• Top-level:
• README, LICENSE, CONTRIBUTING, .gitignore → meta/config
• assets/logo.png → branding
• src/ → all application code and configuration
• Inside src/:
• appscript.json → Apps Script project manifest (scopes, web app settings)
• webApp.html → HTML/CSS/JS client served to user
• main.js → entry points and UI-to-server dispatch
• prompt.js → prompt construction logic for Vertex AI
• vertex.js → wrappers around Vertex AI API calls
• ideas.js, geo.js → domain logic: keyword idea retrieval, geo-specific clustering
• util.js → shared helper functions
Extract key insights from README
• Architecture implied:
User interacts via Google Sheets + embedded web app → Apps Script backend → calls Vertex AI → processes & writes back
• Dependencies: Google Workspace (Sheets), Google Cloud (Vertex AI), Google Ads (developer token)