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!

Hi ​@Gabrielng 

For us to have more info, post screenshots showing how your Zap steps are outlined and configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.

Hi ​@Gabrielng 👋 Did you have any luck with Troy’s suggestion to use System variables to add a timestamp of when the Zap runs into the Google Sheets? 

Let us know if that sorted it or if you still need any help!

HI all,

Apologies for not coming back to this thread sooner. We learn something new everyday!
​@Troy Tessalone’s suggestion worked like a charm. I didn’t know anything about Zapier variables.
Thank you so much!

No worries ​@Gabrielng! Really glad you were able to sort it with system variables 🎉 Big thank you to ​@Troy Tessalone for helping out here! 🙌 

Hope all goes well with the webinars, we're always here if you ever need any help!