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 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.

25013 Topics

A
abrow214Beginner
asked in Troubleshooting

Zapier Formatter for spreadsheet-style formula is not working

I am losing my mind a bit with this one and I am hoping someone can help!I am using a spreadsheet-style formula with an ‘IF’ statement to get my output.What I am trying to write is: If the discount % value is null, then put the discount value, otherwise, take discount % divide it by 100 and multiply it by price). The part I am having trouble with is the multiple it by price. For some reason, if the discount % value is null, it is taking the discount value and multiplying that by price?? I have tried so many different variations of this I cannot figure out why this is happening: Here is my statement:IF(“Discount Percentage”=””,Discount,Discount Percentage/100*Price)I have also tried putting brackets around the false statement component to ensure Discount doesn’t get multiplied by price, alas, it still does!IF(“Discount Percentage”=””,Discount,(Discount Percentage/100*Price)) 

5
A
1 year ago
P
Praveen.reguriNew
asked in Troubleshooting

Marketo Static error: "Unable to load choices"

Hi All,We are trying to add a lead to  Marketo Static list and when trying to configure the zap, we are seeing the below error when fetching the static list information. “Unable to load choicesWe're having trouble loading 'List' data. The app returned `{"message":"{\"requestId\":\"d732#1849ff08157\",\"success\":false,\"errors\":[{\"code\":\"606\",\"message\":\"Max rate limit '100' exceeded with in '20' secs\"}]}"} What happened: Executing triggers.fetch_lead_lists.operation.perform with bundle {"message":"{\"requestId\":\"d732#1849ff08157\",\"success\":false,\"errors\":[{\"code\":\"606\",\"message\":\"Max rate limit '100' exceeded with in '20' secs\"}]}"} Console logs: ` as error, which we cannot read.” Can we limit the number of lists fetched. Thanks and RegardsPraveen Reguri

2
Danvers
1 year ago
M
Mitchell ZezimaBeginner
asked in Code & Webhooks

Webhook GET - List all clients from CRM, how do I filter records?

Hello,I am running a Webhook GET request which displays all clients from my CRM (Servicem8), however Zapier only returns the first record.How do I filter the records based off a a certain UUID that is contained in the record?p.s - Im not a programmer of Zapier expert, im trying to create an automation for my plumbing business which I have been trying to do for weeks, as it will save us so much time! I finally thought I had sussed it but now come across another stumbling block. Thank you 

5
Troy Tessalone
1 year ago
G
gnarlyjeffNew
asked in How Do I

Is there a way to parse text without using email parsing?

I need to parse authentication codes and their original recipient addresses from the gmail inbox they are forwarded to. I tried using the email parser, however this can only extract the text body and not the recipient information. I also cannot forward the inbox to a parsing inbox, since auto-forwarding is already being used on it for another purpose. I used the “New Email Matching Search in Gmail” which already extracts the “To:” address, but cannot parse the email body. Is there a Zapier extension that I can send the text body to and have it extract the code? 

2
Danvers
1 year ago
J
James PowellNew
asked in Troubleshooting

Memento error: “App not found.”

Good Morning I have set up a ZAP using my companies outlook account using Memento database and it is confirmed as connected and i run a test and enverthing runs fine. However when i got to run it form memento nothing happens and i get an error “App not found” in the zap history.If i link this to an individual outlook account it seems to run fine. Also i am attaching a PDF document and when the e-mail is recieved it is in a unrecognisable format.Would appreciate any help from anybody as it would be a good help to get this working.

3
Danvers
1 year ago
Z
ZenboothNew
asked in Troubleshooting

Using webhooks and changes to the HubSpot authorization

This post was split from   Hi @christina.d I contacted Hubspot support and asked them a similar question.  For native Hubspot integrations, no changes are needed, but if you are using webhooks inside of Zapier to communicate with Hubspot, those will no longer be supported post Nov 30.As we are using native webhooks inside Zapier for Hubspot, this is of concern to us.  It appears that Hubspot will require OAuth authentication, but I am not seeing how to change to OAuth inside of the Zap -- it only list “Basic Auth” as an option.Can you advise?Thanks.

1
Danvers
1 year ago
A
academiakilimoBeginner
asked in How Do I

How to delay pulling data or refresh it after it’s been pulled in Notion?

I am currently using zapier to create new database entries on Notion, pulling data from another database on notion.ProblemWhen a new database item is created in mi first Notion database a tag is added AFTER the new item is created. SO when the zap fires the new item does not have the tag assigned yet. I created a delay in the zap, but I do not know how to tell zapier to refresh the lead data to check for the new tag AFTER the item is created. SO when the zap fires the new lead does not have tag yet therefore mya zap doesn’t run. I created a delay in the zap, but I do not know how to tell zapier to refresh the lead data to check for the new tag.  Its a similiar problem to the one answered in this next post, but I couldn’t solve it in this case. 

5
Danvers
1 year ago
K
KittyCBeginner
asked in Troubleshooting

Discord Pings have stopped working?

Omg I messed the the title and can’t change it now - it’s discord PINGS have stopped workingI’ve been using Zapier to send notifications to my Discord server for I think over a year now, and I use @here and @everyone tags to get everyones attention. In the last while, the notifications have stopped pinging people. The tag still shows it like it has tagged everyone, but it’s not highlighted and it’s not making a noise for anyone: I’ve tried checking permissions and checking the tips for formatting, but everything seems to be as it should be? The bot has premission ot @ mention everyone, so I’m not sure what the issue is. I feel like something must have changed with either discord or zapier in the past few months for this to stop.Some screenshots of my integration: 

4
Danvers
1 year ago
E
EnderNew
asked in How Do I

Custom fields are not visible in Invoicde.com flow.

Hello everyone,I am planning an integration with Invoiced.com. I cannot see the custom fields I created on Invoiced.com on the zapier action.1 - There are custom fields I created for Customer.2 - There are custom fields I created for Invoice.I need urgent help on this issue. Thanks in advance for everything.

1
Danvers
1 year ago
L
LMVBeginner
asked in Troubleshooting

When creating a test it won't let me connect new offers in Kajabi

I am new to using Zapier and would like to create a workflow for my online products. I watched the videos on how to create a workflow but still getting stuck. I would like to connect my Shopify to Kajabi when they make a purchase/cancellation. When creating a test it won't let me connect new offers..Can someone please help! Thanks.

6
L
1 year ago
C
charlyargNew
asked in How Do I

WooCommerce to Zoho -> New Order: Invoice, Update Stock for all items

I’m trying to figure out how Zapier can help me integrate WooCommerce with Zoho (Books, inventory).This is a new website, with a new Zoho installation, and I haven’t bought the Zapier WooCommerce plugin yet (I understand that will be a requirement to start the testing)My intention would be to: When an order is marked complete, create a new invoice in Zoho (Books I think, probably Invoices) If 1) is possible.. Does that additionally discount stock for the line items? If it doesn’t, is there an additional Zapier to update the stock for each product in the order?Thanks a lot! 

1
C
1 year ago
H
HuntyjobsNew
asked in Troubleshooting

Error whem I'm trying to login on my laptop

HiI have an issue when I’m trying to log in on my Zapier account.I’m getting the following error, and I don’t know if it’s an error associated with my laptop’s MAC address or anything else.  I really don’t know what can I do.I am able to log in using another laptop but I can’t using mine.Thanks in advance for any help you could provide.

1
nicksimard
1 year ago
A
Anonymous
asked in How Do I

How do I create a Zap to check if a user role is assigned to a specific user in Discord?

I am looking for a way to create a zap that will check if a user role is assigned to a specific user in DISCORD.

1
nicksimard
1 year ago
copypastedan
copypastedanNew
asked in Troubleshooting

Unable to notify new Twitter followers using their handle

Hey everyone, looking for a bit of support. I want to tweet a new follower a message, but for some reason I can’t get it to @ them it’s just tweet their handle, meaning they will not be notified. It’s just @test instead of @test with a link to profile as demonstrated there. I’ve tested and tested over and over, and the worse thing is I’ve done this simple zap before but for whatever reason now it isn’t working 😅

1
Troy Tessalone
1 year ago
J
jordanstoichkovsmilegalaxyBeginner
asked in Code & Webhooks

Update Google Contact field with empty data

I need to update Google Contact from our CMS through Zapier Webhook. I have created the hook and sends data from our CMS. If the field is not empty it works. But if some field is empty the zap do not update this Google Contact field.EXAMPLEData in Google Contact:Name: JordanFamily: StoichkovPhone: 999999Data send from CMS with webhook:Name: JordanFamily:Phone: 0123312Result: The zap updates Name and Phone field, but not Family because it is emplty and new Contact data is: Name: JordanFamily: StoichkovPhone: 0123312Expected result is:Name: JordanFamily:Phone: 0123312I have tried Formatter step with default value, spreadsheets formulas but every time if the data field is empty (nodata) it is not send to clear Google Contacts field.

4
J
1 year ago
E
ElenibitNew
asked in How Do I

Prestashop and Sendy need to buy a Zapier subscription?

Hello, I see there is a payed module on prestashop for zapier. I need to connect prestashop to sendy.co I need to subscribe on a payed plan of zapier or I can use free plan? My shop is moving first step. Thank you

3
MohSwellam
1 year ago
N
NagamanickamBeginner
asked in How Do I

Can we restrict text field

Can we restrict User input in the Normal text field below? Please take a look at the help text, There is some value I mentioned, but I want to restrict the user if the user enters values except these.Is this possible in Zapier?Thanks in advance.

4
C
1 year ago
P
PetrugalsBeginner
asked in How Do I

Switching Off Auto Save

Is there a way to temporarily switch off auto save when building a new Zap.   I’m trying to add about 200 suburbs to the Action step with the “Or continue if”  but the process gets slower as I go along as it has to re-save all the ones I’ve just entered each time and it’s taking for ever.   Maybe the is a better way. 

2
P
1 year ago
M
Magdalena WilhelmBeginner
asked in How Do I

I get an error message when my Zap triggers, and the Zap Run is on hold in my Zap History.

I built a simple interface that has always worked.I pick up a webhook and bring this data to a card after the master task. I get an error message every time the trigger fires. In my history I see that the data record is on hold. What can I do here?

1
nicksimard
1 year ago
H
healthybeginningsBeginner
asked in How Do I

Full year history of zaps

My account was up for renewal so I searched on my account how often and where zaps were used. I could only find from the last 2 months. How do I find the full history from over the past year?

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

How do I duplicate a row in Google sheet based on cell

How can I create a duplicate row based on the number of quantities? On the attached image you’ll see that a row is created with the quantities 2. What I want to happen is create single rows showing quantity 1 depending on the quantity. In the case of this image, I want to create 2 separate rows instead of only one row with quantity 2. If quantity is 3, then create 3 rows showing quantity 1. If quantity is 4, then create 4 rows showing quantity 1. Ect. Disregard first row, that was triggered to show how I would like it to show.  Is this possible? 

6
GetUWired
1 year ago
T
Tom808Beginner
asked in How Do I

How do I transfer an invoice from Booqable to a file column in Monday.com when a customer creates a reserved order?

Is it possible to create a zap when a customer creates a Reserved order in Booqable, then the invoice is transferred from booqable to a file column in Monday.com?

3
T
1 year ago
L
lkfunnelNew
asked in Code & Webhooks

Count Line Items

I referred to your previous post about this but unfortunately it is now closed but also the code is not working.  It is returning a 0 even though the input has 3 comma separated items.Please can anyone help.Here is the code again: let items = [];if (inputData.names) { items = inputData.names.split(","); }return [{ length: items.length }];

1
Troy Tessalone
1 year ago
C
cpzapBeginner
asked in Troubleshooting

Multiple users of Chrome extension

I have a folder that I have shared with my team member (we have a Team account). This folder is full of Zaps that are triggered by the Chrome extension. I am able to see the Zaps but my teammate is not. Does anyone have any insight?

2
Liz_Roberts
1 year ago
K
kc-devBeginner
asked in Troubleshooting

Workflow Builder error: Oh no! This step contains too many fields to render properly. Visit zapier.com to set up this step

Hello, Within a Slack Workflow, I’m trying to create a new Google sheet (which works), and then update a row of that sheet (which doesn’t work). I’m using the Id from the previous create Sheet step, but it doesn’t seem to recognize it, because there are no Worksheet options for me to select from.I’ve retrieved the Zap from the trash (it seems that whenever these Zaps are created inside Slack Workflow, that they immediately go to the trash). I’ve also tried to edit this directly in Zapier, but it shows a lot of warnings, including that the event “Workflow Step in Slack” is deprecated. So I’m unable to edit here, though the current instructions on the Workflow Builder say: “Oh no! This step contains too many fields to render properly. Visit zapier.com to set up this step”. How can I move forward? Thanks!

2
Liz_Roberts
1 year ago
Terms & Conditions