.png){kind=logo}
Update Existing Cell in Clay Table via HubSpot Webhook
Hey. Is it possible to update existing cell in Clay table with webhook from Hubspot instead of creating new row? I need to update just one cell
Hey. Is it possible to update existing cell in Clay table with webhook from Hubspot instead of creating new row? I need to update just one cell
While webhooks in Clay are primarily designed to import data and create new rows, you can update existing records in Clay through HubSpot using the Update Object action instead of webhooks. Here's how: 1. Use the Update Object action in your Clay table 2. Select your HubSpot account 3. Specify the object type you want to update 4. Enter the HubSpot Object ID for the record 5. Map the specific fields you want to update 6. Configure whether to ignore blank valuesThis approach gives you more control over updating specific cells while maintaining data integrity.If you specifically need to use webhooks, note that the webhook feature is designed for importing new data into Clay tables. Sources: Hubspot integration overview | Clay University Import Data to Clay Using Webhooks
Ok. And is it possible to trigger column run with new row added?
Yes, this is possible through the auto-update feature. By default, columns are set to automatically run enrichments on new rows when they're added to the table. You can control this behavior in the run settings of your column: 1. The auto-update feature is enabled by default 2. You can toggle it off if you don't want automatic updates, but be aware this might lead to stale data 3. You can also set up conditional runs using formulas to make the column run only under specific conditions Sources: Apify integration overview | Clay University Google Sheets integration overview | Clay University Snowflake integration overview | Clay University
But will the whole column run for all the rows or just to the new row?
By default, when a new row is added, the auto-update feature will only run enrichments for that new row, not the entire column. If you want to run enrichments for specific rows, you have a few options: 1. Let auto-update handle just the new rows automatically 2. Filter for specific rows you want to update 3. Use conditional runs to specify exactly when enrichments should runThis approach helps conserve credits and prevents unnecessary enrichments on existing rows that may already have the data you need. Source: Guide: Ways to save Clay credits | Clay University
I mean if I run the column for existing rows, then add a new row will the column run for all the rows again?
No, when you add a new row after running the column for existing rows, the column will not automatically re-run for all rows. By default, the auto-update feature will only run enrichments for the newly added row.If you want to preserve existing data and only run enrichments for new rows, you can use filters to run the enrichment specifically on those new rows. Source: Apify integration overview | Clay University
Ok, can I put run condition based on specific timeframe or date?
Yes, you can set up conditional runs based on timeframes or dates. You can do this through the Run Settings of your action by using comparison operators to evaluate date-based conditions. For example, you can create conditions like: • Compare dates using greater than/less than operators• Check if a date falls within a specific range• Match exact datesTo set this up: 1. Go to the Run Settings of your action 2. Click "Use AI" in the Conditional runs editor 3. Define your date-based condition 4. Click "Generate formula" to create the formula 5. Verify the output to ensure it works as expected Source: Conditional runs | Clay University
Can I create column with actual date and put run condition to update the date automatically every day?
Yes, you can create a date column using the Date/Time formatter and set up conditional runs to update it. Here's how: 1. Create a column using the "Format Date/Time" action to get the current date 2. In the Run Settings section, scroll down to "Conditional runs" 3. Click "Use AI" in the conditional runs editor 4. Create a formula that evaluates to true each day to trigger the updateNote that by default, the column will auto-update for new rows, but you'll need to set up the specific conditional formula to ensure daily updates for all rows. Sources: Clay formatters overview | Clay University Conditional Formulas
Can you give me an example of such formula?
To create a formula that triggers a daily update for a date column, you can use the following approach: 1. In the Run Settings section of your date column, scroll down to "Conditional runs"
2. Click "Use AI" in the conditional runs editor
3. You can use a simple formula like:
trueThis will ensure the column updates every time the table refreshes (which happens daily by default).Alternatively, if you want more control, you can create a condition that compares the current date with the last updated date.Remember that you'll need to have auto-update enabled for this to work automatically. The formula will evaluate each time the table refreshes, and if it returns true, the date will update.
Sources:
Conditional Formulas
Conditional runs | Clay University
Is there internal time count in Clay to make it work?
Clay has a built-in 24-hour sync cycle for tables connected to CRM sources, which automatically updates data every 24 hours. However, there isn't currently a way to schedule custom enrichments or updates - this feature is being actively worked on.For your date column, you can rely on the default auto-update feature which will update new records, but there isn't an internal time counter that you can use for custom scheduling of updates. Sources: Can I schedule data enrichments so they re-run on their own? - FAQ | Clay.com FAQ: What are the default sync settings for CRM integrations?