Preventing Duplicate Gong Call ID Processing in Spreadsheet

If I have a column with Gong Call IDs, and I want to prevent a later column from running if an ID has already been ran, how would I achieve this? I've tried a few formula columns but it doesn't seem like I am able to reference an entire column to check for duplicates..

4 comments

Channeled
APP
·
·
To prevent a column from running if a Gong Call ID has already been processed, you can use a combination of deduplication and conditional runs. Here's how: 1. First, dedupe your Gong Call ID column to remove duplicates: • Click on the Gong Call ID column header • Select 'Dedupe' from the dropdown menu • Confirm the duplicate values to remove 2. Then, set up a conditional run for the column you want to control: • Open the column settings • In the "Only run if..." section, create a condition • Use a formula to check if the Gong Call ID is unique or not processed before If you're still having trouble, you might need to use a more complex formula or consider a custom solution. If you need further assistance, please request to talk to a human agent for more detailed help.
Sources: Table columns | Documentation | Clay University Datagma integration overview | Documentation | Clay University
Owen C.
·
·
This is a recurring webhook, and the duplicate call IDs are coming in from the webhook, so im not sure if i can just de-dupe once and resolve the issue. Unless I am not understanding this correctly?
Channeled
APP
·
·
To prevent a column from running for duplicate Gong Call IDs coming from a recurring webhook, you can use a combination of techniques: 1. Set up a conditional run for the column: • Open the column settings • In the "Only run if..." section, create a condition to check if the Gong Call ID is unique 2. Use a Lookup action: • Add a Lookup action to check if the Gong Call ID already exists in your table • Create a column that flags duplicates based on the Gong Call ID 3. Use an AI formula: • Create a formula to identify unique Gong Call IDs • Set up the "write to table" action to only run for new, unique IDs This approach will help prevent processing duplicate Gong Call IDs from your recurring webhook.
Sources: Push Data To Your CRM [Clay 101] - Clay University Smartlead integration overview | Documentation | Clay University
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

Preventing Duplicate Gong Call ID Processing in Spreadsheet | Clay