Skip to main content

Get Help

Find answers to your questions. Ask the Community for help or hire someone to help you.

28674 Topics
J
jadjugahBeginner
posted in How Do I
Which of the fields in ConnectWise Manage ticket are supported by the “New/Updated Ticket” trigger?

Which of the fields in ConnectWise ticket is supported by the “New/Updated Ticket” trigger ?Thanks  This post was split from the topic:   

1
jesse
2 years ago
B
BretJorgNew
asked in Code & Webhooks
Remove variable text from string.

I have this output["*Nps*","4 out of 10","*Why*","Great"], null, ["*IsStaff*","true ","*IsActive*","true ","*UserId*","auth0|5a577dxxxxxxx228a03e564c ","*IsTrial*","false ","*HasNoSubscription*","false "], ["*SubscriptionStatus*","{\"enableReview\":true,\"enableRise\":true,\"plan\":\"team\",\"status\":\"active\",\"endDate\":\"2028-06-13T00:00:00.000Z\",\"role\":\"seatHolder\",\"subscriptionId\":\"xxxxxx-4af4-4417-8fbd-xxxxx\",\"isRetrialEligible\":false,\"isTeamAdmin\":true,\"seats\":202}","*Platform*","Mac","*Browser*","Chrome 103.0.0.0","*Url*","<https://xxx.BlahBlah.zone/>","*Device type*","desktop"]and need to extract only the auth0|5a577dxxxxxxx228a03e564c in the output. In trying to remove everything up to the value above, I’ve tried the following JavaScript to no avail: let Response = inputData.Response.split(/"*Nps(.*)UserId*",":/g)[0]; output = [{Response}];I started from this thread

2
Troy Tessalone
2 years ago
D
DentiavitaBeginner
asked in Troubleshooting
When the contact form is submitted, the file uploaded is not sent in my CRM

Hello, I have added a filed in my contact form to upload a file. I have connected my Zap with Bigin CRM. When the contact form is submitted, the file uploaded is not sent in my CRM. Can you help me please what problem is this? Thank youThe form is created with Elementor Pro forms.

4
Danvers
2 years ago
H
HibracadabraBeginner
asked in How Do I
How do I only trigger on Notion records where a checkbox is set to “true”?

Hey all,  is there any way to create a flow where only the events with a “true” checkbox from my attached Notion Database are added to my Outlook calendar?I tried many ways but unfortunately I haven't found a way yet to make that possible, therefore I would appreciate your help very much!Best wishes, Tim

4
christina.d
2 years ago
A
adzsmith162Beginner
asked in Code & Webhooks
How do I add an activity to the HubSpot contact timeline from chatbot data?

Hi all, I’m using ‘webhook catch’ to post data from a chatbot into Hubspot but we have a lot of returning customers so ideally I need an activity to be posted in the contact timeline when any updates are made/posted like they would if a change was done manually Can anyone advise?

2
A
2 years ago
J
JLCNew
asked in How Do I
Can't set up zapier to google chat

Trying to fix a broken zap and cannot for the life of me find out how to add the bot to google.I have added a connection with my Google credentials to Google Chat. However when I try to create a zap the trigger for google chat is greyed out and says “not available”. Also my google spaces don’t have a “Zapier” bot to add into.

1
GetUWired
2 years ago
J
Julien MalengoNew
asked in How Do I
Where to get the "Recipient Id" in order to Send message from page in Facebook Messenger when using Facebook Messenger as an action?

Hi, I'm trying to use Facebook Messenger as an action and got stuck on step where I must enter the Recipient Id. Here below you can see the step where I am stuck.Thank you in advance!

1
Danvers
2 years ago
D
DennisthefencingguyNew
asked in Troubleshooting
Is there a way to pull custom field data from Jobber quotes?

Greetings...I’m new to zapier and am having trouble getting specific data from a Jobber quote to Google Sheet.  I set up the zap but in Jobber we created custom fields for all quotes.  Is there a way to pull this custom field data? Thank you,Dennis

5
A
1 year ago
A
angelradvBeginner
asked in How Do I
Is it possible to send unique content in an email without the webhook action?

I have already configured the triggers I need, this is more about the action: I need to send a unique code from a list of codes in an email, this means picking the first code in the list and deleting it then including it in an email, I don't want to call an API endpoint for this, because I would have to code it and if I’m going to code an API endpoint for it, I rather modify my functions.php in my WordPress theme and not use Zapier at all. More context:I’m triggering the Zapier for the event paid trigger in WooCommerce integration. Thanks in advance.

3
A
2 years ago
A
AustHongBeginner
asked in Code & Webhooks
The transformation code from EverNote to WordPress cannot be rendered fully

I used Zapier to generate new blog in WordPress from very new note in EverNote. The text part are fine, but the image items don’t work, and the images don’t appear in WordPress blog. I look at the transformation code of image as an example<a shape="rect" href="https://d2908q01vomqb2.cloudfront.net/fc074d501302eb2b93e2554793fcaf50b3bf7291/2022/07/13/A-well-architected-pipeline-can-improve-the-modularity-security-and-governance-of-your-deployments.jpg"><en-media alt="AWS X-Ray helps developers analyze distributed applications, such as those built using a microservices architecture" width="1664" height="952" hash="251b20a09bbf5e0a44915d8b9d5d4891" type="image/jpeg"></en-media></a> This cannot be rendered by WordPress until I manually make small change with img and src<img src="https://d2908q01vomqb2.cloudfront.net/fc074d501302eb2b93e2554793fcaf50b3bf7291/2022/07/13/A-well-architected-pipeline-can-improve-the-modularity-security-and-governance-of-your-deployments

4
A
2 years ago
B
bryanhjNew
asked in Troubleshooting
SMTP Erroring Out when signing in

I’m trying to sign into the gmail server (smtp.gmail.com) with TLS on, port 587. I keep getting the error in the attachment or another similar (request timeout on port 465, etc). I’ve verified login info. I can’t turn off “less secure app protection”. I’ve tried different ports, verified my IMAP was turned on. Also tried filling in the “from” address with the same email.Ideas?

1
christina.d
2 years ago
W
Walking ComfortBeginner
asked in Troubleshooting
Files Uploaded to OneDrive using action in Zapier are losing their File Extensions

Hello, I am using Zapier to upload files into OneDrive. This is a switch from Google Drive which we were using previously. I am noticing that whenever the upload action is taken, the file extension is lost and OneDrive and Windows interprets these as the “File” file type. Google Drive would preserve the file type when uploading, but OneDrive does not seem to. Is there anyway to conserve the file extension so when it is emailed to other people, they do not have any issues opening it. I have tried manually appending .jpg or .pdf to the end of the filename in the OneDrive step configuration, but this just gives me an “Access Denied” error. Attached are screenshots showing what I am talking about.  

11
S
1 month ago
A
AdamZapBeginner
asked in How Do I
How can I create a database of Zaps in Notion?

I am trying to create a database of my zaps that I created which would make it easily searchable (this would be in notion). I am wondering if there is any sort of “when a new zap is created” and I would send the information to the database?

1
nicksimard
2 years ago
I
Ink Factory StudioNew
asked in How Do I
Create Quickbooks Estimate - keep Amount field blank for certain line items?

Hello!We have a pretty static menu of services and products at our company, so our salespeople ultimately end up creating a lot of identical estimates in Quickbooks. We’re trying to automate this process to more easily generate our most “basic” proposals using a completed Asana task as our trigger.So far so good! Our formatted line items are working pretty seamlessly, but we do have a few line items in our estimates that we intentionally don’t apply a cost amount to (things that will be adjusted later on, or terms and conditions that don’t have a cost association).Via a Zapier integration, the default for an “empty” Amount field is to input “0.00”. It’s a required field for each line item, so we can’t exclude it. Is there a way to assert that these should stay blank? Or to delete the 0.00 after the estimate has been created (via integration, not manually!) Please let us know what other info we can provide!

1
Danvers
2 years ago
J
jadjugahBeginner
asked in How Do I
How do I create a Jira ticket once ConnetWise ticket reaches certain status

Am creating a Zap, what does the   Specific service ticket filter and project filter means. Am connecting Jira with ConnectWise. I want to create Jira ticket when the ConnectWise ticket gets to a specific status.

1
christina.d
2 years ago
M
msclBeginner
asked in Code & Webhooks
How to authenticate with Cloud Firestore REST API via Webhooks

Related to this question: ^ Zapier doesn’t seem to support updating just documents in Firestore, only Firebase (doesn’t make much sense to me as to why) and because of that, I need to write a custom webhook to do the update. That step in my zap makes sense and should work fine. However, before that can happen I need to authenticate and get a bearer (oauth) token to then authorize that PATCH request, but I can’t figure out how to do this within the context of a zap.All Google docs point to needing a running web server environment of some kind so you can execute the gloud CLI, or use custom code to generate a JWT which obviously isn’t possible here (and I’d prefer not to standup a cloud function to call out to, etc). So I guess the question is: I’d like to, within the context of a Zapier Webhook (so some kind of HTTP request), get an oauth token for a service account I have in GCP so I can authorize my Cloud Firestore REST API request. Is that possible given Google’s current REST APIs an

0
M
2 years ago
G
GreatnessNew
asked in How Do I
Tracking Zapier Short Link Clicks

Hi there,Does anyone know if there is a way to track the number of clicks a Zapier short link receives? Trying to gather that information within Google Analytics 4 but nothing appears to be showing up.

1
Troy Tessalone
2 years ago
S
synapticleeBeginner
asked in How Do I
How do I send each phone number a unique message in Twilio + Google Sheets?

Hi, I have a pretty simple workflow but I can’t understand how to implement it. I have a google sheets with two columns, Phone number, and Message. I want to loop over all rows and have Twilio send each phone number the corresponding message.The other question here is similar but I don’t have enough context to implement it:First of all, “find rows” seems to require a value to find a row, and I don’t need to subset it by any specific value. I just want the rows. “get rows” is confusing because of the output of the function. I want it to “get” separately the phone number cell, and the message cell, so that one can go into the “recipient” of twilio, and one can go in the “message” as a variable. I think it requires some fancy line-item formatting but I don’t understand how zapier does this. Thank you!

4
christina.d
2 years ago
C
Chuckademis30TGRCNew
asked in How Do I
How can I keep original OneDrive file formats when uploading to MS Outlook?

I created a trigger to upload a file as an attachment to an email in outlook as soon as it is downloaded into a onedrive folder, when it uploads the file it changes it to a txt file on the outlook email. How do i keep it as the original file type i.e. a pdf or word doc?

2
jesse
2 years ago
A
al2022New
asked in How Do I
How to delete Slack Messages triggered by a Zap?

I accidentally created a trigger that was too sensitive and now I’ve flooded my slack channel with hundreds of messages made by the zap. How do I delete all of the messages?

3
Troy Tessalone
2 years ago
S
SkilldomNew
asked in Troubleshooting
Getting an Error 1045 : When connecting MySQL

Hi,We’re trying to connect MySQL for creating zap between MySQL and Sendgrid. We created an user by granting all privileges for accessing to the MySQL but here in zapier when we try to connect zap, it is throwing some error. Could you please help us with resolving the issue, here we’re attaching the screenshot of this issue for your reference.Thank you 

2
jesse
2 years ago
J
jonmrichNew
asked in Code & Webhooks
Using randomUUID() in Zapier to generate UUID

I'm using Zapier's code module to write some Nodejs to generate a UUID.I know that I can use node's crypto "library" because I've used it in the past to hash some text (MD5) to send to an API endpoint. I also know that I can use the crypto function randomInt.For example, the following will correctly without errors return a number in the stated range:```const crypto = require('crypto'); let num = crypto.randomInt(1, 7);output = [{id: num}];```When I try to use the randomUUID function (documentation), like the following, I get the error "TypeError: crypto.randomUUID is not a function" from Zapier. Their logs are showing  that the code step cannot find `module 'uuid'`:```const crypto = require('crypto'); let uuid = crypto.randomUUID();output = [{id: uuid}];```I almost gave up there, but tried one last weird thing:```const crypto = require('crypto'); let uuid = crypto.randomUUID; //changed thisoutput = [{id: uuid}];```Note that I removed the `()` and this didn't throw an error and returned

1
GetUWired
2 years ago
C
Christian HomiBeginner
asked in How Do I
Extract Text from Email without parsing

Hi, within the text below I want to extract:1. the 5-digit code after the string ‘homi.one ‘, i.e. 123452. the mobile number i.e. +3069xxxxxxxx3. the first name Jane4. the surname DoeThe text is the body_plain of text extracted from Gmail for enquiries from customers.The order of info should remain the sameHow can I do this? I am using the text formatter, and I think I may need to use the extract pattern, or split text, but not sure where to go from there.Any help would be greatly appreciatedI have tried parsing, but I had a LOT of trouble, and the parser was always getting it wrong. Body_plainVisit request for the following listing.# homi.one 43866Suburb (Region)Property 41 m<sup>2</sup> for sale€42,000https://www.site.com/abcI really like this property.Please send me more information.It will be me and my two dogs. Jane Doe+3069xxxxxxxx (All day)abc@defg.hij 

3
jesse
2 years ago
M
matt19New
asked in How Do I
How can I record a message on a Salesforce contact when a message is sent in Skipio?

Anyone familiar with Skipio? I would like to know if i send a message via Skipio will Zapier be be able to tell Salesforce a message has been sent on a contact.. Thank you for your help!

2
M
2 years ago
B
BrunoleclercBeginner
asked in How Do I
How can I transfer information from HubSpot to Google Sheets for reporting?

Hello,I have some small problems to set up a ZAP, I am open to all ideas. I would like to feed a report on Google sheet, so only numbers...From Hubspot, and every week get me the numbers (for example : new incoming contacts, those who have gone through some phases of the pipeline…)I started my zap with a "Schedule by Zapier" running "every week" Then I log in to Hubspot, then I use "Get Deal in Hubspot", I then block in the configuration to turn them into numbers... and select the correct phase of the pipeline.Thanks !

3
christina.d
2 years ago
Terms & Conditions