Implementation Notes: Building a Personal Blog Operations Dashboard with Streamlit and the Gemini API
Notes from building a single-pane operations dashboard that unifies Google Search Console and GA4 data with Gemini 2.5 Flash-powered quality scoring, after burning out on switching between 12 browser tabs across six sites every morning. Includes the full Streamlit implementation and weekly low-quality detection job.
Google Looker Studio × Gemini API: Automate Business Report Analysis with AI
Connect Looker Studio with the Gemini API to auto-generate AI insights on reports. Includes Apps Script code, daily trigger setup, and troubleshooting tips.
Gemini API × BigQuery: AI-Powered Data Analysis — From Natural Language Queries to Actionable Insights
Learn how to combine Gemini API with BigQuery for natural language data analysis. Covers SQL auto-generation, result summarization, and production-ready patterns with practical Python code examples.
Building an Autonomous Data Analysis Agent with Gemini 3 Pro and LangGraph
Learn how to build a multi-step data analysis agent that autonomously handles CSV parsing, visualization, and report generation using Gemini 3 Pro and LangGraph, with complete code examples.
Build an AI Data Analysis Agent with Gemini API — Combining Code Execution, Function Calling, and Structured Output
Learn how to build a production-ready AI data analysis agent in Python that combines Gemini API's Code Execution, Function Calling, and Structured Output to automatically analyze CSV/Excel data, generate visualizations, and produce structured reports.