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.

25129 Topics

luisjbdouglas
luisjbdouglasNew
asked in How Do I

Can I create a ZapBot that can read a Zapier Table and provide output?

Hi, I’m experimenting with ZapBots and I was wondering if I can create a ZapBot that can read a Zapier Table, search it for the ZapBot input and then output information from the table based on the logic?  Thanks!Luis

4
SamB
Community Manager
7 months ago
Rocketlane
RocketlaneNew
asked in How Do I

How to exclude weekends from date range calculation?

I’m building a workflow to allocate hours to a resource based on a request form. In the form, i get the Start date and the end date from the user. I’m using the Compare dates action in Utilities, and I am getting the difference in total no. of daysMy question - How do I exclude weekends from the total no. of days? Any help would be appreciated! Thanks! 

1
Troy Tessalone
7 months ago
J
jackxyBeginner
asked in How Do I

How can I set up my Zap to use the current time?

hello im using facebook leads to google sheet zapsi want to see my data korea time databut first action that name "생성시간"it include 1.created time <but its not actually real time so im confusinghow can i check real time to set up?

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

How do I use discord server nickname instead of username

I am currently trying to set up automation so that the messages that are sent from our discord server will be sent over email also but the issue is that the people that would be reading the emails don't know our discord usernames and in the server we have all renamed ourselves to be easily identifiable but im having trouble figuring out how to get zapier to insert the nickname instead of the username. If you have any idea if/how this may be posible please let me know. Also i dont have a great deal of background when it comes to programing or api’s this is a project for my highschool robotics team cause our school is super strict about communications.

1
christina.d
1 year ago
N
Nicky TBeginner
asked in Troubleshooting

Zapier to Facebook connection

Hi there, I’m struggling to connect Facebook to Zapier. The connection looks totally healthy on the Zapier side, but the data is not pulling through. On the Facebook, it allows me to connect to Zapier as CRM via the ‘instant forms’ section, the connection disappears when I navigate away from the page. I also also tried to connect via the Leads Access section of my business settings in Facebook and no CRM shows up when I try to find Zapier.Any suggestions? Thank you 

4
rachael.silvano
1 year ago
A
AkilaBeginner
asked in How Do I

woocommerce orders

Hello all! On our website, we use woocommerce for sales. We would like to write successfully paid orders and client details on a Google sheet. Is there any way to do this without the Woocommerce-Zapier plugin? Thanks in advance.

6
A
1 year ago
R
RzcrewBeginner
asked in How Do I

Shopify to Wave invoice creation with Shipping and tax line items

I’m trying to create a zap that creates Wave invoice whenever a new order in Shopify is created. However, I don’t see any way to add shipping line or Processing fees. This is important to us since we want customer to pay the invoice via Wave and be automatically exported from Shopify to Wave.

4
R
1 year ago
frankie210
frankie210Beginner
asked in Troubleshooting

Getting an error when triggering MySQL database to Hostgator

Trying to connect a MySQL database in Hostgator but keep getting an error. Not sure if I am entering correct info under host, port, database name and database username. Any advice/tips?

5
christina.d
1 year ago
S
sweepbrightBeginner
asked in How Do I

How do I create a DM in Google Chat DM via Zapier ?

Hello there, I am trying to notify a specific user with a DM in google chat/spaces. I can’t seem to figure this one out.Using slack as an analogy where this is perfectly possible (searching for a contact via his email address and then sending him a direct message). Is there any way to accomplish this in Google Spaces / chat ? tnx

4
christina.d
1 year ago
A
awilliamsBeginner
asked in Troubleshooting

Stuck at .txt. Can't get Typeform PDFs to download in Google Drive

Hello, I have two Zaps set up with the ultimate goal of getting Typeform responses moved into a downloadable PDF in Google Drive. The first Zap is running successfully, which is taking Typeform responses and moving them into a template in PDF Filler, then creating a new PDF document with the user’s email address as the file name. The second Zap is giving me a headache, and that’s moving that completed PDF from PDF Filler to Google Drive. I can only generate a .txt file in Google Drive, and I do not have the option to select a file as shown in the Zapier documentation. This is the same problem described in this form post, but changing that first step isn’t solving my problem. Any help is much appreciated! 

15
A
3 months ago
C
ChambersSFBeginner
asked in How Do I

Only trigger email parser zap on first message of thread

Hi,I’ve set up a zap using email parser as the trigger and it works well except that it fires every time there is a reply to that thread. Is there a way to limit triggers to only the first message of the thread? Here are the specifics of my zap:email arrives to Gmail and is automatically forwarded to parser inbox with a filter. parser triggers zap which creates an opportunity in Copper CRMI wonder if there is a way to either limit the filter in Gmail to only forward the initial message of the thread to the parser inbox or to limit this in the Zap using filters or something. Thanks!

2
Liz_Roberts
1 year ago
HOPS0522
HOPS0522New
asked in Troubleshooting

Duplicate Gmail Attachments in Google Drive: How to Filter Uploaded Attachments to Avoid Duplicates in Zapier

Hello everyone,I created a zap to upload new Gmail attachments to my Google Drive. That works fine, I can get the attachment to Google Drive. Here is my challenge:  If I respond/reply to the person that sent the attachment, for example to say thank you, my zap runs again and uploads the previously received attachments again. Now I have duplicates of the files in my Google Drive. I have tried to search my google drive for the attachment by file name and if nothing shows up continue (resulting in a true result). Then in a Zapier filter step I add if the file is over a certain size and if the file search is true then continue with the upload.  Any one else have this issue? Any ideas how to fix?  

3
ken.a
11 months ago
JackTwist
JackTwistBeginner
asked in Troubleshooting

Unable to post Slack thread updates as private comments in Zendesk ticket

Hey all,I have a question on how to create a specific flow that will allow me to:Zap 1: Escalate a issue from Zendesk to Slack (already have a zap for that), which creates a new Slack message in a private channel. The message itself includes a couple of internal information as well as the Zendesk Ticket ID as numbers (no link towards it is sent, just numbers) Zap 2: Post new thread updates as a private comment in that Zendesk ticket from that existing message escalated in a private channel. Each message needs to be sent as a private comment on that particular ticket.I was trying to follow this guide: however, it’s not working at all as from what I understand, in Find a Ticket in Zendesk I can’t point Zapier to read the information from the initial message that includes a Ticket ID.I also tried to create some sort of a workflow but that didn’t work either. I also tried something with a Sub-Zap but I’m not sure if I got that right, so any help would be very much appreciated, thanks in ad

7
agileops
7 months ago
C
codeulikeBeginner
asked in How Do I

Can Zapier create two Salesforce objects and link them together?

I'm just evaluating Zapier, can it create two Salesforce objects and link them together?Lets say in Salesforce I have two custom objectsFoo__cBar__cand Bar__c has a lookup or master detail field Bar__c.Foo__c that links it back to Foo__c.Using Zapier can I create the two objects and link them together?e.g.Create new Foo__c recordGet the ID of that new Foo__c recordCreate nmew Bar__c recordFill in Bar__c.Foo__c to point back to the Foo__c record I just created Thanks

3
SamB
Community Manager
1 year ago
monicaamb
monicaambNew
asked in How Do I

Connect my WooCommerce with Microsoft Dynamics NAV

How can I connect my WooCommerce with Microsoft Dynamics NAV because I want to receive the orders I have in WooCommerce into Navision also. How can I do it? I see these events but I am not sure the one I need to choose or if it is possible to do what I want -> 

4
chanelle
11 months ago
P
Percolator ConsultingNew
asked in Code & Webhooks

running code on raw JSON while retaining other context

We have a zap that’s making a callout to an API (which returns JSON) and we next need to parse the response via a  Code step.  We want to be able to parse the raw JSON, because the way Zapier is structuring the response as line items is proving to be problematic (it’s not handling leading or trailing nulls properly). In looking at other posts, it seems like the recommended approach here is to make a separate webhook zap w/ Catch Raw Hook, and then sent the JSON to it via a Custom Request Webhook action, using Data Pass-Through.  For example: How to transform JSON response? | Zapier Community However, my issue is that there is also data from previous steps in the original zap that need to be retained, because they’ll be needed for actions that follow the JSON parsing.  As far as I understand it, if I use Custom Request, the entire data payload will consist of the raw JSON from my API call.  So when using a 2-zap approach like this, how do I make sure other details besides the JSON make

1
Troy Tessalone
1 year ago
Z
ZodBeginner
asked in How Do I

Ninja form dropdown menu zaps to Google Sheets

Hi all,I’m trying to figure something out here I hope someone can shed some light on for me. I’ve used Zapier before for Ninja Forms to zap a row to Google Sheets without any problems but this is my first time adding a form dropdown menu. I had hoped that I could add a zap just for the dropdown itself (labelled Show Name) but see every option listed in the menu as though they’re separate fields.:  For those familiar with Ninja Forms, this is how the menu appears on the WordPress end:  I’m scratching my head trying to work out a solution and would very much appreciate any assistance or pointers. Thanks, Neal

9
christina.d
1 year ago
joshloe
joshloeNew
asked in Troubleshooting

Unable to display images or attachments from Gmail in a Slack channel.

I’m looking for a way to display/attach an image from an email to GMail into a Slack Channel.I have everything setup so far, but it is not displaying the image.   It just shows it as a file to download.   I used to have this working, but for some reason it is not anymore.  It is showing the file but not the image: 

9
ken.a
8 months ago
T
ThatOtherMattBeginner
asked in How Do I

Multiple FB Pages to Create Page Post

Hello,I have Inoreader set up to curate Facebook Page posts from numerous pages that are a members of our association. The RSS feed then triggers a ‘Create Page Post’ to share all of those posts to a single Facebook Page. I’ve had this set up for over a year and it worked beautifully at first. Whenever one of our members would post on their FB page, the zap would share it to our FB page, saving me tons of time manually sharing each of their posts. Over time, more and more of their posts are appearing on our page as a generic ‘Facebook.com’ link. When you click it, it takes you to the shared post, but the actual post does not appear on our page. All of our members’ posts are appearing this way, with the exception of one or two pages whose posts share perfectly. I’ve tried and tried to figure out what is different about the pages that work vs those that don’t, but can’t figure it out. I’m sure it is Facebook just being Facebook, but it’s frustrating that it used to work and now doesn’t.

10
Danvers
1 year ago
T
techiesNew
asked in How Do I

Send Mass Calendar Invite via CSV - email and date as parameters

Hello, I have created a CSV file that consist of Event title, email addresses and dates that they need to be reminded for in our google calendar workspace. Is this something Zap is capable of?

1
Troy Tessalone
2 years ago
M
Melanie BondoBeginner
asked in Troubleshooting

Unable to choose an event when updating an event in Google Calendar

Moderator Note: Split from this topic:   Hi Warren! Can I confirm that I’ve understood the issue? In the update event step, when you use the dropdown list for the Event, there’s nothing there? There’s nothing in the area that the arrow is pointing to in this screenshot? If that’s the case, then you’re right that it’s because the event needs to have been recently created for the Zap editor to pick it up.  Another way that you can choose a specific event for the Zap is to use the ID of the event in the ‘Custom’ tab in the dropdown menu. To find the event ID, clicking edit on the event in your calendar, when the edit tab opens the ID is in the url. It’s the string that starts after https://calendar.google.com/calendar/r/eventedit/ In this example, the Event ID is the text that starts ‘MmZu’. When you’re copying the ID from the url, make sure that you only include the string of letters and numbers, stop if you hit any punctuation, so the ID in the example above ends with ‘jb20’   When you

10
SamB
Community Manager
1 year ago
JortArie
JortArieBeginner
asked in How Do I

Applying a Date / Time Formatter to Line Items > not skipping null items

I am using Zapier to send a Gravity Forms trigger to Airtable. The Gravity Forms form is used to receive up to 9 meeting dates + meeting topics. Each of these meetings should become an individual record in Airtable. The form has the following fields that are read as line items:DateStart timeEnd timeTopicThis list repeats 9 times in the Gravity Forms form.Users can decide how many meetings they want to register, i.e. they can fill in 3 dates, or 9, or 1, etc. Second stepThe second step in Zapier (after pulling in the data) is a Line Itemizer. This works like a charm. Third stepThe third step is combining the date and start time and converting this to the format Airtable can read. This data is later used to create new records with a Date and Time field in Airtable. Resulting in: Problem statement: Now all of a sudden the date input reads “now”, instead of the blank or null it was in the second step. According to this help article, this is a common problem: When a valid date cannot be par

7
JortArie
1 year ago
C
Contessa_StoreNew
asked in Troubleshooting

Getting error when creating a new Zap : "Lost race to unpause the Zap"

Hi, I got this error after creating a new zap: “Lost race to unpause the Zap” What’s meaning? & how to fix?

1
Troy Tessalone
2 years ago
Jonathan Salem
Jonathan SalemNew
asked in Troubleshooting

Error Connecting Bitrix Account: "404 This page is not what you're looking for" and Site Cannot Be Reached

Hello Zapier Community!I am posting this to seek assistance regarding the two error messages we encountered while attempting to connect our Bitrix account to Zapier. We have been receiving a "404 This page is not what you're looking for" error message as well as a "Site Cannot Be Reached" error. Both of these errors are preventing us from successfully establishing the connection. Here are the specific details of the issues:Error Message 1: "404 This page is not what you're looking for"Platform: Bitrix Steps Taken: We inputted our Bitrix URL during the connection process but encountered the aforementioned error message.Error Message 2: "Site Cannot Be Reached"Platform: Bitrix Steps Taken: We inputted our Bitrix URL during the connection process, but we encountered the "Site Cannot Be Reached" error message.We have already taken the following steps to troubleshoot the issues, but without success:Double-checked the accuracy of the Bitrix URL provided during the connection process. Verifie

1
christina.d
10 months ago
G
gabriel.bonfimBeginner
asked in How Do I

Zap still held even using filter action

 I have a Zap called 'ABC' (fictitious name) that is used to count a new conversion on Facebook (through the action 'Facebook Conversions') every time a new row is added to a specific Google Sheets spreadsheet.Every time the spreadsheet in question is updated with the desired data, it automatically gets a lot of empty and unwanted rows, and these empty rows are causing the 'held zap' problem in Zap ABC, because ABC returned too many items at once.Trying to solve it, I created, between the Google Sheets trigger and the Facebook Conversions action, two actions:1. The first returns the default value 'empty' if the worksheet row has no data;2. The second makes zap only be executed if the default value is different from 'empty'.In the tests I did, zap behaved as expected: it only pushed a conversion on Facebook when the spreadsheet row had data (that is, it was not empty).Even so, the 'held zap' problem keeps happening. Does anyone have any solution for this?I accept all help, even if it is

3
Troy Tessalone
1 year ago
Terms & Conditions