From Gmail notifications to Google Sheets: how we measured 94 hours a year before automating anything

Hi all, sharing a simple workflow and the process around it.

We sell on eight marketplaces and were checking order notification emails six times a day, three minutes each time. Before building anything, we listed every repeating task, timed them and calculated yearly hours (times per week × minutes × 52 ÷ 60) plus a “payback ratio” (yearly hours ÷ setup hours; we skip anything under 5). The notification check alone came to about 94 hours a year.

The winner was a two-node workflow:

  • Gmail Trigger with the Search filter from:"Sender Name" and Read Status set to Unread and read emails (the default only takes unread emails, so it misses notifications you’ve already opened)
  • Google Sheets → Append row in sheet, with three expressions:
    • Date: {{ $now.format('yyyy-MM-dd HH:mm') }}
    • Subject: {{ $json.Subject }}
    • Sender: {{ $json.From }}

Three lessons from building it:

  1. Filter by sender, not subject. A subject filter also pulled in customer conversations, with names and addresses. A sender filter only brings in automatic notifications. Test the filter in Gmail’s own search box first.
  2. Delete test rows before publishing, so you can tell the first real run apart from your Execute step tests.
  3. Set an error workflow (Error Trigger → Gmail) so you hear about a broken credential before you notice the empty spreadsheet.

We wrote the whole process up as a workbook for non-technical small business owners (Build Your Own Automation). Happy to answer questions about the measuring part or the workflow itself.