metabase-pipeline

Automate marketing data ingestion from GA4, Google Ads, Facebook Ads, and PrestaShop into PostgreSQL.

1|Updated Apr 6, 2026
One-click install
npx skills add https://github.com/pkoka888/server-infra-templates --skill metabase-pipeline
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: metabase-pipeline
Source: https://github.com/pkoka888/server-infra-templates/tree/main/.agent/skills/metabase-pipeline
Command: npx skills add https://github.com/pkoka888/server-infra-templates --skill metabase-pipeline

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Automates the collection, normalization, and loading of marketing data from GA4, Google Ads, Facebook Ads, and PrestaShop into PostgreSQL to empower Metabase visualizations.

Core Features & Use Cases

  • Multi-client data synchronization from GA4, Google Ads, Facebook Ads, and PrestaShop to PostgreSQL.
  • LangGraph ETL orchestration for scalable, repeatable workflows.
  • Environment and credential safeguards with client isolation and non-secret handling.

Quick Start

Initialize a new client environment with the setup script and run the full pipeline for the chosen client.

Frequently Asked Questions about metabase-pipeline

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate marketing data ingestion from Google Ads and Facebook Ads into PostgreSQL for Metabase?

Automate marketing data ingestion into PostgreSQL by running Python-based ETL pipelines orchestrated with LangGraph, which normalize Google Ads and Facebook Ads data for Metabase visualizations. The pipelines handle multi-client data synchronization securely.

Can I isolate ETL workflows when managing Metabase data pipelines for multiple clients?

Yes, you can isolate ETL workflows for multiple clients. The pipeline applies per-client isolation to ensure secure credentials handling and repeatable deployments across different data sources like GA4, Google Ads, Facebook Ads, and PrestaShop.

What is the best way to orchestrate repeatable ETL pipelines for GA4 and PrestaShop data?

The best way to orchestrate repeatable ETL pipelines for GA4 and PrestaShop data is using LangGraph orchestration, which coordinates scalable Python-based workflows to load normalized marketing data into a PostgreSQL data warehouse.

How do I set up a new client environment for multi-client Metabase data synchronization?

To set up a new client environment for multi-client Metabase data synchronization, initialize the environment using the provided setup script, then run the full configurable ETL workflow for the chosen client.

Does this data pipeline handle credentials securely for multi-client Metabase deployments?

Yes, the data pipeline handles credentials securely for multi-client Metabase deployments. It enforces environment and credential safeguards with strict client isolation and non-secret handling throughout the ETL orchestration process.

What are the limitations of using script-driven ETL pipelines for Metabase analytics?

The script-driven ETL pipelines are limited to specific data sources: GA4, Google Ads, Facebook Ads, and PrestaShop. They require a PostgreSQL data warehouse and depend on Python-based LangGraph orchestration to execute the multi-client data workflows.