.png){kind=logo}
Is there a way to update a row in another table via an enrichment
Is there a way to update a row in another table via an enrichment
Is there a way to update a row in another table via an enrichment
You can update rows in another Clay table using the "Write to Other Table" action. This integration allows you to: • Transfer data from one Clay table to another• Create or update rows in the target table• Map column values between tables• Handle different data types including lists, single values, or objectsFor finding existing rows before updating, you have two lookup options: 1. "Lookup Single Row" - Best for checking one specific record 2. "Lookup Multiple Rows" - Use when you need to find multiple matching records Sources: Lookup Single Row in Other Table with Clay Write to Other Table with Clay Labs Lookup Multiple Rows in Other Table with Clay
This is incorrect information -- you cannot update rows in the target table, only create them
The Write to Table integration in Clay can only create new rows in a target table, not update existing ones. When transferring data between tables, you can: • Create new rows in the destination table• Map specific columns from source to destination• Transfer different types of data (lists, single values, or objects)• Set up auto-update for new rows• Configure conditional runs using formulasIf you need to update existing data, you'll need to explore alternative approaches or reach out to our support team for guidance. Sources: Write to table integration overview | Documentation | Clay University Write to Other Table with Clay Labs
Mathew I. did you get a reply on this? I'm having the same issue
The Write to Table integration in Clay can only create new rows in a target table, not update existing ones. When using this integration, you can: • Select a destination table within your workbook• Map columns from your source table to the destination table• Configure auto-update for new rows• Set conditional runs using formulasIf you need to update existing data in tables, you'll need to explore alternative approaches or request assistance from human support. Source: Write to table integration overview | Documentation | Clay University
Did that answer your question?
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Nicolas P. yea no way to update a row, you can only create
No workarounds, no nothing?
Only workaround is to set up a "reverse connection" in your sheet You write data (i.e. a unique identifier like Linkedin URL) from sheet 1 --> sheet 2 In sheet 2 you "Look up" the row in sheet 1 to populate the data in sheet 2 If you change the data in sheet 1, you can re-run your "Look up" which will update the data in sheet 2 That said, in my experience these "reverse lookups" are bad practice -- they greatly increase the complexity of your worksheets. You are much better off ONLY writing data from 1 sheet to another to keep your dependencies linear vs. multi-directional
Hi Mathew, thanks for reaching out! I’m looking into this now. You’re correct—there’s no way to update records in another table via enrichment, aside from the workaround you described using the lookup system.