Upload HTML directly to Google Drive as Google Doc

Pull campaigns, summarize performance with Gemini, and send a clean report to Sheets.

Overview

Centralize ad metrics, let Gemini summarize key performance changes, and keep a tidy dashboard in Sheets.

Requirements

  • •Facebook Ads account with reporting access
  • •Gemini API key
  • •Google Sheets spreadsheet to write the report
Google SheetsHTTP RequestGemini

How to use

  1. 1.Pull campaign insights for the last 7 days
  2. 2.Aggregate KPIs and generate a short narrative summary
  3. 3.Write metrics and summary into a Sheets tab
  4. 4.Send a notification with the link to the report
← Back to templates