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.

25761 Topics

Dan0nator
Dan0natorNew
asked in Code & Webhooks

issue passing variables to python

I have a zap that processes json data into a python script. when I assign the input data you can see that there are null values in the string. This is good and expected, but when it gets to the code the null values are removed. I have tried replacing the “,,” values with “,null,” but because the “,,” values are stripped out before the code runs this does not work. I think this is an issue with the code functions in zapier.  

4
Dan0nator
1 year ago
gses
gsesBeginner
asked in Troubleshooting

Zap editing with new Trello custom fields does not work

Hello all,I have a problem with editing the zaps if in the meantime new custom fields on Trello should be integrated there.Example:I have a zap that triggers “card moved to list” on Trello and then sends an email automatically via Outlook.If I now want to add something to this existing emailtext and for this want to use a new custom field on Trello, which I have created in the meantime, Zapier does not find this field to use it in the text.If I create a new zap, then it works. However, I would like to use it also in the edit function.Can someone help me?Many greetingsAlex  

9
SamB
Community Manager
1 year ago
dandotson
dandotsonNew
asked in How Do I

How do I extract and store email recipients from multiple lines using Zapier Table or email Parser?

Hello there!  Pretty new to Zapier.  I have a Zap that takes a new email message, pulls the sender, recipient, subject, etc, and inserts that info into a spreadsheet (Smartsheet).  The mailbox that it is pulling from has multiple SMTP addresses assigned, so the recipient part is important.  I have stored all of these SMTP addresses in a Zapier table along with the “Pretty” name of the recipient.  For example, “sales-sandiego@contoso.com” would be in the Table with the “Pretty” name of “San Diego Sales”.  I’m using a Lookup to get the Pretty name and insert that into the Smartsheet.  Here’s my challenge. I’ve found that actual SMTP address might end up in the CC line, or even in the BCC.  So my v1 Zap has a lot of Paths.  If the Lookup for the recipients in the To: line returns false, then it does another lookup for the CC: line, etc.  It’s working, but it seems I could clean it up.  My thought for to make this a little more elegant would be to store all recipients in the TO: and CC: li

2
SamB
Community Manager
10 months ago
Rightway Recruitment
Rightway RecruitmentNew
asked in Troubleshooting

Problem with Ninja Forms multiple checkbox field only sending single option over to Google Sheets

Hi I am having problem receiving multiple options selected during filling form. but when receiving in google sheet only 1 option is getting registered. plz guide me what i am doing wrong, already spent 4 hours of searching answer on youtube/google/help forms on zapier and ninja form without any success 

1
Troy Tessalone
1 year ago
I
IsraphilNew
asked in Troubleshooting

Custom Acton Discord "Unhandled variable found in the domain filter `{{process.env.BASE_URL}}`."

Hey guysBeen trying to use the last custom action feature to create a zap where “when a message is posted into X channel, automatically create a thread message linked to it”Here it what it looks like :  But when I try to use it in my zap, i get the messageUnhandled variable found in the domain filter `{{process.env.BASE_URL}}` Which I don’t understand :( I’m unfortunately no developper my knowledge stops here.Can you help me figure out what is happening?Here is what the zap looks like; the first 2 steps are working fine, it’s when I add the last one (the custom action) that I get the error :   

15
ken.a
8 days ago
darylweston
darylwestonBeginner
asked in Troubleshooting

Zapier ChatGPT generating short articles due to timeout

So I am new to user Zapier but seem to understand its limits so far. I am having ChatGPT generate an article barely only a second paragraph, its hitting a brick wall. This is within only 30 seconds or so also.I keep getting was_cancelled false not true as I have read many times that would show timeout, it barely runs more then 30 seconds most times and whether it says true or false, either cuts off the response and then retries to ask again sometimes 3 times. It seemed to work at first and now giving multiple errors like this one. Whether I use ChatGPT3 Turbo or ChatGPT4 with massive amounts of tokens currently with ChatGPT3 I use 3800 or more. It cuts off and does this weird retry and gives me 3 outputs instead of giving me one long output.Could you help me with understanding why this is, is this a Zapier limitation hit or OpenAPI limitation?

8
Troy Tessalone
8 months ago
FlyingLenz
FlyingLenzBeginner
asked in Troubleshooting

Field missing from lead connector create opportunity - trigger is Acuity

I want lead connector to create an opportunity from a booking on Acuity. Most of it is working the way I need, but I am baffled as to why lead connector is not returning these fields:opportunity value opportunity name statusIs there a reason that these fields would not come back from lead connector to Zapier so that I could populate and set the status when an Acuity booking comes in?

14
SamB
Community Manager
4 months ago
A
Allen121Beginner
asked in How Do I

Best way to create a new Opportunity in Salesforce from Google Sheets

I’m looking for the best way to have Zapier look for a new row in a Google Sheet and perform a few searches that will ultimately create a new Opportunity in Salesforce. My questions are: What’s the best sequencing of my steps? First find if a Contact exists? If one exists, then find an Account based on the company name? If one exists, find if there’s an existing Opportunity? If one doesn’t exist, then create a new Opportunity? What’s the best way to create different paths, depending if a Contact/Account/Opportunity exists or doesn’t exist? Thanks!

4
A
4 years ago
C
ChesterNew
asked in Troubleshooting

Zapier account reset password not working

Hi, We have multiple Zapier accounts in our organisation, and we are trying to reset a password for one account but it seems that Zapier is not sending a reset password email? Could you help us find why? Thanks. 

1
Troy Tessalone
2 years ago
F
FonsoNew
asked in How Do I

Sending a specific part of an email thread only

In relation to this post:How can I exclude the whole email thread from sending? So currently my flow is1. Slack workflow to GSheet2. GSheet to Email3. Filtered Email (from responder) to GSheet However in step 3, I’m pulling the correct email, but it sends the entire thread history- is there a way I can send only the last email received and no thread? 

1
R
1 year ago
A
Anup641New
asked in Code & Webhooks

Run large number of actions for paginated API?

When a large number of triggers or actions occur within a short time span, ... code rate limit after 10,000 requests in a 1-minute window as provided by zaiper , how we can handle this in zaiper , if zaiper unable to process 10000 actions and than next pulling happened before this

5
jayeshkumarbhatia
2 years ago
J
jazapperBeginner
asked in How Do I

How can I set a specific time with my local timezone within my Google Task action?

I am trying to use a zap to create  a Google Task with a due date and time.  In my specific example, I want a task that is due at 6:00am in my local time zone. I have Set Up Action to set Due Date to a date/time (screen shot below with relevant section highlighted). However, when I run the test case, the time is set to 00:00:00:000Z, although the date remains correct  (screen shot below with relevant section highlighted). Can anyone advise what I’m doing wrong?

2
J
2 years ago
J
jesperNew
asked in Troubleshooting

can't connect autotask account: Integrationcode invalid

when i try to connect my autotask account i get this error: integration code invalid.its not a permission issue because i tested that already.does someone know what i can try?

2
christina.d
2 years ago
B
buildersasiaBeginner
asked in How Do I

Google Docs is Not Detecting My DOCSX When Using "New Document in Folder"

Hello, I am checking out Zapier and it has been awesome. Except for one thing: I am having trouble getting my docsx detected in Google Docs / Google Drive.  Here is my setup: I have a writer that sends me 20 to 50 pieces of articles everyday (in docsx format). The way we operate is that I send him an email with the topics for each article like: Topic 1Topic 2Topic 3Topic 50.. And then he sends me back an email with the 50 pieces of articles attached into the email. I then click “download all attachments” and go into my merry way into manually posting each articles on my website. After doing this for one month now, I am beginning to think that I don’t want to keep on doing this for the rest of my life. That’s why I looked for alternatives and found Zapier, and it really solves my problem since i can even make Google Docs communicate with my Wordpress site. But the thing is, my writer doesn’t write the articles directly into Google Docs. He uses Microsoft Word on his desktop and just att

4
Liz_Roberts
3 years ago
K
kennywongNew
asked in How Do I

Help: Posting an attached photo in google form in google slides instead of text

Help! I am new to Zapier. I created a google form for users to attached photo.I setup the steps in Zapier. However, the link is posted instead as text instead of a image.I tried add ({{photo}}) but no use.  Anyone can assist 

3
Troy Tessalone
2 years ago
A
aliviacNew
asked in How Do I

How to automatically add files into the correct folder in Box from SmartSheet?

Hi All! My organization uses SmartSheet to track projects and collaborate. What we want to do is use Box as a document recepticle so that we can stop relying so heavily on email. What this means is that we want updates in SmartSheet to be reflected in Box, and viceversa. Ideally it would look like the following actions and triggers: Rows Added to SmartSheet → Folder created in Box.  This is a Zapier that I was able to successfully create. Where I’m running into problems is the below:  Files added to row in SmartSheet → Files added to folder in Box with the same nameThe reason we don’t want to link through Box directly is because we’re dealing with hundreds of files for dozens of organizations daily, and the Box integration through SmartSheet requires you to go down the folder path to choose the folder you want. We’re hoping this Zap will be able to auto-add files to the appropriate folders since we don't really reference the folders at present, but for documentation sake would be good

2
AndrewJDavison_Luhhu
3 years ago
T
TdejeneBeginner
asked in Code & Webhooks

500 error on Custom POST using formatter

I am getting 500 Internal Error on a custom POST Request to Missive   

5
Jillian
3 years ago
P
prin4700New
asked in How Do I

Append Text to Top of Google Doc

I’m trying to append text to the top of a Google Document instead of the bottom of the document.  Is there a way to do this now? 

2
christina.d
2 years ago
T
TheBengineerBeginner
asked in Troubleshooting

BOX Find a File Step Not Creating a Shared_Link

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.Previously, my BOX Find a File step would generate shared links, most importantly a Shared Link Download URL. This was a critical sub-step, as I’d then use that Shared Link Download URL to upload the file to Uploadcare (which fed later steps). I’m not sure what changed but the creation of this link began getting very inconsistent and has now stopped working entirely. It constantly says: shared_link: null And then my Uploadcare step fails, bc there is no link to upload (its looking for Shared Link Download URL which used to get created but no longer does). Am I missing something? Do I need to modify a config either within Zapier or Box? Thanks in advance,Ben   

6
H
1 year ago
A
aholubNew
asked in How Do I

Transfer Google calendar event to another Google calendar

Can I trigger on an event being added to a Google calendar, and then add that same event to a different Google calendar? I want to copy the event from one Calendar account to another. I found the add-detailed-event action, but that seems to require me to specify all event details in the action itself. I want to copy the details from the event that triggered the action. Thanks!

7
Troy Tessalone
2 years ago
T
Two Wheel CompanyNew
asked in How Do I

How do I do a gross profit calculation from Pipedrive deals and product costs from within my Zap?

Hi there.We are currently using Pipedrive as our new CRM system, and have created a custom field called “gross profit” which should be a calculation of.Gross profit = Net profit - cost of products.When connecting pipedrive and Zapier i am able to retrieve the Deal Summary (total price) of a deal. And i am also able to retrieve the cost of the associated products. For example 1000,1000,5000,300Those values should be used for making a calculations:1000 + 1000 + 5000 + 300 = 7300. And after that i can make the Gross Profit calculation:Gross profit = Net profit (Summary / total price) - the calculation.But i am having trouble on how to take the numbers, and divide them and thereby making the calculations.Can someone help on this issue?

1
Danvers
1 year ago
J
Jim RoysdonBeginner
asked in How Do I

How would you Trap Task Status's?

I have searched the community and the web for a solution to this, but have not found an answer. So I am here to see if the community can help point me in the right direction.   I have several ZAPs that connect webhooks to CRMs and ticketing systems for clients. These are simple API integrations and have no error checking. This was done on purpose.  When a ZAP fails, it shows in the ZAP history. I would like to use another ZAP to monitor those and should one be stopped with an error, then notify either me or my client with the payload from the webhook that triggered it.  Now don't get me wrong. I know the why of the failure (possible duplicates).  Let’s use SalesForce as an example. I have an instance where I can create LEADs. This works all well if each lead is new and unique. However, if a lead comes in that is similar in name or email address, that LEAD will fail to be created because sales force thinks there is a duplicate (even though it may not be). In the Task History, there is a

3
AndrewJDavison_Luhhu
4 years ago
K
kbeislyBeginner
asked in How Do I

Received a Send Data (error) but don't know what is wrong

I’m testing a new form and received this error: The record could not be sent to Salesforce.Guardian_Care_Givers__c is too long, should only be a maximum of 18 characters.Guardian_Care_Givers__c is the SalesForce API name. Is the problem that the field name is too long for Zapier?  If so, then do I need to work with the SalesForce team to rename it to something less than 18 characters?  I don’t think this is related to the data in my test run, I typed the data into Salesforce and it wasn’t too long to be accepted. 

4
Liz_Roberts
3 years ago
A
ACACNew
asked in How Do I

Adding (Google Drive) Files to Streak Box

Does anyone know if there’s a way to add a Google Drive File or Folder to a Streak Box? I’m using Zapier to update my Streak CRM. One of the issues I’m running into is linking it to Google Drive. In Streak, I typically add an attachment to the associated Google Drive Folder of the box.This seems straight forward though I’d like to automate the process. However, there doesn’t seem to be an option to to “Add File(s) to Box” in Zapier. There seems to be all the other items (comments, notes, etc) that you can append/add to a Streak Box. This is clearly supported by the Streak API (https://streak.readme.io/reference#add-files) but I don’t see this option anywhere in Zapier.

1
Troy Tessalone
3 years ago
L
LeslyCNew
asked in How Do I

Connecting Jira to Zapier when Jira uses google sign in

I am having trouble connecting Zapier to our jira instance because when it asks for login information it tells me that my credentials are incorrect, but I think this is because we go through google to log into JIRA? Can someone help me figure out how to connect Zapier to my JIRA while using my Google login? :) 

2
jesse
3 years ago
Terms & Conditions