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 Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Apps 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.

20221 Topics

J
jadjugahBeginner
posted in How Do I

Which of the fields in ConnectWise Manage ticket are supported by the “New/Updated Ticket” trigger?

Which of the fields in ConnectWise ticket is supported by the “New/Updated Ticket” trigger ?Thanks  This post was split from the topic:   

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

How can I keep original OneDrive file formats when uploading to MS Outlook?

I created a trigger to upload a file as an attachment to an email in outlook as soon as it is downloaded into a onedrive folder, when it uploads the file it changes it to a txt file on the outlook email. How do i keep it as the original file type i.e. a pdf or word doc?

2
jesse
1 year ago
S
SkilldomNew
asked in Troubleshooting

Getting an Error 1045 : When connecting MySQL

Hi,We’re trying to connect MySQL for creating zap between MySQL and Sendgrid. We created an user by granting all privileges for accessing to the MySQL but here in zapier when we try to connect zap, it is throwing some error. Could you please help us with resolving the issue, here we’re attaching the screenshot of this issue for your reference.Thank you 

2
jesse
1 year ago
M
MWPBeginner
asked in Troubleshooting

How can I re-run Zaps when Facebook/Instagram picture URLs change?

Hi All, I am using a third party app, which retrieves data from SoMe and FB Pages. It works just fine, but Facebook and Instagram links to pictures are changing over time. Which makes the Zap to pictures unusable over time. Is it possible to add a feature, which updates the post (and all previous zaps) That will ensure that the Zap is retrieving the actual link, and if any adjustments has been to text is also updated, it will be transferred as well. It would be very helpful when integration SoMe into other apps. RegardsMick

4
jesse
1 year ago
7
700plusclubBeginner
asked in Troubleshooting

Why is my trigger not running automatically?

Hi community, I created multiple ‘trigger and action’ zaps on Zapier Trigger: Deal Matching Filter in PipeDrive             That is, Deal status on PipeDrive is changed to wonAction: Add Tag to Subscriber on Drip The test ran fine, but the trigger is not working irl. ‘Deal Matching Filter in PipeDrive’ → ‘Test Trigger’ is not pulling in new deals from PipeDrive. I had to choose from multiple deals, from the drop down option, and select one of them (Deal A, Deal B, etc.) manually for the zap to work  How can i make it work automatically? 

13
E
1 year ago
Troy Tessalone
Troy TessaloneZapier Expert
posted in Troubleshooting

Feedback: have known issues with Zap available publicly

 Note: This post was is a reply to this post @DanversFEEDBACK: If there is a known issue with a Zap app, then it’d be great if this was somehow indicated on the Zap app profile help page, perhaps as a new article.Having known issues not publicly accessible for reference ultimately is a waste of time for everyone involved.Being able to know when an issue was reported or started and when it was resolved or if it’s still open as a history log would be idea, especially for troubleshooting, a la the Zapier Status page incident history: https://status.zapier.com/#incidents-list

1
Danvers
1 year ago
A
angelradvBeginner
asked in How Do I

Is it possible to send unique content in an email without the webhook action?

I have already configured the triggers I need, this is more about the action: I need to send a unique code from a list of codes in an email, this means picking the first code in the list and deleting it then including it in an email, I don't want to call an API endpoint for this, because I would have to code it and if I’m going to code an API endpoint for it, I rather modify my functions.php in my WordPress theme and not use Zapier at all. More context:I’m triggering the Zapier for the event paid trigger in WooCommerce integration. Thanks in advance.

3
A
1 year ago
C
Christian HomiBeginner
asked in How Do I

Extract Text from Email without parsing

Hi, within the text below I want to extract:1. the 5-digit code after the string ‘homi.one ‘, i.e. 123452. the mobile number i.e. +3069xxxxxxxx3. the first name Jane4. the surname DoeThe text is the body_plain of text extracted from Gmail for enquiries from customers.The order of info should remain the sameHow can I do this? I am using the text formatter, and I think I may need to use the extract pattern, or split text, but not sure where to go from there.Any help would be greatly appreciatedI have tried parsing, but I had a LOT of trouble, and the parser was always getting it wrong. Body_plainVisit request for the following listing.# homi.one 43866Suburb (Region)Property 41 m<sup>2</sup> for sale€42,000https://www.site.com/abcI really like this property.Please send me more information.It will be me and my two dogs. Jane Doe+3069xxxxxxxx (All day)abc@defg.hij 

3
jesse
1 year ago
B
BretJorgNew
asked in Code & Webhooks

Remove variable text from string.

I have this output["*Nps*","4 out of 10","*Why*","Great"], null, ["*IsStaff*","true ","*IsActive*","true ","*UserId*","auth0|5a577dxxxxxxx228a03e564c ","*IsTrial*","false ","*HasNoSubscription*","false "], ["*SubscriptionStatus*","{\"enableReview\":true,\"enableRise\":true,\"plan\":\"team\",\"status\":\"active\",\"endDate\":\"2028-06-13T00:00:00.000Z\",\"role\":\"seatHolder\",\"subscriptionId\":\"xxxxxx-4af4-4417-8fbd-xxxxx\",\"isRetrialEligible\":false,\"isTeamAdmin\":true,\"seats\":202}","*Platform*","Mac","*Browser*","Chrome 103.0.0.0","*Url*","<https://xxx.BlahBlah.zone/>","*Device type*","desktop"]and need to extract only the auth0|5a577dxxxxxxx228a03e564c in the output. In trying to remove everything up to the value above, I’ve tried the following JavaScript to no avail: let Response = inputData.Response.split(/"*Nps(.*)UserId*",":/g)[0]; output = [{Response}];I started from this thread

2
Troy Tessalone
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
J
JLCNew
asked in How Do I

Can't set up zapier to google chat

Trying to fix a broken zap and cannot for the life of me find out how to add the bot to google.I have added a connection with my Google credentials to Google Chat. However when I try to create a zap the trigger for google chat is greyed out and says “not available”. Also my google spaces don’t have a “Zapier” bot to add into.

1
GetUWired
1 year ago
T
trackingpremiumNew
asked in Troubleshooting

Quickbooks Online Business Validation Error: The payments you entered add up to more than the amount received

HI,I try to created a payment to an invoice with stripe and quickbooks and I get this error message when I run a test. Failed to create a create payment in QuickBooks OnlineBusiness Validation Error: The payments you entered add up to more than the amount received. Everything looks good from my end. I wonder if there is a way to resolve. Thank you

2
Danvers
1 year ago
I
immoinov.frBeginner
asked in How Do I

How can I get data not in JSON format when sending data from Google Sheets to SuiteDash?

Hello , i have a little problem and would like to get help , the problem is when i use Schedule to automate getting data from google sheets and send the received data to SuiteDash , in action google sheets i select event “Get many spreadSheet Rows” and  i am getting data in a array in json format with key and value , how can I get data not in json format ? , because I can't exploit the data in json format to populate fields . Any help or ideas? Thanks!

8
Danvers
1 year ago
J
Julien MalengoNew
asked in How Do I

Where to get the "Recipient Id" in order to Send message from page in Facebook Messenger when using Facebook Messenger as an action?

Hi, I'm trying to use Facebook Messenger as an action and got stuck on step where I must enter the Recipient Id. Here below you can see the step where I am stuck.Thank you in advance!

1
Danvers
1 year ago
I
Ink Factory StudioNew
asked in How Do I

Create Quickbooks Estimate - keep Amount field blank for certain line items?

Hello!We have a pretty static menu of services and products at our company, so our salespeople ultimately end up creating a lot of identical estimates in Quickbooks. We’re trying to automate this process to more easily generate our most “basic” proposals using a completed Asana task as our trigger.So far so good! Our formatted line items are working pretty seamlessly, but we do have a few line items in our estimates that we intentionally don’t apply a cost amount to (things that will be adjusted later on, or terms and conditions that don’t have a cost association).Via a Zapier integration, the default for an “empty” Amount field is to input “0.00”. It’s a required field for each line item, so we can’t exclude it. Is there a way to assert that these should stay blank? Or to delete the 0.00 after the estimate has been created (via integration, not manually!) Please let us know what other info we can provide!

1
Danvers
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
B
bryanhjNew
asked in Troubleshooting

SMTP Erroring Out when signing in

I’m trying to sign into the gmail server (smtp.gmail.com) with TLS on, port 587. I keep getting the error in the attachment or another similar (request timeout on port 465, etc). I’ve verified login info. I can’t turn off “less secure app protection”. I’ve tried different ports, verified my IMAP was turned on. Also tried filling in the “from” address with the same email.Ideas?

1
christina.d
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
robertandrews
robertandrewsBeginner
asked in How Do I

Tool needed: How to pull Google Analytics and other data into a monthly snapshot doc?

A client wants to receive a monthly one-page doc showing items including: Google Analytics highlights for the previous month, inc. items like the following: Top-level site traffic Top content pages Other items, inc Social engagement stats from LinkedIn, Twitter. Upcoming content marketing plans and highlights/initiatives. Google Analytics is my kryptonite.Do any simple tools exist with which I could make a doc/dashboard-doc, drag in some widgets for Google Analytics... and ?This is not just about Analytics. I'd also like to add in some manual/narrative other material, and maybe pull in some data from other software/services, too... eg. I use Airtable for upcoming-content planning, and then there's the social networks.

3
christina.d
1 year ago
C
CW1978New
asked in How Do I

Selecting Excel spreadsheet stored in Google Drive

Hi community, I am trying to connect Jotform to a Excel spreadsheet stored in my Google Drive but the only storage connections available to connect to is Onedrive and Sharepoint.  I have added Google Drive find my file before the excel connection but it doesn’t really work.  Before I give up and just use a Google Sheet, can anyone tell me how to easily connect jotform to an excel spreadsheet file stored in Google Drive?  It just can’t be that hard, I’m obviously missing something easy here.  Thanks so much!

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

How do I pull the license code from Google Sheets and email it to the customer when the WooCommerce order contains a software license product name?

2 part questionI want to sell license keys for a 3rd party software, so IF woocommerce order contains SOFTWARE LICENSE PRODUCT NAME then pull license code from google sheet and email to woocommerce customer my other question; IF company name is filled out, THEN send order details to slack channel 

2
christina.d
1 year ago
I
IcarusZapsBeginner
asked in How Do I

Is this possible: Spreadsheet update to Search MYSQL to Email

I am familair with MYSQL queries and also familiar with zapier tasks when a spreadsheet updates. Wondering if this is possible: When our recieved inventory spreadsheet has a new row the zap would:Search for the item name in our MYSQL order database Return all the matches from the MYSQL DB (only customer name, email, telephone, state) email us the resultsI think it’s possible. Just haven’t really run a query in zapier. I usually run them in phpmyadmin

3
Andrés at Connex
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
A
AdamZapBeginner
asked in How Do I

How can I create a database of Zaps in Notion?

I am trying to create a database of my zaps that I created which would make it easily searchable (this would be in notion). I am wondering if there is any sort of “when a new zap is created” and I would send the information to the database?

1
nicksimard
1 year ago
M
ModernNew
asked in How Do I

How do I set up time tracking for Acculynx and Timero to track each tech's time?

Hello, I am just getting started with Zapier for the first time. I am trying to get time tracking set up with Acculynx and Timero to start tracking each techs time. I need some help setting it up for the first time. Can some one help me get started. I have already connected both acculynx and Timero but thats as far as I have gotten. 

4
jesse
1 year ago
Terms & Conditions