.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?
So if I put 12/19/2024 in a date column for each row, how can I make it to update record to 12/20/2024 the next day?
Automatically
Currently, Clay doesn't have a built-in feature to automatically increment dates by one day. While Clay has a Date/Time formatter and AI formulas functionality, there isn't a way to create dynamic date calculations that automatically update daily.The AI formulas and conditional runs in Clay are primarily designed for formatting, cleaning, and reshaping existing data, rather than creating dynamic time-based updates.If you need to track daily incremental dates, you would need to either: 1. Update the dates manually 2. Use an external system to manage the dates and sync them to Clay 3. Consider reaching out to our support team to discuss alternative approaches for your specific use case. Sources: AI Formulas + Conditional Runs [CRM Enrichment] - Clay University Clay formatters overview | Clay University
Any examples of external systems to manage the dates?
You can manage dates through several external systems and sync them with Clay: 1. CRM Systems like Salesforce or Hubspot - These can be connected to Clay and allow you to manage dates that sync automatically. 2. Custom Applications - You can send date updates to Clay using webhooks, which allow you to push data from your own systems into Clay.Note that when working with dates, make sure they follow Unix time set to midnight to ensure compatibility with your chosen system.To get data into Clay from your external system, you can either: ** Use webhooks to send data directly ** Export to CSV and import into Clay * Use the HTTP API integration to push data from your application Sources: Upsert Object with Salesforce Hubspot integration overview | Clay University
Can I update the date for existing rows in this way?
Not creating a new ones?
Yes, you can update dates for existing rows in Clay using external systems like Snowflake. Here's how: 1. Using Snowflake integration, you can: • Set up a connection between Clay and Snowflake • Use the Update Row or Upsert Row action to modify existing data • Specify a lookup field to match rows between Clay and Snowflake • Map the date fields you want to updateThe process will use Snowflake's SQL API to maintain up-to-date data across both platforms, allowing you to update existing records based on specified query conditions.Note that fields with null values will be ignored during updates to prevent overwriting existing data. Sources: Update Row with Snowflake Upsert Row with Snowflake Snowflake integration overview | Clay University
So I can automatically update just one cell in Clay row using Snowflake every day
Pull current date in Clay date cell for each row?
Yes, you can automatically update a single cell in a Clay row using Snowflake. Here's how: 1. Use the "Update Row" action to modify specific fields in your Clay table 2. Set up a lookup field to match the specific row you want to update 3. Map only the single field/cell you want to update 4. Enable auto-update for automatic daily updatesNote that fields with null values will be ignored during updates to prevent overwriting existing data.Keep in mind that while auto-update runs automatically on new rows by default, you can control when updates happen using conditional formulas that trigger only when specific conditions are met.The update will use Snowflake's UPDATE statement to modify the existing record based on your specified conditions. Sources: Snowflake integration overview | Clay University Guide: Ways to save Clay credits | Clay University Update Row with Snowflake
How to extract current date for each day from Smowflake?
Is it possible to pull current date only?
You can use the Format Date/Time action in Clay to get the current date in your date cells: 1. Add a Format Date/Time action to your table 2. Input the current date as the source 3. Select your desired date format 4. Enable auto-update to keep the dates currentThe action will automatically format dates for new rows, and you can control when updates happen using conditional formulas. Sources: Format Date/Time with Clay Formatters Clay formatters overview | Clay University
Hey, thanks for reaching out - Just to confirm, You can't UPSERT but you can add values (create a row) and use a Update enrichment to update the values but within Snowflake, not within clay
You can use the formula to create today's date and/or use the created at column to reference a date. We also have a formatter for the date that can be found in the enrichment panel by clicking the "add enrichment" button at the top right of the page.
Hey. I’m looking a way to update date cell automatically
Is there any way?
Was thinking to use webhook from Hubspot but looks like it creates new rows, not updates existing ones
Looking for any way to update date cell and use specific dates like 15 of each month to run another column
Hey! Unfortunately there's no way to upsert data with webhooks, - they can only create new rows and it's the same with every other enrichments, api etc. We simply don't have that function yet. But you can work with dates in a couple ways: 1. Use a formula to return specific dates 2. Create a formula that returns today's date or when a specific column was last modified
How to create a formula that returns today’s date?
You would reference a column and say: If /column is present, return today's date ! More on formula https://www.clay.com/university/lesson/how-to-use-ai-formulas
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.
Hey! Need some help with my table