Skip to main content
Question

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

  • August 28, 2020
  • 3 replies
  • 83 views

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

joshb
  • New
  • 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
  • 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
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • October 27, 2020

Hi @Lindsay39 

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