Productivity · n8n

Automatically Log Your Daily Zendrop Order Summary to Notion Every Morning

This workflow pulls your Zendrop order data via HTTP request each morning and creates a clean daily summary page in Notion. E-commerce managers get a consolidated view of orders without manually logging into Zendrop.

difficulty Intermediatesetup 45 minresult Every morning you receive a new Notion page with the previous day's Zendrop order count, status breakdown, and timestamp — ready for your team to review.—

—

1
Step 1 — Set up the daily Schedule Trigger
Add a Schedule Trigger node. Set Trigger Interval to Days and Hour to 7 so the workflow fires every morning at 7 AM. This is the starting point of the automation.
2
Step 2 — Fetch yesterday's orders from Zendrop
Add an HTTP Request node. Set Method to GET and URL to https://api.zendrop.com/v1/orders. In the Headers section add Authorization with value Bearer YOUR_ZENDROP_API_KEY. In Query Parameters add start_date and end_date both pointing to yesterday's date using the expression {{$today.minus({days:1}).toFormat('yyyy-MM-dd')}}. Store your API key in n8n credentials or the node notes field — never hardcode it in plain text.
3
Step 3 — Summarise the order data
Add a Set node connected to the HTTP Request output. Create three fields: orderCount set to {{$json.data.length}}, reportDate set to {{$today.minus({days:1}).toFormat('yyyy-MM-dd')}}, and rawSummary set to Orders fetched: {{$json.data.length}} for {{$today.minus({days:1}).toFormat('yyyy-MM-dd')}}. This flattens the response into simple values ready for Notion.
4
Step 4 — Create a summary page in Notion
Add a Notion node. Set Operation to Create and Resource to Page. Connect your Notion account via the built-in OAuth credential. Set Parent Database ID to the ID of your Notion orders database (found in the database URL). Map the Title property to Daily Order Summary - {{$json.reportDate}} and add a Rich Text property called Summary mapped to {{$json.rawSummary}}. Add a Number property called Order Count mapped to {{$json.orderCount}}.
5
Step 5 — Test and activate
Click Execute Workflow to do a manual test run. Check your Notion database for the new page. Verify the order count and date are correct. Once confirmed, toggle the workflow to Active so the Schedule Trigger fires automatically each morning.

Frequently asked questions

Where do I find my Zendrop API key?

Log in to your Zendrop account, navigate to Settings > API, and generate or copy your API key. Paste it into the HTTP Request node's Authorization header as `Bearer YOUR_API_KEY`. Keep it private and never share it publicly.

How do I find my Notion database ID?

Open the Notion database in your browser. The database ID is the 32-character alphanumeric string in the URL between the last slash and the question mark, for example `https://notion.so/workspace/DATABASE_ID?v=...`. Copy that string and paste it into the Notion node's `Parent Database ID` field.

What if Zendrop's API returns an error or no data?

Add error handling by enabling `Continue on Fail` on the HTTP Request node. You can also add an `IF` node after the HTTP Request to check if `$json.data` exists and has items before passing data to the Set node, preventing empty pages from being created in Notion.

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.

Automatically Log Your Daily Zendrop Order Summary to Notion Every Morning

Step 1 — Set up the daily Schedule Trigger

Step 2 — Fetch yesterday's orders from Zendrop

Step 3 — Summarise the order data

Step 4 — Create a summary page in Notion

Step 5 — Test and activate

Frequently asked questions

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

Automatically Sync Zendrop Products to an Airtable Base Daily

Get Daily Zendrop Fulfillment Success Rate Alerts in MS Teams