Build an Email Nurture Sequence with Gmail, Sheets & Zapier

Create a week‑long drip campaign using free Google tools and Zapier

8 lessons about 6 hours beginner

Build an Email Nurture Sequence with Gmail, Sheets & Zapier

This short course is for Indian students and career‑switchers who want a practical, job‑ready automation skill. You'll learn to connect Gmail, Google Sheets, and Zapier to build a fully automated email nurture sequence.

By the end of the week you will have a working drip campaign that sends personalized emails each day for seven days, tracks responses in a sheet, and updates contacts automatically.

After completing the course you’ll be able to design, implement, and troubleshoot similar automation workflows for startups, agencies, or any small business that relies on email marketing.

What you will work through

1 Understanding the Nurture Flow Alex Cattoni · 15 min 2 Setting Up Google Sheets as a Contact DB TechFryDay · 9 min 3 Creating a Gmail Draft Template Jeff Su · 7 min 4 Zapier Basics: Trigger from Google Sheets Masters of AI & Automation · 17 min 5 Project: Build Day‑1 Email Automation All About AI · 4 min 6 Logging Opens & Clicks with Gmail Filters Leila Gharani · 7 min 7 Project: Complete 7‑Day Sequence with Loops Kevin Mogavero · 16 min 8 Review, Optimize & Deploy Zapier · 36 min

Final project 7‑Day Email Nurture Workflow Unlocks after all 8 lessons 0 of 8 lessons passed Locked

Final project

7‑Day Email Nurture Workflow

Submit a public link Checked by a reviewer Unlimited attempts

Create a complete nurture sequence that:

Sends a daily email to a list of contacts stored in Google Sheets.
Personalises each email with the recipient’s name.
Logs each sent email and open status back to the sheet.
Handles unsubscribes via a Zapier webhook.
Includes a simple landing page link (e.g., Bitly) in the emails.

Submit: a public Zapier workflow link (or exported JSON) and the Google Sheet (view‑only link).

Reviewer checklist:

Correct trigger from Google Sheets on new row.
Email content uses dynamic fields.
Delay steps create a 1‑day interval.
Open‑tracking updates sheet accurately.
Unsubscribe webhook removes contact from the list.
Workflow runs without errors for at least two contacts.

Sign in to take partYour progress and project are saved to your account.

The teaching videos are made by independent creators and play from YouTube, with the creator credited on every lesson. Nexgino builds the path, the notes, the project and the certificate.

8 lessons · free Start free