Hi All.
I am trying to get data from HTML into a Google Sheet. I have tried with the text parser with my test HTML. I had the sheet all set up but the data doesn’t map in as a row.
My regex seems to pull out the data I need into a bundle/bundles? Here’s my regex:
(Name|Email|Phone|Property|Arrival|Departure):\s*([^<]+)
My HTML text is:
Hello First Surname
You have received a new confirmed booking (Id: B12681234).
BOOKING (#B12681234)
Status: Booked
Arrival: Jul 07 2025
Departure: Jul 14 2025
Nights: 7
Property: My property - Name
Guests: 4 guest(s)
--------------------------------------------
QUOTE (#456784)
Status: Agreed
Guest details
Name: Jane Doe
Phone: +1676985678
Email: janedoe222@gmail.com
Country: United States
This must be easy to do but I don’t seem to find any resources to explain.