Greetings.
I want to connect Outlook to Google Sheets, populating the latter with data from the former in a new row. The Sheet is set up with headers. The data I am trying to pass is City, Zip, and Profession from a regular email. I can “see” the data as input in the text parser either from the body preview or body content, but I cant get it to separate the data into 3 named variables and thus allow me to map it to sheets.
Before I spend another 2h going in circles would some kind soul help me out?
1 Like
Hey Robin,
can you show the setup of the text parser module and a sample email body you are testing with?
Of course
a> the email input
Location: Honolulu, HI
Zip: 96817
Profession: Property Management
b> The text parser module
c> the regex
Location: (.?), .?\nZip: (\d{5})\nProfession: (.*)
1 Like
Hi @Robin_Hones
You can use Match element module to extract text easily from key value pairs
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
Hi @Robin_Hones
Example
Output:
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
1 Like
Thank you Stoyan. I will check into this different module and confirm when I get home tonight
1 Like
Hello Stoyan
Thank you, I can replicate your solution no problem. However, I am now stuck on how to get the values in each of the 3 bundles into appropriate columns of one new row of a spreadsheet. I know I need the sheets/add a row module, but there has to be a module, or modules, between the text parser/match elements and that add row module?
I have tried an aggregator and a get module but cant get either to do what I need.
1 Like
Hi @Robin_Hones
Hope this helps to get the values. You can directly map these into you add a row module.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation