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

20279 Topics

C
chris.hodgkissNew
asked in How Do I

quotient to wave

I am trying to get accepted quotes within Quotient to produce a draft invoice can anyone advise on what might be going wrong for me? Common Problems with Wave on ZapierLast Updated: Jan 27, 2020Error Message: "INVALID: Transaction line items in the transaction currency are over balanced."There are a few scenarios where this error appears when using the action "Record Sales":If the "Sales Tax Amount" field contains a value, then "Sales Tax Abbreviation" must also contain a value and vice versa.  If the "Processing Fee Amount" field contains a value, then "Processing Fee Expense Category" must also contain a value and vice versa. Lastly, check you've selected the incorrect "Number Format". Use "Major Units" when working with decimals (e.g. $1.21) and "Minor Units" when there are no decimals (e.g. 121¢). 

3
AndrewJDavison_Luhhu
2 years ago
O
oshaugryBeginner
asked in Code & Webhooks

Splitting orders and line items from Shopify to another shopify store

Hello,I have a dropshipping store that uses two suppliers to fulfill orders.I have an issue when a customer places an order with product from both suppliers in it. Customer purchases Product A and Product BSupplier A fulfills Product A and Supplier B Fulfills product B.I have a conditional formate set up so that based on which supplier the product belongs to , the order will continue down path A or B.Here is the problem. The conditional formatting picks up both suppliers, but  sends the entire order (Product A and Product B) to each supplier. I only need product A to go to supplier A and Product B to go to supplier B. Is there a way to do this?I have access to my suppliers shopify and I am webhooking in the orders from my store into their store. So here is where all of the line items from the entire order show up and cause me issues.  Thanks

4
AndrewJDavison_Luhhu
2 years ago
S
shwetaBeginner
asked in Code & Webhooks

Running into issues after returning a valid output through Postman

Facing issue to create trigger const options = { url: 'https://anywheredevwebhost.azurewebsites.net/api/TokenAuth/ConvertEncryptPasswordForTesting?pwd="5454454""', method: "GET", headers: { Authorization: "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxIiwibmFtZSI6ImFkbWluIiwiQXNwTmV0LklkZW50aXR5LlNlY3VyaXR5U3RhbXAiOiJQWUpETlhWREpaQkpOTVhTSTZCQTdQMk5DQk40RENUTyIsInJvbGUiOiJBZG1pbiIsImp0aSI6IjRjN2RiMGFmL…….", Accept: "application/json", }, params: {},};return z.request(options).then((response) => { response.throwForStatus(); const results = response.json; // You can do any parsing you need for results here before returning them return results;});Getting the error:When I am calling same API in postman, it returns a valid output but I’m having issues with Zapier could you please help.Thanks in advance

3
AndrewJDavison_Luhhu
2 years ago
T
tashafrankenNew
asked in Code & Webhooks

How to set up custom Vimeo webhooks?

Hi! We are looking to create a zap where: once someone unsubscribes/pauses their subscription on our vimeo platform, they are automatically added to an unsubscribed email list on Flodesk. The web hook topics we need to trigger this are:For paused–– customer.product.paused customer.product.resumedFor cancelled–– customer.product.cancelled customer.product.expired I have created these in Postman because Zapier X Vimeo doesn’t send through those lines of code (photos below), but am unsure the step needed to then connect this Postman data to our Vimeo interface so the integration can run.   For reference this is what we are trying to achieve:1– The customer.product.paused / customer.product.resumed / customer.product.cancelled / OR customer.product.expired webhook needs to be triggered in VIMEO2– When one of those lines have been triggered in VIMEO, we will need Zapier to add the customer to an unsubscribed email list in FloDesk What steps are needed next?  Thanks so much!Shelby

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

400 Error from JW Player

Hello,I am trying to run a zap from jwplayer to google sheet. My aim : anytime I download a video on jwplayer, I want to create a row in a google sheet. I can define very well my zap, can establish connection with jwplayer through the API credentials… Testing in zap definition is running well. But When I want to run my zapp, it looks like it is searching for a while then I get this message Error turning Zap on: Got 400 calling POST https://api.jwplayer.com/v2/webhooks/, expected 2xx. I tried several time… but I get Stucked…Some picture will describe my problem…Testing is working fine  in My App menu Media definition is working fine :  Testing one record in Zap definition is working fine and I can get one example from my account in test trigger But If I try to turn ON my zap, in different way, i still kept the same message and ZAP doesn’t turn ON : I DO NOT UNDERSTAND… Thanks for your help

2
SamB
Community Manager
2 years ago
R
Robert BlaauwendraadBeginner
asked in Code & Webhooks

Dynamic dropdown trigger with parameter

I have created a dynamic dropdown input field in my resource which runs a trigger. This trigger makes a request to my api and returns the data as fields only if they’re of the kind ‘post_type’. This works fine but in the future I want to use this input field for multiple zaps, so the following if-statement has to be replaced:if(content_type_kind == 'post_type')with something like:if(content_type_kind == type)where ‘type’ is a variable which is different for each resource with this input field.How can I send this variable from my resources to this trigger?

3
R
2 years ago
J
jeremyNovigiBeginner
asked in How Do I

Using Google Sheets to perform calculations on contact details in HubSpot and update contacts with new data - lagging

I am currently creating a Zap in which when a contact is updated or changed in HubSpot, the contact is imported into an a Google sheets and certain statistics are calculated based on the imported data. Once the statistics are calculated, the contact details in HubSpot are updated with the new statistics. The final step in the zap is to delete all the imported dataI’ve managed to get this to work when small numbers of contacts are changed. However, I encounter a number of issues when larger numbers of contacts are changed. (I’ve tested by changing 100+ contacts in one trigger):The zap itself becomes laggy when it is triggered. I imagine this is because the zap is importing details, exporting calculations and then deleting the row for each contact. The lag results in some rows not being deleted. The number of tasks used is extremely high since the zap has 5 tasks and the zap technically runs for each updated contact. If the zap runs 100s of times a day, its likely that the monthly task l

4
J
2 years ago
M
mmorrisseyBeginner
asked in How Do I

Use Google Calendar Events to Create Daily Agenda Google Doc

Hi,I create a daily agenda Google Doc every day using a template and I’d like to automate that. I found a tutorial that mentions populating Google Docs using calendar event info but I haven’t found any details to actually do this.I have the zap template to create a daily google doc, but I can’t figure out:How to create a google doc template that will use calendar data How to add that step to the zap that creates my daily agendaIs this actually possible?

6
nicksimard
2 years ago
W
Warr FlooringNew
asked in How Do I

Extracting Date from within Email text

helloi am new t this but after trying all combos i am stuckall i want is for my gmail to link to calendar for workthe problem all the data is in the email date address etcexample:Job Reference: NAP106212Customer Name: abcdefgheudMobile Phone: 1982372894Work Phone: 12345959Install Date: 09 Jun 2021Install Address: 35 iefheufhInstall Suburb: iejfiefInstall City: eifhiehfi dont know how to extract the date to crate a new event for as the date is just when the email arriveddo i need to have the email body split as i have tried the whole body as to no luck cheers  

1
M
2 years ago
S
spatialdevNew
asked in How Do I

Eventbrite to Google Calendar event - incorrect time

I have a zap set up that automatically takes new Eventbrite events and adds them to a Google Calendar. However every time a new Eventbrite event is scheduled, it ALWAYS gets put on my Google Calendar at 8:21pm on the day the Eventbrite event gets created (not the day its scheduled for).This is how the date/time field is set up in my Zap.Any help? 

1
Troy Tessalone
2 years ago
F
Fug1Beginner
asked in How Do I

Using input data as Google Sheets Spreadsheet or Worksheet name

I’m trying to figure out if it’s possible to use input data from an upstream trigger or action to specify the Google Sheets Spreadsheet or Worksheet name to use. The trigger for this zap is a webhook from Google Sheets that includes a variable called “id”. I would like to use the contents of that variable to determine which Spreadsheet or Worksheet should be written to with the output of the zap.

9
S
2 years ago
C
coolguy007New
asked in How Do I

Office 365/Outlook Sending Duplicate Emails

I have an automatic email setup that gets triggered when a client signs a Practice Ignition proposal. Office 365 Outlook is supposed to send a message to my admin/onboarding team… but lately it’s sending 3 duplicate messages. Anyone else encountering this error and know how to fix it?

1
Troy Tessalone
2 years ago
T
tootsies19Beginner
asked in How Do I

Trello to Slack Zap - add only the latest Trello comment

I’m working on a Trello to Slack zap, where any updates to a card in Trello will push a Slack post. The issue I’m facing is I want to insert the most recent comment from the Trello card. The only option I can find is to insert all comments, which makes the Slack post super long and unnecessary. I just want to show the most recent comment on the card to show the latest update. 

1
T
2 years ago
M
MikeJonesUSCBeginner
asked in How Do I

Jira description field - how to get the entire Description field as markdown?

I’m having the same issue.Expected behavior is a single description input field from Jira, containing markdown.Instead, it appears to parse out the Jira description field into multiple inputs, which are just plain text.Example:Jira Descritpion Intro text bullet list 1 bullet item 2 bullet item 3 More descriptive text about the issue. When I go to setup the action in Zapier, there are two options for Description that include content. The 1st one has the intro part as plain text and the content after the bullet list as plain text.  The 2nd option has only the bullet list, but as separate plain text entries. Second line content redacted by meThe goal is to get a single input of the entire Description field as markdown (which is how it’s supposed to be provided by the Jira API)

2
M
2 years ago
P
Pau RolonNew
asked in How Do I

Connecting to MySql 8 Digital Ocean database - Bad handshake error

I’m trying to create a connection to my database from Digital Ocean, using Mysql 8 version, everything is configured to give access to anyone to our database, ssl is disabled, bind address is set to *, firewall allows the zapier IP, but it keep failing with the error (pymysql.err.InternalError) (1043, 'Bad handshake'). I don’t know what else to try to be honest, need some help, thanks.

1
Troy Tessalone
2 years ago
A
AJRugglesNew
posted in How Do I

Test & Continue in Zap Editor shifts my "place" in the Zap

It’s hard to describe this behavior, but when I’m creating Zaps and I click Continue on a step, the browser jumps to lower down in the Zap, so I have to constantly scroll up to see the results of the test, for example. What I don’t like about it is that I can lose my place in the Zap if I’m not super focused. Perhaps this is a browser specific issue? Does anyone else have this issue? I’m using Chrome.

2
A
2 years ago
S
Sean JonesNew
asked in How Do I

Issue with sending information from a multistep ClickFunnels to Google Sheets

Hi there, My company wants me to use Zapier to record questions that follow the initial optin page to Google Sheets. There are multiple steps: 1 Optin: button click opens popup that presents the user with an optin form.  the user submits the form with the submit on the popup and is redirected to next step. 2 Next step: a series of custom_type form fields are presented with a button at the bottom. click the moves to next step. 3 next step: another page with custom_type form fields and a Submit form button at the bottom. as of now… ClickFunnels records the contact and will send the contact to Zapier on the optin step.  But, I am having a hard time with the two pages of qualifying questions that follow the initial optin step.  I need to record to the answers to Google sheets before forwarding the user to a thank you page and I am a bit lost.any assistance would be appreciated. Thanks a ton!     

2
william
2 years ago
R
ReputationToolsNew
asked in How Do I

Custom CRM Intergration with API

My client is using a home built CRM which has it’s own API, but is not set up with Zapier.  What do they need to do to get connected so that they cansend out review campaigns using the Rephttps://zapier.com/developer/public-invite/113914/31a5dced6c22ae98917316d0cac737d6/Your Zapier API KEY[API KEY REMOVED] REPUTATION KAHUNA 2.0Automate company integration with Reputation KahunaYOU WERE INVITED BY: [EMAIL ADDRESS REMOVED]The Reputation Kahuna 2.0 team invites you to test their Zapier integration before it's available for everyone. Neat! Accept the invite and build a Zap with Reputation Kahuna 2.0 to get started.If you know and trust the developers behind this email address, then this invitation should be safe to accept. This app has not been reviewed or approved by Zapier for functionality or security.

2
william
2 years ago
3
3growRussNew
asked in How Do I

Error Authenticating WordPress

Hi,  I’m receiving the following error when trying to connect WordPress to Zapier: authentication failed: Got 401 calling POST https://3grow.net/wp-json/zapier/v1/token, triggering auth refresh. I have ensured the Zapier plugin is installed and activated. Please could you provide a solution, or get in touch to assist? Many thanks,Russ

2
william
2 years ago
A
ArnoxNew
asked in How Do I

Can you use Zapier to remove or delete people/users from apps and FB groups?

Hi There,I am playing around more with how we can use zapier to streamline areas of our business. We work with a number of clients that are currently set up in a CRM system, PTD app and a private FB group. Is there a way when we remove a client from one it removes them from the others? Don’t mind the order to do this but would be great if instead of having to remove the client from all 3 places we can just do in one click. I am a complete beginner at this so any help is greatly appreciated.Thanks,Becky

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

system to release files when criteria is met

My current workflow when I release files to a client has me uploading them to Dropbox.  Those folders are sometimes manually created and  sometimes when I receive a booking (which is handled by zapier: google.forms/sheets/emails/ dropbox/ xero) Once files are uploaded the client is notified by Dropbox, but I also send an email. My problem: "the clients" are not always paying for the work. But I rely on the clients to provide invoicing details.  I need a system to withhold the files until details have been provided (full name/pH/email)In the past I built this into a booking system, but this deterred clients from making bookings (really!). So I need a system that will not impede bookings at all. But that when they want the fruits of my labour, they have to jump a small hoop as painlessly as possible.My first idea was to have them fill out a form, Or drop a contact into dropbox that unlocked the privacy setting on a Dropbox folder, but this is not a zapier action. (Wah!)I have ADHD. I kno

3
william
2 years ago
T
thinker500Beginner
asked in How Do I

Google Sheets: The read operation timed out.

I am getting the following error quite a few times when reading from or writing to Google Sheet. I know it’s because of the total number of columns and rows that Google or Zapier can handle at a time of operation. Is there any specific/known limit of columns and rows that we should not exceed to not get this error?Thanks 

5
D
2 years ago
O
OliOdinNew
asked in How Do I

Email with PDF from Outlook to google drive, reformat the email and forward to Outlook again ? Zapier, ConvertAPI, Google Drive

HI  I try to send emails with pdf attachments to google drive. save attachments to google drive and send the an email to a new email address with a new title and body text.  ich can save the files to google drive but it creates a Zip file.    i can unzip with using ConvertAPI but then it creates URL  and this ulr I dont know how I bring them back to google drive ?  how can I download them to google drive to send them away by email ?  when I upload again to google drive then it uploads again zip or just a txt. but I need the PDF file.  thank you find advance for any help 

2
william
2 years ago
P
PazmanNew
asked in How Do I

File contents too big

HiI’m trying to add an image -65kb to Trello from OneDrive and right from setup it says ‘file contents too big’.  Any ideas what I’m doing wrong? I need to see the image on the Trello card, not a link.Thanks

3
william
2 years ago
J
julia.polanco2New
asked in How Do I

Unable to find valid UUID to integrate Notion with Outlook Calendar

I am unable to find the UUID of an event in my Outlook calendar to fill Zapier’s item field, so that my Outlook events trigger and update my Notion calendar. What should I fill the the item field with?  

7
william
2 years ago
Terms & Conditions