Eric M.

Fixing Duplicate Rows with Write to Other Table Function

I'm seeing an interesting issue where I'm using "Write to other table" and about ~half the time it duplicates the row into the other table. So two rows appear for the won write function. Any thoughts on how to fix that?

1Comment

Commented on Optimizing Workflow for Delayed Webhook Processing...·Posted inClay Support

Eric M.

Muhammad S. n8n is definitely on my list! thank you 🙂

Commented on Optimizing Workflow for Delayed Webhook Processing...·Posted inClay Support

Eric M.

Asher good call. Don't know why I didn't catch that! At first I was concerned about having duplicative company rows, but I should just be able to do a lookup and say if it already exists, don't push the company info into Clay again, just the individual. So basically, Webhook -> Process Individual -> Process Company (w/ a new row for each individual, just don't update to Hubspot if it's duplicative) -> Publish to Hubspot

Commented on Optimizing Workflow for Delayed Webhook Processing...·Posted inClay Support

Eric M.

https://app.clay.com/workspaces/543763/workbooks/wb_0t0ljgbXU8aH9Ygepho/tables/t_0t0ljghqCSn6Zwhvirp/views/gv_0t0ljgh6pyJSu5WdNs7

Posted in Clay Support·

Eric M.

Optimizing Workflow for Delayed Webhook Processing in HubSpot

Hello, I have a question delaying a table run. TLDR, I have leads coming in from a Webhook, being processed to evaluate the individual's information, and sending information to (a) a company table and (b) a Hubspot publishing table for processing. Unfortunately it takes longer to complete the company table (~2-3 min) than the Hubspot publishing table, so it's often not complete by the time I'm pushing information to Hubspot. So often it will push a partial set of information that is incomplete. Here's what I've tried:

Pushing data into the Hubspot table rather than pulling it (not possible by my read, you can only push a new row, not update a row)
Adding ~1 min of delay into the workflow by using a series of https://postman-echo.com/delay/10
Having a second "Lookup Single Row in Other Table" condition on the first "Lookup Single Row in Other Table" being complete

Unfortunately none of these have worked. Any thoughts?

8Comments

About

Country
My Company Website
Title