Automated weekly product promotion emails for e-commerce with Algolia and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 21 nodes and runs on a schedule (every week at 08:00) (plus 1 other trigger). Along the way it connects Google Sheets and Gmail. It also calls q2oj96oc70-dsn.algolia.net over HTTP.
How it runs
Trigger: On a schedule (every week at 08:00) (plus 1 other trigger).
- Date range generator (low code) (Edit Fields (Set)): sets 1 field: dateRange
- Request products from Algolia (HTTP Request): calls q2oj96oc70-dsn.algolia.net (POST)
- What day are we ? (Edit Fields (Set)): sets 5 fields: Day of week, Day of the month, Month…
- Extract Discounted Products (Split Out): splits a list into separate items
- Sunday ? (If): checks a condition and branches into true / false
- Keep only useful product data (Edit Fields (Set)): sets 6 fields: name, price_eur, description…
- Output date of today (Edit Fields (Set)): sets 1 field: timestamp
- Find last Monday's date (Date & Time): formats or calculates dates
- Put back all hits in one clean array (Aggregate): combines items into one
- Clean Promo start date (Date & Time): formats or calculates dates
…plus 9 more steps. See the full node list below.
Services it uses
HTTP calls to: q2oj96oc70-dsn.algolia.net
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Date & Time
n8n-nodes-base.dateTime - Aggregate
n8n-nodes-base.aggregate - Gmail
n8n-nodes-base.gmail - HTML
n8n-nodes-base.html - Merge
n8n-nodes-base.merge
From the author
Automated Weekly Newsletter for E-commerce Promotions (based on Algolia) This workflow automatically sends a beautifully designed HTML newsletter every Sunday at 8 AM, featuring products currently on sale from your Algolia-powered e-commerce store. Who's it…