Google Workspace Studio Tutorial: Batch Lead Outreach with the "Repeat for each" Loop

Описание и применение

Автоматизация рассылки персонализированных писем новым лидам с помощью Google Workspace Studio, Gemini и Gmail, уменьшая ручную работу с 45–60 минут до автоматического выполнения каждый рабочий день.

Задача

Manual daily follow‑up email drafting for 15–20 new leads consumes 45–60 minutes of copy‑paste work.

Результат

The flow automates lead outreach, reducing manual effort from 45–60 minutes to a few minutes of setup and daily trigger execution, while ensuring each lead receives a personalized email and is logged and marked as Contacted.

Рабочий процесс

• Schedule trigger runs every weekday at 9:00 AM
• Get sheet contents filtering rows where Status = New
• Repeat for each over the filtered rows
• Ask Gemini to draft a personalized email body
• Draft a Gmail email with a fixed subject template
• Add a row to the Outreach Log tab with draft details
• Update the lead’s Status to Contacted
• Post a summary message to Google Chat

Доказательства

Every weekday morning, our agent will read the tracker, pick out only the New leads, draft a personalized email for each one using Gemini, log every draft, mark the lead as contacted so it never gets double-emailed, and post a summary to the sales team's Chat space.

Источник

Get sheet contents step pulls rows from a sheet that match a condition you set.

Источник