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.

25698 Topics

L
Lukas0610New
asked in Troubleshooting

Google Calendar error message: Failed to create an update event in Google Calendar, the app returned "not found"

Hey Guys,I have this Google Sheet with some fields:adding the event to my Calendar works like a charm:But I don’t now how I can Access this Event and. for example, change the Start Time.  I get this error message! I hope someone can help me!Thanks

3
D
1 year ago
A
atulBeginner
asked in Troubleshooting

Mautic error: Authentication failed (error #500)

Hello Team i am trying to connect mautic with google sheet from zapier but when i try to connect zap to mautic i gives me and error This is the error As i have enable all auth and also from mautic i have cleared all the cache but still the same is there any way to connect this 

2
A
1 year ago
J
j000mBeginner
asked in How Do I

Vimeo Trigger: New video by search -> Only for public video's?

I am setting up a Vimeo Trigger: New video by Search, but it's only working for public video's. Not the video's that are on any privacy setting.How can I bypass this in order to set a trigger for my own non-public video's. Anyone know?

4
J
1 year ago
F
FraserHNew
asked in How Do I

Lookup Google Sheet (Not Row- Entire Sheet) (Docparser)

Hey Guys, I need help with a Docparser workflow: What am I trying to do: I have 2 different document types that I need to verify the data matches. To do this I am using DOCPARSERI submit a jotform containing the 2 different PDFs that then goes through ZAPIER to send both DOCS to DOCPARSER Now to retrieve the data from DOCPARSER you need to use a new ZAP so what I have done is:ZAP 1: Retrieve the first DOC and then CREATE a new google sheet from template and input the Parsed data into required row EASYPEASY.ZAP 2 Retrieve the SECOND DOC and update the next required row  THE PROBLEM:With ZAP 2: After I pull in the Parsed Data I need to Lookup the new Google Sheet Created in ZAP 1 But I cant work out how to do this? Obviously because it will be a new sheet every time I cant just select the required sheet the usual way? Does anyone have any words of wisdom to help?

2
F
1 year ago
D
dmend18Beginner
asked in Code & Webhooks

POST Request to External API with attribute Arrays

Hello All.I am trying to create a Zap using WebHooks by Zapier to import contact data from a connected service (in this case Google Contacts) to a CRM using the CRM’s API. According to the guildelines for using the API detailed here (which are fairly standard), I need to use a POST Request with the data for some attributes (email, phone, address, etc.) requiring an array of objects. Here is where I run into trouble. Below is an example of a simple-yet-complete set of data I would hope to convey:{ "firstName" : "John", "lastName": "Smith", "emails":[ { "type": "Work", "address": "johnsmith@google.com", "isPrimary": false } ]} I was able to get the full Zap working fine with simple json strings. Namely, I could get the contact info from Google Contacts, field map first/last name, prefix, suffix etc. into the POST Request, and then fire the webhook off to the CRMs API. Sure enough, it would give me a success message and add a new

9
D
1 year ago
D
ds22LNew
posted in Troubleshooting

Insightly Integration Error Despite Test Check OK

Unable to load choices We're having trouble loading 'Insightly Object' data. The app returned "An error has occurred." it has worked just fine and I do not believe I have made any changes recently, anyone else experiencing this issue?

0
D
1 year ago
A
AshleyBBeginner
asked in How Do I

How do I total sales from a spreadsheet within the last 6 days from today’s date using Storage by Zapier?

Hi,Please can someone assist. What is the best way to solve the following. I want to sum total sales data from a spreadsheet thats within the last 6 days from todays date.I want to store those values and sum them together and store them in a zapier storage. I need the Zapier storage to clear itself so that only the last 6 days worth of data is stored as a total. Hope this makes sense.

4
Troy Tessalone
1 year ago
Z
ZapMonsterBeginner
asked in How Do I

How do I build an algorithms with ZAPs

We currently use Zapier to filter jobs from a jobsite into a Leads List.STEP 1I would like Zapier to assign each job various weighted points according requirements e.g.Job one requirement A: -3Job one requirement B: 0Job one requirement C: 5STEP 2I would then like Zapier to assign each job a status depending on the total number of points receivedSuper Hot: 5 - 10 pointsHot: 3 - 4 points etcSTEP 3Add the jobs to the Leads list as per usualHow do I do that? 

5
nicksimard
1 year ago
J
Jpeterson123New
asked in How Do I

If/Then Statement within a Zap field.

Is it possible to do an if then statement inline, within a zaps fields? Instead of having to use the zapier paths filter before the zap? This would help me in not duplicating steps when only 1 field in that step is different.

4
D
1 year ago
B
besophroBeginner
asked in Code & Webhooks

TypeError: Cannot read property 'toString' of undefined

This is for a customer note on a couple of zaps wondering how to clear the error. It looks like the zap is working with still sending the information to Active Campaign but it still sends errors. Any help appreciated. // this is wrapped in an `async` function// you can use await throughout the functionreturn { line_items_ids: inputData.lineItemsVariationID.toString(), line_tags: (inputData.tags==undefined || inputData.tags.indexOf('subscrib')==-1)?'[product] online course (Empowerment),[stage] customer':'[product] online course (Empowerment),[stage] customer,[stage] subscriber'};

3
B
1 year ago
D
dieselfishNew
asked in How Do I

How do I consolidate all tag names in a single tag field?

I’ve seen several topics describing this same issue. Unfortunately, they are all closed so I’ve had to start a new topic. It looks like there was no resolution to the earlier posts. Wondering if there have been any updates.I'm using the Pocket integration to push new entries to Notion. Pocket allows me to save "Tags" associated with each saved item, but the format of these tags in Zapier is difficult to account for using the interface.For example, if I save a web page with the tags "MySQL", "Pocket", & "App Integration", the data pulled from Pocket is formatted like this:However, when I try to customize the record in the Notion section, the fields associated with this entry are formatted like this:I'm really just looking for a single Tags field. Since the tag names change all the time, something like Tag 1, Tag 2, Tag 3... etc. would be preferred. Any suggestions on how to consolidate? I can't account for all possible tag names upfront. Thanks!

3
T
6 months ago
B
BrunoleclercBeginner
asked in How Do I

Update a specific cell in Google Sheets

Hello,I'm having some difficulty setting up a ZAP:I would like to connect Hubspot to a Google Sheet to feed a report, for example as soon as there is a new contact, that in a cell of the google sheet, that's +1, which is added each time.I can't first target a specific cell: we can update rows, columns but a specific cell...And then add it with the value already present in this cell.Thank you for your help, 

1
GetUWired
1 year ago
T
TwoByteMacBeginner
asked in How Do I

How do I know which RSS feed to use when testing the trigger of my Zap?

I’m sure this is a basic question but I’m new. I have created several Zaps for RSS feeds and I see different channels (A, B, C, etc) and noticed different items show up in different channels under Test Trigger. Of course, I don’t know which channel to tell the Zap to monitor. Is there a way to select all?

2
T
1 year ago
S
Stephen HolderBeginner
asked in How Do I

How do I send a “Thank you” email using Mailchimp to anyone who purchases a product via ThriveCart?

Hi all, I hope you can help me I have products on Thrivecart and want to send a ‘thank you for the purchase’ email to someone who purchases a product, bump, upsell or downsell.   I use Mailchimp. Zapier is rather complicated.  My question is, is this even possible? Many thanks Steve  

4
S
1 year ago
G
gerhard.reisingerNew
asked in Code & Webhooks

Send data from Zapier to PHP

Dear Community, I want to receive data in Zapier from Facebook Lead Forms (Premium App). This is working fine so far.Now I want Zapier to send these data to my PHP Webserver - so there should be a PHP-Script on my webserver listening for Zapiers data-messages.Could you please give me a hint, or maybe even a working example, on how to do this?I was able to find many community topics the other way around, by sending data from PHP to Zapier. But not in the direct I want: Zapier to PHP. Thank you in advance,Gerhard

2
G
1 year ago
C
Charles DonerNew
posted in How Do I

Stripe and google analytics integration

I need help

2
Andrés at Connex
1 year ago
R
Rob S.New
asked in How Do I

How do I upload a single file to Dropbox when an Outlook email contains multiple attachments?

I have an Outlook email that contains 5 attachments but I would only like one of the files to be uploaded to Dropbox. Is there a way to do this? Thank you. 

2
jesse
1 year ago
F
FFPT LLCBeginner
asked in How Do I

How to send data from Square to GSheets without affecting pre-existing formulas on spreadsheet

How do I send transaction information from Square to GSheets via Zapier without affecting the formulas I have preset in certain columns of my spreadsheet?The zap is basically just taking customer name, purchase quantity, total amount paid, and the date (with a reformatter) and sending it to a new row in a tab of my spreadsheet. Then in that same row, I have a few columns (where the zap isn’t sending any information to) that already have preset formulas to do things like calculate my net pay per transaction, adding customer information from a different tab to the row, etc. I don’t want Zapier to do anything to these rows, just let the formulas do their work after it submits the information I’m asking it to from Square. But for some reason when Zap sends the information to the sheet, it’s removing the formulas from these columns, causing them to remain blank. So the automation is working perfectly fine, besides removing the formulas from my spreadsheet that I already have there. Is there

1
christina.d
1 year ago
A
AbeWyseNew
asked in How Do I

Send Tracking Numbers from WooCommerce to Monday.com

Can anyone tell me how to send a tracking number that’s in WooCommerce over to Monday.com when we mark an order as Completed in WooCommerce?

1
jesse
1 year ago
O
oshoBeginner
asked in Code & Webhooks

cloudconvert screenshot Header Template

i want the header of the pic to have time stampthis is the relvent fieldheader_templateoptional, input HTML template for the print header. Should be valid HTML markup with following classes used to inject printing values into them: date, title, url, pageNumber, totalPages.  i tried <span class="date"></span> and got error please help 

1
jesse
1 year ago
A
AmedeeNew
asked in Troubleshooting

Required field "To" (to) is missing.

Hey Team!   I just got done setting up my Zap for the first time.   I used email parser with clicksend to send new clients a text message when they complete a form.   The good news is that it appears to be working but I keep getting an email from zapeir telling me there is an error.   It says “Required field "To" (to) is missing” but the to field is filled in properly???   Please help!   It says this..  Zap alert We ran into a problem with one of your Zaps.   Untitled Zap Received 1 error Edit this Zap Error Message   ClickSend SMS Required field "To" (to) is missing.

4
christina.d
1 year ago
S
SteffCostaBeginner
asked in Troubleshooting

SignNow document only gets emailed to our company email address, and not the customer.

Hey @jesse, running into another issue I was hoping you could help with.I set up the Zap using the steps above, however, on completion of the signing, the document only gets emailed to our company email address, and not the customer. We’d like a copy of the signed waiver to be sent to both - the company email address and the customer. Here’s how it’s been set up for your reference: 

3
jesse
1 year ago
C
Christina TaiBeginner
asked in Troubleshooting

Squarespace Form - Salesforce Lead - Test Not Working

I get the following error when testing my Squarespace to Salesforce Zap. The Zap test would not go through:Failed to create a create lead in Salesforce (Legacy)[{"message":"you cannot add hrs more than 56","errorCode":"FIELD_CUSTOM_VALIDATION_EXCEPTION","fields":["How_many_hours_a_week_can_you_volunteer__c"]}] When I click on the Troubleshoot Zap button after getting the error message, I get the following guidance from Zapier:Status Code 400 Bad RequestLast updated: 2 years agoProblemYour Zap is likely to be missing a required field, or a field value wasn't in a recognized format. For example, if a field in your action step is expecting an email address, but the value given is a name, the app may return a 400 error.SolutionCheck that your fields are correctly set up and mapped to each other. Please assist.

1
jesse
1 year ago
C
craiglloydBeginner
asked in How Do I

How do I change a Slack bot icon for zaps?

Hello! New Zapier user here. I’ve set up some zaps and bots for Slack, but I can’t find the option to change the icons for my Slack bots. How do I do that? I’m currently on the Starter pack. 

2
jesse
1 year ago
A
Alanis P.Beginner
asked in How Do I

How do I set up a Yes/No text that will respond according to response

So I am trying to use Twilio to send a mass text message to everyone who has a number in our SQL database informing them of how much time they have worked that day so that way they can confirm or decline that time. I want to try setting it up where they can confirm their time and it will update our SQL server or if they decline their time they can state what time they clocked in and out so that way it can be sent to their supervisor. I am not sure if it’s possible to set it up where all that happens and if it gets declined the supervisor could confirm or deny on their end if that employee declines their time. We have our own SQL server that is hosted by a outside source but I already have that connected to my Zapier account as well as my Twilio. I have my SQL server as my first step so that that it can find new or updated rows, and then I have it set to find the needed data and then have Twilio send the text with that data. To simplify what I am asking:After the text is sent, if they a

8
A
1 year ago
Terms & Conditions