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.

25450 Topics

A
acarusoBeginner
asked in How Do I

a trigger only update a row of spreadsheet Google instead of "new or update"

In order to save a number of task, the Zappier should be let to setup a trigger only when a row is updated instead of “new or updated”This zap is running to every single row and I dont need it.Is it feasible or already exists and I didnt see it? Is there any way to workaround?Tks so much I’m beginner here pls look over 

2
A
1 year ago
R
rozapetrovaBeginner
asked in How Do I

Error Message: ActiveCampaign: The app returned "Invalid contact email address".

Hello, Trying to connect Active campaign and Facebook Leads Ad. I have problem into the "set up action” part. hat email should i write into the subscriber field if it is not yet received? Tried everything already - nothing works. Nor from the dropdown menu not to write my email instead. Actually when i wrote my email it bagan sending automatic replies to me instead of to my new leads! Please help! Their support is taking forever to answer and where is no LIVE chat is just making impossible using the app especially for the first timeThanx in advance

8
R
3 years ago
A
alortiz3Beginner
asked in How Do I

How do I transfer WordPress form data to Kajabi?

I have a WordPress site with multiple forms that I would like to connect to Kajabi. Each form has unique data that should be transferred to my Kajabi site. There does not seem to be an option to trigger an action in Zapier. It appears that the only way to transfer data from WP to Kajabi is when a New User is added.Is there a way to get my forms data into Kajabi using Zapier?

7
A
2 years ago
L
luffyNew
asked in How Do I

Custom Zapier App: Lazada Open API Integration OAuth2 Authorization

Hi, I need the following Custom App Zapier Integration with Lazada Open API via Oauth 2.0 https://open.lazada.com/https://open.lazada.com/doc/doc.htm?spm=a2o9m.11193531.0.0.758c6bbeITKyQc#?docId=108260&nodeId=10777Story: To Get Order Details, Order Status and send the details to other applications on ZapierTriggers: Order Created, Order Updated https://open.lazada.com/doc/doc.htm?spm=a2o9m.11193487.0.0.3ac413feKcf80v#?nodeId=10617&docId=108147Actions: Update Order Status https://open.lazada.com/doc/doc.htm?spm=a2o9m.11193487.0.0.3ac413feKcf80v#?nodeId=10617&docId=108147Thanks

1
H
2 years ago
R
Rishabh VermaBeginner
asked in How Do I

Is there a way to upload files from Salesforce related object to Asana using Zapier ?

Hi,I am trying to create a zap that can run when a record in Salesforce created and on the creation of that record I want to create a project in Asana, a task in Asana and then I want to attach the file from Salesforce ‘Notes and Attachment’ to Asana under the task I created but I am not able to do so.Here is the link for the Zap I created:https://zapier.com/shared/d6de660f748994b13b53416ed2ecd9eb42706064It is a time sensitive matter and I do have to finish this zap as soon as I can.Any help would be much appreciated. Thanks and Regards

10
christina.d
1 year ago
Woo at SpotOn
Woo at SpotOnBeginner
asked in Troubleshooting

Are search step results limited to 'exact match' (unable to use more complex matching methods like 'greater than')?

Using Zapier + Salesforce, I am trying to return a list of all users created within the last 60 days, every time the Zap is run.I attempted to use the “Find Record(s)” Event for the Salesforce Action:I proceeded to appropriately configure the Action to reference the “User” object, and set the “Field to Search By” to “CreatedDate”:However, I want my “Search value” to be any date that is greater than today minus 60 days. From the looks of this, is seems that the “Search value” field is restricted to only a single value. Well, it does mention that it supports line-items and comma-separated, but as you can see the actual value for that field in Salesforce is a timestamp down to the second. Obviously, it makes no sense to load in a list of values that represent every separate second between {{zap_menta_human_now}} and that minus 60 days.A very simple SOQL query would solve for this beautifully. BUT, of course, it looks like when you use Zapier’s “Find Record by Query” Search Event, it does

4
ken.a
10 months ago
P
ProteusbrBeginner
asked in How Do I

Google Slides Template Dynamic URL

I send invoice using google slides. I want to use my url like that (https://loja.pericialmed.com/?add-to-cart=394&ywcnp_amount={{valor}}), to have dinamic price , but editor change the url to this (https://loja.pericialmed.com/?add-to-cart=394&ywcnp_amount=%7B%7Bvalor%7D%7D), and is not working. Any suggestion how to send dinamic url to my custmers? Maybe some HTML code...

3
P
2 years ago
lauri
lauriBeginner
asked in How Do I

How to create new Google Drive folder by subject and transfer Gmail attachments to that folder?

Hi, Been messing around with Zapier for a while now but can’t figure out if the following is possible. I’ve got a massive amount of email that each have multiple attachments that id need to upload to Google Drive. The problem is that each of these email should be uploaded to a dedicated folder. All off the email have different subjects so i could make a Zapp that creates a folder by the subject but is there any way to add file transfer to the same Zapp? *New labeled email in Gmail create new folder by subject and transfer attachments to that folder

3
SamB
Community Manager
1 year ago
S
SolarStreamBeginner
asked in How Do I

Extract a URL from a list of URLs and get just the output from one

Hey community! I have a problem. I want to separate two URLs from a list of two which is given me in one list. i manged to get an output from this list of two separated outputs.  But I fail to use those outputs when I want to update a CRM entry. I just can select the output from pandadoc but not the two outputs transformed by Zapier.  How can I select the transformed output from step 3 in step 6? Thanks in advance!

5
Troy Tessalone
6 months ago
A
ArbiNew
asked in Troubleshooting

Odoo error: Failed to create a lead in Odoo CRM, ValueError: "name 'Env' is not defined" while evaluating Console logs

I get the error " Failed to create a lead in Odoo CRM"   when I test action on Odoo CRM, I looked in to troubleshoot  "ValueError: <class 'NameError'>: "name 'Env' is not defined" while evaluating Console logs:" and it says that I have a bad request 400 required field is missing or a field value wasn't in a recognized format.I checked the required field which is "opportunity" and the format of the other fields like email and name, but it won't work.any help please

4
M
1 year ago
K
KHABeginner
asked in How Do I

Trello custom feilds not updating with boolean fields

Hi,I’m working out a new Zap and when using Trello (Update Card) as the Action, I tried to change the custom feild on the card from True to False on the set up action, but on test this does not have any effect to the trello card.I’ve also tested the opposite, and also tried manually unticking the custom feild on the trello card and telling zapier the feild is true to tick the box but still no effect.Is there any way to update custom feilds (checkbox) or is this an error?Thanks

4
nicksimard
3 years ago
N
Nick BetgemBeginner
asked in How Do I

the CompanyID field is missing when creating a ticket in Autotask.

When creating a ticket in Autotask the field CompanyID is missing. This is requiered by Autotask and so the create ticket action can not be performed.Is there any way to add this field or has this to be done by the developer of Zapier? 

17
JammerS
1 year ago
Wojtek108
Wojtek108Beginner
asked in Troubleshooting

Unable to get the correct "Publish date" from the original YouTube video

I have a simple zap: whenever I put a youtube video on a given playlist, the zap creates a row in google sheet with info relevant to that video: title, link, date published and chanel name. It turns out that the Publish Date I get is the date I put the video on my playlist and not the date when the creators published their videos. See the screenshot.How do I get “the right publish date”? I mean the original date of publishing the video?Thank you!Wojtek  

10
Wojtek108
2 months ago
T
themalernNew
asked in How Do I

How do I run my zap only 3 times a day?

Hello.I would like to ask for some help about running or limiting a zap to 3 times a day.To start off my zap rewrites news articles from RSS feeds using ChatGPT and reposting it to my website. The basic workflow of my zap can be seen below:1. TriggerApp: RSS by ZapierEvent: New Items in Multiple FeedsTrigger:    - Feed URLs (Multiple Feed URLs)    - What Triggers a New Feed Item?: Different Guid/ URLTest: OK2. Chat GPT (Rewrites latest content from RSS feed)3. ChatGPT (Writes blog post title based on rewritten content)4. ChatGPT (Writes abstract based on rewritten content)5. Create Post in WordpressThe problem is, is that the article news feed updates more than once a day, sometimes they post 30 news articles in a couple of hours. I cannot afford to run the zap everytime there's a new news article in the RSS news feed as it would deplete my ChatGPT credits.What I would want is to just post 3 times a day. I do not care what time time the news article gets posted as long as there is a li

4
Troy Tessalone
3 months ago
S
SteepsNew
asked in Troubleshooting

Microsoft SharePoint error: Error from halted execution: Unable to create an item

I am attempting to use the “Create List Item” function for Microsoft SharePoint. I receive this error when attempting to put a User ID in the “Assigned to” field: Failed to create an item in Microsoft SharePointError from halted execution: Unable to create an item: A 'PrimitiveValue' node with non-null value was found when trying to read the value of a navigation property; however, a 'StartArray' node, a 'StartObject' node, or a 'PrimitiveValue' node with null value was expected. The description for “Assigned to” states:Enter the User ID. Since querying for the User ID requires admin approval in the SharePoint API, we've left this as a text input field. You must enter the User's ID, which is often numeric. Note: the User ID for a given user may vary between sites. I have tried the user email address, display name, Azure AD Object ID, and Puid. None of these work and always result in the error above. If I leave the “Assigned to” field blank, the Zap works fine. I have also discovered th

1
ken.a
4 months ago
G
GusDorfBeginner
asked in How Do I

How would one add DNS records in order to create a subdomain?

How would one add DNS records in order to create a subdomain?The titl asks it all.I am in namecheap right now and I do not think that will be possible.I have heard it can be done in Cloudflare.Anyone know how this can be done?Thank you.

4
G
1 year ago
Ilya Lukach
Ilya LukachNew
asked in How Do I

How to run zap only once for a new unique Stripe user?

Hi Zapier Community!Whenever a new user signs up on our website and picks a number of seats in the subscription, it triggers Stripe to create a payment for that number of seats. Not all payments are completed, therefore I want to set an automatic email-reminder to the user that didn’t complete the payment in 24 hours (or when the created payment is set to “Expired” by Stripe).Is there a script or anything that would use user’s email as a unique identifier and run Zap only once?Previously I tried running Zap only once based on the Invoice Prefix ending number. Filter would look for “-0001” at the end of the invoice number and the actions would run only once. However, the “Updated Subscription in Stripe” Trigger doesn’t have that line.Any other ideas would be helpful! :)

1
SamB
Community Manager
1 year ago
T
Tanya1992Beginner
asked in How Do I

A/B test in Mailchimp

Hello! I hope someone could give me a hand with one thing that seems doable to me, but I cannot figure out how.Here is a workflow that I am trying to create:A deal enters a new stage in Zendesk sell Add a tag in Mailchimp (once that is done, Mailchimp will automatically start sending an automated email campaign).This workflow is easy, but here is where it gets tricky. I have 2 automated email campaigns in Mailchimp which I would like to compare. Mailchimp has an A/B test option, but only for singular emails which are sent once. It is not possible to A/B test the whole email drip campaign.That is why I was thinking of creating some kind of a filter that would be adding every 1st, 3rd, 5th deal (odd deals) to one Mailchimp tag (so they would be receiving A campaign), while every 2nd, 4th, 6th…deal (even deals) would be added to another Mailchimp tag (so they would be receiving B campaign). That is my way of creating A/B tests that Mailchimp does not have. What confuses me is that filter

1
J
2 years ago
ZapUser0001
ZapUser0001New
asked in Troubleshooting

What is the point of ZAP Reruns when you can't run the whole ZAP from the begining? How to do a proper rerun

It is extremely disheartening and misleading that Zappier can’t run failed ZAPS from the initial step to the last step. What is the point of the half baked ‘ I will only run the failed step’ approach?If the failed step is due to some erroneous data passed from the earlier step ( which ran without an issue. But the data on the table was wrong)  there is no point of running the failed step again and again. I fixed the data on the eariler step but it wont pass to the new one now because Zappier doesn't run the whole Zap. The failed Zap is attempting to rerun again with the old data that was wrong.What is the point of this? And no, I can’t recreate the trigger. There is no way to do that. If any of the devs are ever looking at this community posts, please fix this. 

1
SamB
Community Manager
1 year ago
K
kcarlsonNew
asked in How Do I

How to trigger completed jobs from Service Titan?

Hi! My company is new to Zapier and we are trying to set up a sub zap process and are having difficulty doing so. Our desired outcome is: When a new job is booked a zap is sent out to scan in necessary documents. Once this task is completed in the Task Management portion of ServiceTitan we want two zaps to go out to two different people to do the next steps in our work flow process.We cannot use the delay option in Zapier because all of the jobs scheduled are for different periods of time.Is this possible and how would we set this up?Thank you for any help provided!

4
SamB
Community Manager
9 months ago
qspeaker
qspeakerNew
asked in Troubleshooting

Error: “Cannot publish your draft, as one or more of your accounts are expired. Please correct any errors in the Zap Status sidebar.”

The zap between CallRail and Salesforce had been working correctly for days, but when a new draft was made to integrate another step ion the zap suddenly this error occurred: “Cannot publish your draft, as one or more of your accounts are expired. Please correct any errors in the Zap Status sidebar.”I’ve reset the connection a few times, but it still wouldn’t work. I reverted to the old zap without the added step and it wouldn’t work. I rebuilt the old zap from scratch and it wouldn’t work. But every time I hit test it functions successfully, and on live it says “accounts expired”. What is happening???

9
ken.a
11 months ago
A
atorunBeginner
asked in How Do I

Can I link Messages in Amazon Seller Central to Zapier?

Hello, I’d like to use Zapier to connect Amazon Seller Central so that all messages received from our Amazon customers can be forwarded to our help desk software.  Is it possible to link messages from Seller Central? Thanks!

7
H
6 months ago
P
Phuong TranNew
asked in How Do I

How can we get the AdSet Name + Campaign Name when we have a messenger that comes from Facebook Ads Messenger?

We used Mobile Monkey to get attributes such as Name, Phone, Email, and the answers to our questions but only the AdSet Name and Campaign Name are the things that we can't find a way to get when we get inboxes from Facebook Ads Messenger.

2
nicksimard
3 years ago
D
DID_identityNew
asked in How Do I

DocuSign Missing Envelope selection

Until recently (as recent as last week) when triggering a DocuSign zap I was able to select the exact envelope type I am aiming to work with during the zap process. As the UX received an update this option is not available anymore and instead now i can only interact with all envelopes in the DocuSign. As I manage many Envelopes this is a huge issue as I would need to export the completed envelopes by envelop category and not only as bulk.   Have anyone else seen this issue?  Will it be fixed?  Any workaround? 

2
Liz_Roberts
4 years ago
J
Jeff ThornsBeginner
asked in How Do I

MySql update by custom query and Views as tables

Hello, For a project I seem to be running into limitations with the MySql integration with Zapier. The first one is no having the option to run a custom query to update the database, because of that it takes about 10 steps to update my database instead of just one with the help of a stored procedure. I tried to use an update stored procedure with find row by a custom query but sadly it’s read-only. secondly, I would love to do the same things with views as we currently can do with tables, so things like updating and selecting can take fewer steps. Does anyone have tips?

3
J
3 years ago
Terms & Conditions