How we launched 10 000 personalized emails overnight

We automated the end-to-end Smartlead campaign: from raw spreadsheet to AI-powered sends, all without manual intervention.

Client

Company

year

Oct 2023

services

Frontend Development

platform

Web and Mobile

Project overview

A raw lead list in Google Sheets was turning into time-consuming email campaigns. We built a Make.com scenario that:

Filters new rows in the master sheet
Uses Gemini AI to extract core keywords from each item
Pulls search-volume & ranking data via the JungleScout API
Scores top keywords and builds personalized HTML snippets
Auto-creates and populates a Smartlead campaign for overnight delivery

‍

Execution

Sheet trigger: Watches for fresh entries in Google Sheets

AI enrichment: Gemini module extracts context-relevant keywords

Data fetch: JungleScout API calls retrieve market metrics

Snippet builder: Transform module composes custom HTML per lead

Campaign launch: Smartlead module creates and fires the campaign

‍

Project results

10 000+ unique, personalized emails sent each night

100% hands-free operation after initial setup

Significant uplift in open and reply rates without added headcount

‍

What our great customers say

I highly recommend David for any website development project. We worked together to develop a new website for our agency, and I was incredibly impressed with the entire experience.

Abdul Majeed K.

@andysmith

“Drakogn filmeon dorlerin saled tiner lorem ipsum dolor sit ametolil colonsec tetur adipiscing lectus a nunc mauris scelerisque sed egestas”

Lily Woods

@lilywoods

“Col consectetur adipiscing lectus a nunc mauris scelerisque sed egestas Lorem ipsum dolor sit ametoli drakogn filmeon dorlerin saled tiner”

Sophie Moore

@Sophiemoore



