Under the hood of every ZackFlow dashboard: Google Sheets as your interface, Apps Script as the automation engine, and Gemini AI as the intelligence layer. Here's exactly how it all works together.
Every ZackFlow product follows the same four-layer architecture. This is intentional — it means once you learn one product, you can use any product in the ecosystem. The stack is designed to be self-contained, zero-dependency, and forever-usable.
Google Sheets serves as the user-facing interface for every ZackFlow dashboard. This is not a basic spreadsheet — it's a fully customized, pre-styled application with tabs, buttons, dropdowns, formatted output cells, and conditional formatting. You interact with it the same way you interact with any spreadsheet: typing into cells, clicking buttons, and reading results.
The advantage? Zero learning curve. If you can open a Google Sheet, you can use ZackFlow. No new software to download, no accounts to create, no browser extensions to install. It runs entirely inside the Google ecosystem you already have access to.
Google Apps Script is the hidden engine that powers every ZackFlow dashboard. It's a JavaScript-based scripting platform built directly into Google Workspace. When you click a "Generate" button in a ZackFlow sheet, Apps Script executes the underlying logic: it reads your input, constructs AI prompts, calls the Gemini API, processes the response, and writes formatted results back into the sheet.
Apps Script handles everything behind the scenes: menu creation, custom dialogs, API communication, data formatting, error handling, and property storage. It's the bridge between your simple spreadsheet interface and powerful AI generation.
The Gemini API is the AI model that generates all strategies, content calendars, brand frameworks, and tactical plans. When Apps Script sends a request, Gemini receives a carefully engineered prompt containing your business context, goals, and platform preferences. The AI then generates structured, actionable output tailored to your specific situation.
Gemini was chosen for its deep integration with the Google ecosystem, its strong reasoning capabilities for strategic planning, and its generous free tier that makes ZackFlow accessible to everyone. The free tier allows 60 requests per minute — more than enough for any individual or small team.
Your Gemini API key is stored securely using Google's PropertiesService — a built-in key-value storage system within Apps Script. Your key is encrypted at rest by Google, never exposed in the sheet cells, and only accessible by the script itself. You set it once during the setup wizard, and it persists across all sessions. You can also clear it at any time before sharing the sheet with collaborators.
Here's the exact data flow when you press the "Generate" button in any ZackFlow product:
This entire sequence executes in approximately 30-45 seconds. The AI processes your request, returns structured data, and Apps Script populates multiple tabs with formatted content — all automatically, with zero manual intervention from you.
This is the most common question we get. Here's why Google Sheets is the perfect foundation for AI-powered dashboards:
Over 2 billion people use Google Sheets. Your users already know the interface. No training needed.
Works in any browser on any device. No app store, no installation, no updates to manage.
Apps Script runs natively inside Sheets. No external servers, no deployment pipelines, no infrastructure to maintain.
Share your dashboard with team members. They see live results, can edit input cells, and everyone stays synchronized.
Google Sheets is completely free with a Google account. No subscription, no usage limits, no hidden costs.
Export to Excel, CSV, or PDF at any time. Your data is never locked inside a proprietary platform.
We evaluated multiple AI providers before selecting Gemini. Here's why it's the right fit for ZackFlow:
Gemini is built by Google, the same company behind Google Sheets and Apps Script. The integration is seamless — API calls are fast, authentication is straightforward, and the free tier is generous. When all three components come from the same provider, compatibility is guaranteed.
Gemini excels at multi-step reasoning, strategic planning, and structured output generation. For content calendars, brand frameworks, and workflow strategies, we need an AI that understands context, maintains consistency across multiple tabs, and produces actionable (not generic) recommendations. Gemini delivers on all three.
The free tier allows 60 requests per minute with no cost. For individual users and small teams, this is effectively unlimited. A single strategy generation uses one API call. You could generate 60 different strategies per minute on the free tier. This is what enables our "zero monthly fees" promise.
Gemini supports structured JSON output natively. This means the AI returns data in a predictable format that Apps Script can parse and write directly into sheet cells. No post-processing, no regex hacks, no manual formatting — clean data goes in, clean formatted results come out.
Every ZackFlow product includes a built-in setup wizard that runs the first time you open the sheet. Here's what it does technically:
The wizard uses SpreadsheetApp.getUi().showModalDialog() to display a styled HTML dialog where you paste your API key. Once saved, the key is stored in PropertiesService (encrypted by Google) and the custom ZackFlow menu appears in your sheet's toolbar. If you ever want to remove the key (e.g., before sharing), you can clear it from the menu — the wizard will reappear next time the sheet opens.
We take security seriously. Here's how your data and API key are protected:
Your Gemini API key is stored in Google's PropertiesService, which encrypts data at rest. The key is never visible in sheet cells, formulas, or the script editor's source code.
Your business inputs (niche, goals, target audience) are sent only to the Gemini API for processing. ZackFlow does not collect, store, or transmit any of your data to our servers — because we don't have servers.
ZackFlow doesn't require you to create an account with us. You only need a Google account (for Sheets) and a Gemini API key. No email lists, no login credentials, no tracking.
Before sharing your sheet with collaborators, use the "Clear API Key" option from the ZackFlow menu. This removes your key from PropertiesService so others cannot use your API quota. They can add their own key later.
How does the stack perform at scale? Here are the real numbers:
| Metric | Value |
|---|---|
| Strategy generation time | 30-45 seconds |
| API rate limit (free tier) | 60 requests/minute |
| Tabs per product | 10-40 tabs |
| Sheet size after generation | ~2-5 MB |
| Apps Script execution timeout | 6 minutes (platform limit) |
| Actual execution time | ~45 seconds |
| Google Sheets row limit | 10 million cells per sheet |
For context: a typical ZackFlow strategy generation uses only a fraction of these limits. The 45-second generation time is well within the 6-minute Apps Script timeout. The generated content occupies only a few hundred rows — nowhere near the 10 million cell limit. Performance is fast, reliable, and consistent.
The ZackFlow technology stack is intentionally built on platforms that are stable, widely adopted, and continuously improved by Google:
Because ZackFlow products live inside Google's ecosystem, they benefit from Google's infrastructure, security, and reliability. You don't need to worry about ZackFlow "going offline" — your dashboards run on your own Google account, on your own data, with your own API key. They work as long as Google Sheets exists.