The Submit Time UTC data is missing from Google Lead Ads to Google Sheets

  • 28 August 2020
  • 3 replies

  • Anonymous
  • 0 replies

If you manually download Google Leads, one of the fields provided is Submit Time UTC. But this option is missing from the field options. How do I add that?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +10

Hi @Lindsay39 

Just checking in. Did you manage to get this sorted?

Userlevel 7
Badge +11

Hi @Lindsay39!

As @joshb mentioned, if getting the date/time that the Zap triggered would be about the same as what Google Ads provides under the Submit Time UTC field, then you could follow his advice to use the timestamp feature :)

Userlevel 1

Hey @Lindsay39,

Google may not be sending that sample result through their API.

I’m not familiar with Google Lead Ad triggers’ sample results. What data does come through?

If you are setting up the Zap to trigger when the lead comes through, you can use {{zap_meta_human_now}} is the Google Sheet Action field where you wan to capture the submitted time.

There are some pretty cool ways you can manipulate the date and time, if needed.

Let me know if that works for you. If not, let me know where you are getting stuck.