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.

来源