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.

25638 Topics

C
caselNew
asked in How Do I

RegFox Pre-Registration Trigger

We want to auto-enroll people who have pre-registered in RegFox into our Thinkific course. As of now, the only trigger event for registration is “New Registrant.” Is there anyway to create a Zap for a New Pre-Registrant?

2
C
2 years ago
I
Ivan DNew
asked in How Do I

Dynamic selection of sender account depending on day of the week

Hello Experts! I am a new person in zapier and here is my problem. My automation looks like this: a person fills out my form in google forms, then he receives a welcome letter from me (“Thank you for filling out our form. We will contact you shortly!”) and I want this letter to come from two different gmails accounts, depending on the days of the week. Or in other words: i need dynamic selection of the sender depending on the day of the week (for example: on weekdays it will be gmail 1 and on weekends it will be gmail 2 / or on even days gmail 1 and on odd days gmail 2).How can I link two gmail accounts in zapier and make them work on specific days of the week?  And can it be done at all  ?Thanks!

2
SamB
Community Manager
2 years ago
R
Rawad9New
asked in How Do I

MySQL timeout error connecting to account

We hit an error adding your new accountauthentication failed: Timeout connecting to 185.192.69.216:3306 (185.192.69.216:3306). Try opening up any firewalls and ensure your device is listening on port 3306.What is the port should I use?

2
christina.d
2 years ago
D
Digitas ZapBeginner
asked in How Do I

Zap missed Facebook lead and due to compliance we can not downloads leads

Hi Awesome people,  I am using salesforce as CRM and Zap missed few of the leads which as still in Facebook form Library but due to Compliance I can not download the leads and upload it manually or cannot use google sheet and Zap to sync leads in Salesforce. is there a setting or configuration in Zapier to pull old leads?  Thanks Nitin Gupta

2
D
2 years ago
A
andybananaNew
asked in How Do I

Does my Zapier subscription include GST / billing question

Hey allDoes my Zapier subscription include GST?I am in Australia. I am billed in USD but am trying to be billed in AUD can’t find the option to do so. And if in AUD, I’d like to know if I am charged GST?Thanks!

2
A
2 years ago
N
nickmeptikBeginner
asked in How Do I

Is there a way to ensure Zap only triggers for certain updates in Pipedrive?

Hey all! TL;DR - PipeDrive is triggering Zapier an excessive amount of times. Presently I’m using PipeDrive (Our CRM) to trigger a series of actions in Zapier. I have the action set to “Whenever a variable is updated in PipeDrive, trigger”. This is an instant action - which is what I prefer because PipeDrive only offers two types of actions:When any piece of a deal (deal being a project) is updated  Whenever a deal changes project states. The simple fix is that I can change Zapier to only listen when the deal’s state changes, however, this means that I can only poll for an update at much lower intervals.  So, my solution has been to have Zapier listen for any changes in PipeDrive, then filter it out. However, this means that Zapier is getting pinged some 500x a day when it only needs to be pinged some <25 times. Is there a better way to prevent this and have PipeDrive only update Zapier in certain circumstances, or is there a way to have Zapier only listen to certain variables?  Tha

2
Michael Lucas
2 years ago
E
eortizBeginner
asked in How Do I

Trouble parsing CSV file line items using Formatter

Hi everyone,I’m trying to import a CSV file from a new attachment in Gmail, but I’m getting some troubles using Formatter.This is the sample CSV file: And this is my Formatter set up: The problem is that for every line item, Formatter is not assigning the values to the correct columns (header names):    Any help would be appreciated.Thank you

2
E
2 years ago
A
Anonymous
asked in How Do I

connection not possible with Facebook Lead ads

HelloI'm desperately trying to log in to Zapier with my Facebook leads ads, but I can't log in with the ad account. For the business manager it's set ok, ditto for the page, for the ad account I have an error message telling me that the ad account is in another BM., But I have all the permissions on this account. I had Facebook by phone confirming that everything is ok from their side.I tried with the owner login too, and it’s the same error message.Does anyone have an idea to solve this problem ?Thank you

2
A
2 years ago
F
FalesBeginner
asked in How Do I

Can I send a text to multiple phone numbers?

Hello,  I have many married contacts to whom I need to send important information over SMS.  My question is this: can I configure Zapier to send a text to every phone number I have on file for my contacts. In other words- can I send a text to multiple phone numbers.  Occasionally, one or more phone numbers on file for my contacts is not available for sending- either it is an internal phone number or incomplete, entered incorrectly or something else. If one of the phone numbers can not be reached, would zapier still send SMS to the remaining, valid numbers?  

2
Troy Tessalone
2 years ago
M
Max.ZBeginner
asked in How Do I

Limit to number of Acuity triggers in a single day?

Hi all!I have a Zap which is two steps:Appointment is created in Acuity Create a case in ZendeskToday, one of our appointments was not converted to a case. I looked at the Zap and see that it was never triggered. There’s no error or anything from what I can see.In addition to this Zap, we have one which edits a Zendesk case when the appointment is rescheduled and another which closes the case when the appointment is cancelled. We had quite a few events in Acuity today - could it be that we ran into some kind of limitation in Acuity or Zendesk? Has anyone experienced this before?And I have already checked - we have over 1,000 tasks left for this month so it was not a limitation on our Zapier account from what I can see. Any thoughts on this are appreciated. Thanks! Update: The appointment was scheduled at 2:11 PST and the Zap was just triggered at 2:58 PST. So it went through but the delay has caused a problem with our agents’ scheduling. Hoping to figure out why it was delayed for so l

2
M
2 years ago
R
RocketNew
asked in How Do I

HubSpot error: Property "date_contact_created" does not exist

error setting up an airtable to hubspot zap : Property values were not validdate_contact_created: Property "date_contact_created" does not exist,i've been trying various fixes by adding the date fields i have on airtable but it still comes up, checked the common problems with hubspot article as well, unfortunately it doesn’t really help with this specific error, i could be wrong,pls let me know how I can get this fixed.  Thanks in advance

2
R
2 years ago
J
jaimemesdentsBeginner
asked in How Do I

Checkbox problem between Gravity Form and Sellsy

Hello, I have a small problem between Gravity Form and Sellsy with Zapier.I can't understand, I made a zap that follows the answers of a prospect registration form on my website ( https://www.jaimemesdents.fr/contact/professionnel/ ). The answers to this form are then sent to Sellsy via a Zap.In this form, there are simple conditions. We show this or that checkbox depending on the response to the radio button above. The checkboxes are absolutely identical except for the condition. However, in my Zap, the information retrieved is different (see these screenshots https://ibb.co/0s4jf6z and https://ibb.co/2yXWBH3). And since the answer received by the first screenshot (https://ibb.co/0s4jf6z) is not presented as a classic checkbox, it is not valid and it blocks the rest of my zap.To make it work, I had to (temporarily) remove the checkboxes in question by radio buttons. However, this does not allow me to have all the necessary information in my contact files on Sellsy.Have you ever encoun

2
J
2 years ago
M
MDemetrioBeginner
asked in How Do I

Search all rows in Google Sheets for a value

I need some help getting a Zap to work. I have a sheet with all of the meetings we’ve had this month. When we close a deal we set a field to “Yes”.  Until then, it’s marked “No”.I would love to have Zapier, find all  of the rows marked “No”.  Then I’d love to lookup the user in Chargebee.How do I set the Zap so that it doesn’t stop at the first “No” that it finds.  I would like it to find all of the “No” rows and complete the steps that follow. I see that we can “Get many” but that limits me to 20 and I may need far more than 20How do I format the step to find all of those rows and not just the first “No”

2
M
2 years ago
F
Flimsy FoxNew
asked in How Do I

Does Zapier support wildcard searches on Twitter?

I’m looking to wildcard search Twitter handles and usernames (i.e. “@bot1*”) and pass all of the returned accounts into a list. Does Zapier offer this functionality?

2
SamB
Community Manager
2 years ago
R
RussStephensBeginner
asked in Code & Webhooks

Is there a way to update a POST webhook (XML) request to get the specific data in an array?

Hi allI’ve been struggling with one particular webhook for a week now and really need some help. Worth mentioning that I’m not a developer but work with webhooks daily, just not familiar with this particular format.I’ve been working with the Zapier support team but am going to see if anyone has any ideas how I might get this working correctly.I’m raising a Custom Request (POST) webhook that is testing quite successfully. The trouble is that when I try to pull the results through in the next action step, the data isn’t actually pulling through as an array which is what I need it to do.It looks like the data is nested in an array when testing the webhook (see screenshot below):  But this issue happens in the following step in that Payment, Payment2, Payment3, and 4-6 are not grouped together. For example, we'd expect that since each of your payments have a PaymentReference field, that the Reference data for each of the three payments would be group together in a line-itemized field. But

2
R
2 years ago
A
AbeBeginner
asked in Code & Webhooks

How to watch new Firestore documents with a specific status?

I want to ask about firestore trigger, related to this zapier article https://zapier.com/help/doc/common-problems-firebase#creating-a-firestore-structured-query-for-a-search , I have Firestore collection “users”,and it has multilanguage status. like this.users {    “language”: “en”,    “foo”: “foo”,    ,,,,} I could make zap to watch just new document in “users”,but I don’t know how to watch new document in “users” with having language as “en”. I don’t know how to write this. Could you anyone help me with this?

2
A
2 years ago
S
SMLDNNew
asked in How Do I

Is it possible to create a Zap to filter the number of Opens from Mailchimp to Hubspot?

Hi, I was hoping that maybe a feature in Zapier might be able to solve this issue! I have Mailchimp to Hubspot synced already and this is a great feature. So we can see all the opens and clicks from our Mailchimp campaign directly in our Hubspot account. I have created 2 lists:1 for Mailchimp Opens and1 for Mailchimp Clicks My question is - IS IT POSSIBLE TO CREATE A ZAP TO FILTER THE NUMBER OF OPENS FROM MAILCHIMP TO HUBSPOT? What I mean by that is - can I add a column in my Hubspot list for Mailchimp opens that will tell me the NUMBER OF TIMES A CONTACT HAS OPENED MY EMAILS. Please see my attachments for a bit more clarity. Hopefully I have explained this clearly and hopefully someone can help with this. Thanks!  

2
S
2 years ago
A
Anonymous
asked in How Do I

Send emails (Gmail) with attachment (Google Drive) from a Google Sheet list

I keep building this automation the wrong way and just need a second brain to help me out because it's a combination of troubleshooting issues. The problem to solve is this: I run a summer camp that requires constant emailing to a variety of groups on a daily basis. For example I have to email parents four times for every week of camp they come because that’s just how much reinforcement and pacing parents need. For added context: using an email system like Mailchimp has not been successful because of filters in emails now. It almost always gets ignored or set to the trash, and the information in each is separate, important, and immediate so making sure they get it and see it is of top priority. I want to make an automation that: 1) calls a list of emails from a specific sheet (Google Sheets) 2) Set up an email draft with those on the list tagged under BCC to send to myself. (Gmail)3) Attach documents to this specific email OR use a template that has the attachments ready to go (Gdrive

2
A
2 years ago
M
Marco456Beginner
asked in How Do I

How to send Myparcel.nl shipping labels to Gmail as PDFs?

Hi Zapier Members, I just made a zap where a shipping label (PDF) is automatically created in MyParcel.nl when an order comes in in my payment software. But now I want to have this PDF automatically sent to my Gmail account, so that when I get home in the evening, I can send these individual PDF mails together to the email address of my printer, which will print the shipping labels. Does anyone know how I can do this?This is the user manual of Myparcel.nl (company for making shipping labels):https://myparcelnl.github.io/api/#1_A(english version)I myself can't find the right information in this manual because I don't do this very often, but maybe someone of you can find the right information for me here? so I can complete this last step😊 I look forward to your responses, best Sincerely, Marco 

2
M
2 years ago
M
Maria LucioBeginner
asked in How Do I

Dates from Typeform not added to Google Sheets in the correct format

Hi you all, I have a zap that passes information from typeform to gsheet, one field is "start date" but instead of giving me the date: 2021-08-20T14:24:12S it started giving me a random number that looks like this: 44428,68347The number has no format in gsheet, can some one help me out please?

2
Troy Tessalone
2 years ago
4
4pillarfundingNew
asked in How Do I

How to pull screenshot of table (specific cells) from Google Sheet?

Hello all, I have a Zap set up but just running into a tiny problem that has become a head scratcher. My firm provides business financing. I have created a formula to provide prospective clients with a quote for what an offer would look like using Gravity Forms and Google Sheets. Upon submitting the Gravity Form it automatically updates a chart in Google Sheets and redirects the client to a different page showing them their quote. So all is good and fine except one tiny issue.  It is not a unique URL so every time a NEW client submits a quote request the table updates and changes.  This of course does not scale and if a client ever wants to come look at their quote later on it will likely be different. Here is a step by step of the Zap. Form Submission in Gravity Forms (http://4pillarfunding.com/quote)Create Spreadsheet Row in Google Sheets (with Gravity Form Submission Data)Lookup Spreadsheet Row in Google Sheets (find newly created row)Update Spreadsheet Row in Google Sheets (in a di

2
SamB
Community Manager
2 years ago
P
pinguNew
asked in Code & Webhooks

Odoo ERP Self-Hosted, DateTime format issue - "code object of type 'DateTime' has no len()" error

When trying to connect to an odoo database to create a calendar event, Zapier throws an error:File "/home/odoo/addons/odoo/odoo/addons/base/controllers/rpc.py", line 60, in xmlrpc_1 response = self._xmlrpc(service) File "/home/odoo/addons/odoo/odoo/addons/base/controllers/rpc.py", line 49, in _xmlrpc result = dispatch_rpc(service, method, params) File "/home/odoo/addons/odoo/odoo/http.py", line 139, in dispatch_rpc result = dispatch(method, params) File "/home/odoo/addons/odoo/odoo/service/model.py", line 41, in dispatch res = fn(db, uid, *params) File "/home/odoo/addons/odoo/odoo/service/model.py", line 94, in wrapper return f(dbname, *args, **kwargs) File "/home/odoo/addons/odoo/odoo/service/model.py", line 181, in execute res = execute_cr(cr, uid, obj, method, *args, **kw) File "/home/odoo/addons/odoo/odoo/service/model.py", line 165, in execute_cr result = odoo.api.call_kw(recs, method, args, kw) File "/home/odoo/addons/odoo/odoo/api.py", line 385, in call_kw result = _call_kw_mode

2
Danvers
1 year ago
G
gstanilandNew
asked in How Do I

Trigger on updated documents in MongoDB

Does Zapier support a trigger to catch an update to a field on an existing document? It looks like it only triggers on a new document or new field. 

2
SamB
Community Manager
2 years ago
P
PelleNew
asked in How Do I

Trigger when Google Sheet cell is an upcoming date?

Hi! Is it possible to trigger a zap when a cell in a Google Sheet is a date in, let’s say, one week from now? Thanks!

2
P
2 years ago
F
frgoalBeginner
asked in How Do I

Edit or delete Facebook Lead Generation connection with MS Dynamics

Hello all, Is there a way to edit the data being sent from the Facebook Lead Generation to MS Dynamics? I created a connection that creates a new contact in the CRM and populates the name, email & phone number fields when a lead is generated but I wanted to see if I can include the Lead Generation campaign as well so we can differentiate between different types of leads in the CRM? I tried deleting the connection so I could recreated it but none of the online instructions on how to do this worked.Thanks,FR 

2
F
2 years ago
Terms & Conditions