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.

25440 Topics

L
leadrouterBeginner
asked in How Do I

Gravity Forms Issues

Hi I am trying to submit a form to gravity forms. I am getting the following error. I have re connected. Deleted and reinstalled. Nothing works.   

3
SamB
Community Manager
2 years ago
T
Tezza1976Beginner
asked in How Do I

New Paid Order in Shopify - how to retrieve the product cost

Hi, I have created a Zap that sends an email to a supplier when a new paid order is created in shopify, I have created the email with all details apart from cost from the supplier, the cost is shown in the shopify listing, how do i pull the cost into the email to the supplier please? Sorry, new to this

5
SamB
Community Manager
2 years ago
C
Clayton GeorgeNew
asked in How Do I

Zaps using SQL Server - Port forward restrictions

I’m with IT support for a new client, and while preparing to transition their network configs to a new firewall, I’ve noticed multiple unrestricted SQL-related port forwards - one of which is labeled “Proposify Zapier”. I need to get more information on how these ports are accessed and if they can be IP-restricted. I would prefer to speak to someone in a non-forum setting if possible, but I’ll take what I can get. Thanks for your time.

3
SamB
Community Manager
2 years ago
S
sbullet46New
asked in How Do I

authentication failed: javascript exception: error: certificate has expired

My connection with Parseur stopped working suddenly and received the above error message when testing the zap.  I go to reconnect and I just keep getting the error. 

21
christina.d
2 years ago
D
DigitalDaveNew
asked in How Do I

Possible to enter search string to filter ConnectWise tickets by instead of selecting previous ticket?

I wanted to attempt to create a Zap that looks for a specific string of text in new tickets on a specific service board and then perform an action. Based on the above, I created a trigger, well I should say attempted. I can select the board from the drop down list, but when attempting to use the “Specific Service Ticket Filter” section, it is listing EVERY ticket we’ve have in CW starting from ticket #1. Typing terms in the search box returns no results unless the term was found in the initial set of tickets loaded by Zapier. I had to click on the “Load More” button over 30 times to find any additional results. Seeing that we are on ticket #798202 currently, it would take me approximately 4 days of continuously clicking on the “Load More” button to potentially get to the the new tickets that are being generated.  My question is the following: Is there a way to just type in a string and have the Zap use that instead of having to select a previous ticket? 

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

How to replay a failed step at certain intervals?

Hi all,I have the following flow set up to create a new Slack channel for each new client, then search for a launch announcement, after which it sends copy of that launch message to finance:I create a calendar event with a new client This triggers the creation of the client’s slack channel (i.e. the Slack channel changes every time) After delaying for a certain period, Zapier searches for the ‘live’ keyword within the client’s slack channel If found, this sends a Slack message with the text containing ‘live’ to a specific user. If not found, how do I get it to retry at specific intervals (e.g. daily) until the ‘live’ keyword appears on the channel?Thanks in advance!   

1
Troy Tessalone
2 years ago
M
MBFBeginner
posted in How Do I

Set-up automation - Use Keap invoices to create Shopify sales

Hey there!I’m looking for a Zapier Expert to help setup an automation between Keap and Shopify.The goal is for when an invoice is paid for, that Zapier creates an automation to automatically generate a new sale on Shopify whilst linking tax-free and tax-inclusive products.I’ve tried it myself, but have challenges setting it up correctly. Any help would be great!

5
T
2 years ago
I
iJordyMNew
asked in How Do I

How do I convert text string into values?

Edit: I mean number instead of value.I am using Zapier to log orders in Google sheets. The problem is however that when I try to calculate, for example through formulas I get the notification that it is a text string and cannot be converted to a number.. Have tried to use the formatter, but simply cannot seem to make it work. How do I get Zapier to log a number as a number instead of text?

6
Troy Tessalone
2 years ago
V
Valentin VendyBeginner
asked in Troubleshooting

Odoo CRM certificate has expired

Hello,Suddenly my zaps using Odoo CRM are not working anymore because of an authentication failed. We did’nt change anything, it just happened suddenly. When trying to reconnect, I get this error, see screen shot. I don't understand. Please can you help.Thanks

5
Troy Tessalone
2 years ago
D
DonINew
asked in How Do I

ManageEngine ServiceDesk incident description missing

When setting up a ZAP to push data from Manage Engine Service Desk to Azure DevOps, the Incident Description from Manage Engine doesn’t appear to be an available field in the Action Event to send in the Incident Description into a Azure Devops User Story. Is there a way to get this field in Zapier? Is this field restricted because of the Trial?  I am currently trialing the software. If this isn’t possible we are probably going the route of using Manage Engine’s API to pull it and upload to Azure ourselves. Hoping Zapier can get this field.  Any help\tips would be appreciated.

5
D
2 years ago
Z
ZoBro23Beginner
asked in Code & Webhooks

Instant Google Sheets webhook not working

The Google Sheets instant webhook is not working, but the Team Drive (polling) one is… Please help me.

3
Troy Tessalone
2 years ago
S
SonnyWellnessBeginner
asked in How Do I

How can I create a HiBob trigger that integrates employee holiday bookings with Deputy?

There are only 5 triggers for HiBob currently, and they are all focused around creation or removal of employee… I need a trigger that can transfer the data of an employees booked holiday to be transferred to Deputy.Simple workflow___________________________Trigger: HiBob - Employee Books Holiday Action: Deputy - Adds Unavailability to Calendar/Rota How can I get this developed or created? Or is there a way to use custom web hooks to deliver this functionality?  

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

Start and end date on Google Calendar event changed to the same date

Hi there,I’m currently working on a new zap which I’m setting up between gsheet and google calendar. Everything seems to go to the Google Calendar fine, however, the start and end time for some reason are being the same. I’ve also checked the timezones for both Google Calendar and Zapier and they are both correct at GMT+9. Any help on this matter would be appreciated.  Best,Jay

1
Troy Tessalone
2 years ago
Z
ZoBro23Beginner
asked in Code & Webhooks

Cannot send to Google Sheets: Parse Error

I am getting the above error. Here is my Zap link: https://zapier.com/shared/4a86e88543da34463ac31ffce5c710184c6832e1. Please help me.

1
Troy Tessalone
2 years ago
A
AndrewGaffNew
asked in How Do I

How to match order subitems in monday.com with items in Excel?

Hi Guys, I am using a Zap from Excel to Monday.com which pulls through the Rows in a table as items.However, these are Purchase Orders and I would like Zapier to pull through the Purchase Order Lines as Subitems relating to the Purchase Order No (Name of the item on Monday). For Example.Order No: 1 (Item)           Subitem Name: Pen           Subitem Name: Pencil The table in Excel contains all of this information. However, getting a Zap or Monday to match this and input it under the correct Item I cant work out. Hope that makes sense...

5
Troy Tessalone
2 years ago
S
sushmaNew
asked in Code & Webhooks

WordPress permission_callback argument error

Notice: register_rest_route was called incorrectly. The REST API route definition for zapier/v1/token is missing the required permission_callback argument. For REST API routes that are intended to be public, use __return_true as the permission callback. Please see Debugging in WordPress for more information. (This message was added in version 5.5.0.) in /home2/sxbtrohj/public_html/wp-includes/functions.php on line 5313  getting the error on my site

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

Sendinblue - Kayako: How can I add contacts with Name and Email Id

Hello, I have done connection between kayako and Sendinblue. But contacts adds with only email id. How can I get add contacts with name and Email Id? Thanks,Mani

4
GetUWired
2 years ago
M
MKB DesignBeginner
asked in How Do I

How to add time entries into Quickbooks Time using Google Sheets?

I am struggling with a zap that creates a time entry in Quickbooks Time from every line entered on a Google Sheet.  I would like for my admin to collect and log time performed by several people working on a single project.  I don’t want to give her access to my Quickbooks account and I can’t add her to my Tsheets account (long story). Has anyone written a zap for this that they are wiling to share.  I also use projects in Quickbooks so the time entry would have to link to the correct project

3
SamB
Community Manager
2 years ago
C
carl shenBeginner
asked in How Do I

Error on Facebook Lead Ads "Invalid permission issue with Facebook, ensure this account can access the page."

HiDr.MVP FB Customer from FaceBook Lead Ads Data error message ‘Invalid permission issue with Facebook, ensure this account can access the page’，As shown below：Also in FaceBook Zapier application permission setting ，As shown below： All set to on。use simultaneously.https://developers.facebook.com/tools/lead-ads-testing/。tested, all messages were successfully sent.But when the customer actually transmits, it fails. May I ask what caused the problem, thank you

5
SamB
Community Manager
2 years ago
Z
ZoBro23Beginner
asked in Code & Webhooks

Google Sheets quotation marks being dropped

The Google Sheets webhook will give me the data of all the columns in a row, but the problem comes when the column contains a quotation mark. “ blabla’blabla “ gets automatically translated to “ blabla “. Is there any way to keep the quotation mark. For example, use `` or “” for JSON.

2
Z
2 years ago
N
Nathan HamiltonNew
asked in How Do I

Select owner in Airtable using member name from Trello?

I’m setting up a Zap that is triggered by any card being dropped into an In Progress list in Trello.That trigger then creates a new record in an Airtable base. That’s easy enough to set up as a Zap.But I can’t figure out how to get the Trello Member Name to populate the new Airtable record in a column named owner.The only option I could see was mapping a Trello field named Member IDs (or something like that) to the Owner column in Airtable.I’d like the Airtable record to display the actual Member name on the Trello card, not the ID.Is there anyway to achieve this? If the Member ID route is the only option, is there a way in Airtable you know of to map a set of names to specific Trello Member IDs?Thank you for your help! Loving Zapier so far.

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

Set Microsoft Office 365 calendar appointment reminders to 30 mins?

The O365 calendar appointment seems to be a little light on in what can be done, has anyone found a way to change the calendar reminder from it’s default of 15mins to say 30mins? Similar to what you can do with Google Calendar Zaps.

6
Troy Tessalone
2 years ago
J
justSethBeginner
asked in How Do I

Dynamically select Zoom event based on Salesforce event name

Hello- Currently, I create about ten zaps a month that does the same exact thing.The user registers for an event in SalesForce, the Zap filters the Event by Name hat I add manually, then creates a registration in Zoom for the user.  Again, I do this separately for each event… about ten per month.What I’d like to do is create a single Zap that uses dynamic filter. So, where <salesForce Event Name> = <Zoom Event Name> This way, I create one zap that looks for matching names on both platforms. If they exist, create user registration in Zoom. Does this make sense? Many thanks,Seth

1
robschmidt
2 years ago
L
LZAXSNew
asked in How Do I

Will tracking number work within Shopify "Update Order" Zap?

Will an added “Tracking Number” in Shopify work within the “Update Order” zap?

1
Troy Tessalone
2 years ago
D
DubjohnstonNew
asked in How Do I

Manage Zapier for multiple companies but not their app

Hi,I am looking at connecting my software to Zapier as an App. This App will be used for very simple functionality in Account Software Apps (Zapier connected). I would like to pay for all Zaps using my App and manage it on behalf of my clients. I would not know the password to my clients Accounting software (ie, to connect app). This would likely be a Teams or Company account but wanted to ensure the following capabilities:1) I would manage all Zaps. Ideally, my clients would not have access to Zapier.2) I would know my clients email address they use to log into their Accounting software (ie, Xero), but not their password.3) I would send my client a link (or similar) to log into their accounting package to then connect/sync Apps (my app with Accounting app).4) All billing would come to me.I hope there is a solution.Any help would be great. I'll also need a developer to connect my app (less than a handful of triggers. I have an API) to Zapier.ThanksDub

3
D
2 years ago
Terms & Conditions