Skip to content
FlowHub
FluxonLab
Google Sheets
Ecommerce & Ordersfree

Nov - Workflow sending weekly promos for Algolia-based e-commerce (No AI)

by Emir BelkahiaUpdated Aug 2026
RequiresGoogle SheetsGoogle SheetsGmailGmail
Share Post Share
Get row(s) in sheetGet row(s) in s…HRRequest products from AlgoliaRequest product…SOExtract Discounted ProductsExtract Discoun…ScOn sundays 8.00 amOn sundays 8.00…SeWhat day are we ?What day are we…IfSunday ?SeDate range generator (low code)Date range gene…ScTest trigger for low-code branchTest trigger fo…SeOutput date of todayOutput date of …DTCalculate end of rangeCalculate end o…SeOutput Promo Validity Date RangeOutput Promo Va…DTFind last Monday's dateFind last Monda…DTFind last Sunday's dateFind last Sunda…DTClean Promo start dateClean Promo sta…DTClean Promo end dateClean Promo end…AgPut back all hits in one clean arrayPut back all hi…Send newsletterHtNewsletter Generation (HTML Format)Newsletter Gene…MeMerge data for newsletterMerge data for …AgAggregate data for NewsletterAggregate data …SeKeep only useful product dataKeep only usefu…1234567891011121314151617181920
1/5
FLOWS
STEPS · 20
Runs on a schedule

On a weekly schedule, fetches Algolia product data from Google Sheets, builds an HTML promo email, and sends it via Gmail.

Tags

cronadvancedGoogle SheetsGmailSocial Mediadiscoveredpending-review
Connects
sheetsGoogle SheetsgmailGmail
CategoryEcommerce & Orders
Triggercron
Complexityadvanced
Nodes21
AddedJun 27, 2026