Personalized emails to leads — drawn from their profiles

Keep leads in a table — the scenario finds each one's profile, studies it and writes a personalized email to fit the lead, then sends it from your mailbox.

  • The email reflects the specific lead's profile
  • Studies and writes for each one on the list itself
  • Sends from your mailbox
  • Removes studying profiles by hand
Set it upScriptera

How it works

To pass leads from Microsoft Excel 365 to Mailjet automatically, use a ready-made scenario — no manual copying, no lost leads.

  1. Starts when: When clicking ‘Execute workflow’
  2. Then: Get Leads
  3. Check: Loop Over Items
  4. Then: Google Search for Person LinkedIn
  5. Check: Only People Links
  6. Then: Aggregate
  7. Then: Get LinkedIn Person
  8. Check: Current Company Exists?
  9. If yes: Set Company URL
  10. Then: Get LinkedIn Company
  11. Then: Set Data
  12. Then: Generate Personalized Email
  13. Then: Gmail
  14. If no: Google Search for Company LinkedIn
  15. Check: Only Company Links
  16. Then: Aggregate1
  17. Then: Set Company URL1
  18. Then: OpenRouter Chat Model
  19. Then: Structured Output Parser

You can launch this Microsoft Excel 365 + Mailjet integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios