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:
-
Setting Up the Trigger in RedTail: I created a Zap with RedTail CRM as the trigger app, using the "New or Updated Contact" event.
-
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.
-
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¶ms={"emailAddress":"{{Email}}"}
-
Headers:
- I included these headers (tried various inputs for Authorization):
{ "Content-Type": "application/json", "Authorization": "Bearer YOUR_API_KEY", "id": "{{zap_meta_human_now}}" }
- I included these headers (tried various inputs for Authorization):
-
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() };
- "Code by Zapier" action to generate a UUID for the
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:
- Resolve the "Header missing request ID" error, if the workaround I outlined will give me the desired result.
- 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