Triggering Row Updates Between Two Company Tables in Database

Andy Schirrmeister · 2025-10-15 17:46:37.239426+00

i have two company tables, table 1 and table 2. when a company gets added in table 1 that's already in table 2, i want to trigger that company/ row to rerun in table 2. is this possible?

Triggering Row Updates Between Two Company Tables in Database | Clay

15 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes, you can achieve this using our "write to table" feature with auto-update enabled. [1]
Set up a write to table enrichment in Table 1 that writes to Table 2. Enable auto-update so when new companies are added to Table 1, they automatically trigger the write to table action. [2]
In the write to table configuration, use "Update row(s) if existing rows are found" to rerun existing companies in Table 2 when they're added to Table 1. You can also use conditional triggers with "Only run if" settings to control exactly when the rerun happens.
This creates an automated workflow where adding companies to Table 1 will trigger reruns of matching companies in Table 2.
Clay Support
APP
·
·
Is that what you were looking for?
Andy Schirrmeister
·
·
i'm not seeing: Update row(s) if existing rows are found in the write to other table enrichment
Clay Support
APP
·
·
The "Update row(s) if existing rows are found" option is available in Google Sheets integrations, not in the write to table feature. [1]
For write to table between Clay tables, the feature automatically handles existing rows differently - when you send data to a table that already contains matching rows, it updates those existing rows by default. [2]
The write to table feature focuses on auto-update settings and conditional runs with "Only run if" conditions rather than explicit update toggles. [3]
Clay Support
APP
·
·
Did that answer your question?
Andy Schirrmeister
·
·
wrong. when i send data from table 1 to table 2 and the account/ URL already exists, it still creates a new row. I am trying to not create a new row, and instead update the row that already exists
Clay Support
APP
·
·
You're correct - the "send table data" feature creates new rows by default. However, according to our documentation, when you first send a row it creates a new row in the destination table, but for subsequent sends, it updates that same row. [1]
This suggests the feature should update existing rows on subsequent sends rather than creating duplicates. If you're still seeing new rows created for existing accounts/URLs, this may be a technical issue that needs human assistance. Please request to talk to a person for further troubleshooting.
Clay Support
APP
·
·
Is that what you were looking for?
Andy Schirrmeister
·
·
connect me with someone, yes. thank you
Clay Support
APP
·
·
I’m routing you to our human team now. They’ll be able to assist you further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Andy Schirrmeister
·
·
https://app.clay.com/workspaces/449365/workbooks/wb_0t4562tjuWsFbd3ugzy/tables/t_0t46n98EAWASDiMMuGP/views/gv_0t46n98DzA4rycfp5wB
Natalie Ho (Clay)
·
·
Hi Andy, thanks for reaching out! Unfortunately, there isn't a native way to automatically trigger rows to rerun in Table 2 when a matching company is added to Table 1. But this is a commonly requested feature that we're aware of. One workaround you could consider is to set up Table 2 to rerun on a schedule:
1.
Click the ⛭ icon (gear) in the top right of Table 2
2.
Select "Rerun columns on a schedule"
3.
Choose your frequency (daily, weekly, etc.)
4.
Select which columns should rerun
Natalie Ho (Clay)
·
·
Let me know if you have further questions or need additional help! 😊
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!

Clay Support
APP
·
·
Yes, you can achieve this using our "write to table" feature with auto-update enabled. [1]
Set up a write to table enrichment in Table 1 that writes to Table 2. Enable auto-update so when new companies are added to Table 1, they automatically trigger the write to table action. [2]
In the write to table configuration, use "Update row(s) if existing rows are found" to rerun existing companies in Table 2 when they're added to Table 1. You can also use conditional triggers with "Only run if" settings to control exactly when the rerun happens.
This creates an automated workflow where adding companies to Table 1 will trigger reruns of matching companies in Table 2.
Clay Support
APP
·
·
Is that what you were looking for?
Andy Schirrmeister
·
·
i'm not seeing: Update row(s) if existing rows are found in the write to other table enrichment
Clay Support
APP
·
·
The "Update row(s) if existing rows are found" option is available in Google Sheets integrations, not in the write to table feature. [1]
For write to table between Clay tables, the feature automatically handles existing rows differently - when you send data to a table that already contains matching rows, it updates those existing rows by default. [2]
The write to table feature focuses on auto-update settings and conditional runs with "Only run if" conditions rather than explicit update toggles. [3]
Clay Support
APP
·
·
Did that answer your question?
Andy Schirrmeister
·
·
wrong. when i send data from table 1 to table 2 and the account/ URL already exists, it still creates a new row. I am trying to not create a new row, and instead update the row that already exists
Clay Support
APP
·
·
You're correct - the "send table data" feature creates new rows by default. However, according to our documentation, when you first send a row it creates a new row in the destination table, but for subsequent sends, it updates that same row. [1]
This suggests the feature should update existing rows on subsequent sends rather than creating duplicates. If you're still seeing new rows created for existing accounts/URLs, this may be a technical issue that needs human assistance. Please request to talk to a person for further troubleshooting.
Clay Support
APP
·
·
Is that what you were looking for?
Andy Schirrmeister
·
·
connect me with someone, yes. thank you
Clay Support
APP
·
·
I’m routing you to our human team now. They’ll be able to assist you further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Andy Schirrmeister
·
·
https://app.clay.com/workspaces/449365/workbooks/wb_0t4562tjuWsFbd3ugzy/tables/t_0t46n98EAWASDiMMuGP/views/gv_0t46n98DzA4rycfp5wB
Natalie Ho (Clay)
·
·
Hi Andy, thanks for reaching out! Unfortunately, there isn't a native way to automatically trigger rows to rerun in Table 2 when a matching company is added to Table 1. But this is a commonly requested feature that we're aware of. One workaround you could consider is to set up Table 2 to rerun on a schedule:
1.
Click the ⛭ icon (gear) in the top right of Table 2
2.
Select "Rerun columns on a schedule"
3.
Choose your frequency (daily, weekly, etc.)
4.
Select which columns should rerun
Natalie Ho (Clay)
·
·
Let me know if you have further questions or need additional help! 😊
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!