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.

25601 Topics

S
SarahZNew
asked in Troubleshooting

Zap not firing when adding Click Up Task to AirTable

Hi there, I have a zap that should when a task is added to Click Up, a new record in a table should be created in Airtable. It works fine in the test but never works in ‘real life’.  I don’t get any error message. Any ideas as to why?  I’m not sure what part of the Zap I should look at to see what’s wrong since it works fine in the test. Thanks.

5
Troy Tessalone
1 year ago
S
stylebaseBeginner
asked in Troubleshooting

Authentication failed with Google Cloud mySQL

Hi,I am trying to connection Zapier to mySQL instance of Google Cloud Platform.I have added the IP of Zapier to my instance connection, as I did with my private Ip (which worked fine).  I get the following error: Timeout connection to IPADDRESS:PORT. Try opening up any firewalls and ensure your device is listening on port XX. I am not sure what I am doing wrong as I took the steps on Google Cloud side. I feel like I might not be taken the username in the right place, but it does say root on my account.  Thanks in advance for your help!   

3
jesse
1 year ago
B
btmicletteNew
asked in How Do I

How do I extract data from current Gmail Messages to Google Sheets?

I have about 300 emails in a Gmail inbox, all are from the same form submission email (Squarespace originally) and have relatively similar data. What I mean by this is that the oldest messages/form submissions don’t have as many data fields as the new ones, as the form that users submitted through was added to over time.I am trying to create a Zap that will find all the emails from this address, pull the important data from each, and place it in a Google Sheet so I can do some further analysis of the data. I’ve found that a good trigger is “new labeled email”, since I can create a new label in Gmail called “Form Submissions”, and place all the emails from the Squarespace form submission email (something like squarespace.info) into it and Zapier will catch it.I have also found that I can easily set up the event to be “create new row” on a certain Google Sheet. The issue I’m encountering is that I can’t find a way to selectively pull the data I want from the body of each email. I can sel

2
Troy Tessalone
1 year ago
Z
zap29550Beginner
asked in Troubleshooting

Testing MySQL Premium with Looping by Zapier

I have a Looping by Zapier followed by a MySQL Premium.However, MySQL Premium doesn’t seem to understand the Query when it’s used as Find Row via Custom Query.The underlying query looks like:SELECT org_name FROM vw_ctvt_org_basic WHERE org_key = {{157114913__data[]target_org_key}}When I go to test, it tries:Is this a bug?

2
jesse
1 year ago
C
ChabadAUNew
asked in How Do I

Trying to update a record if it exists and create one if it doesn't

Hey, I am trying to recreate these steps with Paypal and Salesforce. But the update record step is not working… 

12
C
1 year ago
justindeal
justindealZapier Staff
posted in How Do I

Zapier Labs Research

👋 Hi there, I’m Justin, a principal engineer at Zapier.I'm working with the Labs team on something I find exciting: trying to figure out how much it’s possible to blur the line between a "user" and a "software engineer." To start to understand that, I'd love to know more about the products that you use (including, but not limited to Zapier), what kinds of problems you've successfully solved due to their flexibility, and where you've gotten stuck because of their limitations. Some examples might be: You created a spreadsheet from scratch and figured out some new formulas along the way. Or maybe you got stuck with a particularly tricky formula. You set up a form and made use of various field types, styling, or rules to make something you really liked. Or maybe you needed a field type that wasn’t supported, or you couldn't make it look or behave the way you wanted. You created a website using some kind of website builder and integrated it with another product like Zapier, with minima

0
justindeal
1 year ago
S
SFJoAnnBeginner
asked in How Do I

How do I extract ClickUp case# from in array?

What I’m trying to do:  When I close a task in ClickUp (Case # is a custom field on task), I want to create a Task on the corresponding case in Salesforce. To do this I need a step to find the Salesforce Task.  Case # is a unique value and I should be able to find the case by using the Case # from the custom field in ClickUp.  The issue:  I have several custom fields on tasks in ClickUp that allow me to see important information, like Contact and Client Name.  When I access the Custom fields in ClickUp, it looks like and array.  Example:  00001234,0,Elizabeth.   The Case # is the first value in the array. Using the Extract Number function, I get “00001234, 0”.  If I use the Truncate function to capture the first 8 characters, I get:  “00001234,0,Elizabet”.I can’t find an option that return ONLY the 8 digit case #.As a Salesforce Admin, I’m allergic to code and would love to find a no or low code solution. Any suggestions?

4
S
1 year ago
P
ProdCrewNew
asked in How Do I

How do I trigger on a record entering a view on Airtable when the old trigger is deprecated?

I have several zaps that are triggered by a record entering a view on Airtable. This trigger seems to have been deprecated, and now only allows triggers by creating new views and when a record is updated. This causes serious workflow issues for me, is there something I can do to bring back the old trigger?

3
christina.d
1 year ago
V
Vinayak TikoleNew
asked in Code & Webhooks

Read the GET return content from Zapier Webhook

I am fetching all the customers list from AccountEdge Connect App using zapier webhook.For that created trigger and set all the data including API details and  parameters, I am getting customer list form AccountEdge Connect and in next step of webhook I am getting success message in return in DATA IN tab, as follow{    "id": "49fc62a8-a6d5-4b7f-b94b-41103e9cf227",    "request_id": "628e3162-9ef1-4177-a57c-03bfd06e4d40",    "attempt": "628e3162-9ef1-4177-a57c-03bfd06e4d40",    "status": "success"} How to read customer list form 1st step of zap?I want to get list as input to my PHP API..

1
christina.d
1 year ago
K
KWFBeginner
asked in How Do I

Can two Zaps with the same triggers run simultaneously?

Hello guys, I am having another problem with my zaps, so I have a zap that has been running for a year with no fail. The trigger is “Shopify » New Paid Order”The action is to Create a Document from Text and then Create an Asana Task I then made another Zap using the same Trigger Shopify » New Paid OrderCreate a Document From Text Create Loop from Line itemsFind DocumentAppend Text to Document I published it two days ago but it is still not picking up any orders from my shopify account the other zap runs fine. What I wanted to do is to run these zaps simultaneously and see if they are running smoothly beforedisabling the first one completely.

5
jesse
1 year ago
D
draconeo73Beginner
asked in How Do I

How do I extract a value from the last line in Google Sheets if the row number constantly changes?

I am using Twilio with Zapier and my app in the first phase storing outcome on the hooked google spread sheet, this value specifically mobile number is stored on the last line of this spread sheet, how can you specified for this value to be extracted from last line if this number of the line is always different  , can be this specified on some point or not , at the moment I am specifying for example this value is on the row 13 for example can I specified will be like always last row within this spreadsheet? Thank you 

2
jesse
1 year ago
1
1845SarahNew
asked in Troubleshooting

I am getting an error when creating a booking in Resource Guru, but it doesn’t provide a specific reason.

HelloHas anyone tried to connect Smartsheet to Resource Guru?Have a form in Smartsheet which creates a row on a sheet: I want this row to create a booking in Resource Guru.I’m getting a troubleshooting error but its doesn’t flag what field the error is in! I am a total beginner btw!Many thanks!

2
jesse
1 year ago
Z
zkrizNew
asked in How Do I

I cannot find "Attachment ID" field to insert in a “Featured media” field

I’m trying to create a new Wordpress post every time a Facebook page post occurs. Additionally, I would like to set a Facebook post picture as a Featured image for my Wordpress post.Prior to creating a new Wordpress post, I successfully upload a picture as a Wordpress media.But then, when I create a Wordpress post, I don’t know what to put in a “Featured media” field. E.g. when I put “Media details file” from an upload step, it creates a post with an empty Featured image.I tried to apply advice from this thread  but I cannot find “Attachment ID” field in an upload step anymore.Which data from an upload step should I use?

2
jesse
1 year ago
M
miadavidNew
asked in How Do I

How to automate selling with zapier?

Hi Zapier Community Team, I am new here, I want to know that, Can I get help from zapier to sell my books and managing selling automatically. Kindly guide me. Thanks

2
sardamit
1 year ago
M
mariecuriousBeginner
asked in Code & Webhooks

How to Format Query String Params - Webhooks GET Request

I am trying to pull a list of records from Airtable using dynamic parameters. One field is a date field, and using Airtable’s internal Find Records action does not allow for dynamic dates.I have been able to pull Airtable records via Zapier with the GET request, but only for a specific view. Due to the nature of what I want to do (pull a list of records within a given date range, that is based on the date of a NEW record and not related to today’s date), a view will not work.I have experimented and done lots of googling but haven’t found info on how to format the Query String Params so it pulls records based on this dynamic criteria.Any help is appreciated, including other methodologies which may be better suited to this task.

7
Danvers
1 year ago
M
mAnarchyBeginner
asked in How Do I

How do I access a specific index in a Fareharbor custom field array?

I am trying to pull custom fields from Fareharbor (in this case 2 option drop down and a checkbox) into custom fields in HighLevel (LeadConnector).It appears though that the custom fields are all grouped into arrays (either at the booking level or customer level), so how do I access a specific index in the arrays?

3
M
1 year ago
A
Anonymous
asked in How Do I

What will it cost to use Zapier with Wave if I have a small eBay business?

Hello, I am currently using GoDaddy Bookkeeping, but I have to switch to a new platform because GoDaddy is being discontinued permanently. I am thinking about signing up for Wave Bookkeeping, but I’m having trouble figuring out what it would cost for me to use Wave in conjunction with the Zapier app that would automatically import and integrate my eBay sales information.Wave is free, but Zapier may or may not cost me anything, depending on how many “tasks” I use. Can you guys help?I have a small eBay store that has about 300 items for sale at any given time, and I sell an average of 30 items a month. So basically I need data on everything I add to my inventory, every sale I make, and every fee associated with every sale, such as the cost of a shipping label and the fees that eBay charges me. Do you think the free Zapier membership will cover all of these line items of data, or will I need to upgrade to a paid plan?

2
A
1 year ago
P
pavelgqNew
asked in Code & Webhooks

How do I add lists to Webhook post requests?

“This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.”So I’m trying to send a post request  using zapier webhooks that looks like this:{    "recipient": {        "first_name": "xxxx",        "last_name": "xxxxxx",        "address": {            "street1": "xxxxxxxx",            "street2": "",            "city": "San Franscisco",            "state": "CA",            "zip": "xxxxxx"        },        "email": "xxxxxxxxx",        "phone": "xxx-xxx-xxxx"    },    "kit_types": [        "example_lipid_kit"    ]}I can nest values using double underscores, but I’m not sure how I’d go about adding a list like you can see for  kit_types. Any advice? 

2
Troy Tessalone
1 year ago
M
Miguel_AlmanzorBeginner
asked in How Do I

How do I generate a record in MySQL once a new file arrives at the Brick FTP Server?

What I want to do is once a new file arrives at the BRICK FTP Server, I generate a record in a MYSQL database with the data that comes inside the file that arrived, which is an XML

2
M
1 year ago
D
do25New
asked in How Do I

How can I save GoFormz data and create a pdf out of it?

I’m trying to extract a data and create a pdf out of it using this process however I’m having issue about the integrationsProcess  option 1Goformz → ZAPIER → PDFMonkeyProcess option 2Goformz → Google Drive(save as CSV) → ZAPIER(using Google Drive Trigger and Zapier Formatter) → PDFMonkeyis there any other easiest option available?I’m having issue on extracting data from a new csv in google drive in option 2 For option 1, I need to upgrade my subscription to goformz while I’m unsure if its feasible .. I needed to generate one pdf file per form completion .. while option 2 is storing records in bulk..I’m new in using zapier  Can anyone help me ?Thanks  

10
christina.d
1 year ago
D
DrillZ 2 SkillZBeginner
asked in How Do I

Phone number wont integrate from Wordpress/Modern Events Calendar

I am not able to add phone number field so i can Zap a phone number to Text P2P

8
christina.d
1 year ago
S
ShiroyashaNew
asked in How Do I

What is the best way to manually approve leads into my CRM using the "New or Updated row" trigger?

Hi everyone,I’m setting up a Zap where the leads acquired from a Typeform are collected into a Google Sheet.Using a second Zap, i’d like to manually approve (through checkboxes or dropdown options) the leads: the approved leads would then be transferred inside my Dynamics 365 CRM.The problem is, if i used checkboxes while watching row changes inside a specific column with the “New or Updated row” option, the zap wouldn’t always trigger and i don’t understand why the leads aren’t always added to the CRM. I still haven’t tried with the dropdown menu. What can i do?I also have a couple questions:I’ve seen that Zapier only detects new values inside a specific cell (and it doesn’t detect values which have already been “watched” inside that cell in the past), as written here by @Troy Tessalone (thank you Troy!): What happens if, say, i delete row #2 and then re-create it? Will Zapier “reset” and be able to see “old” values again? What happens if i delete row #2 and the following row (#3) rep

6
christina.d
1 year ago
V
vt-cureNew
asked in How Do I

New to Zapier

I would like to know how to effectively use this service...

2
jesse
1 year ago
K
katejgNew
asked in How Do I

Mail Merge Zap Trigger & Action

I am trying to send a mail merge through a Streak pipeline to multiple email addresses within one email thread. The way streak typically sends mail merges is to include all email addresses in the TO column and every recipient receives an individual email thread. However, I want to create a CC column in my pipeline so that additional email addresses will be placed in the CC box when composing the email so that one email thread will be sent to all recipients on the email and everyone can respond to the same thread. I don’t know how to create this trigger > action sequence or if it is even possible. Does anyone have any experience or any ideas to build this specific task? Thank you!  

1
jesse
1 year ago
A
agarbreBeginner
asked in Code & Webhooks

How to Parse JSON objects?

Hello all, I’m trying to use data coming from a JSON file but I cannot find the right way to do so. I’m struggling on how the data is coming from another tool and make it available to use. JSON I’m getting looks like this{"headings":[{"name":"KEY","table":"SQL","type":"STRING"},{"name":"CREATED","table":"SQL","type":"DATE"},{"name":"REG_PLATE","table":"SQL","type":"STRING"},{"name":"MAKE_SLUG","table":"SQL","type":"STRING"},{"name":"CANONICAL_MODEL_SLUG","table":"SQL","type":"STRING"},{"name":"MODEL_SLUG","table":"SQL","type":"STRING"},{"name":"MODEL_NAME","table":"SQL","type":"STRING"},{"name":"PRICE","table":"SQL","type":"INT"},{"name":"MARKET_VALUE","table":"SQL","type":"INT"},{"name":"MILEAGE","table":"SQL","type":"INT"},{"name":"MODEL_YEAR","table":"SQL","type":"STRING"},{"name":"REG_YEAR","table":"SQL","type":"INT"},{"name":"COLOUR","table":"SQL","type":"STRING"},{"name":"GENERIC_COLOUR","table":"SQL","type":"STRING"}],"rows": [{"cells":["AAAA","2022-05-01","AAAA","Ford","fiesta-

1
Troy Tessalone
1 year ago
Terms & Conditions