← Back to work
BackendBackend only

Anonymous Survey Email Distribution

Excel → unique links → bulk email, without tying answers to identity.

What they needed

An existing dashboard/scanner portal needed one module: upload employee Excel data, mint unique encrypted survey links, send at scale, and track completion without linking a person to their answers. IT also needed SPF/DKIM/DMARC guidance.

What I delivered

  • Excel column mapping for email, stream, function, department, location, age, gender
  • Unique encrypted URL generation against the existing scanner link
  • SendGrid / AWS SES path for 1,000+ sends
  • Completion tracking with anonymity constraints; DNS/auth records for deliverability
  • Security architecture review notes for the client’s IT team

Why it helped

Surveys go out in bulk with trackable completion, while answer anonymity and mailbox deliverability stay first-class.

Tech in the build

Custom backend workflowExcel ingestSendGrid / AWS SESDNS auth records

Access

Backend module for an existing private dashboard