I was applying for a customer support role at Zapier when i got this question, of course i had to document it, for those searching for this answer.
How this integration works:
- A new email is received from a specified sender
- Zapier adds new rows in Google Sheets.
Please note it will log new mails, not old mails that have been received before enabling this option.