Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How can I create a Zap for offline phone call conversion tracking using Google Sheets?

Hi, 

I need help, if someone guide me, I’ll be thankful to u.

I want to create a zap for Offline conversion tracking for “phone calls” based on Google Sheet. Is there any way to do this just like OCT for leads we do.

 

Regards,

Hi @nicolebernardino 

What app are you trying to use for tracking the offline conversions? (name/screenshot)

I am trying to use Google sheet template the same we used for lead tracking, while using zapier for OCT. We can’t do Offline conversion tracking with GCLID for phone calls?

Hi @nicolebernardino 

If you are trying to use GAds there is this Zap action: Send Offline Conversion

In the settings, there is a field: Conversion User Identifier Source

With an option for: Phone Number

 

Thank you for your response. Do we have to add some extra columns in our Google sheet template for it? like phone caller ID, timings, etc.?

@nicolebernardino

I recommend trying to configure the desired Zap action step so you can see the fields.

  • Check which fields are required/optional/conditionally required
  • Check the field types and descriptions for guidance about expected values
  • Adjust your GSheet as necessary

 

When in doubt, test it out.

Hi @nicolebernardino 👋

How did you get on with Troys suggestions here, is the Zap working now?

Keen to ensure you’re all set so please let us know whether you need any further help at all 🙂

Terms & Conditions