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 Zapier University 101

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Popular Apps Q&A 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

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

Interest Areas User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

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

15823 Topics

L
LinkjoyBeginner
asked in Code & Webhooks

How to add multiple line items group?

Hi,I have a array of json objects something like below, "ab_rotator_data": [  {      "redirection_link": "https://www.npmjs.com/package/vue-cli-plugin-browser-extension",      "percentage": 25  },  {     "redirection_link": "https://www.npmjs.com/package/vue-cli-plugin-browser-extension",     "percentage": 25  },  {     "redirection_link": "https://kripeshadwani.com/dns-records-explained/",     "percentage": 50  }] I have tried to use Line item group but I can see only one dictionary in editor.

2
L
5 months ago
D
dl_adminBeginner
asked in Troubleshooting

Mailchimp Transactional integration fails in case of 60 or more templates

When using Mailchimp Transactional in a Transfer, the “select template” dropdown field does not get populated if there are more then +/- 60 templates available in Mailchimp Transactional / Mandrill.Zapier returns an error: “Failed to fetch choices. Please make sure all previous required fields have values. Error while invoking: Error during execution: Response payload size exceeded maximum allowed payload size (xxxx bytes).  

1
Danvers
Community Manager
5 months ago
E
ErnCosPLZNew
asked in How Do I

Need to collect data generated in a zap loop and use later in another zap

Hello!I have a multi-step looped zap that gets a list of my clients then a loop starts gets the first one, looks for their info in a database use the info to post content on a specific app goes back to step 3 for the next memberThis happens overnight. Now, what I need is to send an email hours later, during the day, to notify the member of the posted content.Question: What’s the best way to achieve this without delaying the whole loop?I thought using a sub-zap could be the answer, but a “Delay” step inside the sub-zap will delay the loop too, right? Because the main app awaits for the info from the sub-zap. Is that correct?What about “digest”? (I have never used it).Thank you,Ern

3
E
5 months ago
N
NeilTJNew
asked in How Do I

Recording Stripe gross and fee amounts in Xero

Hey folksI’m very new to Zapier and probably should play around with it more to get from crawling to walking - but I have an accounting need that is fairly urgent that I can’t work out.I have had someone set up Zapier for me to create invoices out of WooCommerce into Xero which are paid through Stripe & PayPal.What is missing though is a zap that picks up:payments that are made direclty into Stripe & PayPal without going through WooCommerce; and all fee amounts so that I can account for them in Xero.I could ask the helper to help me again but we are looking to DIY to keep our costs down.Has anyone set this up before - and are you able to share me what this looks like?taNeil

3
D
8 months ago
A
Accademia Pedagogia VivaBeginner
asked in How Do I

How to start an automation 1 time a day at midnight

Dear all,I need to start an automation 1 time a day at midnight.My need is that zapier do this thing:At midnight - 1 time a day Check the orders on my site with “pending status” Turn orders with "pending" status into "completed" statusBelow the automation outline that I created, but I had 10 orders in "processing" status and zapier turned only 3 into "completed"Thank you for your help.  

3
R
5 months ago
M
MPtrBeginner
asked in Troubleshooting

Failed to create an updated invoice in QuickBooks Online: A business validation error occurred while processing your request.

Hi everyoneI try to update an existing invoice to add new products with line item. To begin and for practice I try to change the current product by an other (eg 4Kg with 12Kg) So I use the action step (Find Product Quickbooks) ans search for “12Kg”: And then I put the corresponding product information in the Update Invoice step like this:  When I test it I get this Error Can you help me? 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. 

1
Danvers
Community Manager
7 months ago
M
mel.asselinNew
asked in How Do I

Updating WooCommerce Order Status based on WPForm

Hi, My woocommerce site offers local pickup only. I am trying to figure out a way to have the order status in woocommerce updated to “picked up” following the completion of a custom WPForm at the time of pick up. Is this possible with zaps?

2
EJR
7 months ago
Z
ZappBranniganNew
asked in Troubleshooting

HTML in my zap not parsing correctly

I have a Zap that posts from Wordpress to a private Facebook group when I create a post in WP. It posts successfully. However, within the message body of the post in Facebook, it is not parsing the HTML tags (see attached screenshot). Any suggestions? Thanks!

2
chanelle
Community Manager
5 months ago
K
KTinBK2Beginner
asked in Troubleshooting

Issue with Monday.com formatting on phone?

Hi!  I saw that there are some old posts on this topic but it looks like recently Monday.com changed so that text can be accepted into the phone column: https://support.monday.com/hc/en-us/articles/360014205860-Zapier-JSON-Formatting-Examples.  I am getting this error message when I try not mapping phone, when I try phone as raw text, and when I try phone with the instructions given on this post.  Is there maybe a bug happening? 

1
christina.d
Community Manager
8 months ago
H
HostWiseCoNew
asked in How Do I

Zap to different email addresses based on a selection in Google Forms

Hi All - We have a team that does cleaning inspections for our properties. They go to a Google Form, select the name of the cleaner that executed the clean, then conduct the inspection. We use Form Publisher plug-in in Forms, which generates a PDF and emails it to Management. I’m currently using Zaps out of my email to then forward the PDF to the cleaner, based on the Subject (e.g. Cleaning Inspection Report For Frank Ricard).The problem - while this works, based on my current Zap structure, each Forward is a new Zap, and I’m approaching my 20 zap limit. I’d like to have some sort of “if / then” but I can’t figure out how to do this. Like, “If Subject = Frank Ricard, Then email Frankthetank@gmail.com. Or if the Subject = My Boy Blue, Then email “myboyblue@gmail.com.” That way I don’t have to keep increasing my Zap plan as my cleaning team continues to grow.Any ideas on how to do this, so I don’t have to continue increasing my Zap plan?

2
nicksimard
Community Manager
7 months ago
D
devopsuserBeginner
asked in How Do I

How to convert a number to text?

I have a Google Form which has the field “ИНН” and this field can start from zero (“0”) and has a numeric format (I checked this with the Zapier ISTEXT(value) formula)But i need save this “0”I use “Lookup Spreadsheet Row in Google Sheets” action to write values to Google Sheets and after that action “0” lostBefore action:  After action:  Can you help me? What function should i use? 

4
christina.d
Community Manager
5 months ago
D
dale-dillonNew
asked in How Do I

What is the difference between Event Email and Email in my Zap field type?

Mapping Mondays to Zoho CRMHaving issues bring data across to CRMDon't understand difference between  field typeEvent Email:and Email: We are checking crm for existing email address , if not present add record in module contacts DC

5
PaulDavidson
7 months ago
S
SafeBaseNew
asked in How Do I

Zap is not properly assigning lead in Salesforce

I have a zap setup to create a lead and assign it to a specific person, but when it runs th lead is being assigned to the SFDC admin

3
Liz_Roberts
Community Manager
7 months ago
J
JT_ABCsBeginner
asked in How Do I

How do I collect or pass login information to Stripe when creating a new user?

So I’m using Stripe to take payment information for a TalentLMS monthly subscription course as well as one time sales. I’m trying to use Zapier between Stripe and TalentLMS. It looks like I have create new user, add user to the course, etc. However, at the point of adding a new user from Stripe, it’s asking for the user’s login and password information. How and where do I collect or pass that information along to Zapier? Thanks.

4
J
7 months ago
D
David OgletreeNew
asked in How Do I

Adding Multiple Google Ads Conversions from spreadsheet

I get a email every day from a CRM with a csv that includes several conversions.  Does the “Send Offline Conversion in Google Ads” action only do one at a time or is there a way to do more.  I have a Code zap that works sending just one.  

1
Troy Tessalone
6 months ago
S
sjkwapienBeginner
asked in How Do I

Connecting to a BambooHR Report

I attempted to follow the simple guide provided by Zapier, with the following directions:“Create a new report under the "Reports" tab and grab the id from the URL as shown here. “However, that is no longer how BambooHR titles its report pages.  Now it’s done via <uniquename.bamboohr.com/reports/custom/<reportname>/id# but when I enter the ID #, it tells me the report isn’t found.  Presumably, because the format is no longer functioning?Any advice for how to get the report to actually pull would be great!

3
christina.d
Community Manager
7 months ago
E
Eduardo13Beginner
asked in Code & Webhooks

How to push and create a spreadsheet row(s) in google sheet only if a value is present?

I have set up a catch hook in webhooks by zapier from our ecommerce store to a google sheet (Create Spreadsheet Row(s)) and in between created a filter action to only continue if a variable exactly matches a specific name. The problem is that with our ecommerce store users can buy different products at once and the way it is pushing to the google sheet is that if that value exists, it pushes all of the other values too. But what I basically want to do is to only push to the google sheet rows that contain the filter and to disregard everything else. I thought of adding a second action filter and a second spreadsheet row(s) in google sheet but it is still pushing all the variables that if the filter exists, pushes everything into the google sheet. How can I get through this?  

2
jesse
Community Manager
6 months ago
A
agarbreBeginner
asked in Code & Webhooks

Parse JSON data coming from PULL

 I’m getting the following data from an API[ [ { "keyword_data": { "id": 657125, "name": "abarth 124 spider review" }, "positions": { "2022-08-11": 3 }, "positions_mobile": { "2022-08-11": 4 } }, { "keyword_data": { "id": 657126, "name": "abarth 124 spider price" }, "positions": { "2022-08-11": 5 }, "positions_mobile": { "2022-08-11": 7 } } ]] and I was wondering if there’s a way to turn this into a google sheet with columns likekeyowrd_data positions date positions_mobile date   abarth 124 spider review 3 2022-08-11 4 2022-08-11                I’ve been trying to parse the data through the CODE step but I’m not being able to get the correct code.I was wondering if this is something you could help me with? Thanks  

2
A
7 months ago
X
XsourceITBeginner
asked in How Do I

How do I select a table when connecting JotForm to SQL when no table is available?

Currently using Jotform to capture information for 3rd party database.The configuration between Jotform and SQL via Zapier has been done.  Currently face a challenge when selecting a table the is No choices available.  Could someone please assist if they have had this challenge before and what needs to be done next.  Please  Thank you

5
R
5 months ago
A
Amrita_BhagwanNew
asked in How Do I

How to create job post (custom type post)on wordpress by email parsing?

Hi all,I want to develop a job board website. I want specific feature in that is, job posts will be created automatically by email (Gmail) parsing.I tried Zapier, but it creates only blog posts.These job posts are custom type post and not the regular default blog posts on WordPress.Is there any way to parse the email data and create a new job post? Please help me to resolve this issue.

2
A
6 months ago
K
KBarlageNew
asked in How Do I

Microsoft Teams and SolarWinds Service Desk Integration

I would like to use Zapier to integrate Teams and SolarWinds Service Desk. I have setup Teams using New Channel Messages as the trigger. SolarWinds Service Desk is configured to Create Incidents as the action. The issue I am finding is, SolarWinds Service Desk has a required field for “Requester’s Email Address”. None of the data options available to pull from Teams populates the users email address. How would I go about getting the users email address from Teams data?

4
christina.d
Community Manager
7 months ago
M
MondayMavenBeginner
asked in How Do I

Is it possible to use Zap to build a file in Dropbox?

Hi,I am attempting to use a Monday.com Item status change to trigger a folder being set up in Dropbox.  (I think I have gotten this far)  I would also like that folder to be created from a “folder template” that we have built. And for the file names to be updated depending on the name of the top line folder - which is determined by the Monday.com item name.   I am not sure this level of automation is possible.  If so, is there a video of the build process?  Thank you in advance for your brilliance.  

4
M
6 months ago
D
DragomirBeginner
asked in How Do I

Custom Field not available for card creation

Whenever I’m trying to push a new card in to Trello I cannot populate my custom field.My idea is to push google calendar start & end times of events into cards.By default the ‘Start’ is available, I created the ‘end’ but I cannot seem to be able to populate it.

3
Paolo
5 months ago
R
RussellHBeginner
asked in How Do I

Create New Invoice In Quickbooks Online -- Location field doesn't work

I’m using Zapier to generate QBO invoices from Shopify orders. Everything is working well, except that I cannot get any data to populate in the “Location” field of the QBO invoice, which I need for tax tracking. 

2
R
7 months ago
R
rada2647New
asked in How Do I

Connect two boards in Monday.com?

Can I connect one monday.com board with another monday.com board. What I want to do is the following. When a new item is created in board 1, I want to look for the item by ID in board 2 and then make a change in a status. Please let me know if this is possible. 

1
chanelle
Community Manager
5 months ago
Terms & Conditions