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.

25177 Topics

T
Trying to Male Things WorkNew
asked in Troubleshooting

Memberpress Error - Transaction Subscription

I have MemberPress and Zapier connected. I’m able to create memberships and transactions just fine. The ONE issue I am facing is that the subscription IDs are not being passed on in either the create or update transaction actions in Zapier. Everything else is created or updated just fine. But this one issue is preventing the subscriptions of being recognized as active. 

2
Danvers
1 year ago
A
AlaloBeginner
asked in How Do I

How do I create a new opportunity in Sellsy from a form submission on my website?

Hello,I have an issue :I need to create a new opportunity in Sellsy from a form submission on my website.I think Gravity forms is the plugin that would suit better my need but I’m not sure. I cannot test it.What settings can I make connecting Gravity forms and Sellsy ?Can I set up the name of the opportunity created ?Would the fields (mail, phone etc.) will automatically fill the Opportunity created ?Thank you :)

13
C
2 years ago
J
junNew
asked in How Do I

How to trigger for specific phrase in Intercom then create/reply to ticket in Zendesk?

HiWe are looking to create a new Zap with the following scenario.Customer talks to Intercom chatbot “I want to raise an issue”, then the conversation would be converted into a new ticket in Zendesk. Customer talks to Intercom chatbot “I want to see my ongoing tickets”, then he can see Zendesk ticket status in the Intercom chatbot Is this something we can do with a Zap? Thanks!

4
SamB
Community Manager
3 days ago
A
Anonymous
asked in How Do I

Salesforce and Constant Contact email list sync - how many tasks?

I want to set up a sync between Salesforce and Constant Contact and vice-versa. Here is the SF to CC sync criteria:IF contact is in SF AND Active is checked AND Email Opt Out is unchecked AND Mailing list has a particular value THEN Add contact to a predefined mailing list in Constant ContactHere is the CC to SF sync criteria:IF contact is in Constant Contact AND Status is equal to “Unsubscribed” AND Contact exists in SF THEN Check off Email Opt Out field in SFHow would these tasks get calculated if I have 4,000 active contacts?  I suppose the first pass is one thing, then it’s just occasional passes as contacts are added or unsubscribe.Any help is appreciated.  Thanks!

3
A
2 years ago
S
SHIORINew
asked in Troubleshooting

Cannot get attachment from Slack message

precondition・Email linkage to the email address issued in the slack channel <call it A>.What I want to do1. <slack>  A is notified to slack2. <Zapier> when A is notified, retrieve the contents of the email in the slack's message3. <Zapier> take action according to the content of the acquired emailPROBLEMIn step 2, I cannot retrieve the contents of the email.I have read some help and understand that I can get it if it is an "indented type attachment". However, if it is a "non-indented type of attachment", can I not get the ATTACHMENT?It is good to know if it can be acquired or not.If it cannot be obtained, I will try to achieve it in a different way (a little more difficult). Thanks

2
nicksimard
1 year ago
I
IBERIARECNew
posted in Troubleshooting

Facebook Lead Ads Error: Failed to create test lead for the specified leadgen form

Hello, I am having problem with creating the zapFailed to skip testing for Facebook Lead AdsError while retrieving: Test Lead Creation Failed. Failed to create test lead for the specified leadgen form I have done the form 3 times and not working. Thanks for the help

1
christina.d
1 year ago
A
alexadagostinoBeginner
asked in Code & Webhooks

Issue with Monday Get Item by Column Value in monday.com

Has anyone experienced this before. I am trying to pull in Monday data into Zapier so that I can update fields in Monday when someone reschedules. So to break it down:I have the Monday Reschedule function. I then have 3 checks using Get Item by Column Value in monday.com (three different databases) to see if the person exists in any of these databases.  What I am finding is, for some reason, even though I am clicking a specific reschedule appointment In the “get Item by Column Value” it’s actually pulling the completely wrong person making it so I cannot do proper checks to get my zapier to actually launch.What I DO find though is if I get it to launch, it WILL run right but just not during the test. Anyone else experience this? ​​​​​​​ 

2
Troy Tessalone
2 years ago
F
Fahad.SBeginner
posted in How Do I

What are the Best Courses/Ways to become a Zapier Expert

Hey guys, I’ve been doing a lot of soul searching for the past 2 years with different skillset to see what I like doing the most and I finally figured out that I am the most happy/content when I create automations, I love doing them and it is so much fun.Anyways I have decided to fully focus on marketing automation,  am quite familiar with Zapier and have done numerous basic to mid tier automations for organizations I work for and few clients I have, but nothing advanced, so I wanted to know from fellow Zapier experts here on how you guys became experts and what is the best way to do it.

0
F
1 year ago
Adeliand
AdeliandBeginner
asked in Troubleshooting

When MS Excel receives the information, it stores it as a string and not the usual “48587” format it uses to store date data.

Hello all,  I have a problem sending dates to an Excel spreadsheet, which would later be used as data for a pivot table. I have an app that sends infos such as date and time of delivery, and I know how to format this incoming data to something Excel can understand, such as 30/11/2022 (I work from France where date formatting is different).Problem is, when Excel receives the information, it stores it as a string and not the usual “48587” format it uses to store date data.It eventually means that my pivot tables don’t work the way I want them to, as I can’t sort anything by dates (Excel has an option to sort by “last month”, “next week”, etc that I want to use).  Bottom point is, Is there a way to make Zapier send dates data in a way Excel would recognize instantly ? like the 45848 or whatever ?  Thanks a lot!

4
Adeliand
1 year ago
O
OrangeHatNew
asked in How Do I

Spotify to Radio.co integration error

HelloI am trying to set up a Zap so that when I add a new track in Spotify, the track is added to my Radio.co account but I receive an error each time. The Radio.co account is fully subscribed.I get the following error:Got 400 calling POST https://studio.radio.co/api/v1/zapier/stations, expected 2xx.Any ideas?Thanks.  

2
AndrewJDavison_Luhhu
3 years ago
E
ericgTinkerer
asked in Troubleshooting

Trouble Using INDIRECT ROW Method to Insert Dynamic Formula with VLOOKUP

I’m hoping to use INDIRECT and ROW in a formula to get around the fact that new rows do not copy down formulas. I was able to get this method to work for one formula but I have another formula that it’s not working on. No error is given, just a blank value.=IFNA(VLOOKUP(INDIRECT("D" & ROW(),'Shipped Orders'!B:X,23,FALSE),""))I’ve tried it every which way with no dice. Any formula pros know what’s going on?

6
E
2 years ago
N
nickfNew
asked in Troubleshooting

How to post Jira comments to another app

Hi,We’re building a Zapier app which requires Jira task updates to contain the latest comment field in the payload on a Jira Software Cloud > Updated Issue Action. I can see this issue has previously been raised, but without any resolution: Please can someone from the team push this forward. Thanks, Nick

2
christina.d
1 year ago
T
TaxprepperBeginner
asked in How Do I

Remove line items from imported .csv

Hi,I receive a daily .csv report in Gmail then use Zapier to create a task in ClickUp for each line item in the report.My issue is that some line items in the .csv don’t require a task to be created. So I’d like to filter those out prior to creating a task in ClickUp.My questions are:Can I remove line items meeting a certain condition after step 2 below? Can I add a filter step to the loop without prohibiting the loop to execute for the remaining line items? 

1
Troy Tessalone
2 years ago
M
micahsaBeginner
asked in Code & Webhooks

Remove specific tag from customer and leave the rest

(This is a follow up question to the thread found here:  Remove tag from Shopify customer once membership canceled | Zapier Community) I want to remove a specific tag from a customer and leave the rest.  I have the following setup action and code:When testing the code, it works if the tag I want to remove is the first in the list. However, if the tag not first, it doesn't remove the tag, and leaves all of them in place. Result attempting to remove Tag2 (doesn’t remove tag):Result attempting to remove Tag 1 (DOES remove tag): So what am I doing wrong? 

2
M
2 years ago
J
JLOBeginner
asked in How Do I

automatically forward to matter gmail/clio

Hello,  Has anyone come up with a way to automatically forward email replies to Clio matters? Clio provides maildrop addresses for each matter that allow the user to send or forward emails directly to the matter. When I send an email regarding a case I CC the maildrop address so that the matter receives a copy. I'd like to set up a zap so that the response is also automatically sent to the matter. I could also include the maildrop address within the body of the email.  I played around with it a few months ago but got busy with other things. I think there's probably a way to do it with mailparser, but I did have much luck. Thoughts? Thank you. 

3
Danvers
1 year ago
K
Kevin WatheyNew
asked in How Do I

Zapier -> Google Sheets

I have a zap setup to update a google sheet (Sheet A) when a sale is made, and then within Google (Sheet B) I pull data from Google (Sheet A) but when the zap triggers it adds another row to sheet B for some reason so the data cant be pulled (i.e. row 18 to row 18). Did I set this up wrong?? How would I fix it?

6
william
2 years ago
J
JohannaNew
asked in Troubleshooting

Freshdesk empty values

Hi,I want to integrate Freshdesk tickets/ contacts into Active Campaign. However when i take “ticket created” as a trigger start, it does not send along the Requester E-Mail, which is definitely not Null nor empty.  Anyone having the same problems? Thanks,JOhanna 

2
chanelle
1 year ago
B
BookSmartsNew
asked in How Do I

Run a Zap for existing customers (not a New customer trigger)

Hi I am just starting out with Zapier and have successfully created a Zap to set up a Google contact when I add a new Customer or Lead to my Method CRM app.  I would like to know if I can have this Zap (or a copy) run once to pick up all of my existing customers - i.e. there is no “trigger” as I have not created a new Customer or Lead in my CRM app.  So I’m basically looking for a one-time import to set up all of my existing CRM contacts in Google Contacts.  Any suggestions?Thanks!Michele

1
Wemakefuture
3 years ago
E
erincottNew
asked in How Do I

Shopify open order report to Monday (with updates)

Hi! Ultimately, I’m looking to automate a weekly report process I do in Shopify. I think my first question is can I create a zap that runs on a timetable (Daily, weekly, monthly, etc), rather than based on an action in another app? I’m assuming not, so my more realistic question is below: Currently, I go into Shopify to run an open order report, generally for the previous 7 days. I then export this to Excel (bc that’s the only option) and copy/paste it into Google Sheets (bc that’s what my org uses). From there, I use the data to highlight any overdue unfulfilled orders for our operations team.  Overall, I would like to create a zap that pulls new orders as they are created from Shopify to Monday, but then also update the line item as the order is fulfilled. With this, I can set an automation within Monday that says once an item has a status of fulfilled, to move the item to another group/board.  Additionally, a good percentage of our orders have multiple items on the order and having

2
chanelle
1 year ago
LukaBazooka
LukaBazookaBeginner
asked in How Do I

Is it possible to delete a Digest completely?

Still kind of on the topic but my question is, how do you completely remove the Digest that has been created? So it doesn’t show up on the Digest list at all. I have created some test Digest names and would like to get rid of them.

2
LukaBazooka
2 years ago
M
MratioTNew
asked in How Do I

How do I automate creating a project and adding a client as a guest in Asana when they purchase in Stripe?

Hey all!I would like to create the following automation but I can’t seem to figure it out, so I hope I could get some help.It goes as follows: Client onboards with us (purchase is made in Stripe) A project gets automatically created with their company name The client gets automatically added to the project as a guest via their emailThat’s itI’m not 100% sure if it’s currently possible with Asana. But I’d love to get some advice on this. Thanks!

3
SamB
Community Manager
2 months ago
R
rolfweimarBeginner
asked in How Do I

Attachments in Facebook Messenger

Hi. Sometimes people send pictures to my facebook page’s inbox. How do I set up a zap to automatically download those pictures to my google drive? Thanks,Rolf

7
nicksimard
3 years ago
T
TowerjasdesignNew
asked in How Do I

Zapier WordPress Activation Problem

I am unable to connect WordPress to Zapier.The Zap: Upload new media from WordPress into a DropBox/Google Drive folder.When activating the Zap I receive an error message: Error parsing response. We got: " <!DOCTYPE html> <html> <head> <meta http-equiv="Content-type" content="text/html; charset"You should try reconnecting your WordPress account!When trying to reconnect the WordPress account I get this error message:We hit an error adding your new accountauthentication failed: Error parsing response. We got: " <!DOCTYPE html> <html> <head> <meta http-equiv="Content-type" content="text/html; charset"Make sure you click "Allow" or "Accept" on the permission popup Double check your Account has the correct permissions Check out our help docs for more informationI’ve searched through the web as much as I can and have only found one other similar instance:  But still proved to be unsuccessful. Support would be greatly appreciated thanks.

3
AndrewJDavison_Luhhu
2 years ago
W
WebigailNew
asked in How Do I

How to trigger Zaps on Jira for only certain issues using JQL?

Hello,  When I try and create a Zap for Jira I have a ‘Update’ as a trigger option. Is it possible to trigger only for certain types of issues? I don’t see any option to trigger on an update using JQL. I can see a Create option to use JQL. Thank you

1
M
1 year ago
J
Jungle FeedBeginner
asked in How Do I

How do I update the tracking field in monday.com to find and update the order in WooCommerce?

Hello, I would like to transfer the tracking number listed here : When I change the status of the Tracking Update field. So far I have only managed to update the latest Woocommerce order. This means that every time I change the status of the Update Tracking field, it is always the same order that updates and not the corresponding one on Monday.Here are the blocks I used:  Anytime a specific column value changed in board is created in monday.com > Find order in WooCommerce > Update order in WooCommercehttps://zapier.com/shared/mondaycom-to-woocommerce-woocommerce/c930da5a8e0df91cd3493835b7dfd387db37085b Could someone give me a little help? 🙂

2
D
1 year ago
Terms & Conditions