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.

24929 Topics

S
sajib353New
posted in Troubleshooting

Error: Failed to create a new row in MySQL (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server

Failed to create a new row in MySQL(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'mail.satyenboseclub.com' (timed out)") (Background on this error at: http://sqlalche.me/e/e3q8)

0
S
1 year ago
S
SamudraSEONew
asked in How Do I

How do I fill in the "Create Activity in Pipedrive" action?

HelloPlease help me solve the following Zapier to Pipedrive automation issues1. Why are the fields in Zapier and in Pipedrive different?2. In the "Create Activity in Pipedrive" action. There is no "Contact person" field, whereas in Pipedrive there is a "Contact person" field, how do I fill in this field?For more details, you can see the picture in the link that I attached Best regards

3
chanelle
1 year ago
S
schooltechteamBeginner
asked in Troubleshooting

Unable to receive email from Hubspot

Hello, When testing a Zap to send an email to a recipient in Hubspot, the email never gets to the user’s actual email address.  It shows in Hubspot that it has been logged/sent, but recipient does not receive it.  What settings should I check? Thank you.

5
S
1 year ago
C
chrisgscottNew
asked in How Do I

Pull weekly conversion data from Drip into Google Sheets

I want to automate the process of tracking conversions week-to-week using Zapier, but I’m not really sure how to pull it off. I really just want to be able to see the running trends of how many new free trials our saas app gets on a weekly basis, without having to bug my dev team to build it out for me.The end result I’m looking for is the number of new free trials that start each week gets stored in a column in Google Sheets. I’d like to base this off of a custom event that is fired in Drip.So I think the general idea is that every time the “New Free Trial Signup” event occurs in drip, I need to increment the number of free trials started in Google Sheets, but I also need to be able to tell Google Sheets when to create a new column at the end of the week and to start over from 0.Or I suppose I could use Schedule by Zapier to just pull all of the conversion data from Drip once a week and cram it into a Google Sheets cell. But how do I get it to only count the number of times that event

1
Liz_Roberts
1 year ago
T
The Chronic CC
asked in Troubleshooting

Filter out every n-th item from a lineitem or Printful order shipped

How would I separaste the 1,3,5,7,etc links passed from a printful order shipped trigger. The items ordered pass two links into “Items Thumbnail URL” where the 2nd URL is the desirable URL to keep out of the two for any item ordered.  I have 6 URLS and want every other URL from the item I cant seem to separate or truncate the right way, I want it to be dynamic to accommodate orders of different sizes

1
Troy Tessalone
1 year ago
J
jparnellBeginner
asked in Code & Webhooks

Webhook to excel save question

Webhook is providing data to an excel spredsheet throughout the day and after a certain time (ex. 1:00PM) we want the zap to do a save as and place into a folder in onedrive business.  Does anyone know if this can be done?

4
Troy Tessalone
1 year ago
T
techegNew
asked in Troubleshooting

Subscribing Failed

Does anyone know if the issue with Yoast SEO to Discord has been resolved, had this issue since October and heard nothing back and still have the same issue. The error message I get is; The app returned "Subscribing failed. A subscription already exists.".

1
Liz_Roberts
1 year ago
S
SacBeginner
asked in How Do I

Setup a HubSpot property modification trigger

Hi all!! I have been trying to do the following: Create a zap that triggers an action (concretely, create a Panda Doc document) when a particular property of a contact is modified in hubspot.  Example: I have a client called Joe who has passed from “client” to “ex-client” in our pipeline of lifecycle stage. At this point, I want panda doc to generate a signable document where all the client’s info is filled-in automatically for him/her to sign the cancellation of the contract.  I’ve tried to use the “Contact Recently Created or Updated in HubSpot” trigger, but in the “Trigger” step, I am only allowed to enter “values”, and I am not sure what values they are grabbing, but certainly not the values of the latest hubspot modification. Also, if anytime there is a modification in hubspot, it’s going to trigger a Panda Doc document creation, it’s obviously not a good solution, so I need to be able to filter out and create a Panda Doc documente only when the value of the field “Lifecycle Stage

5
S
1 year ago
T
tscheysBeginner
asked in Troubleshooting

Sub-zaps not found in new Zap

Hi, When I try to call a sub-zap in a new zap, the list of sub-zaps is empty, although I have 6 sub-zaps in my account, I can not select any.   I have plenty of sub-zaps in my home folder (see screenshot). They worked fine until now.   I understand this is still in beta, so maybe this is a bug? Thanks in advance for your help, Tim

4
R
1 year ago
C
cutmethodteamNew
asked in Troubleshooting

Calendly to Close CRM

Hi Community, I’m having trouble integrating data from a “new invitee” event in Calendly to the Close CRM. I’m doing the following with no success.New Invitee in Calendly triggers “create a new contact”. The zap is pulling the data I need into Close but its creating a duplicate contact every-time the Calendly invitee re-schedules or books a new event, ie books call one and then books call 2, a duplicate contact is created.Instead, I selected “search for an existing contact, or create one in Close CRM”. The problem when selecting this option is that is does not pull the email and phone number from the Calendly invite into the contacts section and it requires a SOURCE ID from the CLOSE CRM.I’ve tried the above tiggers with a “lead” instead of a “contact” with no avail. When I attempt to do a further setup it asked for the Close CRM Source ID for the Lead, which is problematic because then the rule that is set up pulls data from all new Calendly events to the one/specific Contact or Lead

2
nicksimard
1 year ago
H
hkalebjianNew
asked in How Do I

How can you get an example url from the Shopify API?

This question was originally posted on the aritcle:  HI there. I’m following your steps but the Shopify API doesn’t display a url example anymore. Any idea on how to get it?

1
Troy Tessalone
1 year ago
A
alon123New
asked in Code & Webhooks

Google sheet date field turns to random numbers

I created a webhook from my element or form to a google sheet.for some reason the date and time field I defined shows random numbers, what seem to be the reason and how do I fix this?* ill mention that the test from Zapier send those properly and the random numbers appear only when I send the form manually

1
Danvers
1 year ago
B
bawaNew
asked in Troubleshooting

The app returned "'500' is not of type 'integer' - 'key'".

I’m getting this error when I pass the int value to the `key`

1
Danvers
1 year ago
V
Vineet SinghBeginner
asked in Troubleshooting

Updating Notion item content is not appending text but replacing it with new one

I was trying to update the notion item with additional data by updating the content field which was suppose to append the text but in my case it is replacing the text with new update . 

5
L
1 year ago
D
dunkstewartNew
posted in Code & Webhooks

Sending selected text to Zapier via a chrome extension

I created a simple chrome extension that sends the currently selected text to Zapier via a web hook. It solves the problem asked in this question - Select Browser/Website Text, Right Click, Send To Zapier - Searched all day for the answer, can someone help?I built it to streamline my own product research with Dovetail.It’s called Post Selected, hope others find it useful :) Duncan

0
D
1 year ago
J
jrolfeNew
asked in Code & Webhooks

Is there a simple way to validate json?

I have a number of zaps that receive data via a webhook.  I then need to build a different json string using SOME of those fields, some other custom data, etc. to post to a different api using a separate webhook action.  It’s pretty simple, and all works well until some of my fields have invalid characters in them - like quotes or a backslash.  These end up invalidating the json because they are interpreted as string termination or an escape character by the system receiving the json.  In my case, it’s Splunk sending data to a listening Zapier webhook, which I then manipulate and send to a Cisco WebEx space using a custom webhook action.I can fix this by adding a “formatter” action and doing a string replace on any given field for any given character, but when I’m building a json string of say 15 different fields from my initial input, all of which “might” have a “ or a \, then that’s a very inefficient way to format.  What would be ideal if there was a simple “validate json” action, o

1
Troy Tessalone
1 year ago
J
jtiamsBeginner
asked in Troubleshooting

Troubleshooting GoToWebinar Custom Registration Questions: Character Limits & More

Hello. I’m aware that there are currently some bugs that were being worked on with the GoToWebinar app, but it seems like it’s loading my webinars again so I’m hoping those have been fixed. I used the exact same Zap last year to automate registrants from our website using the User Registration plugin in Wordpress to then create a webinar registrant in GoToWebinar. I ran into some issues previously trying to get the test to go through using custom registration questions. It ended up working for me though last year perfectly fine but I’m running into some similar issues trying to get it working now. On the troubleshooting section for GTW it says that it won’t be able to see custom registration questions, it had a similar message last year under troubleshooting, but I was still able to get this to work even using the custom questions. Is this still a common issue with GoToWebinar or can custom registration questions be used still? If so, are there any character limits to the questions or

4
chanelle
1 year ago
amybrocious
amybrociousNew
asked in How Do I

Is it possible to turn a Zap OFF after a zap has been completed?

Hello! I was wondering if there was a way to add an action step for the Zap to turn OFF once a Zap reaches it’s “final” step?For instance, we have a Zap that is scheduled each week to lookup rows in Google Sheet, looped, and then sends an email. After the Zap reaches that last step of sending the email, is it possible to add an action afterwards to turn OFF the Zap? Or do I have to create a separate Zap to schedule it? I’m just trying to avoid having to create additional Zaps if I don’t need to. Thanks for your help!

5
chanelle
1 year ago
R
Recruiter_46135Beginner
asked in How Do I

Google Sheet Navigate to LinkedIn Profile Save to PDF

Is there a way to create a Zap to navigate to a LinkedIn profile from a Google Sheet and save the profile to PDF?

7
chanelle
1 year ago
E
Everette SBeginner
asked in How Do I

Whats the best way to execute an action only once on an update trigger?

I am trying to combine two zaps that contain similar formatting steps. The apps that I am using are Ganttic, Ryver, and Google Calendar.Ganttic currently updates google calendar, then new events on that calendar makes a post (topic) in ryver. These are topics that I do not want to have duplicates of.I am thinking I can add a filter step at the end of my Ganttic update to Calendar update zap that will weed out duplicated posts to Ryver. But I am struggling to figure out what the best field/command to use.Any help would be greatly appreciated. Thank you! 

3
franimal
1 year ago
M
Mark WinNew
asked in How Do I

Go High Level appointment from one subaccount to another

Hello Zapier Community!I am relatively new to using API and Webhooks and I am not sure how to format raw JSON data in order to get a successful response.I am building a zap that triggers off of someone scheduling an appointment on High Level and the zap should send the info of that appointment and schedule an appointment in a different subaccount.High Level API: https://public-api.gohighlevel.com/I am currently using this JSON data with all of the fields filled in from the previous step:curl --location --request POST 'https://rest.gohighlevel.com/v1/appointments/' \--header 'Authorization: Bearer <token>' \--data-raw '{ "calendarId": "CVokAlI8fgw4WYWoCtQz", "selectedTimezone": "Asia/Calcutta", "selectedSlot": "2021-06-23T03:30:00+05:30", "email": "john@deo.com", "phone": "+18887324197"}'I’m getting the response “Unauthorized” not exactly sure what to do, can you help?

0
M
1 year ago
T
twentyteamNew
asked in How Do I

Schedule an email to all records that match a given day

Hi all,I have table that contains records with 2 columns: 1. user email and 2. date and time.  I am trying to create a zap that will regularly scan a table to find a record where the record’s date and time < current date and time for that day. The zap will then send an email (template) to each of the email in the records that match the condition. Grateful if you can advise on the best way to implement this zap.For example assume that right now it’s 11.00 am, Dec 22 2022 and the zap is scanning the following table:Record 1: usera@gmail.com (9.00 am, Dec 21 2022) Record 2: userb@gmail.com (8.00 am, Dec 22 2022) Record 3: userc@gmail.com (10.00 am, Dec 22 2022) Record 4: userd@gmail.com (2.00 pm, Dec 22 2022)Ideally, the zap will send only send emails to record 2 and 3. Record 1 is not selected because the date does not match today’s date and record 4 has not yet happened. Thank you. 

2
Liz_Roberts
1 year ago
E
Eduardo13Beginner
asked in Troubleshooting

Zap to Google Sheet Error

Keep having an issue with a zap to google sheet in which the error says “ This usually happens when the Zap does not receive a response from Google Sheets within 30 seconds confirming we could access the spreadsheet data successfully.” Any help regarding this would be really appreciated. 

1
Liz_Roberts
1 year ago
I
IOS Wallpaper ArtNew
asked in How Do I

How do I create a zap to send my Shopify customer a Discord invite code once they purchase a certain product from my store?

I run a Shopify store and am starting a paid community on discord. I want my customers to pay to be in the community through Shopify and have them automatically get sent an email with a discord server invite once they pay. Is this possible through Zapier?

2
rachael.silvano
1 year ago
R
Ridge TBeginner
asked in Code & Webhooks

Zapier and Bunny.net Integration

What’s up guys, I’ve noticed that zapier does not have any integrations with bunny.net (video storage service). Is there a way around this maybe using API or webhooks?Any advice would be helpful!

2
christina.d
1 year ago
Terms & Conditions