Personalized emails from a sheet — AI writes, the scenario sends

The scenario takes recipients from a sheet, AI writes a personalized email for each, the scenario sends it and marks the status, and pulls replies back into the sheet.

  • Recipients and statuses live in one sheet
  • AI writes a personalized email for each person
  • Sent emails are marked automatically
  • Replies come back as a row in the sheet
Google Sheets

How it works

To move data from Brevo to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Manual Trigger - Start Email Workflow
  2. Then: Get Pending Emails from Sheet
  3. Then: AI Agent - Generate Personalized Email
  4. Then: Send Personalized Email via Gmail
  5. Then: Update Email Status to Sent
  6. Starts when: Gmail Trigger - New Email Responses
  7. Then: Get Matching Email Row by Sender
  8. Then: Update Sheet with Email Response
  9. Then: OpenAI Chat Model - GPT

You can launch this Brevo + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.