Update GoHighLevel (GHL) contacts with new rows from Google Sheets

Hire a Pro Hire Help
1

I created an assessment in Google and need to update GHL contacts with the results of that assessment. The custom fields have been added to the GHL contact folder. The trigger is the new row created. I want to check GHL for an existing contact and if found update custom fields. If the contact is not found then I want to create a new contact in GHL and update the custom fields

2 Likes
2

Hello @Russell_Betts , welcome to make.com community, I have worked and have experience with Make.com and l will love to collaborate with you on this you can schedule a call Here and you can checkout my upwork profile Here, for my pastworks and certifications

3

Hey @Russell_Betts,

Yes it’s possible to create this workflow in Make. There are some nuances to custom field that you need to keep in mind. I run an automation studio called Automation Jinn where we help companies like yours automate their processes and increase efficiency.

I can understand how it can become more technical and difficult to handle it yourself. I am a Make advanced certified with a background in computer science so quite comfortable in integrating API and custom code. Would love to talk more about the project :slight_smile:

Happy to also jump on a call if it’s easier.

Cheers,
Sparsh
Founder
Automation Jinn

4

Hey @Russell_Betts,

If you are looking for someone with more than 5 years of experience and certified expertise, I would be glad to help with this task that takes only a few hours.

Please feel free to explore my services, and I would also be glad to connect on LinkedIn to move forward.

5

Hi Russell,
This sounds like a solid use case for Make. The contact lookup and conditional create/update logic is definitely doable with the right module setup.

I would be happy to help you get this running if you still need a hand.

You can reach out to me on my email here

Colin

6

Hi @Russell_Betts I believe our automation expert can help you with this! Check your DMs for more information :smiley:

7

Hello @Russell_Betts! We’re certified Make.com and GoHighLevel (GHL) developers, and we’ve built many Google Sheets to GHL syncing workflows before.

Here’s how we can help:

  • Trigger the automation when a new row is added in Google Sheets

  • Search GHL for an existing contact

  • If found, we will update all your custom fields with the assessment results

  • If not found, we will create a new contact in GHL and populate all field

If you’d like, I can review your current setup and get this workflow running smoothly for you.

Pick a slot using this link: Calendly

Best,
Proto IT Consultants

8

Hi! I can help you set this up. I’ve built similar Google Sheets → GHL assessment workflows before—for example, I recently created an automation where quiz results were pushed into GHL custom fields and updated the contact immediately if they already existed.

I can do the same for your setup: check if the contact already exists in GHL, update their custom fields, or create a new contact when needed. Happy to help you get this working smoothly!

:page_facing_up: Check my profile: https://www.upwork.com/freelancers/farhana401

:telephone_receiver: Book a quick call:Calendly - Automaxion

9

@Russell_Betts You want every new assessment response in Google to sync into GoHighLevel so that if a contact already exists, their custom fields are updated with the latest results, and if no contact exists, a new one is created and populated with those same assessment fields. The trigger is a new row in your Google Sheet that is connected to the assessment.

I would implement this as a clean and testable Make.com scenario that watches your Google Sheet for new rows, then performs a lookup in GoHighLevel and either updates or creates the contact. The goal is a reliable one-click workflow with clear mapping between sheet columns and GoHighLevel custom fields, plus simple logging so you can verify that every response is synced correctly.

  1. Which identifiers do you want to use to match existing contacts in GoHighLevel? Email only, phone only, or a priority order, such as email first, then phone as a fallback?

  2. Can you share the exact column headers in your Google Sheet and which GoHighLevel custom fields each one should map to, including any that should remain untouched?

  3. Roughly how many new assessment rows do you expect per day, and do you anticipate any bulk imports that might create short-term spikes in volume?

  4. When the same contact completes the assessment multiple times, do you want the latest results to overwrite previous custom field values, or do you need any form of history or tagging to distinguish separate runs?

  5. Do you want any logging or visibility, such as a status column back in the Google Sheet or notifications when a sync fails so you can quickly spot and fix issues?

I’ll wait for your reply. Thanks!