Consolidate data from 5 sources for automated reporting with SQL, MongoDB & Google tools

# n8n Workflow: Consolidate Data from Multiple Sources for Automated Reporting

This n8n workflow is designed to automate the process of collecting and consolidating data from various sources, including SQL databases (Postgres, Microsoft SQL), MongoDB, and Google services (Google Sheets, Google Analytics). The consolidated data can then be used for automated reporting or further analysis.

## What it does

This workflow orchestrates the retrieval of data from five distinct sources, preparing it for a unified reporting system.

1.  **Triggers on a Schedule**: The workflow starts automatically based on a predefined schedule.
2.  **Retrieves Data from Google Sheets**: Fetches data from a specified Google Sheet.
3.  **Retrieves Data from Postgres**: Queries a PostgreSQL database to extract relevant information.
4.  **Retrieves Data from MongoDB**: Connects to a MongoDB instance to pull document data.
5.  **Retrieves Data from Microsoft SQL**: Executes a query against a Microsoft SQL Server database.
6.  **Retrieves Data from Google Analytics**: Gathers analytics data from a Google Analytics account.
7.  **Merges Data**: Combines the data retrieved from all five sources into a single, unified dataset.
8.  **Processes Consolidated Data**: A `Function` node is included, likely for custom JavaScript logic to transform, clean, or further process the merged data before it's used for reporting.
9.  **Provides Documentation**: Includes a sticky note for internal documentation or comments within the workflow.

## Prerequisites/Requirements

To use this workflow, you will need:

*   **n8n Instance**: A running n8n instance to import and execute the workflow.
*   **Google Sheets Account**: With access to the specific spreadsheet(s) you wish to query.
*   **Postgres Database**: Access credentials for a PostgreSQL database.
*   **MongoDB Instance**: Connection details for a MongoDB database.
*   **Microsoft SQL Server**: Access credentials for a Microsoft SQL Server database.
*   **Google Analytics Account**: With appropriate permissions to retrieve data.
*   **n8n Credentials**: Configured credentials for Google Sheets, Postgres, MongoDB, Microsoft SQL, and Google Analytics within your n8n instance.

## Setup/Usage

1.  **Import the Workflow**: Download the provided JSON and import it into your n8n instance.
2.  **Configure Credentials**: For each service node (Google Sheets, Postgres, MongoDB, Microsoft SQL, Google Analytics), select or create the necessary credentials. Ensure these credentials have the required permissions to access your data.
3.  **Customize Nodes**:
    *   **Schedule Trigger**: Adjust the schedule to your desired frequency for data consolidation.
    *   **Google Sheets**: Specify the Spreadsheet ID and sheet name.
    *   **Postgres, MongoDB, Microsoft SQL**: Configure the queries or collection operations to retrieve the specific data you need.
    *   **Google Analytics**: Define the view ID, date ranges, and metrics/dimensions for your analytics reports.
    *   **Function**: Modify the JavaScript code within the `Function` node to perform any custom data transformations or cleaning required for your reporting needs.
4.  **Activate the Workflow**: Once configured, activate the workflow to enable it to run on the defined schedule.

This workflow provides a robust foundation for building automated reporting pipelines by centralizing data from diverse sources.