Automatically Merge JSON Data from Webhook for Lead Processing
Hey! I have a Clay table that’s receiving a JSON payload from a webhook every time a lead advances through a form. That is, we get partial submission data for every step. The problem is, there are 5 steps to the form, and so if they go throuhg the whole thing, we get 5 JSONs in a few minutes each with repeat data. How do I automatically merge these rows? The desired action is to 1) enrich their company information 2) send them an email if they abandon the form by pushing them out of Clay with an HTTP API enrichment to an emailing service