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

21912 Topics

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
U
unieke uitjes
asked in Code & Webhooks

Multiple possible tax rate ids have been found.

Dear,  Im working on moneybird to create a Sales invoice in Moneybird, But if i fill in all the information an error with this information is be shown. '’Multiple possible tax rate ids have been found.'’I dont know what to change in the filled in information? So if anybody knows how to solve the problem, let me know.  Kind regards,  Unieke

5
william
2 years ago
T
tech_pierce
asked in Code & Webhooks

Connect tripadvisor.com reviews to clickfunnel.com using zapier with python

Hello, can you connect tripadvisor.com reviews to clickfunnel.com using zapier with python??

4
william
2 years ago
F
FenixShadows
asked in Code & Webhooks

Can anyone share an example of a trigger coded in Python?

Hi everyone,I would like to know if it is possible to have an example of trigger coded in Python just to understand the logic. Thanks in advance

5
william
2 years ago
S
Sergey SantosNew
asked in How Do I

Email was sent in Plain even though I chose HTML in the Zap

Trigger: Parser - New Email Action: Gmail - Send Email @Troy Tessalone Tr I have a similar issue to @egreene16026 (this post), but probably simpler.I’d like an email received in Gmail be forwarded to several recipients without:showing my email address and recipients can’t see each other’s email addresses.I tried Mail Parser to a test account and It did not have the header info as I removed it in the template.  That part worked as intented. But the email was sent in Plain gibberish, even though I chose HTML in the Zap.Perhaps there is an easier way to do this (maybe even without zapier)?

1
Troy Tessalone
2 years ago
S
ScottyShanksNew
asked in How Do I

How to change a "," into a ";"?

Hello, I currently extract invoices from Quickbooks using Zapier and Zap them into a CRM system called Freshworks. Quickbooks products within the invoices are passed in a single line separated by "," (Example: Product A, Product B). The CRM systems needs the products separated by ";"(Example: Product A; Product B).  Any idea how I do this?

1
XRay Tech
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
A
averycampbell
asked in Code & Webhooks

Paths - if Webhook returns "Bad Request"

I have a Zap that would take two paths. First, it searches for a client based on email via webhook. If there’s a client, then it returns a client ID number and proceeds with path A. If there’s no existing client, the first step would return “Bad Request” and then the goal is for it to proceed under Path B to create the client.However, it appears that because of the “Bad Request” (400) the Zap wouldn’t continue, even though I want it to.How do I fix this?

4
Matt_Boyden
2 years ago
C
clickzapNew
asked in Code & Webhooks

Webhook to ClickUp API with dynamic task_id

HiI’m trying to automate renaming the tasks with some standard naming convention as they are created. I’m trying to use the ClickUp automation webhooks with Zapier integration.I tested the ClickUp API with cURL to rename the task with the task_id. How do I automate this POST call with Zapier as I will not know the task_id?.In short, how do I get the ClickUp task_id as they are created and pass the task_id to the POST call for renaming the task with the help of Zaiper? Thanks in advance!

10
C
2 years ago
I
InaValBeginner
posted in How Do I

How to get subscription payment information for SaaS services with a Zap

Hi guys! I wonder, if there is a way to pull information about the subscription payment amount from one service to another via Zapier? I checked Todoist but haven’t found this option. I need to have this option for any SaaS service, so considering Todoist just as a real life example but it can be any other service as well. I understand that this option is probably available only for certain services…?

2
I
2 years ago
D
davidgecko
asked in How Do I

Inserting Line items from 2 tables to Xero

I have 2 SQL tables that work toghether as a bill. One has name of a person, date, and ItemID that links to other table, where it can be seen which items does he want to have or buy.Tables look like this: I want to insert the last added row in table1, but also all the items that belong to that row. For example the complete row for the Xero bill should look something like this, for last row in table1:Joe,2021-27-03,[Fuel,Oil],[20,2],[1.4,1.7]. All in one row and in arrays, so it can be imported to Xero bill.Can this be done somehow through Zapier? I know it has a Format option, where you can get line items from array. But not sure how to do it from 2 tables like this.

5
Paolo
2 years ago
G
ggus01
asked in How Do I

Gravity Forms > Hubspot - "select" field values not being added

I have several dropdown select properties set up in Hubspot and corresponding fields in my Gravity Forms form. The values are the same in both, but when the form is submitted none of the values are showing up in the Hubspot. Any suggestions/help would be appreciated. Thanks...GGus

2
william
2 years ago
J
JenHernRD
asked in How Do I

Setting up a STOP time for time-sensitive zap

I have a time-sensitive bonus I want to send to new orders for a 24-hour only special. Any guides or templates available on how to do this?I’m going to be linking a new sale via Thinkific to go through a special email sequence via ConvertKit.Thank you!

4
william
2 years ago
H
Hybrid-AgBeginner
asked in How Do I

Saving email attachments to a Pipedrive Deal

I have created a Zapier link that creates a Deal in Pipedrive when I receive an email. I am trying to find how you can save the attachments from the email to the deal. Any help would be greatly appreciated

5
william
2 years ago
K
kq98
asked in How Do I

Sending email with different pre-filled Google Form Link to different respondents

I am trying to send a follow up Google form that shows questions based on a respondent's previous response.  For example, in my 1st form, I have asked the following MCQ question: What role do you want to signup for?- Teacher- Student- GuardI then wish to email the respondents a 2nd follow up form that asks a different question based on the user’s selected signup choice:- Teacher: What subject do you want to teach?- Student: What school do you attend?- Guard: What shift do you want? The 2nd form should not have a conformation question that asks about the respondent's role choice again.Currently, I am exploring the zap that sends gmails when a new response is recorded in Google Form but the zap does not allow me to customise the email so I can send different pre-filled links to the respondents. How can I solve this problem?

2
william
2 years ago
L
Luigi
asked in How Do I

Jotform to Whatsapp

I’m looking for a way to push Jotform messages to the user via Whatsapp… Jotform doesn’t allow this feature… Is there a way to do it using Zapier? Even through 3rd part applications or services? Thx in advance for any help...

3
william
2 years ago
G
gregsnyder
asked in How Do I

Avoiding Duplicate Records in Insightly

I have Gravity forms linked to Insightly so that when prospects fill out a form on our website it generates three things in Insightly:Contact Organization OpportunityOften, someone who fills out the form works for an Organization already in our system, but the current Zap creates a duplicate organization. Instead, I want it to search for the organization in our system and add a new one only if it isn’t there. I used to have the option to do that, but it seems the options have changed.For bonus points, I would love for it to link the contact to the organization and to the opportunity so they are connected in the Related tab of Insightly.

9
william
2 years ago
S
SB!
asked in How Do I

RingCentral Connection

Hi there - I’m trying to connect RingCentral into my CRM to show call data. I’m encountering a hiccup testing my connection to RC.Background:We’re a new RC customer. There’s only a few calls in there. My account is a SuperAdmin w/o an extension. I’m trying to take call logs of our two remote salespeople and append that into our CRM. I’m not concerned about connecting via Zap whatsoever, as I’ve connected tons of Zaps. I successfully connected my account to Zapier, and went to test a Zap of a call ending in RC. When I test the Zap, I get this message:We couldn’t find a callCreate a new call in your  RingCentral account and test your trigger again.If I click on the call log in RC, I see calls in there. I cannot figure out why it wont detect the call.Is it because I am a SuperAdmin, and it’s only looking for calls on my account? I’ve tried searching for a solution on this and nothing is out there.The only thing I was thinking was to get the credentials of our two sales people and login as

2
william
2 years ago
G
gregsnyder
asked in How Do I

Linking Google Sheets to Insightly Projects

I have a Zap that creates a copy of a Google Sheet (and renames it) when we convert and Opportunity to a Project in Insightly. This is great, but I have a one more step I’d love to automate that I can’t figure out.In Insightly, you can link a Google Sheet to a Project in the “Related” tab under Files. There is a Google Drive button and you just search for your file and link it. Is there a way to do this through Zapier?

4
william
2 years ago
S
Stuart_HBeginner
asked in How Do I

Eventbrite - New Order trigger fields duplicated in action step

Hi Zapier Community,Seasoned pro here with Zapier, however we have come across a problem with the Eventbrite ‘New Order’ trigger doubling up on data when populating Actions.To recap, we are capturing data when a ‘New Order’ is received in Eventbrite. The data looks fine on initial testing, however when we go to populate an ActiveCampaign event with actions, the trigger data is doubled up when it populates the field. (eg; phone numbers are listed twice, date fields listed twice, etc etc)I tried using the format option to remove the double up, but because it’s technically not in source data it doesn’t do anything.Is this an error in the setup or potentially something Eventbrite need to address?

9
S
2 years ago
H
hhodgeNew
asked in Troubleshooting

Upload Entire Planning Center Table to Dropbox when New Record Added

Hello!Im working on integrating a DataBase for a company and I am having a hard time uploading files automatically into my dropbox. Im working with the software planning center and I would like to update an entire table to drop box every time a new record is added.Any suggestions? I can only recieve the single new record instead of a whole updated table? Thanks,H

1
Troy Tessalone
2 years ago
D
Daniel Ben-AmotzBeginner
asked in How Do I

Intercom actions need improvements

Hi there,We’ve been using Zapier for a while now and utilizing it’s integration with Intercom yet we’ve been experiencing issues that are caused because the current Zapier actions need to change. The main issue is because there are users who have multiple User ID’s under a single email address. So there are actions where a user can be updated using both email AND user id and some that don’t, causing an error and preventing the zap to perform the desired action (attached photo below):  

4
Danvers
2 years ago
F
FondaticBeginner
asked in How Do I

Deduplication, how does Zapier identify new records

Can someone please explain this to me:When polling... "Zapier automatically deduplicates and sorts for the newest data from the API."How does that work exactly?

3
Troy Tessalone
2 years ago
L
Linda D
asked in How Do I

Cloud convert Google Drive Zap question

Okay- here is what I want my zap to do- before I try to build it- I would like to know if it can be done :)Folder Set: Projects>####Each folder within the projects folder is unique. Inside each folder we save a series of .tif files. Currently we manually take those files, and create pdfs in Cloud convert and put them back in the folder. The zap might look something like this: If new.tif file is saved to a folder within the projects folder, convert to PDF and save the pdf to that same folder. So for example- if “3654.tif” is saved/copied into file the folder Projects>6433, cloud convert would convert it and put it back into folder Project>6433 as 3654.pdf (both files will now be in the folder).  This would happen for any of the different folders within the projects folder. 

2
AndrewJDavison_Luhhu
2 years ago
J
Jordanmm
asked in How Do I

Shared Drive not accessible by Google Docs automation

I’ve tried pasting the Google Shared Drive folder ID into the Custom field in the Google Docs automation as suggested in these help threads, but it doesn’t work. Below are screenshots of the drive URL in question and the error message I receive.    

3
AndrewJDavison_Luhhu
2 years ago
Terms & Conditions