Automated Zoho Inventory to Supabase Product Data Pipeline

This n8n workflow automates the extraction of product data from Zoho Inventory and its subsequent storage into a Supabase database. It simplifies the process of keeping your Supabase product data synchronized with Zoho Inventory, ensuring your product information is always up-to-date in your database.

What it does

1. Schedules Data Sync: The workflow is triggered on a predefined schedule (e.g., daily, hourly) to initiate the data synchronization process.
2. Fetches Zoho Inventory Data: It makes an HTTP request to an external API, presumably the Zoho Inventory API, to retrieve product-related data.
3. Processes Retrieved Data: The data obtained from Zoho Inventory is then processed, likely to extract individual product records from a potentially nested or array structure.
4. Inserts into Supabase: Finally, each processed product record is inserted or updated into a specified table within your Supabase database.

Prerequisites/Requirements

• Zoho Inventory Account: Access to your Zoho Inventory account with API access enabled.
• Zoho Inventory API Credentials: API keys or access tokens required to authenticate with the Zoho Inventory API.
• Supabase Account: A Supabase project with a database configured to store product information.
• Supabase API Key: An API key for your Supabase project with appropriate permissions (e.g., anon key or a service role key).
• Supabase Project URL: The URL of your Supabase project.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file for this workflow.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • HTTP Request Node (Zoho Inventory):
     • Edit the "HTTP Request" node.
     • Configure the URL to point to your Zoho Inventory API endpoint for fetching product data.
     • Set up the appropriate authentication method (e.g., Bearer Token, API Key in headers) using your Zoho Inventory API credentials.
     • Adjust any query parameters or body content as needed for your specific Zoho Inventory API call.
   • Supabase Node:
     • Edit the "Supabase" node.
     • Create a new Supabase credential if you haven't already.
     • Enter your Supabase "Project URL" and "API Key".
     • Configure the "Operation" (e.g., "Insert", "Upsert") and the "Table Name" where you want to store your product data.
     • Map the incoming data from the previous node to the correct columns in your Supabase table.
3. Configure Schedule Trigger:
   • Edit the "Schedule Trigger" node.
   • Set your desired interval for the workflow to run (e.g., every day, every hour).
4. Activate the Workflow:
   • Once all credentials and configurations are set, save the workflow.
   • Toggle the "Active" switch in the top right corner to enable the workflow.

The workflow will now run automatically based on your defined schedule, pulling product data from Zoho Inventory and pushing it to your Supabase database.