I have about 300 emails in a Gmail inbox, all are from the same form submission email (Squarespace originally) and have relatively similar data. What I mean by this is that the oldest messages/form submissions don’t have as many data fields as the new ones, as the form that users submitted through was added to over time.
I am trying to create a Zap that will find all the emails from this address, pull the important data from each, and place it in a Google Sheet so I can do some further analysis of the data.
I’ve found that a good trigger is “new labeled email”, since I can create a new label in Gmail called “Form Submissions”, and place all the emails from the Squarespace form submission email (something like squarespace.info) into it and Zapier will catch it.
I have also found that I can easily set up the event to be “create new row” on a certain Google Sheet. The issue I’m encountering is that I can’t find a way to selectively pull the data I want from the body of each email. I can select “Body” as a data point to be dropped into a cell on the spreadsheet, but I can’t do anything further to cut that body up.
Any advice on how to accomplish this?