Hey there, @LonnyH! Thanks for reaching out in community!
Can you describe what part of the zap specifically is unsuccessful? Are the proper emails not found or perhaps the wrong information is coming through in Google Sheets?
In general though it sounds like you may need an email parser tool like Email Parser by Zapier or Mailparser! Here’s a hub for some common Q&A using Email Parser by Zapier and helpful resources:
It’s worth mentioning Email Parser by Zapier works best if the lead emails coming through are on some type of template where the format is consistent. More on that in this blog post here.
That said, if the emails aren’t templated then we may need a more robust parsing tool. Here’s a list of some of the ones Zapier integrates with.
I hope some of this helps but if you’re still blocked, let us know! We’re happy to keep digging in with you.