Google Sheets Edit Logging Automation

Job ID: 39883111

Budget: ₹600 – ₹1,500 INR

I have a shared Google Sheet and I need a lightweight Google Apps Script that quietly watches every edit and copies the essentials—who made the change, what was changed, and when—into a separate “Audit Log” sheet in the same file.

Key points
• The script should run automatically on every edit trigger.
• Each log entry must include the user’s email, the cell or range modified, the previous and new value (where possible), and the exact timestamp.
• An email notification should be sent to me for each logged edit, summarising the details in a clear, readable format.

Please keep the solution simple and self-contained: native Apps Script only (no external services), easy for me to maintain, and ready for hand-off within a month. A brief setup guide and commented code will be enough for documentation.