Data subject requests: searched, reported and reviewed before release

On request, the scenario searches mail and Google Drive documents, assembles a report, logs the request to the register in Microsoft Excel 365 and emails it to your officer at Microsoft Outlook.

  • Mail and document searches run at the same time
  • The report assembles itself, cover letter included
  • Every request lands in the register — deadlines stay visible
  • Nothing is released without your officer's review
WebhookOllama Model
Set it up for yourselfScriptera

How it works

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

  1. Starts when: DSAR Webhook Trigger
  2. Then: Validate and Prepare DSAR
  3. Then: Create eDiscovery Case
  4. Then: Create eDiscovery Search (All Mailboxes)
  5. Then: Trigger Statistics Estimate
  6. Then: Wait for Estimate to Complete
  7. Then: Fetch eDiscovery Statistics
  8. Check: Merge Email + SP Results
  9. Then: Aggregate and Sanitize Results
  10. Then: Generate Cover Letter (Basic LLM Chain)
  11. Then: Build GDPR Report Document
  12. Then: Convert Report to Binary
  13. Then: Archive Report to SharePoint GDPR Library
  14. Check: Merge A – SP Archive + Excel Log
  15. Check: Merge B – (SP+Excel) + DPO Email
  16. Starts when: Respond 200 Accepted
  17. Then: Log DSAR to Compliance Register
  18. Then: Notify DPO for Review (NOT Data Subject)
  19. Then: Search SharePoint + OneDrive
  20. Then: Ollama Model

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

Similar scenarios