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.

25691 Topics

TravisTubbs
TravisTubbs
asked in How Do I

Retrieve Most Recent Comment from Jira Service Desk

I’m currently setting up a Zap to post comments from Jira Service Desk / Jira Service Management to a Zendesk ticket when the Jira Request is updated.This was working pretty good! A zap first creates the request from Zendesk in Jira Service Desk and stores the Zendesk ticket ID in the request. Then when the request is updated in Jira, it updates the Zendesk ticket with the Jira Request Status and the comment.But then I tried adding more than one comment to the Jira Request.Instead of grabbing the most recent comment from Jira, it grabs ALL the comments on the request. Oops! From what I can tell, when using the field that would contain the text of the comment, Zapier is grabbing every instance of that field in the array that’s returned from Jira.Does anyone have any insight on how to grab just the last item (most recent comment) from the array returned by Jira? Thanks! The zap is currently set up as follows:Trigger: Updated Request in Jira Service Desk App: Jira Service Desk Trigger Ev

3
SamB
Community Manager
2 years ago
L
Leonhard
asked in How Do I

Gravity Forms and Klick-Tipp

I have problems to send data from Wordpress GrafityForms and zapier to Klicktipp contact; tagging works - but datatransfer does´nt work. Would be very happy if there is anybody who help me Many Thanks and best regards Leonhard!!!

3
M
2 years ago
B
ButtonjerBeginner
asked in How Do I

Date / Time Formatter

Has anyone had a real good play with this, I have used it on a few zaps and it has been great however I am looking for something quite specific and I cannot see how to do it:.Scenario:Time / date output from AirTable is in Zulu Time (example: 2011-08-12T20:17:46.384Z).I would like to run through the formatter and come out with say, “Friday the 11th at 10am”. Has anyone done something similar?

3
J
3 years ago
P
ProFlowBeginner
asked in How Do I

Update Record in SugarCRM 7+ - add tag

I would like to use the SugarCRM 7+ to add a tag to a contact.I dont know in advance if that contact has any or multiple tags already, but I do know the contact ID.When I use the Action “Update Record in SugarCRM 7+” - I dont see how to just add an tag to the existing tags. I can add my new tag, but the previous one(s) are deleted.

3
P
3 years ago
D
devteamBeginner
asked in How Do I

Rocketreach find contacts and add to Hubspot

How can I fetch the list of emails  from rocketreach using custom search option in zapier.So basically I need to  create similar search (find contacts option) and get all emails using zapier.Attached image shows search.I need similar thing automated on zapier.So may be we can create and save search in rocketreach and then zapier can fetch all saved searches and automatically get all the emails. Please advise.Very urgent 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. 

3
christina.d
2 years ago
D
DaleS
asked in Code & Webhooks

Increment a spreadsheet column

HiNot sure if I’m asking in the right place.I am trying to create a webhook, with an action of incrementing a  given column in a Zoho worksheet.Update a column value - fine.New row - fine.Increment a specified column - possible?Many thanks

3
william
2 years ago
FreshyJon
FreshyJonBeginner
asked in How Do I

"Drip" campaign with Gmail and Asana

I was curious if anyone had any ideas on how to make the following happen:A Zap (or set of Zaps) that runs daily at 9am. It looks within an Asana project section and gets all tasks in that section. For each one, it finds the email address (in the Asana task’s custom field). It then takes each email address and sends an email (either via Gmail or Zapier Email) at 9am to all of those email addresses (ideally separately, and not as a BCC). Each day, it checks the email fields in that section again, and re-sends the email. It does this for 5 days in a row (per Asana task that it found). On day 6 (or at the end of the Day 5 sequence) it moves it to a new section in the Asana project; and thus it will stop finding this task during the Zap.But obviously for any new Asana tasks that may have been added to that section in the meantime, the Zap continues to run all the time, so any new tasks in that section will also be emailed 5 times.It's like a Drip campaign. Essentially: for each new task in

3
FreshyJon
2 years ago
K
Kateryna
posted in How Do I

Zap between Dux-Soup and Mailshake

Hi,I wanna connect Dux-Soup with Mailshake. But the possibility in the website just Mailshake with Dux-Soup.I need getting information from LinkedIn and then sent an email, not in a reverse.Could you help me? Thanks.

3
steph.n
3 years ago
M
microfawry
asked in How Do I

zap counter

I’m using gravity forms and connected it to tow sheets (google sheets and zoho crm) and i’m using the same form in the two sheets. the question is : if any body fill the form it will count in zapier 1 zap or 2 zaps ?   

3
Troy Tessalone
3 years ago
L
Lynne_Ann
asked in How Do I

Zoom Meeting Registration Add to Tag in Mailchimp

Is there no way to create a zap to add new Zoom Meeting registrants to a tag in Mailchimp? (Only webinar registrants?)

3
nicksimard
3 years ago
P
PSheridan64
asked in Code & Webhooks

Webhooks Test Successful, but not Pulling Data

So I’m attempting to setup a webhook to pull data from a website that pulls a clients Insurance Info from their carrier. That info is then sent to an Insurance Broker for quoting purposes. I’m attempting to set up a Zap that pulls info and sends it to the CRM create a new prospect. I’ve got the trigger set up but it gives me this info: pull_id“This is not the real ID it gives me but a fake one to use here”statusSUCCESSmeta_datanullquerystring The CRM action requires me to input name, address, phone, and email info. However I don’t have any test info for it to use. So I’m not sure what to use in those fields as I can’t procede since it’s required. Here is a link to the webhook info from the site I’m using for the trigger. https://docs.usecanopy.com/?shell#retrieve-a-pull-by-id

3
SamB
Community Manager
2 years ago
M
Mantzikert
asked in How Do I

Updating rows in Google Sheets with muliple items

I have data coming from shopify with Line Items being saved into a Google Sheet.  When an order is updated, new data comes in via a zap.I have to ensure all old line items (that aren’t in the order anymore) are deleted, update any changes to line items and add any new line items.I decided the best way was to update the existing rows to mark items as updated, and then just add all the new items again.However I have to look through the google sheets once, and then once that has finished, the Shopify items once.  How do I do this without running a loop inside a loop?  

3
M
3 years ago
R
Rafi
asked in How Do I

receiving sms (Twilio?) and converting it to speech

I am looking for a zap, if it exists, that will solve this issue for me. I have users who cannot receive sms messages on their cellphones. They need to receive a certain sms with a verification code for remote login. I can set them up with a Twilio phone number for receiving sms, and would need a zap that would then take that sms and call the recipient and read the content of the sms (ie the verification code) to the recipient having converted the sms to speech.I have found the ability to forward sms, to convert to email, to convert email to text, but I havent found anything that converts sms to voice over a phone call.theoretically I could do a roundabout solution of converting to email and then to voice, but it seems more efficient and simpler f sms to speech already exists.Any ideas?

3
R
3 years ago
A
Anonymous
asked in How Do I

Count number of users in a Google Sheet automatically to trigger new flow?

Hey guys - I cant seem to figure this out anywhere. How do I count the number of times a user has shown up in order to trigger a new flow (i.e. if a user shows up 1x send x message, if a user shows up 2x send y message?) really appreciate any thoughts. 

3
R
3 years ago
B
Become
asked in How Do I

How to restore a previous zap version?

Hi, I was exploring 1 zap and by mistake after I click on the field Choose app & event (as per below screenshot), I selected another type (Acuity) which completely replaced the previous setting. I have no idea what was selected before so I can’t redesign the zap again.And Zapier is built in a way thatIt automatically save any changes (no save button :S UX?) There is no way to revert the change you made just 1 sec agoWhat are the options to resolve this? Thanks a lot.   

3
SamB
Community Manager
2 years ago
S
sirtraximus
asked in Code & Webhooks

Webhooks - Return URL from Google Sheets

Hi everyone! I’m pretty new to Zapier but it seems that the possibilities are endless! I’m trying to achieve something using a webhook, but I keep running into errors. I wondered if someone might be able to explain how I can perform the following task.User clicks on a button on my website The button launches a random website from a list of ~300 sites I have in Google sheetsHere’s what I have done so far;Created a webhook and attached it to my website button Zapier Format Number = Spreadsheet-Style Formula Formula = Randbetween(1,300)Here are the steps I am having issues with;Connect and look up Google Sheet with number derived from step 3 Push URL from Google SheetIt seems I am unable to get the webhook to pull a URL from Google sheets based on the number from step 3.Would someone be able to talk me through what I need to do to achieve this?Thank you in advance.

3
william
2 years ago
D
DreamyEyez
asked in How Do I

Google Sheets to WordPress (eCommerce)

Good Day Guys,  I am doing some research to see if the following is possible, I would like to have Google Sheets connect to WordPress for an eCommerce site using WooCommerce. However every time the Google Sheets gets updated, it will need to update the Product Catalogue on WordPress. Please let me know if this is possible with Zapier?  Thank you

3
SamB
Community Manager
2 years ago
P
Panna CRMNew
asked in How Do I

Does Zapier use a single IP address?

Hi, it’s posible to have a single IP Address (or a short list)?My IT manager wan’t to use a list of IP for the security :(

3
SamB
Community Manager
2 years ago
J
jasonwexmon
asked in How Do I

Facebook Conversions not showing up in Ads Manager

Hi there, I have integrated my e-Commerce store with Facebook’s Conversion API using Zapier. Each time an order is made on my store (I’m using Konnektive as a CRM), I’m sending through a conversion event.When looking at my Events Manager in Facebook, I am seeing these conversion events come through, however they are not getting registered as purchases in the FB Ads Manager. One thing I see in Zapier is that there is an option to send through fbq and fbc parameters to identify events. However, these values are stored in cookies so in order to send them through I will need to access the cookies using Javascript and send them through as URL variables. Is this 100% necessary for the conversions to register in FB properly?

3
nicksimard
3 years ago
K
KK-CMBeginner
asked in How Do I

Unable to locate my Google Form spreadsheet

I’ve created a new Google form and connected it to a new spreadsheet where responses will be sent. But when I try to create a zap which is triggered on new response in the spreadsheet mentioned above, it is unable to find the spreadsheet (see image attached).  I’ve tried logging in and out of zapier and creating a different zap but nothing is working. I’ve never had this issue before and have made multiple zaps triggered by google forms. Please help!

3
william
2 years ago
S
SimiT
asked in How Do I

Linking monday.com to Hootsuite

Hi  I have a Monday.com account where I have a board for planning a few social media accounts. I am trying to link this to Hootsuite so that any post I put on Monday.com will automatically be scheduled on Hootsuite. Any ideas on how to do it.

3
M
2 years ago
M
MarkHamilton
asked in How Do I

Simvoly

Hi all.  I was just wondering if the Simvoly landing page builder can be added to Zapier somehow?  Ive searched for it everywhere and how to do it on the net, but cant find anything.  THanks

3
SamB
Community Manager
2 years ago
M
MysterDBeginner
asked in Code & Webhooks

Accessing Raw JSON array data using code by zapier - Output help

Hi there, I am attempting to retreive some JSON data from an API so I can parse out information to a gsheet. The aim is to get raw JSON from the GET request in “code by Zapier”. I’ve been successful in getting the JSON via the webhooks by zapier GET zap but I need raw JSON out so I can properly parse out the sections I need. This is the API call from a swagger page. const options = { method: 'GET', headers: { Accept: 'application/json', Authorization: 'Bearer 059c02e83998cdeddXXXXXXXXXX' }};fetch('https://api.fsomeurl.co/api/v1.0/menus/75966', options) .then(response => console.log(response)) .catch(err => console.error(err));Obvioulsy when I try to use this code in code by zapier I get an error  If you are doing async (with fetch library) you need to use a callback! I am not proficcent in Javascript but I do have a template that I can apply to the raw JSON to parse the information that I require in the next code by zapier step.  Any help in forming the GET request wou

3
Matt_Boyden
2 years ago
M
Maartje
asked in How Do I

New vs Updated Subscription Data from Woocommerce to Google Sheet

Issue: getting subscription data out of Woocommerce to analyse in Google Data Studio. This needs to be done Zapier because Woocommerce doesn’t export this data into a google sheets. Goals:create new subscription (DONE); update subscription when renewed (NEED HELP): how can one update only some of the rows when a subscription is renewed, and can the revenue which comes from the renewal be updated to add the revenue of the renewal to the first revenue generated through the customer buying the membership for the first time? Update total_revenue & next_payment_date etc.   

3
M
2 years ago
L
lukasvrBeginner
asked in Code & Webhooks

Trigger Zap by clicking a webhook link and make it user-friendly for use in emails

I am trying to set up an email to our clients including an offer. I’d like to have the client to have two options shown as clickable links.I am planning to use a webhook and using two different links.https://hooks.zapier.com/hooks/catch/1234567/abcdef?decision=accepthttps://hooks.zapier.com/hooks/catch/1234567/abcdef?decision=rejectIn the next step, the input through the webhook links will be used to trigger different paths of a zap.However, clicking the webhook links will lead to an ugly page. Is there any option to make this more user-friendly? Like automatically closing the window after clicking the link or redirecting after triggering the webhook?I saw two other discussions in the help forum, both without information on how to create a user-friendly method.Thanks for your ideas!    

3
Troy Tessalone
3 years ago
Terms & Conditions