Auto Detect and Enrich New Salesforce Records Daily

How do I auto detect net new records added in SFDC to enrich? e.g. a new account gets created, adds a new row inside a table and run enrichment, update record. Would running a SOQL like:

SELECT Id, Name, CreatedDate FROM Account WHERE CreatedDate >= TODAY - 1

then forcing the table to run 1x day on that column?

6 comments

Channeled
APP
·
·
Yes, you can auto-detect and enrich new Salesforce records using the Lookup Records via SOQL action. Here's how to set it up: 1. Use the Lookup Records via SOQL action with your SOQL query to fetch new records: • Example query: SELECT Id, Name FROM Account WHERE LastModifiedDate > 2024-01-01T00:00:00Z • You can adjust the date filter as needed 2. Configure the run settings in Clay: • By default, new rows in your Clay table will trigger this action • The system will automatically sync SFDC imports every 24 hours 3. To manage auto-update settings: • Navigate to your table name in the top bar • Use the dropdown menu to Enable/Disable auto-update This setup will help you automatically detect and process new records for enrichment on a rolling basis.
Sources: Salesforce integration overview | Documentation | Clay University Lookup Record via SOQL with Salesforce | Clay.com
Channeled
APP
·
·
Did that answer your question?
Justin T.
·
·
running the soql gives me the total records founds but does not extract them into individual rows.
Channeled
APP
·
·
When using the Lookup Records via SOQL action, the results are automatically returned as individual rows in the "Records" output field. Here's how it works: 1. Enter your SOQL query in the input field (e.g., SELECT Id, Name FROM Account WHERE CreatedDate > = TODAY - 1) 2. The action will return: • Records: A list of all matching records, with each record as a separate row • Found At Least One: A boolean indicating if any records were found Each record in the returned list will be automatically separated into individual rows in your Clay table.
Source: Salesforce integration overview | Documentation | Clay University
Channeled
APP
·
·
Is that what you were looking for?
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.