.png){kind=logo}
Adding Timestamp to Clay Table Dataset in Google Sheets
Hey. Is it possible to add something like time stamp to the dataset I push from Clay table to Google spreadsheet?
Hey. Is it possible to add something like time stamp to the dataset I push from Clay table to Google spreadsheet?
Yes, you can add timestamps when pushing data from Clay to Google Sheets. When using the Google Sheets "Add Row" action, you can map any column from your Clay table to your Google Sheet, including timestamp columns. To add timestamps: 1. Create a timestamp column in your Clay table (you can use formulas or enrichments to generate current date/time) 2. In the Google Sheets integration, map this timestamp column to a corresponding column in your spreadsheet 3. Each time data is pushed, the timestamp will be included The integration allows you to select and map any columns from your Clay table to corresponding columns in Google Sheets, so timestamps work just like any other data field.
How to generate time stamp in Clay table?
You can generate timestamps in Clay tables in two main ways: 1. Use the built-in "Created At" column: ** Click the columns dropdown in the upper left corner of your table ** Unhide the "Created At" column ** This automatically timestamps when each row was created 2. Use the Format Date/Time formatter: ** Add enrichment → Format Date/Time ** Input your date source and select your desired format ** Choose "Unix Timestamp" as output format for CRM compatibility * Keep column type as text to avoid formatting issues The Format Date/Time action provides multiple timestamp outputs including Unix Timestamp, Full Date Time, and Localized Date Time.
How to add time stamp in Clay table if I don't add new rows but run the same columns once amonth?
For monthly scheduled runs without adding new rows, use the "Created At" column to timestamp when data is sent to a new table. Set up your monthly scheduled run, then use "Send table data" under Actions to push results to a new table. In that destination table, unhide the "Created At" column from the columns dropdown - this will timestamp each monthly run. This approach creates a run history where each monthly execution gets its own timestamp, even though you're not adding new rows to the original table.
Hello Oleh! Thanks for reaching out! Unfortunately you cannot reference the Updated At field to push outside Clay since it is a dynamic field and could lead to an infinite loop issue.