Skip to main content
Question

To collect Country Data (from ClickFunnels) to Google Sheet

  • December 14, 2021
  • 3 replies
  • 23 views

Hi, 

Recently I am getting new leads from all around the world but somehow when I wanted to collect which country are they from, the google sheet does not update as such.

Here is my set up:-
Opt-in Page (ClickFunnels) → Email lead generate (Keap) → Email, name, phone number, country (Google Sheet)

Any reason why even when they selected the which country they are from, the google sheet still does not update?

Thanks!

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

jayeshkumarbhatia
Forum|alt.badge.img+6

Hey @Ivan0812 ,

 

Can you post the screenshot of how have you configured Google Sheet action? Also a screenshot of your Google Sheet will help a lot.


  • Author
  • New
  • 1 reply
  • December 14, 2021
Google Sheet
Currently I can only use “Contact Profile Location General”, but it does not have any info all the time :(


Hope this helps!

Thanks!​​​​​​​


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31410 replies
  • December 14, 2021

Hi @Ivan0812 

Is Country a required field on your ClickFunnels page?

 

Check your Zap Runs history details for the DATA IN/OUT for each Zap step to determine if the Country data point is in fact returned and populated.

NOTE: You may need to remap the Country data point.

 

You can try changing the trigger test data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger

 

My Custom Field is not coming through for Contact Activity trigger?

Please make sure that a field name is assigned for the custom field. If doing that still doesn't help, please make sure the "Custom Type" was not left as the default inside ClickFunnels:

Once the field name is added and the Custom Type field is customized, try to pull in a new sample and the custom field will showing up.