I am attempting to seize customer information from an email and send it to my Google Sheet. My Text Parser module is not receiving Location Suburb that is supposed to be displayed in $5, therefore it cannot be placed in my Google Sheet. To add context I am sending the customer a Google Calendar link, once they have accepted, I receive a confirmation email which my Gmail Search Emails module scans. The workflow is able to extract every bit of information and add a row in my Google Sheet except for the location. Can anybody please help me solve this issue?
Welcome to the Make Community!
When reaching out for assistance with extracting text, it would be super helpful if you could share the actual text you’re trying to match. Screenshots of text can be a bit tricky, so if you could copy and paste the text directly here, that would be awesome! It ensures we can run it against test patterns effectively. If there’s any sensitive info, feel free to change it to something fictional yet still valid by keeping the format intact.
Providing clear text examples saves time on both ends and helps us give you the best possible solution. Without proper examples, we might end up playing a guessing game, and nobody wants that as it is a waste of time! You are more likely to get a correct answer faster. So, help us help you by sharing those text snippets.
Please format the example text this way to preserve line breaks and special characters:
Here are some ways to provide text content in a way that it won’t be modified by the forum.
-
Method 1: Type code fence manually —
Add three backticks```in a separate line before and after the content, like this,``` text goes here ``` -
Method 2: Highlight and click the “preformatted text” button in the editor —
-
Method 3: Upload your file and share the public link —
(this method is only recommended for large files exceeding the forum upload limit)
If you need further assistance, please provide the following:
Could you go to regex101.com, paste in your Pattern at the top and paste a complete/full example text you are trying to match from below it?
Then, save the regex example and share the link with us here.
This will allow others to assist you here with your pattern. Thanks!
— @samliew