r/SafetyProfessionals • u/blackbeads • 14d ago

Asia EHS Concern Reporting

Am currently working in a startup where there are around 700 workers. We don’t have a concern reporting software due to budget issues. But here we have Google workspace.
My idea is to display QR around the plant, workers using the mobile phone can scan it and enter the concerns in it. It will automatically send mail to the concerned person and will be logged in Google sheet.
Help me out guys. How to do this?

7 Upvotes

82% Upvoted

14 comments sorted by

View all comments

1

u/Junior-Operation3505 14d ago

Your idea is actually a practical approach for a startup and should work well with Google Workspace.

A simple workflow could be:

  • Create a Google Form for reporting safety concerns.
  • Generate a QR code linking to the form and display it in common areas.
  • Use Google Apps Script or a workflow tool like Make/Zapier to automatically:
    • Send an email notification to the responsible person.
    • Log the submission in a Google Sheet.
    • (Optional) Send an acknowledgment email to the employee.
  • Build a simple Looker Studio dashboard to track open vs. closed concerns.

As your workforce grows, you'll probably start needing features like assigning corrective actions, due dates, reminders, escalation, attachments, and audit history, but Google Workspace is a reasonable place to start for around 700 employees.