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.

Simply register an account on Zapier.com if you do not have one already and click the ‘use this zap’ option found here. Follow the instructions and prompts to proceed.

How this integration works:

  1. A new email is received from a specified sender
  2. 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.

Read more.