Hey! I am working on enrichment on demand workflow which after input on native n8n chat processes message, extracts linkedin URL from message, sends it to Clay table, in Clay table finds phone number, sends number back (or blank if not found) to n8n and then returns answer in the chat window.
The biggest issue is, how do I send return message only after it was found in Clay and not before that saying that its blank?
I don’t understand what is the use case of the webhook trigger node in your workflow. You send a POST request to Clay and retrieve a response in the same node.
The output of the HTTP request node is the response returned by the service. Check executions tab or execute the HTTP request node independently for once, what does it return? In your case it must return the phone number or return a blank item.
When I run the HTTP Request node, it just sends data points (like the LinkedIn URL) to the Clay table, and that’s when the enrichment starts inside Clay. The response I get from the HTTP node doesn’t include the phone number yet but it just confirms that the data was sent to the table successfully.
So I’m trying to figure out how to make n8n wait until the enrichment in Clay is finished and the phone number appears in the table, before sending the final reply in chat.