About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Get Help

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

25190 Topics

A
ATree121New
asked in Troubleshooting

assigning discord roles to twitch followers

Hello, I’ve been trying to make it where whenever someone in my discord server follows me, it says it in my general chat and then give the person a role. But everytime I test the discord part of it, it says that something went wrong. How do I make it check the person’s connections and add the follower role if they have the twitch account that just followed me?

1
christina.d
1 year ago
Jirina
JirinaBeginner
asked in Troubleshooting

Failed to create a text transform in Formatter by Zapier: The app returned "Unknown Function: SEARCH"

I am looking for a solution to replicate this formula in Zap (Formatter > Text > Spreadsheet-Stype Formula): =IF(ISNUMBER(SEARCH("VP",F1)),"Vice President")Any help would be greatly appreciated!

3
Brem
1 year ago
R
Ranilynch11Beginner
asked in How Do I

How to create a Zap that adds phone numbers and emails from Google Contacts to Follow Up Boss regardless of type?

I am trying to send NEW google Contacts or Updated info on contacts to Follow Up boss- but follow up boss isn’t fully relevant here. When I add a google contact from my desktop it always has type- so mobile is usually the default- that’s fine. BUT when I add from my iphone it is undefined - this presents an issue creating a zap for phone number or email when the types are always different. I can’t seem to figure out how to make sure the zap just ADDS A PHONE NUMBER and EMAIL Period! 

6
Troy Tessalone
8 months ago
Mavent
MaventBeginner
asked in Troubleshooting

Is Zapier ever going to fix their Clickfunnels 2.0 integration issues?

This is an issue that has been common knowledge for months now- Zapier won’t connect with Clickfunnels 2.0.  We’ve been told several times that it’s been submitted as a “feature request” (whatever that means), but nothing appears to be happening.  Can we just get a straight answer on if Zapier is ever going to support it?  If the answer is “no”, just say no, so those of us who are waiting on it can find a different solution.Thanks!

4
christina.d
10 months ago
E
elizabethm42Beginner
asked in Code & Webhooks

Prevent Zap API Request Fail on http 204 return from Google Group Member Delete

I have formatted an API Request step in Zapier to delete a member in a Google Group.The Delete request works, but returns an error (Raw request failed.). I know that the request is returning an http response of 204 (success). There has to be a way to handle this without having to upgrade my account just to ignore failure messages.Anyone solve for this or something similar?

9
E
9 months ago
Mommy n Me Wellness
Mommy n Me WellnessBeginner
asked in How Do I

Create an Automation when an appointment is rescheduled in TidyCal?

I’m trying to trigger an automation when someone reschedules in TidyCal but the only options are cancelled, new booking or new contact.  I use the appointment date/time and URL in an email that I send through Active Campaign but I can’t get the rescheduled information. Am I asking for the impossible?  

11
shalgrim
7 months ago
BenBen25
BenBen25Beginner
asked in How Do I

How to create WooCommerce users from Salesforce Lead to Account Conversion?

We will be obtaining leads from various places. When our sales people go through the vetting process of our leads , and determine they are to be converted to Account. That trigger we would like it to take those details in Salesfoce and create a new user account on the ecomm site , thus sending them a welcome message to click a link to define their username & password of choice. Double opt in.   

21
SamB
Community Manager
7 months ago
0th
0thNew
asked in Troubleshooting

Discord attachments are joined together.

Hey, I just started using Zapier, and I have a problem involving attachments posting on another discord Server. When Zapier webhook posts a message from another channel it gets tangled up and joined, so attachment url doesn’t work and it doesn’t show as intended. I need help with figuring that one out, thanks.   Attachment webhook message, works when I post only one image to the 1st server, but with two or more images it ends up like that, linked together.    My Zapier settings. 

3
ken.a
11 months ago
H
hyltonNew
asked in Troubleshooting

Error: Could not create record of the "Contact" object: Record Type ID

I’m trying to add a new contact into Salesforce and keep getting this error:“Could not create record of the "Contact" object: Record Type ID: this ID value isn't valid for the user: 0123i000000EBnnAAG” Can someone please help me troubleshoot this?

5
Troy Tessalone
1 year ago
P
PBFNew
asked in How Do I

Updating between Google Sheets and Looking Up Tabs

 How do I make the following happen?I have a Google Sheet “X” that is shared by others and is updated every week with new tabs.I would like to be able to search “X” to find the new tab and search the rows to find “words” and when it does find it output the row into another Google Sheet that is just for my reference.The “words” will appear up to 6 times and I would like for this to run once a week.Is this possible?TIA!

3
SamB
Community Manager
1 year ago
D
DorbsNew
asked in Code & Webhooks

Convert JSON data from Webhook into individual items

I get the raw body from the webhook that looks like this in Zapier:raw_body{"employees":[{"changedFields":["Home Email"],"fields":{"Home Email":"test@icloud.com"},"id":"239"}]}headers__content_length111headers__content_typeapplication/jsonheaders__http_content_length111headers__http_cloudfront_viewer_countryIEheaders__http_x_forwarded_port80headers__http_via2.0 bd3c2afa75612aa52a66a52d84cc0c6e.cloudfront.net (CloudFront)headers__http_x_forwarded_hosthooks.zapier.comheaders__http_cloudfront_viewer_asn16509headers__http_cloudfront_is_desktop_viewertruei’d like to take the ‘employees’ json and have them as selectable fields: Home Email, Id.Is there an easy way to do that through javascript?

1
Troy Tessalone
1 year ago
sgibbs
sgibbsBeginner
posted in How Do I

Tips about Run Javascript in Code by Zapier

I wanted to share this code tidbit because it took me hours to work out what was happening. It has to do with  where the zapier Javascript is expecting semi-colons, especially in looping.My code takes comma-delimited input variables, splits them into arrays, and then puts the elements of the array back together to return JSON. Notice especially where the semi-colons are, since either leaving them out or putting them in the wrong place will cause the Zapier action to fail. Code:var descrline = inputData.descrline.split(',')var qtyline = inputData.qtyline.split(',')var refline = inputData.partrefline.split(',')let gChildren = []var i = 0 ;for(i; i < descrline.length; i++){ gChildren.push({description: descrline[i], quantity : qtyline[i], partReference: refline[i]})}return {gChildren}referring to these 2 lines:var i = 0 ;for(i; i < descrline.length; i++)Normally, in JavaScript, I would put them in one line like this:for(var i = 0 ; i < descrline.length; i++;)In Zapier, you

0
sgibbs
1 year ago
trysenberg
trysenbergNew
asked in Troubleshooting

ChatGPT Returned Image Description Discrepancy: Accurate in Browser, Inconsistent in Zap Tests with Google Drive Links

Hi all, I am trying to create a zap that takes an image link (Google Drive) and generates a description for that image in ChatGPT. When I put a prompt into ChatGPT in the browser, I get a reliable and accurate description, but when I am testing my Zap with the same prompt, ChatGPT seems to describe a completely different image, entirely unrelated to the one under the link in my prompt.Has anyone had a similar problem or know how I can solve this?Thanks all! 

1
ken.a
1 year ago
A
ac12121New
posted in Troubleshooting

ChatGPT is cutting off responses in it's outputs.

I am not getting full response, it breaks after one line. below are my settings I am using chatgpt conversation: Modelgpt-4-vision-preview User Nameuser Assistant Nametext_analyse Assistant InstructionsPlease analyze the following meeting transcript and provide the analysis in a structured JSON format. The analysis should include the following elements: 1. Emotional Tone: A brief summary of the overall emotional tone of the meeting. 2. Lead Analysis: A boolean value indicating if there is a potential good lead in the transcript ('true' for a good lead, 'false' for a bad lead). 3. Lead Details: Regardless of the lead's quality, provide details in a JSON object format, including: - Name (if mentioned) - Expressed Need/Interest - Contact Information (if available) - Additional Notes 4. Lead Reason: Provide a brief reason why the lead is considered good or bad, with relevant details or observations. The expected JSON output format should be as follows: { "EmotionalTone": "Summary of the em

1
SamB
Community Manager
4 months ago
HelloEverybody
HelloEverybodyBeginner
asked in Troubleshooting

Inventory Tracking: Shopify Orders to Google Sheets (multiple of same SKU and upsells issue)

Hey everyone!We use Zapier to link Shopify & Google Sheets, primarily for the purpose of inventory tracking as well as some forecasting.I’ve just realised (11,000 orders later - 🙃), that when a customer purchase 2x of the same SKU, it is only registered as one within the Google Sheet. If two seperate products are purchased, they are listed correctly.I then use some code to count X times certain SKU’s appear, then apply that to our inventory levels - so missing out on double orders is throwing our numbers off slightly.For reference, in Zapier, I am using “Line items SKU” to transfer this data. Would anyone know how to define how many times each SKU was purchased per order?We also use post-purchase upsell apps, which do not fire the Zap at all - if anyone knows how to solve that, please let me know!Thanks!

7
Troy Tessalone
1 year ago
Francis H
Francis HBeginner
asked in How Do I

Converting a table into Google Sheet or Excel into Google Drive

Hi, I am very new and not technical at all. However I am intrigued by Zapier, and believe that it might be able to solve my daily (manual) routine of converting a table from a daily Gmail I received to a Google Sheet/Excel. I have tried a few ways but the closes it gave me is a file name in the Google Drive. I think I failed at Identifying Data?I do not know what to input for:Spreadsheet Containing the Worksheet to Copy (required) Worksheet to Copy (required)  and the email content looks like this below:  Any assistance is greatly appreciated, thank you. P.s. I only have a free version right now as I have just started. 

4
Francis H
11 months ago
C
Colinfm88Beginner
asked in Troubleshooting

Help utilizing info from "Find User in Asana" action, specifically when no user match is found

Hi there!I’ve built a Zap that takes Typeform responses as a trigger and then, based on the content of the responses, creates Asana tasks with different descriptions, assignees, due dates, followers/collaborators, etc. One piece of this that I’m getting stuck on, though, has to do with the “Find User in Asana” action in Zapier.I’m going to spell out a lot of written detail here, but feel free to skip to the end of this post to see the TL;DR version of my question.Background/Context:In the aforementioned Typeform, we have users enter their email address. Immediately after the Typeform trigger in our Zap, we’re using the “Find User in Asana” action so we can use that info to automatically add the person who submitted the Typeform as a follower/collaborator on the Asana task when it’s created. I have “Should this step be considered a ‘success’ when nothing is found?” set to “Yes/true” so that the rest of the Zap will continue even if a user match isn’t found.However, because we’re using t

3
C
1 year ago
KrysFF
KrysFFBeginner
asked in Troubleshooting

How do I connect Persons and Deals in Pipedrive from a trigger

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.Hi all!I’ve got what is seemingly a super simple Zap set up but it just won’t connect the right information and I can’t seem to make it add up. Your help would be greatly appeciated.I have a contacts name, email, and company name coming in to a survey tool called ScoreApp. I’m using their submission as a trigger in zapier to create a Deal in my CRM software; Pipedrive.The ‘Deal’ gets created. The ‘Person’ gets created. But no matter what I try to change, the ‘Person’ will not automatically sync/connect with the ‘Deal’ in Pipedrive.I’ve tried using the Person section in the Deal to call from both the first name and the email but neither is making the connection.What am I doing wrong? 

2
KrysFF
1 year ago
Samad808
Samad808Beginner
asked in How Do I

from Lead status update in Hubspot to mail sent from Zoho mail: How I can reduce Zap task usage?

My zap Trigger is when lead status change on hubspot I want to send an email from contact owner email. But only on specific lead status not on all lead status.For that I’m using filter as well to see if lead status match with my required lead status upon which the email will be sent.As you can see in below screenshot, If also using path for selecting contact owner zoho email account so email can be send from that particular owner only with customized email template draft with contact owner detail. This means each zap is 6 tasks and eats it’s way through my allowance quicklyIs there any way for me to combine these tasks and reduce task usage? 

11
christina.d
1 year ago
AI_hello
AI_hello
asked in Troubleshooting

Extract URL from Slack message giving double URL

we have a zap that takes a pushed message from Slack, strips out the URL using the Extract URL function in Zapier Formatter & puts the URL into a google spreadsheet. mostly this is working great.however, for some of the Slack messages, it’s putting the URL twice, with a line between them, like this: https://www.google.com|https://www.google.com.this is annoying, because then the spreadsheet user can’t click on the link & the heading scraper i have in my spreadsheet won’t work.i can’t figure out how to fix it. any ideas?

1
Troy Tessalone
1 year ago
E
Etrogger17
asked in How Do I

Create a mini ecard website for our users using Zapier?

We would like to create a page that allows our audience to send a personalized electronic holiday greeting card to a friend. Kind of like our own mini e-card site for our users. The user would choose one of 6 or so cards that we design. Then the user would enter the name and email address of who they would like to send the card to and a personal message, plus their own name and email. And the card would be sent. And along the way we would ask them if they would like to sign up to our mailing list. Any idea of a workflow using Zapier in combination with other services that would allow for this to be built without using a developer?

1
AndrewJDavison_Luhhu
4 years ago
D
dnpfinancialNew
asked in How Do I

Integrating Xero and Infusionsoft for Invoicing

I am working through the zap when we create a new quote and invoice in infusionsoft and the person pays it will zap it to xero by creating an invoice and marking it as paid.   We use item codes in Xero and I am trying to figure out how to make it zap with the different one each time. My thought process is that when I setup the product in infusionsoft there is something I should be adding to trigger it for the item code.   Also we charge the merchant fee back to the customer, so I am thinking I should add that in the tax field.   Thanks in advance for your help.

1
Liz_Roberts
4 years ago
S
saroj38New
asked in How Do I

Connecting Gravity forms and zoho recruit

I have connected gravity form and zapier to create zoho recruit candidate but I have a issue assigning specific job to the newly created candidate.  

2
Liz_Roberts
3 years ago
A
Anonymous
asked in How Do I

Squarespace isn't sending client emails to strip

Hey guys I am trying to do two things, create a zap where STRIPE charges - create a new subscriber in Mailchimp then when set value charges in stripe trigger - a new subscriber is created in Mailchimp with a tag added to them- Mailchimp then will send of the automation emails I have made within mailchimp.   The issue I have is that Squarespace is not sending the client email address to stripe so I can not do the zaps? Has anyone else had this issue as I have read a few forums with similar issues and I am not sure what to do?

1
nicksimard
3 years ago
E
edchanBeginner
asked in How Do I

text file or csv to be sent as email

I have a requirement to read from a notepad text file (or a csv) to read n rows of text, and email it to an email address found on the n+2 row. How can I use Zapier for this?

3
AndrewJDavison_Luhhu
3 years ago
Terms & Conditions