Home
cd ../playbooks
Data & ReportingAdvanced

Data Pipeline Builder

Data pipeline and ETL automation - extract, transform, load workflows for data integration and analytics

10 minutes
By communitySource
#etl#data-pipeline#integration#analytics#automation

Your data lives in 5 different systems and getting it into one place for analysis means a brittle chain of manual exports, Python scripts, and cron jobs that break every other week.

Who it's for: data engineers building integration workflows, analytics teams connecting data sources, startups setting up their first data infrastructure, BI teams automating report pipelines, companies migrating from manual data processes

Example

"Build an ETL pipeline from our Stripe and HubSpot data into PostgreSQL" → Extract, transform, load workflows with scheduling, error handling, data validation, and incremental loading — based on proven n8n workflow patterns

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

Or install from your terminal:
npx ccplaybooks add data-pipeline
# Data Pipeline

Build data pipelines and ETL workflows for data integration, transformation, and analytics automation. Based on n8n's data workflow templates.

## Overview

This workflow covers:
- Data extraction from multiple sources
- Transformation and cleaning
- Loading to destinations
- Scheduling and monitoring
- Error handling and alerts

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

README.md

What This Does

Build data pipelines and ETL workflows for data integration, transformation, and analytics automation. Based on n8n's data workflow templates.


Quick Start

Step 1: Create a Project Folder

mkdir -p ~/Documents/DataPipeline

Step 2: Download the Template

Click Download above, then:

mv ~/Downloads/CLAUDE.md ~/Documents/DataPipeline/

Step 3: Start Working

cd ~/Documents/DataPipeline
claude

$Related Playbooks

Data & Reporting

Data Analysis Validator

QA-review data analysis for methodology, accuracy, and presentation before sharing

10 minutes
Intermediate
Data & Reporting

Data Context Extractor

Extract company-specific data knowledge and generate tailored analysis templates

10 minutes
Advanced
Data & Reporting

Spreadsheet Data Analyst

Analyze spreadsheet data, generate insights, create visualizations, and build reports from Excel/CSV data.

10 minutes
Intermediate
Data & Reporting

Data Extraction Assistant

Extract structured data from PDFs, Word docs, emails, and HTML using the unstructured library.

10 minutes
Advanced
Data & Reporting

Engagement Pattern Analyzer

Analyze which posts get saved vs liked vs replied to, find the patterns, and separate what your audience actually values from vanity engagement.

10 minutes
Intermediate
Data & Reporting

Eval Config

Configure content eval settings.

15 minutes
Intermediate
Data & Reporting

Eval Suite

Batch evaluate multiple content pieces.

15 minutes
Intermediate
Data & Reporting

Executive Dashboard

Design executive marketing dashboards.

15 minutes
Intermediate
Data & Reporting

Excel Automation Workflows

Automate Excel workflows including real-time control, VBA execution, and dashboard updates using xlwings.

10 minutes
Advanced
Data & Reporting

GEO Monthly Delta Report

Compare two GEO audits of the same site and generate a client progress report showing exactly what moved, by how much, and what is next

10 minutes
Intermediate
Data & Reporting

GEO Report PDF Renderer

Render a GEO audit markdown file into a styled client-ready PDF with a cover page, color-coded score tables, and severity callouts

10 minutes
Intermediate
Data & Reporting

GEO Client Report Generator

Turn AI-search audit findings into a client-ready GEO report with a weighted 0-100 readiness score and a three-tier action plan

10 minutes
Intermediate

Browse all Data & Reporting playbooks →