I have these emails that I get, that I made a zap to have their content go into a google sheet, and then in the google sheets I had to use this weird formula to pull the data that I needed our of the cell next to it. I used this formula =REGEXEXTRACT(A2,"(\n.*){4}")
Basically in Cell “a2” its like a paragraph of text, so in “B2” I am pulling out just the persons name. etc.
But when I am setting up mojo, it only sees the text in A2, but it doesnt “see” the text in B2 (the zapier error is “no data”) , I am guessing because its technically a formula and not actually “Bob Smith” which is what I want it to pull into a mojo list.
Am I on the right track here? Thank you for your insight.