8 importable JSON files for n8n + a brief installation guide in .md format

ReportFlow: Client Report Generator for Micro-Agencies

Name: ReportFlow: Client Report Generator for Micro-Agencies
Brand: Fizoni
Price: 59 USD
Availability: InStock

Version 1.0.0 Updated: 2026-09-19 Quality: 82/100

An n8n workflow kit that pulls data from Google Analytics 4, Facebook Ads, and CRM (HubSpot), calculates metrics, generates insights via LLM, and sends white-label reports to clients on a schedule.

📁 What is inside (ZIP, 9 files)

01_ga4_daily_pull.json
02_facebook_ads_pull.json
03_crm_sync_leads.json
04_metrics_aggregator.json
05_llm_insights_generator.json
06_report_render_html.json
07_schedule_dispatch.json
08_client_onboarding.json
README.md

Problem

Micro-agencies spend 5–8 hours a month preparing reports for each client: manually exporting data from GA4 and Facebook Ads, cross-checking with the CRM, calculating CPL/CAC/ROMI, writing insights, and assembling the presentation. With 5–10 clients, that's 25–80 hours of routine work that doesn't scale and doesn't make money.

Solution

ReportFlow automates the entire cycle: scheduled data collection from GA4, Facebook Ads, and HubSpot, normalization and writing to a unified storage, metric aggregation by client_id and period, generation of text insights via LLM, rendering of a white-label HTML report with charts and tables, saving to Google Drive, and automatic delivery to clients via Email/Telegram/Slack. New clients are onboarded through a webhook form with key validation.

More details

ReportFlow is a ready-to-use system of 8 connected n8n workflows that automates client reporting for micro-agencies. Instead of spending 5–8 hours of manual work per client each month, you set up the connections once — and the system then collects data daily from Google Analytics 4, Facebook Ads, and your client's CRM (HubSpot), stores it in a single repository (Google Sheets), and aggregates it by client_id and period. Based on the aggregated metrics, an LLM module generates written insights: what grew, what declined, what anomalies appeared, where budget is being overspent, and what the action plan is for the next period. Then a white-label HTML report is rendered with the agency's branding, charts (Chart.js/QuickChart directly in HTML), tables, and a recommendations block. The finished report is saved to Google Drive as HTML, and a PDF can be generated via the browser's built-in print function. A distribution dispatcher sends reports to clients on schedule via Email (SMTP/Gmail) and/or Telegram/Slack, logging delivery and errors. New client onboarding is automated: a webhook form accepts API keys, client_id, branding, and schedule, validates connections to GA4, Facebook Ads, and HubSpot, and registers the client in the database. Each workflow can be used independently or assembled into a single pipeline. This isn't a prompt or a guide — it's working integrations that you import into your n8n and launch right away. The product is suitable for reselling to clients under your own brand: the white-label logic is separated into a dedicated rendering and onboarding configuration step.

What you get

01_ga4_daily_pull.json — daily Google Analytics 4 metrics collection via Cron, written to Google Sheets
02_facebook_ads_pull.json — daily Facebook Ads stats collection via Cron with field normalization
03_crm_sync_leads.json — sync deals and leads from HubSpot via Webhook or Cron
04_metrics_aggregator.json — aggregates GA4 + Ads + CRM by client_id and period, calculating CPL, CAC, ROMI, and funnel conversion
05_llm_insights_generator.json — generates insights, anomalies, and an action plan via LLM in JSON format
06_report_render_html.json — renders a white-label HTML report with charts, tables, and LLM outputs, saved to Google Drive
07_schedule_dispatch.json — report delivery dispatcher via Email and/or Telegram/Slack with logging
08_client_onboarding.json — client onboarding webhook form that captures keys, branding, and schedule, with connection validation

Installation guide

1. Import all 8 JSON files into your n8n (Workflows → Import from File). 2. Create accounts and get API keys: Google Analytics 4 (Service Account), Facebook Ads (Marketing API), HubSpot (Private App Token), OpenAI/Anthropic (API Key). 3. Create a Google Sheets spreadsheet with sheets for raw data and client settings, connect Google Drive for report storage. 4. Configure credentials in n8n for GA4, Facebook Ads, HubSpot, Google Sheets, Google Drive, SMTP/Gmail, Telegram/Slack. 5. Run 08_client_onboarding.json and send a test webhook with client data to validate connections. 6. Enable Cron triggers in workflows 01, 02, 03, 04, 05, 06, 07. 7. Manually verify the full cycle via Webhook in 04_metrics_aggregator.json, then switch the system to automatic mode.

Requirements

n8n (self-hosted or cloud, version 1.x+), a Google Analytics 4 account with API access, a Facebook Ads account with Marketing API access, a HubSpot account with a Private App Token, a Google account for Google Sheets and Google Drive, an OpenAI or Anthropic API key, an SMTP server or Gmail account, a Telegram bot or Slack webhook (optional). Basic skills in working with n8n and API integrations.

Options and pricing

Choose the level that suits you:

Basic — $35 · Основной набор файлов продукта.
Standard — $59 · Полный набор + инструкция по внедрению.
Extended — $94 · Всё из Стандарта + расширенные материалы и обновления.

Frequently asked questions

What is included?

An n8n workflow kit that pulls data from Google Analytics 4, Facebook Ads, and CRM (HubSpot), calculates metrics, generates insights via LLM, and sends white-label reports to clients on a schedule.

In what format will I receive the files?

After payment you get a secure link and a ZIP archive with all materials. The link is shown on the order page and available via the Telegram bot.

How long is the download link valid?

The link is active for 24 hours, up to 5 downloads.

Do I need special skills?

The product is designed for entrepreneurs and specialists. A step-by-step guide is included; no programming skills required.

Can I get a refund?

For refunds, contact support: [email protected].