Extracting Timestamp from Webhook Column in Clay Export Data

is there anyway I can extract the text “Received Janaury 15, 2025 at 1:21 PM GMT” from the Webhook Column? it does not seem to be payload data that can be pushed to another column in Clay nore exported nor added to Google Sheets Use case - this is the best way for me to identify/timestamp when I exported the data from Trigify via webhook https://app.clay.com/workspaces/135137/workbooks/wb_Z3uwG2q4F5Xy/tables/t_rog2ANoyrW3e/views/gv_BBf7v5MeRxCN

2 comments

Channeled
APP
·
·
You can use Clay's Extract Values feature to retrieve this timestamp information from your Webhook Column. Here's how: 1. Add an "Extract Values" node to your workflow 2. Connect it to your webhook data 3. In the configuration: • Set "Data" to your Webhook Column • Choose the appropriate "Extraction Type" to match the timestamp patternThis will extract the timestamp text and store the matches in a new column that you can then use for your tracking purposes. Source: Extract Values from Data with Clay
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.