Hi! I am trying to extract a number from an email. I use the text with this code (?i)(PROPERTY\s*ID\s*[:\-]?\s*[A-Za-z0-9\-]+) and i have this output:
Output 0
Property ID: 1133
which is the required output. I used also this code (?i)PROPERTY\s*ID\s*[:\-]?\s*([A-Za-z0-9\-]+) which was giving me this output:
Output 0
1133
I have a google sheet form that in the next steps I create a zap google sheet and I configure it to search from this sheet, the required spreadsheet, worksheet, column and lookup value which the lookup value is this code and from the sheet is finds this code and extracts the info from the whole row. When I run the test everything works just fine it extracts the data but when I sent the email and triggers the zap to start it keeps failing in this step and says that
This Google Sheets step hit an error
Required field "Lookup value" (lookup_value) is missing.
Which is weird.. Can you help ?
