Auto-reply to emails from the right people, logged in a sheet

The scenario replies to emails from set senders and stacks the whole correspondence with replies as rows in a sheet — with the option to rate each reply.

  • Replies only to emails from set senders
  • An assistant writes a to-the-point reply
  • Saves the email and reply as a row in таблица
  • You can rate a reply — the rating goes to the sheet too
Google SheetsWebhook
Set it up for yourselfScriptera

How it works

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

  1. Starts when: On email received
  2. Then: Identify trigger #1
  3. Then: Configure
  4. Check: Determine which trigger ran
  5. If yes: Only continue for specific emails
  6. If yes: Generate UUID
  7. Then: Extract message content (advanced)
  8. Check: Is text within token limit?
  9. If yes: Generate reply
  10. Then: Format data
  11. Check: If no spreadsheet in configuration #1
  12. If yes: Get sheet IDs #1
  13. Check: If no sheet IDs
  14. If yes: Create spreadsheet
  15. Then: Store spreadsheet ID
  16. Then: Get data from `Format data` node
  17. Then: Paste data
  18. If no: Get data from `Format data`
  19. Then: Create or update rows
  20. Check: If spreadsheet doesn't exist
  21. If no: Store specific sheet IDs #1
  22. Check: If reply is complete
  23. If yes: Email template
  24. Then: Send reply to recipient
  25. If no: Thanks for your response!
  26. Starts when: Show HTML page
  27. Check: If no spreadsheet in configuration #2
  28. If yes: Get sheet IDs #2
  29. Then: Send feedback for fine-tuned data
  30. If no: Store specific sheet IDs #2
  31. Starts when: On feedback given
  32. Then: Identify trigger #2

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

Similar scenarios