Parsing Information from specific Gmails using Make

How To
1

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.

TIA !

---------- Forwarded message ---------
From: Airbnb express@airbnb.com
Date: Mon, May 1, 2023 at 7:39 AM
Subject: A $27.31 payout was sent
To: <info@******t.mx>

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

462516

*Payout ID

G-NXIK5FSIPU2MC

2

This won’t be as helpful as you hope because I also know nothing about regular expression, but you might want to look into Fivrr or some other freelance option if you don’t get the help you need in the forums.

I’d guess this is pretty easy for someone who knows regular expression, so you might not have to invest much to get the outcome you want.

Good luck!

1 Like