Personalized offer letters with candidate response tracking

A new row in the sheet, and the scenario builds the personalized offer, turns it into a PDF, emails the candidate, and records their answer back in the sheet.

  • The offer goes out the day you decide, not three days later
  • The PDF is built from your template automatically
  • The candidate's answer is captured without email ping-pong
  • Accepted / declined / no reply — all in one sheet
Google SheetsWebhook
Set it up for yourselfScriptera

How it works

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

  1. Starts when: Google Sheets Trigger
  2. Check: If4
  3. If yes: Copy Template1
  4. Then: Update a offer letter1
  5. Then: Document to PDF1
  6. Then: Save PDF to drive1
  7. Then: Assign Sharing Rights1
  8. Then: Send a message1
  9. Then: Update status in sheet1
  10. Starts when: Webhook1
  11. Then: Get row(s) in sheet2
  12. Check: Check Response is Locked?1
  13. If no: Code in JavaScript3
  14. Check: Switch1
  15. If yes: Update Status to Accepted1
  16. Then: Ack. Candidate1
  17. Then: Ack. Hr1
  18. If no: Update Status to Rejected1
  19. Then: Thank you to Candidate2
  20. If no: Update Status Timeout1
  21. Then: Thank you to Candidate3

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

Similar scenarios