Skip to main content
Question

Zapier Unable to Search and Update Existing Contacts in SharpSpring

  • February 7, 2025
  • 1 reply
  • 6 views

Hi everyone,

I'm facing an issue with integrating SharpSpring with Zapier, and I could use some help. My goal is to set up a Zap that searches the SharpSpring contact database to update existing contacts, rather than creating new ones for every trigger.

What I've Tried So Far:

  1. Setting Up the Trigger in RedTail: I created a Zap with RedTail CRM as the trigger app, using the "New or Updated Contact" event.

  2. Attempting to Search Contacts in SharpSpring: I tried to add an action in Zapier to search for existing contacts in SharpSpring. However, it seems that SharpSpring's Zapier integration does not include a "Find Contact" or "Search Contacts" action.

  3. Using Webhooks as a Workaround:

    • I attempted to use Webhooks by Zapier to send a GET request to SharpSpring's API to search for contacts by email.
    • Example URL I used (filled in my account ID, secret key, and email): https://api.sharpspring.com/pubapi/v1.2/?accountID=YOUR_ACCOUNT_ID&secretKey=YOUR_SECRET_KEY&method=searchContacts&params={"emailAddress":"{{Email}}"}
  4. Headers:

    • I included these headers (tried various inputs for Authorization):
      {
        "Content-Type": "application/json",
        "Authorization": "Bearer YOUR_API_KEY",
        "id": "{{zap_meta_human_now}}"
      }
      
  5. Copilot suggested I try using a UUID as written below, but I couldn’t figure out where to put it.

    •  "Code by Zapier" action to generate a UUID for the id header:
      function generateUUID() {
        return 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function(c) {
          var r = Math.random() * 16 | 0, v = c == 'x' ? r : (r & 0x3 | 0x8);
          return v.toString(16);
        });
      }
      
      return { uuid: generateUUID() };
      

 

Despite these efforts, I keep encountering Error Code 102 with the message "Header missing request ID." Additionally, even if this error were resolved, I'm concerned about the lack of a built-in action to search and update contacts in SharpSpring, which is crucial for my workflow.

I'm looking for any advice or solutions to:

  1. Resolve the "Header missing request ID" error, if the workaround I outlined will give me the desired result.
  2. Find a way to search and update existing contacts in SharpSpring using Zapier, rather than creating new ones for every trigger.

I’m also considering moving to MailChimp for marketing/email automation. 

Has anyone successfully managed to set up such a workflow? Any insights or suggestions would be greatly appreciated!

 

Thanks,

Gabriela

Did this topic help you find an answer to your question?

1 reply

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7274 replies
  • February 10, 2025

Welcome to the Community, ​@gbruz! 🎉

I did some checking and it looks like we’ve got a feature request for a search action to be added that would allow you to search for existing leads/contacts which has come up in the Community before:

So I’ve gone ahead and added your vote to that feature request. While I can’t guarantee if or when this search action will be added by the developers of the SharpSpring app, we’ll definitely notify you via email once it is.

In the meantime, when looking into the API documentation for SharpSpring it looks like SharpSpring is a part of Constant Contact. So I’m wondering if you might be able to use the Find or Create Contact action on the Constant Contact app in your Zap instead:

f95317a98a36b5b7b8ee1678af745705.png

Can you give that a try and let me know if that works as hoped?