Automated Zoho Inventory to Supabase product data pipeline

Automatically syncs product data from Zoho Inventory to Supabase database with complete metadata and stock levels on a schedule.

workflowcrm

by Rahul Joshion n8n

Nodes

Triggers

Platform

n8n

Tech Stack

Supabase

How It Works

This workflow runs on a scheduled basis to fetch product data from Zoho Inventory via OAuth authentication. It retrieves complete product information including variants, SKUs, stock levels, and custom attributes, then maps and inserts each item into your Supabase database for real-time inventory management.

Authenticate with Zoho Inventory API

Establishes secure connection to Zoho Inventory using OAuth refresh token authentication to access your inventory data.

Fetch products and variants from Zoho

Retrieves complete product catalog including variants, metadata, stock levels, SKUs, and custom attributes from your Zoho Inventory.

Process and map inventory data

Splits product data into individual items and maps each field to match your Supabase table structure with proper formatting.

Insert data into Supabase database

Pushes the mapped product information row-by-row into your Supabase table, updating your database with current inventory status.

Attached Files

workflow.json