Get Started
Back to Templates

Meta Ads Daily Report to Google Sheet and Email

Created by

Created by: Karan Kathuria || karank

Karan Kathuria

Last update

Last update 17 hours ago

Categories

Share

Description:
This template automates daily reporting for Meta (Facebook) ad campaigns. It fetches ad performance data (Spend, Results, Cost per Result, CPM) from the Meta Ads API, appends the data to a Google Sheet, and emails a summarized HTML report.

Credentials Required:

  1. Facebook Graph API: To fetch ad insights from the Meta Ads account.
  2. Google Sheets OAuth2 API: To update Google Sheets with campaign data.
  3. Gmail OAuth2 API: To email the formatted HTML report.

Instructions:

  1. Set Up Credentials - Connect the following in your n8n credentials:
  • Facebook Graph API with valid ad account access.
  • Google Sheets OAuth2 API (make sure the target sheet exists).
  • Gmail OAuth2 API for sending emails.
  1. Customize Sheet and Email
    Update:
  • Google Sheet link in the “Google Sheets” node.
  • Recipients in the “Gmail” node.
  1. Schedule
    This template runs every day at 9 AM. You can modify the timing in the Schedule Trigger node.