Automated Weekly Product Promotion Emails for E-commerce with Algolia and Gmail

Description

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

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

Set up steps

Setup time: ~15 minutes

Connect your Algolia credentials (Search API key + Application ID)
Update the Algolia index name to match your store (currently set to dogtreats_prod_products)
Create a Google Sheet with subscriber emails (column named "Email")
Connect your Google Sheets and Gmail accounts
(Optional) Customize the HTML template colors and branding to match your store

Requirements

Algolia account with a product index containing on_sale, price_eur, original_price_eur, image, name, and description fields
Google Sheets with subscriber list
Gmail account for sending emails

How to customize

Change promotion criteria**: Modify the filter in "Request products from Algolia" node (e.g., category:shoes instead of on_sale:true)
Adjust product count**: Change hitsPerPage value (currently 6)
Modify schedule**: Update the trigger node to run on different days/times
Personalize email design**: Edit the HTML template node to match your brand colors and style
Add unsubscribe logic**: Extend the workflow to handle unsubscribe requests

💡 Pro tip: Use the manual execution button to test the workflow mid-week - it's "smart" enough to calculate the current promotion week even when not running on Sunday.