backend Articles | Zoe.log()

backend

Setting Up Analytics with BigQuery and Looker Studio

Adding structured logging Python Slack bot, stream logs to BigQuery, and visualize usage with Looker Studio dashboards.

Slack Bot Troubleshooting: Duplicate Messages, Cold Starts, and Gemini Latency

Fixing Slack retry duplicates with event deduplication, eliminating Cloud Run cold starts with min-instances, and dealing with cross-region Gemini API latency.

PythonGCPSlack

Adding GCS Memory to Gemini: Teaching Your Bot with Markdown Files

10 min read

How I integrated Google Cloud Storage as a knowledge base for Gemini, allowing the bot to answer questions from markdown documentation without redeploying.

PythonFlaskGCSVertex AI

Integrating BigQuery with Node.js - From Google Sheets to Scalable Data Fetching

8 min read

How I migrated from Google Sheets to BigQuery for analytics data in a Node.js application, including authentication, querying, and build-time data generation.

Node.jsBigQuery

Solving Google Sheets Timeout Issues with Build-Time Static JSON Generation

5 min read

How I eliminated Google Sheets API timeout errors by generating static JSON files at build time instead of fetching data at runtime.

Node.jsGoogle Sheets API