Reports from diagnosis emails — as PDF, straight to the recipients

A diagnosis email arrives — a helper pulls out the patient's details, logs them in a sheet, builds a report from your template and sends it out as a PDF.

  • Patient details pulled from the email into fields
  • Records kept in a sheet
  • The report built from your own template
  • The PDF is emailed to the right people

How it works

To move data from Gmail to Microsoft SQL automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Gmail Trigger
  2. Then: Edit Fields
  3. Then: AI Agent
  4. Then: Code
  5. Then: Append row in sheet
  6. Then: Copy file
  7. Then: Update a document1
  8. Then: HTTP Request
  9. Then: Code1
  10. Then: Send a message
  11. Then: Google Gemini Chat Model

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