Three simple steps from purchase to AI-powered strategy generation. No coding, no setup complexity, no learning curve. If you can use Google Sheets, you can use ZackFlow.
Every ZackFlow product follows the same simple workflow. Once you've done it once, you can do it for any product in the ecosystem:
One click to copy the dashboard to your Google Drive.
Paste your free Gemini API key into the setup wizard.
Answer questions, click Generate, get your strategy in 45 seconds.
After purchasing any ZackFlow product, you receive a link to the Google Sheets template. Here's what happens next:
Click the link provided in your purchase confirmation. This opens a Google Sheet that serves as the master template for your product. You'll see a pre-built dashboard with styled tabs, input cells, and generation buttons — all ready to go.
Click File > Make a copy in the Google Sheets menu. This creates your own personal version of the dashboard stored in your Google Drive. The copy is completely yours — you own it, control it, and can edit it however you want. The original template remains untouched.
Open the copy from your Google Drive. On first open, the built-in setup wizard will automatically appear (since no API key is connected yet). The dashboard also creates a custom ZackFlow menu in your sheet's toolbar for easy access to all features.
Time required: Approximately 1 minute. No account creation, no downloads, no installation.
The setup wizard guides you through connecting your free Gemini API key. Here's the detailed breakdown:
Go to aistudio.google.com (Google AI Studio) and sign in with your Google account. Click "Get API Key" and follow the prompts. The key is free to generate and takes about 2 minutes. The free tier allows 60 requests per minute — more than enough for any individual use.
When you open your copied dashboard for the first time, a modal dialog appears asking for your API key. Copy the key from Google AI Studio and paste it into the input field. Click "Connect" to save it.
Your API key is stored in Google's PropertiesService — an encrypted key-value store built into Apps Script. The key is never visible in sheet cells or formulas. It is only accessible by the script itself when making API calls. Your key stays private and secure.
The same Gemini API key works with every ZackFlow product. If you buy multiple dashboards, you only need to set up the key once per sheet. You don't need separate keys for different products.
Time required: Approximately 2 minutes. The API key is free and takes seconds to generate.
This is where the magic happens. Here's exactly what occurs when you generate your strategy:
Open the "Setup" or "Input" tab in your dashboard. You'll see input cells asking for your niche, target audience, goals, platforms, and other context-specific questions. Fill these in with your actual business information. The more specific you are, the more tailored and actionable your AI-generated strategy will be.
Click the generation button (usually labeled "Generate Strategy" or similar, accessible from the ZackFlow menu or a button within the sheet). Apps Script reads your inputs, constructs a carefully engineered AI prompt, and sends it to the Gemini API.
Within approximately 45 seconds, the AI processes your request and returns structured data. Apps Script then parses this data and writes it into multiple styled tabs within your sheet. You'll see content calendars, strategy frameworks, hashtag banks, tactical plans, and more — all formatted and ready to use.
Navigate through the generated tabs. Each tab contains a different component of your strategy: content calendars with specific post ideas, hashtag banks organized by category, engagement tactics, growth frameworks, and daily action checklists. Use these as your daily execution guide — no further AI interaction needed unless you want to regenerate with different inputs.
Generation time: Approximately 30-45 seconds. You can regenerate as many times as you want with different inputs.
When you click "Generate," here's the technical sequence that unfolds in those 45 seconds:
Apps Script reads your input cells
The script reads your niche, goals, platforms, and context from the designated input cells in the sheet.
Retrieves stored API key
Fetches your Gemini API key from PropertiesService (encrypted storage).
Constructs engineered prompt
Combines your inputs with a carefully crafted system prompt designed to produce structured, actionable output.
Calls Gemini API
Sends the prompt to Google's Gemini API via HTTPS. The AI processes your request and returns structured JSON data.
Parses AI response
Apps Script parses the JSON response, extracting content calendars, strategies, hashtags, and other data components.
Writes formatted results to sheet tabs
Populates multiple tabs with styled, formatted content. Each tab gets its own section of the strategy, complete with headers, tables, and conditional formatting.
Shows completion notification
A dialog box confirms generation is complete. Your strategy is ready to explore and execute.
This cannot be emphasized enough: you never need to write, read, or modify a single line of code to use any ZackFlow product.
All Apps Script logic, API integrations, and formatting rules are pre-built into the template. You interact with buttons, input cells, and menus — never with code.
If you can type into a cell, click a button, and read a spreadsheet, you can use ZackFlow. The entire interface is built inside Google Sheets — a tool you already know.
The setup wizard walks you through the API key connection step by step. There are no configuration files to edit, no command lines to run, no developer tools to install.
After 45 seconds, you have a complete, multi-tab strategy dashboard. No post-processing, no manual formatting, no additional setup. It's ready to use immediately.