Daily Ads Performance Reporting to Notion & Sheets - n8n Workflow

• Marketing teams needing centralized, daily reporting of paid media performance.


• Data analysts who spend excessive time manually merging API data.


• Users looking for advanced examples of parallel data retrieval and merging using an n8n node structure.


• Organizations utilizing n8n templates to streamline marketing operations and reporting.

Manual extraction and consolidation of Google Ads data is time-consuming and prone to human error. This specialized n8n workflow solves this by providing a reliable, automated pipeline that runs daily. The n8n automation extracts two crucial sets of data—top-of-funnel metrics (clicks, impressions, cost) and bottom-of-funnel metrics (conversions)—via parallel HTTP requests using Google Ads Query Language (GAQL).

This robust n8n workflow then merges the data on a campaign level and generates an aggregated daily summary. By utilizing the Notion and Google Sheets n8n node, all performance data is automatically pushed into designated databases and spreadsheets, ensuring marketing stakeholders always have access to the latest performance numbers without needing to touch the Google Ads interface. This is a critical n8n template for any performance marketing team.

The entire process is initiated by the n8n trigger, specifically a Schedule Trigger set to run every day at 08:00 AM.

1. Date Setting: A Set n8n node calculates and defines the yesterday date variable, which is crucial for defining the reporting window in the subsequent API queries.


2. Parallel Data Fetching: The n8n workflow splits into two parallel branches, both using the HTTP Request n8n node to hit the Google Ads API's googleAds:search endpoint. One branch fetches click/cost data, and the other fetches conversion data.


3. Splitting Results: Two Code n8n node instances (Split Click2 and Split Conversion2) parse the array of results returned by the API, turning each campaign's record into a separate item for further processing.


4. Data Unification: The Merge n8n node then combines the click stream (Input 1) and the conversion stream (Input 2) based on two common identifiers: campaign.id and segments.date. This results in a single, comprehensive item for each campaign.


5. Campaign Logging: The merged data is simultaneously sent to a Notion n8n node (Campaign Tracker) and a Google Sheets n8n node (Campaign Daily Report).


6. Daily Aggregation: The Daily Recap2 Code n8n node processes all merged items, calculating totals for clicks, impressions, conversions, and cost, generating a concise summary object.


7. Summary Reporting: The final summary data is stored in a separate Notion database (Daily Summary) and appended to a second Google Sheets tab (Summary Report). This complete process ensures data consistency across all platforms, driven entirely by the n8n automation.

To deploy this powerful n8n workflow, follow these setup steps:

1. Import the n8n Templates: Import the provided JSON code into your n8n instance.


2. Schedule Setup: Verify the Schedule Trigger is set for your desired daily time (default is 08:00 AM).


3. Google Ads Credentials: You must have a Google Ads developer account. Configure a Google Ads OAuth2 API credential in n8n, ensuring you input the developer-token, login-customer-id, and your specific customer ID in the HTTP Request URLs ({{YOURCUSTOMERID}}).


4. Notion Database Preparation: Create two Notion databases:

1. Google Sheets Preparation: Create a Google Sheet with two tabs (Campaign Daily Report and Summary Report) and ensure column headers match the fields being passed by the n8n node structure. Set up your Google Sheets OAuth2 credential and update the Document ID and Sheet Names in the respective Google Sheets n8n nodes.

Schedule Trigger (n8n trigger): The starting point for the n8n workflow, set to run once daily at 08:00.
Set Yesterday Date2 (Set n8n node): Dynamically calculates the reporting date using {{ $now.minus({ days: 1 }).toFormat('yyyy-MM-dd') }} for accurate API querying.
G-Ads Query Click / G-Ads Query Conversion (HTTP Request n8n node): Sends POST requests using GAQL to fetch daily metrics. Requires Google Ads API credentials and uses expression variables for the customer ID and date.
Split Click2 / Split Conversion2 (Code n8n node): Uses JavaScript to transform the single API response item containing an array of results into multiple individual items, enabling parallel processing per campaign.
Merge2 (Merge n8n node): Crucial for combining disparate datasets. It joins the click stream and conversion stream based on matching campaign.id and segments.date values (Enrich Input 1 mode).
Notion1 / Notion2 (Notion n8n node): Writes campaign-level data and aggregated summary data to distinct Notion databases, centralizing reporting.
Daily Recap2 (Code n8n node): Performs complex aggregation logic, totaling clicks, impressions, cost (micros converted to currency), and conversions, before grouping unique conversion types into a single item for summary reporting.
Google Sheets10 / Google Sheets11 (Google Sheets n8n node): Appends both campaign-level and aggregated daily summary data to the corresponding tabs within the target spreadsheet.