tr Skip to content
Data Sync & Backup · Data Ops

Email every contact in a Google Sheet on a weekly schedule

On a weekly schedule, read a Google Sheet and iterate over the rows, emailing each contact. Demonstrates the Iterator (loop) with a scheduled trigger.

ScheduleSchedule Google SheetsGoogle Sheets IteratorIterator EmailEmail
~8 min setup used by 691 sites

Free · import into FlowMattic in one click

How it works

Every step, explained

Import the template and this whole chain runs on autopilot — here's exactly what happens on each run.

Schedule → Google Sheets → Iterator
4 steps
Schedule
TRIGGER
Schedule · Every Week
This workflow runs on a schedule (Every Week) — it starts on its own at the interval and time you set in the Schedule trigger. No incoming event is needed.
Google Sheets
ACTION
Google Sheets · Get Rows
Google Sheets — retrieve rows in JSON format for use with Iterator. Data is mapped from earlier steps; connect your Google Sheets account on import.
Iterator
LOGIC
Iterator · Loop Through Array
The Iterator loops over the list from the previous step and runs the following actions once for every item in it.
Email
ACTION
Email · Send Email
Email — send an email using built-in WP mail function or custom SMTP. Data is mapped from earlier steps; connect your Email account on import.
Why this workflow

Built to own, not to rent

No-code setup

Import the JSON, connect your accounts, and go live in minutes. Every step is pre-mapped — you only add your own credentials.

Runs on your server

Self-hosted on your WordPress install. No per-task fees, no data leaving your infrastructure, no monthly SaaS bill.

Fully customizable

Open it in the visual builder and reshape it — add branches, swap apps, insert filters. A starting point, not a cage.

Ready to automate your WordPress site?

Download this workflow free, or grab FlowMattic and own every automation on your site — no per-task fees, ever.