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.

15740 Topics

J
jd7300New
asked in Troubleshooting

Email by Zapier error: Failed to create a send outbound email in Email by Zapier

Hello!Okay, this is going to be a super basic question, but I just cant make it work.  I’ve used Email by Zapier before and didnt have any trouble, must have been doing something different.All I want to do is get Zapier to send me an email, a notification.  The zap is actually connected to Mailchimp, and each time a new subscriber submits the subscribe form, I want an email notification.  This is super basic!But, I cant complete the build of the zap, because the email always fails the test.  Zapier tells me;“Failed to create a send outbound email in Email by ZapierYou can only send emails to yourself when testing the ZapierMailAPI”So what am I doing wrong?  Come on, point out the obvious for?

2
J
10 months ago
Z
zapfan1Beginner
asked in How Do I

Changing text to number value

Hi,I am trying to check if a value that I receive from a YouCanBookMe me field is larger than 1. The field in YCBM is a text (since it is an input on their form) and it comes in as a fraction (i.e. 1/2).  I am trying to find a way to convert this string to a number and then compare to see if it is larger than 1. I’ve tried using Formatter Numbers but it does not seem to work.  Any ideas?Thanks!

6
Z
1 year ago
T
tesssmaniaNew
asked in How Do I

Ninja Forms > Check date > Send e-mail (ActiveCampaign or other)

Hi, When a ninja form coms in with a certain date, I want my availablity checked in Google Sheets or excell and if that date is true or false to send e-mail A of B with activecampaign depending on true or false. I have tried to set it up many times, but it never worked. Is there anybody who can help me of point me in the right direction? Is this possible at all? Regards,Tessa 

7
T
10 months ago
M
Michael_CalmStormBeginner
asked in How Do I

Typeform and Zapier

Hello,Is it possible to fulfill a  form in Typeform from Zapier? I get proposals from companies per email and would be good to connect the information from these emails and fulfill a Typeform (previously created) automatically. Best, 

3
Troy Tessalone
9 months ago
C
CheetahNew
asked in How Do I

Lookup Table Range

Hi,We have a client running a calculator system. That calculator gives a specific result and depending on the result, the user will get an automated e-mail with a specific Google Drive folder link.What we want, is to capture that result with Zapier, and depending on the threshold, a specific TAG will be sent to Active Campaign, and therefore, the specific automated e-mail will be sent to the client. The thing is, we can’t add these thresholds manually, because we are talking about 750k excel rows.Example:From 110000 to 189999  - TAG will be 01_1900000From 190000 to 199999  - TAG will be 01_2000000Basically what we need ist: if the result is between 110000 to 189999, tag field will be 01_190000Does anyone know a way of doing this? We tried everything on Zapier but couldn’t find a solution, apart from adding these 750k numbers manually, which is herculean.Thanks in advance for all feedback and help.Regards,Joel

6
C
7 months ago
I
iCamp-DanBeginner
asked in How Do I

Delete Specific Dates in Recurring Event in Google Calendar

Hey guys, Been using Zap for a bit now. Trying out a new backend system that links Airtable and google calendar, by creating a recurring weekly event. I created this Zap to handle instructor assignments for weekly afterschool classes. It creates the google calendar event and invites the right people, which is fantastic.My question is, can I delete specific dates from these recurring events? Certain weeks there is no school, so it shouldn’t be on the calendar. I tried the search step, finding the event details and trying to filter by specific dates, but it just keeps deleting every instance of the event, not the specific date. Wondering if anyone has any insight!  

2
jesse
Community Manager
7 months ago
F
Faction PMOBeginner
asked in Troubleshooting

Anyone have experience connecting Scoro to ServiceNow via Zapier?

Hello!Does anyone have experience connecting Scoro to ServiceNow via Zapier?  We recently tested a Zap in the reverse order (ServiceNow to Scoro) and with a little testing, now have it working where a new escalation will automatically create a task in Scoro, in our predefined project.The 2nd piece to this is getting Scoro to talk back to ServiceNow, and update the existing escalation.  We have the Zap trigger set as a New or Updated task, and it’s set to look at bookmark filtering (we have this exact same filtering setup in a different Zap that works well, to send an email notification when a task in Scoro hits the bookmark).We cannot get the Zap to pull data over to ServiceNow, the test action is not working in the Action piece of the Zap, and we don’t see any activity in the Zap history (even though tasks are pulling into the bookmark the trigger looks at).Does anyone have any experience?  Any insights will be hugely helpful.  Thanks in advance!

5
jesse
Community Manager
7 months ago
L
LongBeachSteveNew
asked in Troubleshooting

How do I pull data from multiple SurveyMonkey surveys and append new results to the same worksheet?

I am hoping to pull survey data from multiple SurveyMonkey surveys and append new survey results to the same Worksheet.Example Survey Results: When I test, I get this (not all fields visible): But this shows up in my Excel Table: numbercompleted2022-06-28T15:32:18+00:00135045873853117926692022-06-28T15:32:27+00:00https://www.surveymonkey.com/r/?sm=eIvYi4s0TAPbxnKi_2B1adJ_2Bm7TYZYLC_2BV1aPdZINeys7CwDoyqkQ4GouFBrOtydGJ107.132.116.1858409579881endefaultdefault45403110stringnumber

6
jesse
Community Manager
8 months ago
T
tfredellaNew
asked in How Do I

Filtered WooCommerce "Order Trigger" creating action for all products

I currently have two domains with Woocommerce on it. One is primarily for license keys that get sent when certain products are ordered. For Example, A new customer purchases a membership to my program and received a certificate for 7 night resort stay. The sales rep adds the following line Items:Sku: Platinum199 (this is the membership)Sku: NMB3NCERT (this is a certificate for a 3 night bonus stay) I’ve set up the filters to read read and create an order based on the voucher (2night, 3night, 7night). It’s supposed to trigger an order for a license Key to be sent from my other domain to the used so they can log in and activate the certificate using that license key. It works fine when I test an order with a single voucher, but I run into a problem when there are multiple vouchers and or additional products on the order. In the example above, the filter is set to trigger when the order goes complete and have the NMB3NCERT, then it should place an order for 1(one) license key for the 7 ni

4
jesse
Community Manager
11 months ago
D
dpzapperNew
asked in How Do I

Why are jpg/png files converting to txt documents?

I upload a .jpg/.png image but I receive a .txt document instead and have no idea why/how the file conversion is happening.Please help!

2
jesse
Community Manager
8 months ago
J
Jamie_A-BayNew
asked in How Do I

Requesting additional triggers for the Wave integration

Hi All,I’m fairly new here, so apologies if I’m missing something.  But seems like the Wave integration is quite sub-par. End goal: Pull all of our wave data into a google sheet as it comes in so we can link it to our dashboards in google data studio to get a holistic view of our businesses performance in realtime vs looking at 4 different platforms. I’m looking for additional triggers around when an invoice is sent vs paid. Am I missing some easy functionality around this?Also, we are using wave for our bookkeeping, so I’d like a trigger for expenses tied to our bank account too. Even a trigger of an expense item being approved to pull into a google sheet.How can we make these happen?Thanks for your amazing help in advance!

4
christina.d
Community Manager
8 months ago
L
lambojambo16Beginner
asked in How Do I

Repeating line item data in Shopify order export

I am sending data from Shopify orders to Google Sheets. I want it to contain all the line items of the products in the order, plus associated line item data. However, this leads to some order level data repeating. I would like to make it so that order level data only appears on the first row. It is currently like this And I would like it to end up looking like this; where anything not related to the specific line item is posted once 

5
mzsadiek
1 year ago
N
nathanbrownfaxNew
asked in How Do I

Car pooling via SMS

Hi allI’m not technically the most able, looking for advice.I’m starting a carpool system, and in the past we’ve used a google form. I’m wondering if it would be possible to set up a template/system whereby you would send a message, either by SMS or whatsapp or email, and the data you send would generate a google excel sheet. For instance I text “Nathan, to the city 10am, home again 4pm” to a certain number on whatsapp, or SMS, and my number and the content of my message appears in a live spreadsheet.Thoughts?

3
Danvers
Community Manager
8 months ago
J
jadjugahBeginner
asked in How Do I

How can I transfer the “Initial Description” field information within ConnectWise to Jira?

Is there a way I can pass the “Initial description” information within ConnectWise ticket onto the “Description” field in a Jira Issue/ticket.My zap run fine, but this field is not populating onto Jira. Any solution? Thanks

4
I
2 months ago
E
eduardoeNew
asked in How Do I

How do I save email attachments as separate files in an Evernote note instead of a zip file?

Hi all!I have a specific e-mail address where I receive invoices. I would like to automatically save these invoices into a specific Evernote notebook. I can do this manually by fowarding the email to my Evernote and append to the subject line "@notebookName". But I could not find an email rule that allows me to do this. So I tried Zappier.I was able to create a Zap to do this, but the problem I'm facing is that all attachments in the e-mail are saved into the Evernote note as a Zip file. This happens using the specific Evernote App or the Email App.I would like to save all files separate and in the same note in Evernote. Just as if I forward an email into Evernote. Hope someone has faced this before and found a solution.If onlye Evernote would allow a specific email address for each notebook, like slack does, it would make life a lot easer...

2
E
7 months ago
M
maor356Beginner
asked in How Do I

Get all google drive files under a folder, and send via SMTP email

Hi, I am trying to attach files to an email I am sending. These files are stored in a folder in google drive. The number of files varies per zap run. And also the name of the folder varies every time. Is there a way to find the folder, and get the files within that folder and send them in the attachments of the email?

6
christina.d
Community Manager
9 months ago
M
Marc-TalNew
asked in How Do I

Is it possible to update a Company/Client Record in Bullhorn?

I notice that when creating a Zap there are options to update ClientContacts, Leads, Jobs etc but not to update an acutal Company Record.Has anything been able to overcome this?

1
Troy Tessalone
1 year ago
E
emilycorriganBeginner
asked in How Do I

How to send an email 10 min before an event start time from a webhook

Hi everyone,The goal of the Zap I’m setting up is the following:A user of our wellness app schedules a wellness session with one of our providers The webhook data for this event includes the event start time, user email, joining link, etc. 10 min before the event start time, I want to send an email to the user email reminding them that they have an upcoming session and sharing a joining linkDoes anyone have a solution for how to delay the reminder email until 10 min before the event start time from the webhook? I haven’t seen a way to do this using a filter step. If possible I’d like to avoid having the trigger come from a Google calendar event instead.Thank you!

1
Danvers
Community Manager
8 months ago
K
KalpeshOrdexNew
asked in Troubleshooting

Zap not run while call sub zap “Did you fork or replay this step?” error

I have created on zap, that zap call other two sub zap ,it will working if we manually execute all steps, but facing error while we on the zap 

2
jesse
Community Manager
8 months ago
Y
YanovskiBeginner
asked in Troubleshooting

Looping do not split results

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.Hi,I’ve iterated a lot of things before posting so I can assure you it has became a nightmare !I have a “Find Many spreadsheet rows” action that produces multiple results. Those results must be processed individually through a number of actions so I used the “Looping” action by Zapier.However, when processing the final step (ie Sending an email), it doesn’t “split” each row’s result into a separate email even though it sends the proper amount of emails (Loop iteration is correct)Please find below my setup of the looping action.The email is sent twice with all the above data inside. I’ve tried Line Itemizer Utilities before the loop, after the loop it doesn’t change anything. Zapier doesn’t take each row individually.Thank you for your help !Best, Y

1
Danvers
Community Manager
7 months ago
S
synapticleeBeginner
asked in How Do I

How do I send each phone number a unique message in Twilio + Google Sheets?

Hi, I have a pretty simple workflow but I can’t understand how to implement it. I have a google sheets with two columns, Phone number, and Message. I want to loop over all rows and have Twilio send each phone number the corresponding message.The other question here is similar but I don’t have enough context to implement it:First of all, “find rows” seems to require a value to find a row, and I don’t need to subset it by any specific value. I just want the rows. “get rows” is confusing because of the output of the function. I want it to “get” separately the phone number cell, and the message cell, so that one can go into the “recipient” of twilio, and one can go in the “message” as a variable. I think it requires some fancy line-item formatting but I don’t understand how zapier does this. Thank you!

4
christina.d
Community Manager
7 months ago
G
gldcNew
asked in How Do I

How can I split/parse data from an Invoice Ninja field and add it to my Google Sheet?

Hi, everyone I am fairly new to Zapier and I am still overwhelmed by the number of options. What I am trying to do is take data from Invoice ninja, edit that data and add it to my spreadsheet in the appropriate columns. I am guessing i need two zaps. The data that I can get out of invoice ninja looks something like this: Name of productnotesProduct description.Duration: 9 Hours;Date: 5 Aug 2022;Start Time: TBC;Start Location: TBC by guests. That’s all in one section. How can I get this to split up so I can then add it to my google sheets, so that “Name of product” goes in the correct column, date in another but without “date:” just 5 Aug 2022, Start time in another (again without “start time”) and same for start location. I hope this makes sense and someone can help me with this! I don’t know if there is an integration that can do this, or if it would require custom code.Thanks so much!

4
T
9 months ago
B
Boris ZorbaBeginner
asked in How Do I

How to send SMS messages to customers who input their phone numbers through Typeform?

We run ecommerce website and customers input their phone numbers through our sales funnel.The funnel page is built from Typeform.Is there a way to send message to the number pulled from Typeform?The Typeform fields are also saved on Google sheet.

5
J
10 months ago
T
TREWDreNew
asked in Code & Webhooks

How to Use parseInt()

HubSpot has an “Annual Revenue” property that is currently in single-line text format. I need this field as a number property.Someone recommended that I use Zapier and the parseInt() function to extract the number and then import the number into HubSpot as a new property. I am new to Javascript coding, and my attempts at using Code by Zapier have not been successful. Can you provide the Javascript code I should input into the Code section? Screenshot attached. 

2
T
1 year ago
J
jadjugahBeginner
posted in How Do I

Which of the fields in ConnectWise Manage ticket are supported by the “New/Updated Ticket” trigger?

Which of the fields in ConnectWise ticket is supported by the “New/Updated Ticket” trigger ?Thanks  This post was split from the topic:   

1
jesse
Community Manager
8 months ago
Terms & Conditions