Community Campaign Data Processor

Name: Community Campaign Data Processor
Rating: 1.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

49 views

0 downloads

Data Processingapicampaigncsvdata updatepostgres

Processes and updates campaign data from external sources into a PostgreSQL database.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow fetches campaign data from an external API, processes it through a code node to parse CSV-like data, and then updates or inserts this data into a PostgreSQL database. It's designed for community-contributed templates that require robust data handling and synchronization.

Key Features

Fetches campaign data from a specified API.
Parses CSV-formatted data using a code node.
Updates existing campaign records or inserts new ones into a PostgreSQL table.
Handles dynamic data mapping based on CSV headers.
Supports asynchronous processing of campaign data.

How To Use

Import this workflow into your n8n instance.
Configure the FETCH ALL CAMPAIGNS and EXTRACT CAMPAIGN DATA nodes with your API endpoints and authentication credentials.
Set up the UPDATE CAMPAIGN node with your PostgreSQL database connection details.
Ensure the input data for the Code node contains a field named 'data' with CSV-formatted campaign information.
Adjust the Code node's parsing logic if your CSV structure deviates from standard formatting.

Apps Used

api

campaign

csv

data update

postgres

Workflow JSON

{
  "id": "e5596501-2ebe-486a-b82c-c8484c4ac905",
  "name": "Community Campaign Data Processor",
  "nodes": 0,
  "category": "Data Processing",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.