Daily Meta Ads Performance Reporting to Sheets - n8n Workflow

• Digital marketing analysts who need automated daily reports on campaign performance.


• Agencies managing multiple Meta Ads accounts requiring centralized data storage.


• Data engineers looking for proven n8n templates for advertising data ingestion.


• Users seeking an automated way to combine data fetched by an n8n node into standardized reports.

Manually logging daily advertising performance is tedious and error-prone. This n8n workflow solves this problem by providing a fully automated, scheduled solution for extracting comprehensive Meta Ads insights and transforming them into organized spreadsheet data.

This specific n8n workflow runs daily, fetches metrics from the previous day, and intelligently separates the data into general performance stats (like impressions and spend), non-monetary actions (like comments and shares), and critical monetary actions (like purchases or revenue). By using this n8n template, you ensure your data logging is timely, accurate, and structured, greatly enhancing your reporting capabilities within Google Sheets. This is a crucial automation for any marketing operation built on the n8n platform.

This automation is initiated by a scheduled n8n trigger.

1. Trigger: The n8n workflow is configured to run daily at 3:00 AM using a Schedule Trigger (or can be run manually for testing).


2. Data Extraction: The flow executes a Facebook Graph API n8n node ('Ad insights from yesterday') to pull all performance metrics from the previous day.


3. General Metrics Handling: The data is split and the general performance metrics (impressions, clicks, spend) are immediately sent to the Google Sheets n8n node ('Add General Metrics') for logging.


4. Actions Splitting: The actions array within the insights data (which contains conversion events) is isolated and split into individual records.


5. Action Categorization: Multiple Filter n8n node steps ('filter by action type' and 'Only monetary actions') process the action records, separating them into two streams: non-monetary and monetary conversions.


6. Non-Monetary Logging: Non-monetary actions are logged using a dedicated Google Sheets n8n node ('Add Non-Monetary actions').


7. Monetary Logging: Monetary actions are filtered again and logged using the final Google Sheets n8n node ('Add Monetary actions').

This robust n8n workflow ensures all relevant Meta Ads data is accurately categorized and stored across various designated sheets.

To set up this powerful n8n workflow, follow these steps:

1. Import: Copy the provided JSON and import it directly into your n8n instance using the 'New' button and selecting 'Import from JSON'.


2. Meta/Facebook Credentials: Locate the 'Ad insights from yesterday' n8n node. You must create or select a valid Facebook/Meta Ads credential that has permissions to read the relevant Ad Account data.


3. Google Sheets Credentials: Configure the three Google Sheets n8n node steps ('Add General Metrics', 'Add Non-Monetary actions', 'Add Monetary actions'). You will need to provide valid Google Sheets credentials.


4. Sheet Configuration: In each Google Sheets n8n node, specify the Spreadsheet ID and the exact Sheet Name where you wish to append the data. Ensure the headers in your target sheets match the data keys output by the Facebook Graph API n8n node.


5. Activation: Once all credentials and sheet details are correctly set, activate the n8n workflow to allow the Schedule n8n trigger to run daily.

Schedule Trigger (Everyday at 3am): This is the core n8n trigger, initiating the daily data synchronization process.
Facebook Graph API (Ad insights from yesterday): This crucial n8n node fetches all performance data for the previous 24 hours from the configured Meta Ad Account. Key configuration involves selecting the correct account and date range presets.
Split Out (data column only & split actions): These n8n nodes are used for data transformation, ensuring that multi-record outputs or nested arrays (like 'actions') are broken down into individual, processable items before filtering.
Filter (Only monetary actions & filter by action type): These n8n node steps apply logical conditions to separate conversion events based on whether they involve a monetary value (e.g., purchases) or are non-monetary interactions (e.g., link clicks).

• Google Sheets (Add General Metrics, Add Non-Monetary actions, Add Monetary actions): These three Google Sheets n8n node steps are responsible for the final output. They append the categorized data streams into specific rows within the designated Google Sheets spreadsheet. Each node uses the 'Append' operation.