Courses / Build an Email Nurture Sequence with Gmail, Sheets & Zapier
Lesson 2 of 8

Setting Up Google Sheets as a Contact DB

2
▶

Video by TechFryDay on YouTube · 9 min. We did not make this video and we do not host it — watching it here still counts as a view for the creator.

Create a sheet with columns: Email, First Name, Status, Sent Day 1…7. Beginners often forget to set the header row as plain text, causing Zapier to mis‑read column names. Use data validation for the Status column (e.g., Active, Unsubscribed).

In production, the sheet acts as the single source of truth. Any change – a new lead or an unsubscribe – is reflected instantly for the automation to act upon.

Start learning free

Sign in with your email, Google or GitHub. No password to remember. The same account carries your progress, your certificates and anything else you do with Nexgino later.

Sign in to continue

It takes about fifteen seconds.