Student admissions with validation and email

For each application the scenario validates the data, logs the student to a sheet and sends a welcome email, replying to the applicant on any error.

  • Application data validated automatically
  • Student logged to the sheet
  • Welcome email sent at once
  • Errors returned to the applicant
Set it upScriptera

How it works

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

  1. Starts when: Trigger at Every Day 7 am
  2. Then: Read Student Data
  3. Check: Validate Application Data
  4. If yes: Process Application Data
  5. Then: Update Student Database
  6. Then: Prepare Welcome Email
  7. Then: Send email
  8. Starts when: Success Response
  9. If no: Error Response

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

Similar scenarios