Zoom Registrant sign up time not populating in Google Sheets

what's the trigger set to, new registrant or registrant created? that "created time" token behaves differently between the two, and if the zap fires the instant someone submits, zoom sometimes hasn't stamped the field yet so it comes through empty. past records already have it, which is why editing and testing works fine and live ones don't.

quick check, map it to a plain text column first instead of anything date formatted. if the value shows up as raw text you know it's a formatting reject on the sheets side, not a missing token. if it's blank there too, it's zoom not sending it yet.

i've built basically this for a couple clients and the fix that sticks is a formatter step in the middle, date/time in, iso or whatever format out, then sheets. sometimes a short delay step before the formatter if zoom's the one lagging.

curious what the raw value looks like on those past records that do work

Hi ​@Fabi.SPL, thanks for your response. currently it’s set to “New Webinar Registrant” and that’s the only option available for me. Strange that you have 2 options. 
 

I did what you recommended, setting a plain text column, and it’s blank. Makes sense that the data is not created before the zap ran.

could you share what a formatting step is? Thanks!