Icon

BAPA01 Ingest Gemini to Bronze

☝️ ENTER YOUR BRAND QUESTIONS HERE (e.g. "Which are the top microbreweries in Toronto?")

👇 ADD ADDITIONAL LLMS by coping this Gemini example workflow and modifying the four nodes below for Claude, ChatGPT, Perplexity, Copilot or other LLMs.

☝️ CONFIGURE BIGQUERY by adding your credentials here. Creates a bronze landing table with these columns, which supports multiple LLMs.

Google AI Studio Authenticator
Gemini LLM Selector
Capture the LLM Used (e.g. gemini-flash-latest)
Variable to Table Column
Credentials Configuration
LLM Prompter
Enter brand search prompts here
Table Creator
Google Authenticator
Set Source as "BAPA"
Expression
Create Event Timestamp
Expression
Column Filter
Google BigQuery Connector
Create Run ID
Expression
Create Bronze Tableif Missing
DB Table Creator
Random Numbers Generator
Column Resorter
Combine Run ID with LLM Prompt Response
Cross Joiner
Append to BigQueryBronze Table
DB Loader

Nodes

Extensions

Links