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.

25175 Topics

N
NGKNew
asked in Code & Webhooks

Zap using JS/ Python

Hi,I would like to build a zap step where I receive the IDs from the column in the google sheet in my previous step and return a random ID Please help. KR,Nithya

1
Troy Tessalone
1 year ago
A
azwdsNew
asked in How Do I

Sage 100 On-Premise zap with Service Fusion

We use Service Fusion and Sage 100.  Our Sage database is on an on-premise server and not Sage Online.  Will Zapier work with Sage 100 on premise?  Thanks!

1
christina.d
1 year ago
E
evabreezyNew
asked in How Do I

How do I get customer/contact information when triggering off of a credit card charge in Keap?

I am trying to connect Keap Classic + SmartSheet to create a dashboard. I already have a couple of very basic zaps created so the integration is working. One of the Zaps I’d like to create is a zap that get triggered any time there’s a credit card charged. The action I would like to see would be to pull that data into a Smartsheet sheet. However, the problem that I’m running into now is that the only data available to export to Smartsheet is payment related information and nothing on the customer/contact. I would like to be able to get (in one sheet/zap) the payment amount, the product, the date and the customer name. 

1
christina.d
1 year ago
H
HibracadabraBeginner
asked in How Do I

How do I only trigger on Notion records where a checkbox is set to “true”?

Hey all,  is there any way to create a flow where only the events with a “true” checkbox from my attached Notion Database are added to my Outlook calendar?I tried many ways but unfortunately I haven't found a way yet to make that possible, therefore I would appreciate your help very much!Best wishes, Tim

4
christina.d
1 year ago
H
HydeBeginner
asked in Code & Webhooks

Remove last 3 digits from a string

I’m setting up a logic sequence that takes any UK postcode and removes the final 3 characters and returns the remaining characters.e.g.B48OP becomes B4B755UG becomes B75and WV125ET becomes WV12The postcode string could be 5, 6 or 7 characters long - in each case I want to remove the final 3 characters and return the remaining characters as above. I’ve already created steps to remove spaces and make upper case - it’s just this final bit I can’t figure out.Any ideas?

4
H
1 year ago
D
DentiavitaBeginner
asked in Troubleshooting

When the contact form is submitted, the file uploaded is not sent in my CRM

Hello, I have added a filed in my contact form to upload a file. I have connected my Zap with Bigin CRM. When the contact form is submitted, the file uploaded is not sent in my CRM. Can you help me please what problem is this? Thank youThe form is created with Elementor Pro forms.

4
Danvers
1 year ago
M
mwong1New
asked in How Do I

slack emoji triggers github pr

Hi there, i'm trying to create a github pr request that is triggered by a slack emoji - however i am getting a 'Failed to create a create pull request in GitHubThe app returned "Validation Failed". This is due to the 'head' branch i believe. We would like a head branch to be created when the pull request is created, since we would not have an existing head branch already in place - is there any way to do this?  

3
Danvers
1 year ago
L
leetwitoNew
asked in How Do I

How do I send an email and an internal Slack message whenever someone "subscribes" to my website?

I don't know coding and I want to use Zapier in order to send an email to the user and an internal slack message whenever someone clicks on the "Subscribe" button on my website.How should I solve this? Thanks

1
Danvers
1 year ago
L
lasseabacusNew
asked in How Do I

Assign lead owner in Dynamics

Hi,  I have created a Zap that creates a lead in Dynamics365 when a webform is submitted on our website (via Wordpress/Elementor). However, I’m not able to choose who the owner of the lead should be in Dynamics. Does anyone have a solution or a workaround to solve this issue? Thank you in advance

1
Danvers
1 year ago
J
JuliusNNew
asked in How Do I

How can I redirect to a "Thank you page" in ActiveCampaign when a person purchases on Acuity?

How to integrate Acuity to ActiveCampaign so when a person made a purchase on Acuity they will be redirected to a Thank You Page in ActiveCampaign?

2
EJR
1 year ago
J
joester1976New
asked in How Do I

Do I have to create a new Zap for each sheet or is there a way to set up a trigger for multiple sheets?

Hi all. So here is what I am trying to do. I have a Google Spreadsheet with a sheet A and a sheet B. What I would like to do is when Sheet A or Sheet B has a row added the Zap will send that info to a database.  How do I set up the trigger so that when data in either sheet is added the trigger is initiated. Currently when I use a google sheet as a trigger I can only select one sheet. Do I have to create a new zap for each sheet or is there a way to setup a trigger for multiple sheets?  

2
EJR
1 year ago
M
MarshBeginner
asked in How Do I

Reddit Hot Posts→ Twitter Pages How to Schedule

Hi everyone! I built a Reddit New Hot Posts→ Twitter Pages trigger and here’s the outline:  By far, everything works fine. But there seems no way I can schedule this procedure. The Schedule by Zapier is unavailable when I tried to pick it:  I’ve tried the delay function but it didn’t work as I supposed. I want the whole process action once every 12 hours or once every day. Also, I tried to start with the Schedule by Zapier but then the Reddit app leaves me only one event option: New Link Post, which is not what I want.  Could any one help me with this, please. Thanks ahead!

5
M
1 year ago
A
AjmillerBeginner
asked in Troubleshooting

Kajabi error: Failed to create a submission in Kajabi. Required field "Email" (email) is missing.

Here’s what I’m trying to do: a member joins my facebook group and types their email, as a response to question 3 which collects contact info upon accepting them into group, GroupKit (a chrome extension) updates a google sheets with a new row containing name and other info (including question 3 answer, their email) that triggers a zap which SHOULD create a new form - which is the lead magnet - and add that name+email to my contacts list automatically as soon as i approve within facebookthe problem is this: when I test the zap I get the error: Failed to create a submission in KajabiRequired field "Email" (email) is missing. the email field within the google sheet is actually called “Q3” because when they type their email, it’s the answer to the third question in the fb group. i dont want to break anything by renaming rows in the spreadsheet that zapier is using. so not sure how to fix this?

8
A
1 year ago
I
INSPNew
asked in Troubleshooting

Create Item feed in RSS by Zapier is not working

Hi, Zapier Community Need your help as the Zapier support team is unable to find the reason for Zap failing to create a feed in RSS by Zapier. Here is the situation:Our website is built on Wordpress and using Cloudflare The Wordpress to RSS process was working well but from the past few weeks, the Zap doesn’t run and gives an error at the step pertaining to “Create Item feed in RSS by Zapier “. However, whenever I run the Zap manually using testing steps, it works well. Zapier is unable to create a new item feed automatically but while testing it does create it.Have you come across such issue in the past? If yes, how did you fix it? Your help will be greatly appreciated. Thanks and best regards,Ajay 

5
christina.d
1 year ago
A
akrausNew
asked in How Do I

SocialPilot “Cannot read property 'length' of undefined” error

I have created a custom trigger that copies posts from my website’s blog to Social Pilot. The trigger has been working fine until last week. I have just noticed that it is giving me the error: Cannot read property 'length' of undefined. The Zap’s RUN ID is: 0090f337-49bc-a6a9-ac12-43ca10536391In the Data In section it is showing:group_id:801ff2bc-5ae1-4b34-bbac-0923fbf2875daccount_id:1:1105219post_content:Tennis Ball VacuumA Design Story – Tennis Ball VacuumHi folks, I’m Walter Wardrop, an Operations Management Coach at the Growth Roundtable. Many years ago, I was called on to help a company that had an issue with the product they had designed. The company had come up with an item that was meant to go on top of the plastic container that usually holds three tennis balls. The concept was to put the balls back in the tube/can, then seal and evacuate the air from the can. This would help to store the balls in a better condition, and result in the balls lasting longer before they lost

7
jesse
1 year ago
DavidLGS
DavidLGSZapier Expert
asked in Troubleshooting

MailChimp “New or Updated Subscriber” trigger only works when manually updated

I’m using the MailChimp “New or Updated Subscriber” trigger, but it only works if I manually update the subscriber myself from the MailChimp dashboard.If I use a Customer Journey to manage my contacts and add/remove them from certain groups based on their tags, the Zap does not get triggered.Is that to be expected? Any workarounds? Ultimately, I’m using tags that can be applied automatically based on user behavior. (i.e. fill out a MC survey and get tagged accordingly) Which will then trigger a Customer Journey to add or remove them from certain groups. Which *should* then trigger the Zap to carry out the rest of the automation.The crux of it is that the contact should be able to repeat this whole process as many times as they qualify, starting from the beginning with that very first behavior that applies the first tag. I’ve tested that the zap does get triggered repeatedly from the same contact profile and from the same group, but only when I’m doing it myself. Meaning, I add them to

3
christina.d
1 year ago
I
IWBCryoBeginner
asked in Troubleshooting

The app returned "The resource could not be found.". - Excel - SharePoint

Hey everyone, I keep having this issue with Excel file on Sharepoint - When I edit the zap, the connection works fine and the test pass with not issue, but when it is running, I keep getting the error and nothing is being updated in my spreadsheet. I looked through the articles, but nothing helps.

7
christina.d
1 year ago
S
Sian WNew
asked in How Do I

Sync Dynamics activities with Google Calendar

Hello,I’m hoping to implement Zapier for our organization to sync Dynamics 365 activities (specifically appointments) with Google calendar.  Can Zapier do this?  I’m not seeing an obvious way…Thanks,Sian

3
jesse
1 year ago
H
hippopotamuschickenBeginner
asked in How Do I

Can I post slack replies from a thread to a specific google cell?

I have a Zap that sends data from Tidio Bot > Google Sheets > Slack.The zap creates a new row in a google sheet. The columns are as such:Lead Type Name Phone EmailAfter which the Zap posts the same information as a single message in a private Slack channel. Slack users then reply to the message as a thread. Is it possible to have Zapier to post any replies that are made by users to the original message in a new column of the corresponding row? 

1
christina.d
1 year ago
S
Sian BurtonNew
asked in Troubleshooting

Can't see forms when using Facebook Lead Ads (for Business Admins)

I am trying to set up a Zap using Facebook Lead Ads (for Business Admins) but I can’t see any forms that I’ve created for the ads. I’ve successfully connected my Business Manager account, but the list of forms is empty.Any ideas?

3
jesse
1 year ago
B
Bot TestingBeginner
asked in Troubleshooting

Failed to create a group contact in Google Contacts: Resource name is not a valid contact person resource.

I am trying to make a bot which will look at a new input in google sheets and create a new contact. It will also label or in its terms it would add the contact to an existing group. It always shows an error when I try it. It shows that the contact wasn’t able to be found. I tried the id, name etc and also looked at this https://community.zapier.com/how-do-i-3/we-had-trouble-sending-your-test-through-1146 but it didnt help. Please help!!   

7
B
1 year ago
M
mtsNew
asked in How Do I

How can I get the content of the comments of a finished Basecamp 3 to-do?

Is there any possible Solution for getting the content of the comments of a finished to-do? (My Trigger in Zapier is the fininishing of a specific to-do which is working). Im only getting a “count”(ammount of comments) and a json. URL of the comments. The Trigger “new comment” gets the content of the comment why cant the Trigger “finished a to do/activity” do the same / is there any way to do this? 

1
christina.d
1 year ago
D
DAVE HOWARDNew
asked in Code & Webhooks

Need to update partially blank row in google sheets with info from webhook

Trying to create a new row or update a row in google sheets from a webhook. The data will load fine, all of that is working well. However, column R and T need to keep a formula in them for all rows on the sheet. I want the info from the webhook to be added on the sheet in what are now blank columns a-Q, but I want it to load on the next line where columns a-q are empty. Since I have text already in columns R and T, it is adding the new row on the first row that is fully empty. This doesn't work for me as I need R&T to run a formula based on the text entered in the zap. I have tried to do update or add new rows to google sheet and add new row to google sheet. I'm sure there has to be a way to do this, right?  Or, I am also pulling the info over to another sheet by way of a formula from sheet 1 to sheet 2, but I can’t grab the info from sheet 2 to send to another google sheet because it doesn’t show that it has any values, probably because it is a formula in the cells. 

1
Troy Tessalone
1 year ago
P
Percolator ConsultingNew
asked in Code & Webhooks

running code on raw JSON while retaining other context

We have a zap that’s making a callout to an API (which returns JSON) and we next need to parse the response via a  Code step.  We want to be able to parse the raw JSON, because the way Zapier is structuring the response as line items is proving to be problematic (it’s not handling leading or trailing nulls properly). In looking at other posts, it seems like the recommended approach here is to make a separate webhook zap w/ Catch Raw Hook, and then sent the JSON to it via a Custom Request Webhook action, using Data Pass-Through.  For example: How to transform JSON response? | Zapier Community However, my issue is that there is also data from previous steps in the original zap that need to be retained, because they’ll be needed for actions that follow the JSON parsing.  As far as I understand it, if I use Custom Request, the entire data payload will consist of the raw JSON from my API call.  So when using a 2-zap approach like this, how do I make sure other details besides the JSON make

1
Troy Tessalone
1 year ago
C
CGLtaxBeginner
asked in How Do I

Please help - Small Businesses Need Multiple Users but not Teams!

Greetings Zapier.I own a small business in Canada, and have other clients that might be interested in your product.  However, in my small business, I’m the tech-nerd - but don’t have the time to dedicate to creating zaps.  As such, I have brought in a new hire who will be implementing automation.Here is my problem:As the owner, I need to be able to have control over my account.I need to have multiple users like Team  I need to have control over the users like Company I need to have App restrictions I need to have single sign onHowever we don’t need anywhere close to 50K tasks nor 100K tasks per month.To pay $10,782 USD per year on a month to month or $7,188 USD all at once, just to have a Company account would kill my small business. Based on your price points, the following is 100K tasks per month:Professional: $489/month Team: $499/month Company: $599/monthThe price point differential from Professional to Team is $10/m and Professional to Company is $110 per month ($165/m if paying m

6
C
1 year ago
Terms & Conditions