Estimating a Sheets-Driven Gemini Bill Across the Year-End Price Switch with Apps Script
If you call the Gemini API from a spreadsheet, log the token counts per call and estimate the month in two columns: the intro price that ends on December 31, 2026 and the standard price from January 1, 2027. Apps Script, with real output.
When the Sheets AI Function Won't Generate, Suspect the File's Location Before the Limit
If Generate and insert stays greyed out in Google Sheets, don't assume you hit the 24-hour cap. Spreadsheets opened through Dropbox, Box or Egnyte can't generate at all. Here's the order I check things in now.
Sheets canvas Takes the Entry Point, Not the Execution Boundary
With Sheets canvas available, how much of your hand-built Apps Script can you actually retire? Sorting the answer by execution boundary, with the decision rules and a classifier script that does the inventory for you.
Fill with Gemini Now Speaks 28 Languages — Localize Your App Store Copy in One Sheet
Fill with Gemini in Google Sheets expanded to 28 languages. Here is a practical workflow for localizing app store metadata as a solo developer, plus the review habits that keep machine translation from going live unchecked.
Google Sheets API × Gemini API: A Python Data Pipeline — No Apps Script Required
Learn how to build a fully Python-based pipeline that reads data from Google Sheets, processes it with Gemini API, and writes results back — without touching Apps Script. Covers service account auth, structured output, and rate limit handling.
Using Gemini in Sheets' One-Click Formula Fix Without Trusting It Blindly
Gemini in Sheets can now diagnose and fix formula errors in one click. It's genuinely fast, but it can also produce 'quiet fixes' that parse cleanly yet return the wrong value. Here is a short verification habit to use it with confidence.
Google Workspace × Gemini API Automation: Production Notes on 12 Apps Script Patterns
12 Gemini API + Apps Script patterns for Gmail, Docs, Sheets, and Calendar automation—plus the production snags I hit running this across four sites and an app support inbox: swallowed 429s, JSON code fences, the 6-minute cap, and flash-vs-pro routing, with measured numbers.