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.

25236 Topics

M
mmitchellNew
asked in How Do I

Xero transaction - “JSON for post data was invalid, Error converting value” error

I’m trying to set up a zap between Excel and Xero to make it easier to enter them on a monthly basis.  The Excel side works, and finding/creating a contact in Xero works, but when I try test the creation of the bank transaction I get an error saying that the JSON for post data was invalid, Error converting value (Contact value) to type ‘System.Guild”.  Does anyone have any suggestions? 

3
Troy Tessalone
2 years ago
A
adarshsoni500New
asked in How Do I

How to add multiple line items from Shopify to invoices in Xero, Quickbooks

Please can anybody help me regarding this zap, or if someone can share workflow of zap it will be very helpfulI am stuck at this please help

2
A
2 years ago
M
MortgageCompanyITNew
asked in How Do I

Monday.com adding new row when one does not exist

We have a key field with an ID (First column).  How do I can I look to see if there is a row in Monday.com with the same ID and update the row OR if there is no row add a new one?  Detailed zap steps would be appreciated.

2
SamB
Community Manager
2 years ago
J
JavierNew
asked in Code & Webhooks

Get amount spent in Facebook campaign

Hello, I need to create a zapier webhook, and I want to call with a GET request and receive the amount invested (Cost) from a Facebook ads manager campaign.Is that posible? The leadads "api" doesn't give this information, it's a campaing value (like the Reach, Impressions, Cost per result, potential clients, etc...)I need something like asking "who much I spent yesterday in a specific campaign".Thank you

1
Troy Tessalone
2 years ago
Siddharth Basker
Siddharth BaskerBeginner
asked in Code & Webhooks

Error handling Mechanism and Calling of REST Service

Hello Team, I have recently started exploring Zapier and wanted to know the answers for these following questions:How do we generate specific errors such as Bad request, Unauthorized (400 and 401 for example )and is there any specific error handling mechanism we can use to handle that error. How do we connect to a 3rd party URL for instance if I have a URL that is from SAP and want to fetch it into Zapier(https::datafromsap.com) , which component can I utilize to perform the mentioned action.Please do guide me on the same , thanks in advance, looking forward to the replies Warm Regards Siddharth  

8
Troy Tessalone
10 months ago
K
kpidanBeginner
asked in Troubleshooting

Google Ads error: Failed to create an offline conversion in Google Ads 504 Gateway Time-out

Hello, i am trying to create a google ads offline conversion zap, but i get an error message in the final test. The connection with Google Ads is working, I don't understand how to fix. It has always worked in the past!This is the error message:Failed to create an offline conversion in Google Ads<html> <head><title>504 Gateway Time-out</title></head> <body> <center><h1>504 Gateway Time-out</h1></center> <hr><center>nginx</center> </body> </html> <!-- a padding to disable MSIE and Chrome friendly error page --> <!-- a padding to disable MSIE and Chrome friendly error

3
christina.d
1 year ago
R
RyautomatorBeginner
asked in Code & Webhooks

Still can't set individual user permissions in Google Drive?

Sad to see that after 2 years, no apparent progress has been made on this: The “Google Drive - Add File Sharing Preference” action still does not allow setting permissions for specific users.Can’t do an API call using “Custom Request in Webhooks” either because it only supports basic auth, but Google Drive requires OAuth.Why has nothing been done to address this in 2 years?Does anyone know of a workaround that isn’t a nightmare to setup & maintain?

6
MohSwellam
1 year ago
F
Fabio CustódioBeginner
asked in Troubleshooting

Trello + RD Station > Error Message: While requesting "attachments" from Trello we ran into an error: The app returned "File not found".

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.I need a help. I connected Trello and RD Station (marketing management) using the Zapier. But in some zaps happned this trouble: While requesting "attachments" from Trello we ran into an error: The app returned "File not found".I don't use attachments, for this reason I don't understand.  

13
SamB
Community Manager
6 months ago
A
amoss9999New
asked in How Do I

Using today's date as a value in a Filter

I’m trying to set a filter that checks the Due Date of a task against Today’s date. Any suggestions on how to set a variable value of today’s date in a filter condition?

4
A
2 years ago
D
DavidF.Beginner
asked in How Do I

How to assign Azure DevOps Feature to a Parent Epic

I have a Zap that’s somewhat working the way I want. It links Salesforce to Azure DevOps. When a Field changes on a Custom Object in Salesforce, it creates a new Azure DevOps Feature record.The new Devops Feature record gets created in the correct Project, Area and Iteration because I can map those fields. But it doesn’t get assigned to an Epic so it’s basically “orphaned”.In my zap, I tried adding a step to add a link to the Epic but it only shows up as a link instead of a Parent Work Item. How do you assign a newly created Feature to an Epic?

1
SamB
Community Manager
2 years ago
Z
zap29550Beginner
asked in Code & Webhooks

API call returns a PDF document -- how to alter file type

I have an API call that returns a PDF document, however, the document doesn’t have a file type. Is there any way to change the file type to pdf to be attached to an e-mail? When it comes through now in the e-mail it just looks like: 

10
Z
1 year ago
F
FreezezapBeginner
asked in Code & Webhooks

GET data from multiple URL in the same Zap

Hello, I’m trying to create an automation with Zapier to check if a product is out of stock on Amazon. Here is my current automation:Step 1: Every day in schedule by Zapier (scheduled 1 time per week)Step 2: Get Many Spreadsheet Rows - I linked a Google Sheet file with 10 lines of URLsStep 3: GET in Webhooks by Zapier - here is where I get stuck because I don't know how to get Zapier to check multiple URLs in only one ZapStep 4: Only continue if… Text contain a specific css class (out of stock class)Step 5: Send Outbound Email in Email by ZapierDo you think I'm doing it right/is it possible?Thank you in advance for your help!

2
F
1 year ago
D
duong3New
asked in How Do I

Box to create multiple collaborator from Google Sheets?

I have a zap that will create a new Box folder every time there are change in a column. Also, it can also add a collaborator. I would like to add more than one collaborator. In the field I try to add more than one email it return “ The app returned "Invalid input parameters in request". What is the valid parameters for this to add more then one email to the field?

1
andywingrave
3 years ago
J
joniberoNew
asked in How Do I

Connect DIVI theme forms to MailerLite

Hello, Im new here and i need some help. I’m trying to use Zapier to connect my Wordpress forms, created with Divi Theme, to MailerLite. The zap should start when a web visitor fills the form in Wordpress, and I want to receive his information on my MailerLite accout.Is that possible? I’m trying to start a new Zap but when I choose Wordpress, there is not a trigger of filling a form. Can someone help me? Thanks.

2
christina.d
1 year ago
thrillwave
thrillwaveBeginner
asked in Troubleshooting

Wordpress to LinkedIn: Wordpress title with an apostrophe becomes a string of "’"

I’m having an issue with the title of my wordpress blog posts integrating to linkedin company update posts with an apostrophe in the wordpress title. The apostrophe turns into a weird string of symbols. The trigger is the “new post in wordpress” module. And the action is the “create company update in LinkedIn (1.8.2)”. They both successfully connect. When I run the test, the title returns like this: “text: Equipment Doesn’t Make the Production, But It Can Set It Apart.” And then it posts it as such on LinkedIn. How can I get it to correctly display the title from wordpress to linkedin with apostrophes?  

13
reyanhanan
1 year ago
J
Josh BBeginner
asked in How Do I

Gmail workflow - add a CC email when an OOO reply is sent

I’d like to explore any customization options that will automatically CC a specific email alias any time an Out of Office reply is triggered. We use Gmail as are our email provider. Is this possible within Zapier? 

9
J
2 years ago
E
eyalbasonNew
asked in How Do I

Facebook Ads Receipt PDF

This is a URL that allows you to download invoice summary as a PDF - https://business.facebook.com/ads/manage/invoices_generator/?ts=[START_DATE_UNIX]&time_end=[END_DATE_UNIX]&act=[YOUR_AD_ACCOUNT_ID]&report=true&format=pdf This URL only works for you, if you have an access to the ad account, and while you’re currently logged in to facebook with this profile. I’m wondering if there’s a way to use GET or some other technique in order to retrieve this PDF file to a zap, and then use it somehow (saving it in Google Drive for example). Obviously Zapier don’t have access to this URL so it won’t be able to get the file. Is there maybe a way to grant some kind of permission for Zapier to do that? 

2
chanelle
1 year ago
M
MatthewCBeginner
asked in Troubleshooting

Error when looping through Google Sheet CSV, "Required field "Values to Loop" (loop_values) is missing."

I’m attempting to loop through a CSV of ticket IDs to add tags to tickets in Zendesk. I’ve been partially successful. Despite having 188 unique ticket IDs, I’m only able to loop through 58 of them before I get the error “Required field "Values to Loop" (loop_values) is missing.”I haven’t been able to figure out why it’s hitting this error before having tagged all the tickets represented in the CSV.Thanks for any help you can give!

10
M
2 years ago
C
cpzapBeginner
asked in How Do I

Make Clickup Due Date Recurring

Is it possible to make the due date in Clickup recurring for every year? I can do this manually in Clickup, but I would like to do that from Zapier. Here is the flow I have now: Jotform submission triggers Zap that creates a Clickup task and sets the due date from date entered on Jotform. I would like that date to be a yearly recurring date. Is this possible?

5
MohSwellam
1 year ago
H
hcarterNew
asked in How Do I

How do I automatically add and change which Google Drive parent folder my subfolders get added to, every Sunday?

Hi! I am very new here. I think I have simple one step Zaps down, but now I’m looking to expand on that.I was wondering if someone could help me with this situation: I currently have a Zap using Schedule that is creating a parent folder in Google Drive every Sunday. What I want to do is create a zap that will then add a subfolder to that parent folder every time the trigger I select happens...BUTI want that zap to end or change when a new parent folder is created the next sunday and then I want the subfolders to be added to the new folder instead of the previous parent folder. I hope this makes sense. I just do not know how to tell it to stop adding folders to one parent folder once the new parent folder is created.  

2
jesse
2 years ago
T
thinker500Beginner
asked in Troubleshooting

Not able to use "Formatter by Zapier" app

I am not able to use the “Formatter by Zapier” app. I can use all the other apps. I am the admin of the Zapier account. Then what could be causing this issue? 

6
christina.d
11 months ago
C
cloakBeginner
asked in How Do I

Search a database/csv and display the results on a webpage

Hi All,I have a wordpress website setup for a local based store in my city. The type of product that customers purchase at this store take around 3 months to be ready for them to pick up. This product cannot be sold online/eCommerce as it requires to be built bespoke.During the 3 months, there are a few updates on their order for example, measurements completed, manufacturing completed, etc.All of the customer orders have a unique order number which are stored in a csv file and the csv file also contains the current status of the order. This is a very simple table where there is two columns - OrderNumber, OrderStatus.What I require is to provide customers the ability to review their Order Status on the wordpress website - as follows:1. Customer goes to www.company.co.uk/checkOrderPage2. On this webpage, the customer is presented with a box to enter in their unique order number3. Customer enters in the unique order number into the box and clicks a button4. They are then displayed with t

1
robschmidt
2 years ago
A
abpBeginner
asked in How Do I

Can my Slack thread trigger include the original message?

I have a zap that is triggered whenever I include a certain symbol in a slack message. The zap pushes the message to a google sheet and creates a row for the information.Sometimes I use that symbol in a thread, and the zap continues to work.Is it possible to use that symbol in a thread and have the zap include the original message in the google sheet row?As an example:Original message: My name is Janethread: * I eat bananasthread: * I wear the color redIf the symbol that the zap is looking for is an asterisk, can I have the new rows created include the original message “My name is Jane”?

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

Single Select and Multi Select Fields are not coming in Documint creation step

I have data in Airtable and I am creating PDF in documint using these data values. I am using zapier to integrate airtable with documint for creating PDF automatically.But on creating PDF, in second step documint does not show all the fields in zapier. These fields are single select and multiselect fields. I tried this with make.com and documint app, it works amazingly. Here is the screenshot of everythingAirtable Test Data Documint template Zapier - Documint Step 

3
jesse
1 year ago
S
swombatNew
asked in Code & Webhooks

How to get filename from Webhook POST action?

Hi there,I’m 99% of the way with this and just need a little more help.I’ve got a webhook working, that is receiving a multipart/form-data encded POST query from a form I created on my site. One of the fields is a file. This is received correctly by Zapier since it creates a querystring entry for that file (let’s call it “file”).I want to then upload that file to Pipedrive. At the moment I have two imperfect ways to do this and I’m hoping to find a better one.Method one is to add a Note and, in the body, include the Webhooks field. In the test it looks like it’s including a hydrate text blob, but the note that appears in Pipedrive has a clickable URL instead. When I click that URL, I the file downloads, presumably from Zapier’s servers, and has the correct name.Method two is to use the “Attach file in pipedrive” hook, which asks for a file and a filename. But I have no way to extract the filename. I prefer this method since it doesn’t rely on Zapier continuing to host the file upload (

1
Troy Tessalone
2 years ago
Terms & Conditions