n8n Workflow: Facebook Ads Reporting Automation with Google Sheets

This n8n workflow automates the process of fetching Facebook Ads data and storing it in a Google Sheet. It's designed to regularly pull performance metrics from the Facebook Graph API and update a spreadsheet, simplifying your reporting tasks.

What it does

This workflow performs the following key steps:

1. Triggers on a Schedule: The workflow starts automatically at predefined intervals (e.g., daily, weekly) to ensure regular data updates.
2. Fetches Facebook Ads Data: It makes a request to the Facebook Graph API to retrieve ad campaign performance data.
3. Processes Data (Code Node): A Code node is used to transform and prepare the fetched data, likely extracting relevant metrics and formatting them for Google Sheets.
4. Checks for Data (If Node): It checks if any data was successfully retrieved from the Facebook Graph API.
5. Aggregates Data (Aggregate Node): If data is present, it aggregates the processed data, potentially combining multiple ad entries into a single structure suitable for a spreadsheet row.
6. Writes to Google Sheets: The aggregated data is then appended as new rows to a specified Google Sheet.
7. Merges Paths: The workflow uses a Merge node to combine the execution paths after the conditional check, ensuring the workflow completes gracefully whether data was found or not.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Facebook Graph API Credentials: An Access Token and potentially an App ID/Secret for a Facebook application with permissions to access your Facebook Ads data. This will need to be configured as a credential in n8n for the "Facebook Graph API" node.
• Google Sheets Account: A Google account with access to Google Sheets. This will need to be configured as a credential in n8n for the "Google Sheets" node.
• Google Sheet: A target Google Sheet where the ad reports will be written. You'll need to specify the Spreadsheet ID and Sheet Name in the "Google Sheets" node.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button (usually a curly brace icon {}).
   • Paste the JSON code and click "Import".
2. Configure Credentials:
   • Locate the "Facebook Graph API" node and click on it.
   • Under "Credentials", select an existing Facebook Graph API credential or click "Create New" to set up a new one. Follow the prompts to authenticate with your Facebook account and grant necessary permissions.
   • Locate the "Google Sheets" node and click on it.
   • Under "Credentials", select an existing Google Sheets credential or click "Create New" to set up a new one. Authenticate with your Google account and grant permissions to access Google Sheets.
3. Configure Nodes:
   • Facebook Graph API Node:
     • Ensure the "Resource" and "Operation" are correctly set to fetch the desired ad data (e.g., Ads or Ad Accounts with an Ad Campaigns operation).
     • Specify any necessary parameters like ad_account_id, fields (e.g., campaign_name, spend, impressions, clicks), and date_preset or time_range.
   • Code Node: Review the JavaScript code within this node. It's responsible for transforming the raw Facebook API response into a format suitable for Google Sheets. Adjust it if your desired output format differs.
   • Google Sheets Node:
     • Set the "Operation" to Append Row.
     • Enter the "Spreadsheet ID" of your target Google Sheet.
     • Enter the "Sheet Name" where the data should be appended.
4. Activate the Workflow:
   • Once all credentials and node configurations are complete, click the "Activate" toggle in the top right corner of the n8n editor to enable the workflow.
5. Monitor:
   • You can monitor the workflow's executions in the "Executions" tab to ensure it's running as expected and data is being written to your Google Sheet.

This workflow provides a robust foundation for automating your Facebook Ads reporting, saving time and ensuring consistent data collection.