Personal outreach emails that remember your past correspondence

The scenario walks your contact list, pulls up the history with each person and prepares a personal email as a draft in your mailbox.

  • Each email accounts for your previous exchanges
  • Different recipient types get different copy
  • Language is picked per contact
  • Everything lands as a draft: you have the final say
Set this upScriptera

How it works

To connect SendGrid and Google Sheets, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: When clicking ‘Execute workflow’
  2. Then: Contacts
  3. Then: Extract from File
  4. Check: MatchingByLanguage
  5. Check: Filter
  6. Check: Loop Over Items
  7. Then: PreviousMessagesByContact
  8. Check: If
  9. If yes: ConvertToText
  10. Then: SystemPrompt
  11. Then: Basic LLM Chain
  12. Then: ProcessingOutput
  13. Then: Create a draft
  14. If no: Default
  15. Then: AutomatizationHelper
  16. Then: OpenAI Chat Model
  17. Then: Structured Output Parser
  18. Then: OpenAI Chat Model1

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

Similar scenarios