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.

25517 Topics

J
JinX ClarkNew
asked in How Do I

Excel to Trello Checklist

I am attempted to create a checklist in a Trello card from a spreadsheet, using the line items as the items to be added to the checklist.  Currently, it is working but Trello is creating a separate checklist for each item. Is there something I am missing to be able to create a single checklist from the line items?

2
Troy Tessalone
2 years ago
P
podcastpartnershipBeginner
asked in Code & Webhooks

Troubleshooting Webhook POSTING to Flask Server

I am trying to use my Flask server to receive webhooks from a Zap, but getting an error when I test: Traceback (most recent call last): File "/usr/local/lib/python3.9/dist-packages/flask/app.py", line 2073, in wsgi_app response = self.full_dispatch_request() File "/usr/local/lib/python3.9/dist-packages/flask/app.py", line 1518, in full_dispatch_request rv = self.handle_user_exception(e) File "/usr/local/lib/python3.9/dist-packages/flask/app.py", line 1516, in full_dispatch_request rv = self.dispatch_request() File "/usr/local/lib/python3.9/dist-packages/flask/app.py", line 1502, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)TypeError: receive_webhook() missing 1 required positional argument: 'request' Here is my handler for the webhook:@app.route("/webhook", methods=['POST'])def receive_webhook(request): print(request.json) return request.json It seems like Zapier is calling my handler with no argument. Shouldn’t i

2
P
2 years ago
R
ratibNew
asked in How Do I

How to equally distribute leads to Salestrekker?

Hi Everyone How do I EQUALLY distribute gravity form leads to salestrekker via zapier? Example: If my website generates 10 leads today, they go to saleskekker via zapier to 2 different person and I want them to go in equal like 5 leads each  How can I put this logic in zapier to distribute equally?TIA 

2
Troy Tessalone
2 years ago
K
kialikhon4e4Beginner
asked in Code & Webhooks

How to pull Python code from a GitHub and reformat it for Google Sheets?

Disclaimer: I am not a coder...I've tried researching how to do this on my own, but I'm too far out of my wheelhouse to figure it out. So, I'm hoping someone can show me how to use the Python actions inside of Zapier to automate a repetitive task.The Goal:I want to be able to pull the data of "new move-ins" to the area from my church's website (name, address, phone, etc) and have it put into a Google Sheet, so I can keep track of efforts to welcome them. I know how to set up everything in the Zap, except for the Python actions that pull the data from the site and then formats it the way I need it for the spreadsheet.Someone has already coded a way to pull the info I want using Python, and posted it on GitHub here: https://githubhelp.com/SpencerMKSmith/LCR-APIIt says: To Install, Run:pip3 install lcr-apiUsage:from lcr import API as LCRlcr = LCR("<LDS USERNAME>", "<LDS PASSWORD>", <UNIT NUMBER>)months = 5move_ins = lcr.members_moved_in(months)for member in move_ins:

2
K
2 years ago
M
mensirfrasum34New
asked in How Do I

How to search on a field that may be empty?

Trying to sync up a postgres record to airtable on create/update. The field has a couple of ids that I would like to check for in airtable to determine whether I should create a new record or update an existing one. The first id (optional_id) I need to search on can possibly be null. This causes the search to fail before it can get to the other id(required_id) that should always be populated. Is there any way I can skip the initial search for optional_id if it turns out to be null in postgres?My current outline is as follows: 

2
Troy Tessalone
2 years ago
C
CouparioNew
asked in Code & Webhooks

Custom response to Webhooks or workaround

Hello everybody, as far as I can see, there is currently no option to customize webhook responses. I want to connect the adyen notifications with an app, but adyen requires an [accepted] string.Is there any plan to implement this in the near future? If not, is there any workaround solving this problem? I saw, that this was also a closed request one year ago and quite a few others requested the same feature. Any updates? Thanks!

2
Troy Tessalone
2 years ago
P
Pierre CoutarelNew
asked in How Do I

Problème Tâche Zapier

Bonjour, Suite à un bug de Pipedrive, j’ai 300 tâches automatisables qui se sont déclenchés le 13 février à 4h du matin sur Zapier. Pipedrive m’a évoqué qu’il s’agissait d’une erreur de leur part mais ils ne peuvent rien faire pour moi pour mes tâches Zapier. J’ai fais un mail au support mais j’attends une réponse de leur part car mes zaps ne fonctionnent plus. Cela vous est il arrivé ? Comment avez vous résolu ce problème. Je vous joins un screen du problème.  

2
Troy Tessalone
2 years ago
S
Sacha.adsNew
asked in How Do I

Zapier : JotForm > Google Sheet problem

Hello, I have a problem of integration between Jotform and Zapier.I connect my Jotform account to Zapier, I pull data with trigger, I create my zaap properly then I test it and everything is working, my data loads on google sheet. However, when I do a submission on my Jotform’s form, I don’t see any data in my Google sheet. Zapier seems not noticing that a form has been submit in Jotform.I saw that other people had this problem but I don’t find the solution, do you have any ideas ? Thanks a lot,Sacha

2
Troy Tessalone
2 years ago
C
conbonNew
asked in Troubleshooting

Mention a twitter user when they follow me

Im tryin to get a zap so that when someone follows me on twitter, I tweet something like “@user123 just followed me, thanks!”  But i every time i do this, it leaves out the “@” sign, meaning the user wont be notified about it.  Any ideas here? Im using the `follower screen name` field as the tag. I even tried manually putting an “@” sign before the screen name field but it just removes it. 

2
jesse
2 years ago
A
Amir Digital MarketingNew
asked in How Do I

Possible to connect social platforms to Google Sheets or Google Data Studio?

I’m a digital marketing and i need to create 1 report with all social media platform like Snapchat adsTiktok adsFacebook Ads Google Ads  I need all this platform to send data to google sheet or google data studio Any help in that or suggestion under budget 

2
Satya09
2 years ago
L
Lori A.New
asked in How Do I

Creating my first Zap

I am really struggling with setting up my first Zap transferring data from SmarterSelect to Salesforce. I am have tried and tried, but it’s not working properly. Is there anyone willing to jump on a zoom call w/me to review my work? I would greatly appreciate it! You can contact me at xxx or via telephone at xxx. Thank you, Lori A. 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.  

2
rachael.silvano
2 years ago
T
TristenNew
asked in How Do I

Adding New Trigger for Submittable

Here at the City of Reno, we're considering purchasing a company Zapier plan, but before we do we'd like to make sure it would work how we want it to. I'm trying to create a Zap that will edit a Google sheet once a specific answer to a question is submitted in a Submittable form. The purpose of this functionality would be to notify a department once a submission comes in that involves them specifically, based on the answer to a question.As far as I can tell, there are no trigger options available yet that are dependent on specific questions. Perhaps if this feature were added or I could find it, senior management could be convinced to spend money on the zapier subscription. Please let me know if this is something that can be done, or where my best path for assistance is! Have a great rest of your day everyone,

2
T
2 years ago
T
Timyr82Beginner
posted in How Do I

Need a Zapier Pro to help transfer data from emails to vTiger and Google Sheets

Hi!I have typical data in Inbox (Gmail). Need to trasfer it to CRM vTiger Leads and Google Sheets.The price is negotiable

2
Troy Tessalone
2 years ago
J
JacoNew
asked in Code & Webhooks

How to use webhook to create Jira tickets?

I want to create a new Jira issue from a triggered webhook.How can I use the request’s body fields to customize the new jira issue?For example: The weebhook request body contains the property `plan_name` and I want the issue name will be `plan_name`. Thanks

2
christina.d
2 years ago
M
madeWORKSHOPBeginner
asked in Troubleshooting

Issue with Looping running out of sequence

Could anyone explain to me why my Zap appears to be processing items out of sequence when looping? I’m feeding the Looping action an array of data in a specific order, each item then looks-up an Airtable record and creates a new row on a Google Sheet using that info. The array of items are being received in chronological order according to the ```date``` attribute, but are getting created out of order in the spreadsheet. Attached screenshots showing the loop iterations and the output in the spreadsheet.  

2
M
2 years ago
J
JoelMalissaNew
asked in Code & Webhooks

Feature Request: Strava activity calories and kilojoules

Just started using zapier and I almost love it.  Is there a way to pull calories and kilojoules from Strava when I post a new activity?  I checked the Strava API, and it's provided by the GetActivity function, which zapier might already be using for the other stats that can currently be pulled via zapier.

2
christina.d
2 years ago
J
jamesross135New
asked in How Do I

Add Google Contact and then Assign to a Group

Hi all,I’m really struggling to get this to work. I am trying to add a contact to Google Contacts and assign it to a group. I can get the contact into Google Contact no problem, but the add to contact step doesn’t work. I have read some other posts on this and I believe I am doing it correctly, but for some reason the test doesn’t work.   I use a custom with the ID from the second step. Any ideas would be most appreciated.  

2
J
2 years ago
J
JlordNew
asked in Code & Webhooks

Is there a phone number I can call to talk to a higher level support or even a supervisor?

I have lots of issues with Zapier and the support agents I had email exchanges with just stopped replying. Tony then Maggie, then Dave. We just upgraded our plan to a higher tear and this is the kind of support we are getting? WORST!!   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. 

2
nicksimard
2 years ago
R
RussBeginner
asked in How Do I

Multiple “Sales Tax Abbreviation” possible?

I’m setting up a Square → Wave integration, and in the “Sales Tax Abbreviation” section I’d like to include two sales taxes -- city and state, which I’ve set up in Wave. Is this possible?

2
R
2 years ago
J
James HillNew
asked in How Do I

Convert Currency IF . . .

We are importing USD ($) and GBP (£) invoice data from Scoro to a Google Sheet. If the invoice values is $54,000 then Scoro exports it as 54,000. If it’s £54,000 it exports it as 54,000. What I want to do is to divide the value by 1.4 (our GBP to USD exchange rate), *IF* it is a USD value. We have a column which details ‘USD’ or ‘GBP’. Any thoughts?

2
Troy Tessalone
2 years ago
R
Rachel HNew
asked in How Do I

Trigger test not showing in Mailchimp account

Hello! I have my zap set up so it sends a facebook lead to my mailchimp to become a subscriber. When I test the action I do not see the trigger test email in my mail chimp account. the zap says it’s working but it’s not showing up in mailchimp.

2
R
2 years ago
C
CredenceBeginner
asked in Troubleshooting

WordPress authentication failed “403 Forbidden: Access Denied” error

Getting this error when trying to connect my WordPress. We hit an error adding your new accountauthentication failed: 403 Forbidden: Access Denied. Please see common causes and fixes for 403 errors at https://zapier.com/help/doc/common-problems-wordpress#403-forbidden-error.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 information NO i am not using Jetpack or any other plugin that would block.I am using PLESK for my server.What permission popup is it referring to? I didn't see any popup.

2
SamB
Community Manager
2 years ago
A
Agiel MitchelNew
asked in Code & Webhooks

Monday.com Board ID not found with Python code step

I’m trying to access a board’s ID through Zapier’s code (Python) action.The Python code that checks the type of issue (as a status) and links it to an ID that will be used to assign the issue to a board based on the linked ID.When I do this, I get the ID just fine, but the problem is that Zapier’s Monday.com system isn't recognizing it. There should be more columns, but there isn’t. With code, and broken columns.How it SHOULD look, based on the structure of the actual board. The IDs are the same, but it’s not coming through. Is this a Zapier limitation, or is this a problem on my end?

2
A
2 years ago
M
mikegriefkeyBeginner
asked in How Do I

How to save PDF version and replace existing files in Google Drive?

Hi, I’ve got questions about how to do 2 different things in Google drive:I’m generating a Google Doc from a template, and this part I have working fine. However, what I really want is to generate a PDF from the template. I know that I can just use a different URL for the resulting document to get a PDF version of the Google Doc, but how do I actually save the PDF version of the file into the same Google drive folder? I occasionally recreate one of the Google Docs to incorporate changes to the template, and in the situation where the result doc already exists (same file name), I want the new file to simply overwrite the previous file, as one would expect to happen. However, what happens instead is that a new file is created with the same name, and then BOTH files are in the folder, which is stupid. Is there a way to check if the file already exists and delete it first? I don’t see any “delete” action on the Google connectors.Thanks for any help!/mike

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

How to transfer data from website to white label SaaS platform?

Hey y’all,I am new to Zapier and wanted to understand which tools I need to use to complete website to website data transfer.  I have purchased a fintech SaaS via white label and the UX is just ugly. I am looking to create a more beautiful and user friendly version but still need the white label’s functionality.  Which tools can I use in a membership only back end to transfer data from a website that I own to the white label SaaS platform.  Do I need to build a custom integration?

2
J
2 years ago
Terms & Conditions