This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
I’m trying to have some text pulled from an email that I will use in a later step to add into Google Sheets.
The current Zap I have will trigger when an email is submitted and pull the email, contract number and search out drive for the that specific contract number and then go into that Google Sheets and add in the email address.
I’m trying to see how I can pull the Name and the Gift Selection, but I’m not sure how to go about it.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/97427d08-df25-4a24-a0ca-41447ae6a79f.png)
Currently this is how I have my zap set up - and I’m thinking that I can do another Text formatter but I’m not sure how I can pull that specific Name and Gift Selection from the HTML.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/f8ab8a9d-3449-41a9-b63c-7cdee682bccb.png)
Also - I’m not sure if I could use the Plain Body text or If I should use the HTML Body Text.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/d9eb10df-79c6-4404-a038-4580fb730a7b.png)
Happy to share more information, just not sure what’s needed! :)