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 }}
- Date:
Three lessons from building it:
- 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.
- Delete test rows before publishing, so you can tell the first real run apart from your Execute step tests.
- 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.