Guest emails from booking to review, plus a staff report

From the bookings in your table the scenario sends guests welcomes and review requests, marks what's sent and prepares a daily report for the staff.

  • Welcomes and review requests sent on their own
  • Emails driven by the bookings in your table
  • Nothing sent is duplicated
  • A daily report for the staff
Google Sheets
Set it upScriptera

How it works

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

  1. Starts when: Schedule Trigger
  2. Then: Edit Fields
  3. Then: Get Hotel Reservation
  4. Check: Filter Upcoming Guest
  5. Check: Switch
  6. If yes: Filter Unsent Welcome Emails
  7. Then: Welcome Email
  8. Then: Mark Welcome Email as Sent
  9. If no: Filter Unsent Review Requests
  10. Then: Write Review
  11. Then: Mark Review Email as Sent
  12. Starts when: Daily at 6 AM
  13. Then: Add Information
  14. Then: Get All Reservations
  15. Check: Filter Today's Arrivals
  16. Then: Create E mail HTMl
  17. Then: Send Daily Staff Report
  18. Check: Filter Today's Departures

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

Similar scenarios