Set up a Gmail module to listen to for new emails that meet specific criteria - (sender address and subject line).
Next I need to parse this information.
The emails come through like this - All I need to do is extract the date, the amount paid and then send that info to a google sheet.
When I add a parser step, it asks me to add a regular expression and then I am out of my depth.
Once I parse out the info, I need to change the date format before I send it to Google sheets. This is how the email comes into my gmail.
---------- Forwarded message ---------
From: Airbnb email@example.com
Date: Mon, May 1, 2023 at 7:39 AM
Subject: A $27.31 payout was sent
Payout of $27.31 sent
We’ve issued you a payout of $27.31. This should arrive in your account by
May 08, 2023, taking into consideration weekends and holidays.
Airbnb Account ID