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

20260 Topics

cineag
cineagBeginner
asked in How Do I

How do I assign promo codes on Google Sheets when a tag is added to a contact on Keap Max Classic?

I have a google sheet with several rows of unique promo codes listed. When a tag is applied in Keap Max Classic, I want to assign one of those promo codes to that new contact by:adding the contact’s email address in a cell next to the promo code (using the next blank cell available) then zap that promo code to custom field in Keap I’m not seeing how to do #1. How do I update a row based on the first row in that column being empty?

3
cineag
7 months ago
onlywallets
onlywalletsBeginner
asked in How Do I

Data schema mapping issues in Updated Spreadsheet Row in Google Sheets -> Update Product in WooCommerce

Trigger: New or Updated Spreadsheet Row in Google SheetsAction: Update Product in WooCommerceI’d like to update my WooCommerce product catalog whenever there are updates to the Google Sheet containing the product catalog.I’m running into issues while trying to map the schema of my sheet to WooCommerce, specifically the attributes columns.When I add my attributes, instead of treating them as separate attributes, it aggregates all the columns into a single attribute.Weirdly, this doesn’t happen when I insert multiple metadata columns.Any tips? 

3
Troy Tessalone
7 months 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
7 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
7 months ago
DR.Mohamed
DR.MohamedBeginner
asked in How Do I

no reply label in zapier mail which sent to customer

Dear I’m using Zippier Email in Zap which send email to lead generation as action from new lead Facebook triggering  but the mail is label with noreply@zapeir after sending  so i need support to remove this noreply in zapeir email which sent to the lead generation  Br, Mohamed 

1
Troy Tessalone
7 months ago
Maiden Gully Hall
Maiden Gully HallNew
asked in How Do I

Zapier user needing guidance

How do I connect Skedda to Quickbooks online so that I can send an invoice instantly for a casual user and quarterly for regular users?

1
Troy Tessalone
7 months ago
JortArie
JortArieBeginner
asked in How Do I

Applying a Date / Time Formatter to Line Items > not skipping null items

I am using Zapier to send a Gravity Forms trigger to Airtable. The Gravity Forms form is used to receive up to 9 meeting dates + meeting topics. Each of these meetings should become an individual record in Airtable. The form has the following fields that are read as line items:DateStart timeEnd timeTopicThis list repeats 9 times in the Gravity Forms form.Users can decide how many meetings they want to register, i.e. they can fill in 3 dates, or 9, or 1, etc. Second stepThe second step in Zapier (after pulling in the data) is a Line Itemizer. This works like a charm. Third stepThe third step is combining the date and start time and converting this to the format Airtable can read. This data is later used to create new records with a Date and Time field in Airtable. Resulting in: Problem statement: Now all of a sudden the date input reads “now”, instead of the blank or null it was in the second step. According to this help article, this is a common problem: When a valid date cannot be par

7
JortArie
7 months ago
Bruncher
BruncherBeginner
asked in How Do I

How to schedule to execute a custom query

I want to schedule once a week to execute a stored procedure -  custom query - in MS SQL. By using the Schedule by Zapier, after adding the MS SQL, it only gives option for inserting lines, but not for executing a procedure.What is the easiest way for doing that?

3
nicksimard
7 months ago
K
Kate4604Beginner
asked in How Do I

Google Sheets > ActiveCampaign: How to not lose information if multiple entries for one email address

This is quite long-winded, so bear with me please! I have a Google Sheet that it is being automatically fed into with parsed data (from forms being filled out on a 3rd party site)eg.  Email  Name   Phone Number   Product   Size   Message I then want to set up a Zap to bring that information into ActiveCampaign (I’ll set up custom fields for product, size, message etc). That’s simple enough. However, there is a high chance that one person, with the same email address, will fill out 2 or more forms on the 3rd party site, with different product, size info, thereby creating two or more rows in the Google Sheet.  As the Zap runs it will bring the first row into ActiveCampaign and create a contact with that information and custom fields. But, when a new row with the same email appears in the GSheet, the contact in ActiveCampaign will update with the new, updating custom fields, losing the data from the first row in the GSheet. We want to keep all the information from every time the form is c

9
nicksimard
7 months ago
sadidrahimi
sadidrahimiNew
asked in How Do I

How do I include Gmail filters to add a new row on sheets with only specific words?

Hey all,  I couldn’t find this anywhere on Youtube or here When I don’t include any filters, my spreadsheet row is updated perfectly fine But when I’m trying to filter out words that indicate interest from prospective emails, nothing shows up E,g “setup a time” “demo” “interested” to name a few  I even used Google’s reference of “ “ but to no avail  Here’s what I have typed, and I’m using the simple Gmail to Sheets template Thank you in advance!  

5
Troy Tessalone
7 months ago
TK1970
TK1970New
asked in How Do I

IVR +++

Hello, i’m not even sure if i am in the right place for this question - but here it goes.   I need a system (similar to a banking system) where clients call in and input information through a phone keypad, i need to acknowledge that information, verify it, and ask for a security code; if both answer match what i already have in my database, i will give a specific message to the customer, if not, i will give a different set of voice instructions. Does anyone know how i can get this done?  Am i in the right place?  Been looking online, Asterisk, … and i can’t find anywhere to start. thank you.Tony

1
Troy Tessalone
7 months ago
VictorN
VictorNNew
asked in Troubleshooting

Zapier is incredibly slow, ~30% of actions do not complete

There a few concerns about zapier performance here and there on the forum and community managers politely respond that “team was notified”. I want to share my experience. Things are way beyond “everything is slow” and more in “I am not sure it is working”.I am a paying customer and I am starting to think I should do my automations in Airtable as much as I can, because Zapier is not just slow, it is flaky. Here is a loom, note all the errors in the console.   

1
Troy Tessalone
7 months ago
meghasaraswat.com
meghasaraswat.comNew
asked in Troubleshooting

Expired Connection Issue in Zapier

Hi, I am connecting Zapier to Salesforce, and after some time, it is disconnected again and again. I have connected the account multiple times but still, it is showing Expired Connection.Please assist.  

3
Troy Tessalone
7 months ago
Ribby
RibbyBeginner
asked in Troubleshooting

Failed to create a task in TickTick. The app returned ‘5yhrnlg6@ck-build’

Hello there,I’ve successfully created a zap that adds tasks to my TickTick when they’re created in ClickUp.  I’m now trying to create a zap that marks tasks complete in TickTick when their status changes in ClickUp.  When testing the action, Zapier attempts to create a new task to test the action on, but I get a “Failed to create a task in TickTick. The app returned ‘5yhrnlg6@ck-build’.”  Another post on here alludes to a similar problem with Notion and the solution was to add an additional step to find the Task ID. I attempted to do that by having ClickUp find the Task by ID, using the Task Name as the ID, but get a “Failed to find task in ClickUp, The app returned ‘Team not authorized’”  error message.  Not sure what next steps should be, but any advice would be so appreciated! Thank you! 

3
Troy Tessalone
7 months ago
C
chriswrightBeginner
asked in Troubleshooting

Zapier is creating a duplicate Notion column property when updating database item

I have a simple Notion database. One column is multi select with a bunch of options to select (lets say, Red, Blue Green). I am using Zapier to update an item from having one entry (Red) to having Blue as well. I update the item in Zapier. I add the existing tag using a prv ‘Find Notion item’ step. But when I add the second entry (Blue), by typing in ‘Blue’ I hit a problem.In my notion table Zapier has created a new property called ‘Blue’ even though there is an existing one with exactly the same name ‘Blue’.Any ideas?

4
christina.d
7 months ago
arimeisel
arimeiselNew
asked in How Do I

How to separate text based on word count or character count

I want to be able to give zapier a large amount of text and have it break it down into 4000 word chunks, there doesn’t seem to be a way to split by word count

4
shalgrim
7 months ago
wbayer1800
wbayer1800Beginner
asked in How Do I

Creating Jira Cloud Epic from SF Opportunity updated field. How to send record field info from SF to Jiras epic fields

I am trying to create a zap that creates a jira epic from a SF opportunity via a custom field being updated. My goal is that once this field is updated to “Yes” in SF, the zap will create a jira epic that houses some of the SF Opportunity fields into custom fields. For example, Opportunity Name > SummaryOpportunity URL > Salesforce Opportunity (CF in Jira)Account > Salesforce Customer (CF in Jira) Can this be achieved all within 1 zap or a second zap will need to be created?  Any help would be greatly appreciated!

4
shalgrim
7 months ago
F
FahadBeginner
asked in How Do I

How do I delay of 15hrs of business days only

I would like to add a 15 hr delay to Zapier, but I want the delay to follow a business day, so if zap runs on Friday night, then the delay would be released on Monday not Saturday.How can I do that?

8
shalgrim
7 months ago
chrisrmor
chrisrmorNew
asked in Code & Webhooks

The app returned "JSON parse error - Expecting property name enclosed in double quotes: line 1 column 2 (char 1)". (HTTP Status Code: 400)

Hey All - Trying to POST raw payload. I keep getting this error. When I attempt the post in postman, the outside system gives me a positive response. When I copy the payload into Zapier, I keep receive the same error. Any help would be must appreciated.{ "leads": [ { "first_name": "Chris", "last_name": "Morgan", "email": "email", "phone": "phone", "address": "address", "unit": "", "city": "Lexington", "state": "KY", "zip_code": "40511", "avg_bill": 180 } ] }

3
Troy Tessalone
7 months ago
archiescraper
archiescraperBeginner
asked in Troubleshooting

Failed to create an upload file in Amazon S3: [Errno32] Broken pipe

Hello All,I need some help on a project I am working on.I am trying to upload a file generated in Octoparse to my S3 bucket.What is my key? Isn’t it the folder and a file name inside a S3?In my case I want to upload the file to a source=test inside my raw folder as a test.csv inside my S3 bucket.Is the “raw/source=test/test.csv” correct then?When testing the action I am getting error 32 broken pipe.I was able to upload the file successfully to my Dropbox.Any suggestions? Did anybody encountered this error when uploading to S3? Is there a solution?

3
Troy Tessalone
7 months ago
I
Intelife FormsBeginner
asked in How Do I

Import whole input table from Jotform

Hello,Wondering if there is a way I can do the following:1. Obtain the full input table from a Jotform submission (not the arrays of text, but the full table with questions)2. Paste the whole table into a PDF document with pdfFillerIf this is not possible, is there a more efficient way of doing this without having to manually add a fillable text field into pdfFiller for each input table array?Thanks.

2
chanelle
7 months ago
TheRaceway
TheRacewayNew
posted in Troubleshooting

A business validation error - Select an account for this transaction. But this is not a field I actually see in Quickbooks

While connecting my zap for quickbooks online to create purchase orders based on a form filled in on my website, it has a whole section of fields that I never see what I manually create a PO in Quickbooks. One of these fields is the account field.  Even If I select one of the options zapier found from quickbooks, it still gives me the error when I test my zap.   I would assume quickbooks would be confused why the zap is sending data that it doesnt usually ask for but why would zapier think its needed?  If a select an options from the account field I get this errorFailed to create a purchase order in QuickBooks Online A business validation error has occurred while processing your request: Business Validation Error: Select an account for this transaction. If I leave this field blank I get this error Failed to create a purchase order in QuickBooks OnlineRequired param missing, need to supply the required value for the API: Required parameter Line.AccountBasedExpenseLineDetail.AccountRef i

0
TheRaceway
7 months ago
Kavya
KavyaBeginner
asked in Troubleshooting

Zoho Creator error: We're having trouble loading 'Form' data. Cannot read properties of undefined (reading 'map')

Hi, I have connected my zoho creator account and selected the application. But it is not loading existing forms. It throws an error - We're having trouble loading 'Form' data. Cannot read properties of undefined (reading 'map').Can I understand what is the issue and how to solve it?

4
christina.d
7 months ago
I
imagineertobeBeginner
asked in Troubleshooting

How to preserve line breaks

I have a Zap running that takes a web form submission (from WPForms), creates a new row in a Google Sheet and then uses those cells to create both a Google Doc and a draft email in Gmail.One of the form fields is a long text box that allows line breaks. I have confirmed that the data sent to Google Sheets contains the line breaks, and these are preserved when the Zap sends the data to Google Docs. However, the line breaks are deleted when creating the draft email in Gmail.I have the format type set to “html” but can’t figure out why Zapier is deleting line breaks here. Any thoughts?

6
shalgrim
7 months ago
Digital Agency
Digital Agency
asked in Troubleshooting

Trying to change status of Monday.com lead if they are registered to our Eventbrite event

Hi all,Really hope that this one can be solved 🤞We have a form setup on our website which collects relevant lead information, when the lead submits their information, they are then sent to our Eventbrite page to register for their tickets to come to one of our events. The initial form fill is sent to Monday.com, however once they have gone to Eventbrite and got their ticket, I would like to have a status column in Monday named ‘registered for event?’ changed to ‘Yes’, so we know that the user has registered and got their tickets. Currently I am struggling on the final step, I have a 3 step process in place which looks like this:  However, the last step only works if the Item ID is an exact match to a specific item. This is essentially contradicting what I would like to do, as I would like the second step to match the field (using the email) and then this third step to then find the correct item to update, and then updating the status value to ‘Yes’  Has anyone come across a similar se

10
chanelle
7 months ago
Terms & Conditions