Automated weekly product promotion emails for e-commerce with Algolia and Gmail

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 for

Perfect for e-commerce store owners, marketing teams, and anyone running promotional campaigns who wants to automate their weekly newsletter without relying on expensive email marketing platforms.

How it works

1. Triggers every Sunday at 8:00 AM - Scheduled to start each new promotion week 2. Fetches discounted products - Queries your Algolia index for 6 products marked with onsale:true 3. Calculates promotion dates - Automatically generates the week's date range (Sunday to Saturday) 4. Builds HTML newsletter - Populates a responsive email template with product images, prices, and descriptions 5. Retrieves subscribers - Pulls the latest subscriber list from your Google Sheets 6. Sends personalized emails - Delivers the newsletter to all subscribers via Gmail

Set up steps

Setup time: ~15 minutes