Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

29413 Topics
C
ChortersBeginner
asked in How Do I
Issue formatting email drafts in Gmail from Airtable via Zapier

Apologies in advance if I’m missing something obvious.I’m trying to use Airtable to populate outbound contact email drafts in gmail.Each zap is new email draft to be checked and sent manually.I’ve tried many combinations of plain text, HTML and other functions but can’t get the text to format basic things like new lines, hyperlinks and bold. I’ve tried using HTML tags, formatting in Airtable and other things I can remember.I thought it would just be Body Type selected as HTML, then tags away! Still a blob of text.

459
ken.a
5 months ago
M
MatadorenBeginner
asked in How Do I
How to route Jotform responses by country using Zapier?

Objective: I have a JotForm that collects responses from people want to join my platform, including addresses.I need to create an automation that processes these addresses to determine which country they are in and then directs them through different paths based on the identified country.Detailed Requirements: Extract Address Data from JotForm Determine Country based on address (AI?) Country-Based Pathways: Based on the identified country, I need the automation to follow different paths. For example: If the country is the USA, perform Action A. If the country is Sweden, perform Action B. etc I tried using the OpenAI integration but can’t figure out which option to choose to make this work.

82
ken.a
5 months ago
R
RenarsNew
asked in How Do I
How do I avoid looping in Pipedrive after the deal update trigger run for the new calendar event in Google Calendar?

Hi, i cant figure out how to set up zappier automation for Pipedrive deal update trigger.I have a fields in Pipedrive, and after some update only for those fields I need to update a calendar event (update or make new if cant find a calendar). After that I to need update PD with new calendar link, and new note.And that make a loop.I try several ZAPP filtrs, but unsuccessful.I try to make a filter, and try to trigger if deal update matches this filter. For first time zappier work, but when i remove deal from filter (PD automatization - YES / NO for one field) and when it cam back to filter - second time zappier don't work. Any suggestions how to avoid looping?

183
ken.a
5 months ago
A
Alessandro NemoBeginner
asked in Troubleshooting
GetResponse error: {"code":303,"fieldName":"etichetta","message":"Value not in rage. ID: n9Nlbr Value: 1"}

I have another issue with a GetResponse - Pipedrive integration: I have a multiple-choice field named “Etichetta” as a company field on Pipedrive. I use it as a custom field in Getresponse and when I manually bulk-import contact from Pipedrive to Getresponse, it updates the field.After doing a “Find Organization in Pipedrive” zap to collect the data, I try to add it in a “Create or Update Contact in GetResponse” zap to update it, but it collect the field as “1,2,3,4,5” instead of the name of the field “customer, ex-customer...”.So it gives me this error, how can I solve it? 

244
A
5 months ago
P
pragya28Beginner
asked in Troubleshooting
Failed to send an outbound email

With every submission, I want to get notified so I am using “Email by zapier”. It was working fine till now. But today I got an error “Failed to send an outbound email - The app returned request has expired”. Could somebody help me with the issue? Thanks.

204
ken.a
5 months ago
C
CDDBeginner
asked in Troubleshooting
Zapier and Facebook page Posting

Hi, I have set up a Zap to do a number of things from a Jotform Submission. New Submission in Jotform+Upload Media to Wordpress+Upload Media to Wordpress (second file)+Create a post in Wordpress+Publish photo to Instagram+Create Page Post in Facebook Pages+Create Share Update in Linkedin I can get everything to work accept for the posting to Facebook. I simply can not see the page appear in the Zap to be able to select it. ( see screenshots below) I have disconnected facebook ad deleted the zap and tried over and over again, the Instagram set up worked like a dream and took seconds. I have followed a lot of instructions online but can not seem to find a definitive set of instructions showing how to do this. I have connected two different Facebook admin accounts that are both linked to the facebook page I am trying to link. Does anybody know of a step by step guide that might help me please ? I have asked Zapier support twice and had no response.

482
ken.a
5 months ago
D
DAYSLBNew
asked in Troubleshooting
Issue with fields from NationBuilder not showing in Google Sheets

I am using the ZAP to add a new row to a Google Sheet once a new person is added to my NationBuilder slug.I am able to select all of the fields that I need to add, except for demo and ethnicity, which do not appear in the sample data selection.I reviewed the article How to manually map fields that do not appear in the sample data (aka "custom pill mapping") and constructed the following two field variables to use with the node name from the trigger task used: {{241834171__demo}}{{241834171__ethnicity}} However, when I run the ZAP, new records that should have values in both fields do not show up in the Google Sheet, though the other fields that show up in the sample fields are added correctly.Has anyone successfully added manual fields from NationBuilder to a ZAP that may shed light on my error? 

91
Troy Tessalone
5 months ago
creativeperson
creativepersonNew
asked in How Do I
How to send an existing HubSpot marketing email with Zapier?

I have a bunch of existing marketing emails in Hubspot.   When someone signup a form, I want to send them the same marketing email using Zapier automatically.  However, I don’t see any function in the Zap that allows me to send marketing emails.  The Marketing Emails are already done, we just need to “send one more person”.  Please help.  Thanks. 

2094
ry.schwei
5 months ago
B
BhavyaNew
asked in Code & Webhooks
How to Trace Companies Created or Updated in Hubspot via Webhook in Zapier?

Hello Zapier Community,I have set up a Zap with the following workflow:Catch Hook in Webhooks by Zapier Find company in HubSpot (and create if not available, then update details)Everything is working fine, but I’m having difficulty tracing the companies that are created or updated through this webhook. Specifically, I need to:Identify which companies have been created or updated in HubSpot. Track these companies effectively in my Google Spreadsheet.I would greatly appreciate any guidance or best practices on how to trace and monitor these newly created or updated companies. Is there a way to get detailed logs or reports from Zapier, or perhaps a method to tag or label these entries in HubSpot? I have been looking into Activity and original source and other properties on Hubspot to track it, but it’s not showing anything. Thank you in advance for your help!Best regards,

382
ry.schwei
5 months ago
K
KrazBeginner
asked in How Do I
How do I merge audio & video in Zapier?

I still can't find a way to merge audio and video with Zapier. Does anyone know how? I can't find any Zapier app that allows me to do it. Thanks!

2024
J
5 months ago
R
Rachel at JUSTSOBeginner
asked in How Do I
How do I extract product_name and product_id from a multidimensional array in Zapier to use in my CRM?

HiI am relatively new to Zapier. We have a data source in our first step that includes what looks like a multidimensional array data structure called ‘Orders’ All fine so far.However when we try extract this data for inclusion in a CRM database in step 3, this “orders-lines“ variable is combined into a comma separated string (see below) and we are unable to split the values open to use in different fields.  How do We can access product_name and product_id from that array? Thank you

224
R
5 months ago
B
Brendon Robot SocialNew
asked in Troubleshooting
Clickup fields missing from Zapier

I have a Wufoo form I want to pipe into ClickUp - each entry as a new task. Problem is one of the key fields (Phone) does not show as a field when Zapier connects to ClickUp. All the commentary here pertains to ClickUp custom fields not being available to Zapier but that has been resolved and I get a whole section of custom fields to choose from but Phone is missing. Anyone encountered this?

802
SamB
Community Manager
5 months 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

2136
SamB
Community Manager
5 months ago
D
Dubs24Beginner
asked in Troubleshooting
Confusion with Looping and Delay After Queue

Something isn’t clicking here…I understand that looping runs in parallel, and I can see from others that I’ll need to add a delay step so that things run “in order”.That said, when I put the “Delay After Queue” or “Delay for” step at the bottom of my loop (set to seconds) I’m getting an error that says it expects a step after my delay….Huh? Why is that? Am I misunderstanding how this works?I’ve read the help article 4 times and it’s just not clicking. See image below:In the second image you’ll see that it looped through 3 times, but it indeed did not honor the 5 second delay step.  

1536
D
5 months ago
A
ADCNew
asked in How Do I
Notification

Hi  I have an URL with different company information as JSON: https://www.sik.dk/registries/export/autorisationsregisterThe list get updated  and i would like to once a month go thru this list and add the new companies to a list  My plas wat to use the Zapier schedule trigger, and then zapier web parser to go thro the URL somehow get it to a table and then send it to my CRM system with a Webhook. 

51
Troy Tessalone
5 months ago
A
Alberto D'AmicoNew
asked in Code & Webhooks
Parsing a garbled payload

Hi, I am using a webhook that fetches a payload that I have to parse to extract specific information. Please note that the “payload” here is NOT a field in the incoming message (like email_body), but the whole message.Part of this payload is quite straight forward:FirstName: XXXLastName: YYYZipCode: 3333Another part of it is really strange and cannot be directly reconciled to the form “field: value”, as above.Here a couple of examples, but there are 10-12 of similar sections in the meassage.[EIGNUNG DACH] Haben Sie bereits eine Bestandsanlage? [EIGNUNG DACH] Haben Sie bereits eine Bestandsanlage? 1 0 UUID UUID 2200da203cde013bad001205644bcef7 Label Label Ja, soll aber nicht mit der neuen Anlage kombiniert werden. [EIGNUNG DACH] Leistung in kWp: [EIGNUNG DACH] Leistung in kWp: 1 0 UUID UUID 3ed4dfb0b8af012d2fb938ac6f7d89ab Label Label 4 bis 7 kWpIt is in German, but the above should correspond to the following real-world information.Key: 2200da203cde013bad001205644bcef7 Value: Do you ha

487
Troy Tessalone
5 months ago
Justin-at-Singenuity
Justin-at-SingenuityBeginner
asked in How Do I
Hubspot to Google Sheets - How to insert data into an existing row that has formulas

Hi, I’ve made a Loom video to provide further clarification on what we’re trying to accomplish. In short, I have the trigger and everything from the Hubspot side all set up, but I just need to insert the data in Columns A-F into an existing row (Row 34 in my example, then the next Zap trigger it’ll need to go to Row 35, then 36, etc) because Columns G through Z have formulas that I’d like to leave untouched.Unfortunately on my first attempt, the Zap created a new row and would then require me to pull down the formulas on about 25 columns. I would love for it to know to look for the next blank cell/row in Column A, input the 6 cells of data, and then use the next one for the following Zap trigger. Thanks!Justin   

303
Troy Tessalone
5 months ago
Lynne
LynneBeginner
asked in Troubleshooting
WordPress error: This auth is expired. Please reconnect it here. Authentication failed. 403 Forbidden

I’ve had this zap set up for quite some time now and it’s been working fine, but about 3 days ago it started sending me multiple notifications of 403 (Forbidden) errors, and then was auto-disabled.The zap is to convert new signups on my WordPress site to subscribers to my mailing list on Mailerlite.(The site uses the Eduma theme from ThimPress, but my support package has expired - and I’m not even sure it’s their issue - so at present I’m trying to fix the problem without their help.)This is what I get when I go into the zap to try and fix it:No idea what the endlessly spinning circle at the bottom denotes; maybe it could be part of the problem?I’ve tried reconnecting the account (multiple times) and I get a 403 error. I’m not using Jetpack, so that’s not the issue. I do have WordPress AIO Security but I’ve tried all sorts of changes to the settings and even completely disabled the whole thing, and it’s made no difference.I’ve spent ages ploughing through help pages, both on the Zapier

188741
SamB
Community Manager
5 months ago
D
DenisZhebrtiskiNew
asked in Code & Webhooks
Is it possible to track an email send through third party via zapier?

Im using Skool and and mailerlite for my email service provider. when a new member joins my email list via lead magnet, Skool send him an invitation. it works perfectly. bbut I want to take it to another level, I want Zapier to check if the link on the email was clicked and then update the subscriber in mailerlite. is it possible for Zapier to track an email sent by skool (through Zapier)? if yes how to do it? 

483
Troy Tessalone
5 months ago
M
MishOfficeNew
asked in Troubleshooting
HubSpot error: Halted execution. Property values were not valid. ValidationMessages:

I’ve attached a screen record for context.https://capture.dropbox.com/XHYShI7bKzhErlGPI’m trying to create or update a contact in Hubspot when a job is created in ServiceM8 and I receive this error message…Error from halted execution: Property values were not valid validationMessages: - email: Email address …….@hotmail.com is invalidI would love some help with this if anyone can - thanks!

636
Troy Tessalone
5 months ago
Kate M.
Kate M.
asked in Troubleshooting
Missing spaces in trigger creation for joining specific Mighty Network space.

My different spaces do not come up when I try to create a trigger based on someone joining a specific space within a Mighty Network. Does anyone have thoughts on this?Screenshot of Zapier open showing how the name of the Spaces do not load in the “Network or Space” field. 

1765
SamB
Community Manager
5 months ago
W
William SaigonNew
asked in Troubleshooting
Microsoft Excel worksheet not shown

Good morning guys,I can’t get around this one on my own and unfortunately the AI chatbot can’t either.I want to do something pretty basic: get a notion table updating an excel table. Every time I enter a line in my notion table, I want this to feed my excel one.Notion part: no problem.Excel part: it goes well until the worksheet. No worksheet is found (see below) I am pretty sure there are thousands of post out there and some are surely spot on, but none of the ones I put my hands so far, turned to be helpful. So if there is anything you see as a match, feel free to share. Here is what you need to know:My Microsoft OneDrive account is a Family one. My excel file is an .xlsx I updated the page, clicked on “refreshed”, retried every time after each changes made. I tried with two tables, see below. The idea is: each table as defined rows and the second line filled. I also tried with more complex sheet with more data Let me know if you need any other input from my side. Thanks a lot in adv

2386
SamB
Community Manager
5 months ago
T
TashJDBeginner
asked in How Do I
Allowed Values - How do I work out what it is?

Hi everyone,I’m trying to create a Zap that takes a new Klaviyo profile and creates a corresponding profile in our e-commerce software, Commerce7, using the Dionysus C7 Integration (1.0.0).Setup:Data: First name, last name, and email address from Klaviyo. Issue: Integration requires a Country Code, which fails to be accepted no matter how it’s formatted.Source of Data:Sign-ups are coming from our Cellar Door via a Caard page, which populates the data into Klaviyo without issues. The problem arises when trying to create the new profile in Commerce7 via Zapier.Attempts:I’ve tried directly connecting Caard to Zapier and then to Klaviyo, then to Commerce7. Used webhooks to insert "Australia" or "AU" as the country code automatically. Every attempt results in the following error: Error Message: "Failed to create a customer in Dionysus C7 Integration (1.0.0). The app returned 'must be equal to one of the allowed values'." I can’t figure out why this seemingly simple task is proving so diffic

249
T
5 months ago
D
Dovelement LLCNew
asked in How Do I
How to write a structured query for firebase

Trying to find a firestore document in firebase. Structured queries were tough to figure out. Documentation takes a lot for granted. Here is how i got it to work. The WHERE property is required, and other properties (e.g., FROM, SELECT, LIMIT) are handled by zapier on their end.  Replace “itemLookupCode” with the name of the field you want to queryReplace “234212221” with the value you want to query by {  "where": {    "fieldFilter": {      "field": {        "fieldPath": "itemLookupCode"      },      "op": "EQUAL",      "value": {        "stringValue": "234212221"      }    }  }}

581
Troy Tessalone
5 months ago
A
AnitaojiehNew
asked in How Do I
Can I create a filter in Zapier to send emails based on Paystack transaction amounts?

Hello, please i'd appreciate any need help on filter, fairly new to them. I have two payment flow from Paystack with two different amount for different products - one is 17,000 while the other is 50,000. I want to create a filter to send an email based on the price (Since that's the only differentiating value) Bottom line is in need to create a filter based on a specific transaction amount from Paystack to trigger an email. Please help, i appreciate and will try all techniques i can.

131
Troy Tessalone
5 months ago
Terms & Conditions