Productivity · n8n

Automatically Sync Zendrop Products to an Airtable Base Daily

Fetch your latest product catalog from Zendrop via API and upsert each product into an Airtable base automatically. Data teams stay current without any manual copy-paste work.

difficulty Intermediatesetup 45 minresult Every day your Airtable base is refreshed with up-to-date Zendrop product names, SKUs, prices, and inventory counts.—
—
  1. 1

    Schedule the daily trigger

    Add a Schedule Trigger node. Set Trigger Interval to Days and Days Between Triggers to 1. Choose a time like 06:00 AM so your Airtable is ready at the start of the workday. This node starts the workflow automatically every day.

  2. 2

    Fetch products from Zendrop API

    Add an HTTP Request node named Get Zendrop Products. Set Method to GET and URL to https://api.zendrop.com/v1/products. Under Authentication choose Header Auth and add a header Authorization with value Bearer YOUR_ZENDROP_API_KEY. Add a query parameter limit set to 100 to page through results. Store your API key in an n8n credential for security.

  3. 3

    Extract the products array

    Add a Set node named Extract Products. Enable Keep Only Set and create one field: set products to the expression {{ $json.data }} (adjust the key to match Zendrop's actual response envelope). This isolates the array of product objects for the next step.

  4. 4

    Split products into individual items

    Add a Split In Batches node named Loop Products. Set Batch Size to 1. Connect it after Extract Products. This iterates over each product object one at a time so the Airtable node can process them individually without hitting rate limits.

  5. 5

    Upsert each product into Airtable

    Add an Airtable node named Upsert to Airtable. Set Operation to Upsert. Select your Base ID and Table Name (e.g. Products). Map fields: Name to {{ $json.name }}, SKU to {{ $json.sku }}, Price to {{ $json.price }}, Inventory to {{ $json.inventory_count }}. Set Fields to Match On to SKU so existing records update instead of duplicating. Connect your Airtable credential under Credential.

Frequently asked questions

What if Zendrop returns more than 100 products?

Add pagination logic by checking a `next_page` or `cursor` field in the API response and looping the HTTP Request node with an updated offset parameter. For most small catalogs the single 100-item request is sufficient.

How do I find my Zendrop API key?

Log in to your Zendrop account, navigate to Settings > Integrations or Developer Settings, and generate or copy your API key. Paste it into n8n's Header Auth credential field.

Will this overwrite product data I manually added in Airtable?

Only the mapped fields (Name, SKU, Price, Inventory) will be overwritten on matched records. Any extra columns you maintain manually in Airtable are left untouched by the upsert operation.

Related recipes
Free recipe
Google DriveGoogle Drive
Google Driven8n
—

Automatically Back Up Every Zoom Recording to Google Drive the Moment It Finishes

When a Zoom cloud recording is completed, this workflow instantly uploads the recording file to a designated Google Drive folder. Consultants never lose a client session recording again.

Intermediate · 45 min setup
Free recipe
n8nn8n
n8n
—

Get Daily Zendrop Fulfillment Success Rate Alerts in MS Teams

Automatically pull your Zendrop order fulfillment stats every day and post a clear success rate summary directly into a Microsoft Teams channel. Keep your entire team informed without logging into Zendrop manually.

Intermediate · 40 min setup
Free recipe
n8nn8n
n8n
—

Automatically Celebrate in Slack Every Time a Trello Card Moves to Done

When a Trello card is moved to your Done list, this workflow instantly posts a fun celebration message in a Slack channel so the whole team can cheer together. No manual updates needed — every win gets recognized automatically.

Beginner · 30 min setup
About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.