Skip to main content
Question

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


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?

Did this topic help you find an answer to your question?
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

joshb
  • New
  • 3 replies
  • August 28, 2020

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.


nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • 2115 replies
  • August 31, 2020

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 :)


AndrewJDavison_Luhhu
Forum|alt.badge.img+10

Hi @Lindsay39 

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