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.

25577 Topics

C
CJMMacLawNew
asked in Code & Webhooks

Create Card in Basecamp 3

Basecamp 3 (now actually called Basecamp 4 but it is the same product) has a card table feature that is addressable via the API. However it is not addressable via Zapier to my knowledge. I see an older now closed thread of many others asking for this addition.  Just wondering if there are any plans to address this at Zapier?  

6
Troy Tessalone
5 months ago
Dan0nator
Dan0natorNew
asked in Code & Webhooks

issue passing variables to python

I have a zap that processes json data into a python script. when I assign the input data you can see that there are null values in the string. This is good and expected, but when it gets to the code the null values are removed. I have tried replacing the “,,” values with “,null,” but because the “,,” values are stripped out before the code runs this does not work. I think this is an issue with the code functions in zapier.  

4
Dan0nator
1 year ago
H
handyandyNew
asked in How Do I

Saving Multiple Attachments from Gmail with correct filenames

As mentioned in similar post, the “New Attachment” Gmail trigger will trigger with every attachment in the email. However, The attachment filenames are given as a list containing multiple filenames, which would be the same list per file. How am I able to identify which filename corresponds to the Attachment File (Exists but not shown) in order to name the attachment correctly when uploading to Drive. 

1
Troy Tessalone
2 years ago
S
SearchGrandJunctionRealEstateNew
asked in Code & Webhooks

Are Webhooks available in the free version

Wanting to connect my Real Estate website to my crm using a webhook.  While clicking on Webhook it has a bubble that says “Premium”   

1
Troy Tessalone
3 months ago
A
alexac90Beginner
asked in Troubleshooting

Unable to filter for different products in Stripe

This post has been split from How to distinguish different payment links in Stripe hi @Danvers @christina.d @jesse !! I am jumping i here because I’m experiencing the same issue -- though I am on the paid plan.  I am on stripe legacy, and I’m able to filter out different products and have them link to different segments in my FloDesk. All is good. The filter I use is “invoice lines data description”. I am trying to set this up for a client, and new stripe does not filter for product descriptions, unless I am missing something. Do I need to label something in stripe to have the product get pulled from the data?  I work for multiple clients and this is a huge bummer that I can’t see product information right now within filters. Can you please help?! 

1
Danvers
1 year ago
dandotson
dandotsonNew
asked in How Do I

How do I extract and store email recipients from multiple lines using Zapier Table or email Parser?

Hello there!  Pretty new to Zapier.  I have a Zap that takes a new email message, pulls the sender, recipient, subject, etc, and inserts that info into a spreadsheet (Smartsheet).  The mailbox that it is pulling from has multiple SMTP addresses assigned, so the recipient part is important.  I have stored all of these SMTP addresses in a Zapier table along with the “Pretty” name of the recipient.  For example, “sales-sandiego@contoso.com” would be in the Table with the “Pretty” name of “San Diego Sales”.  I’m using a Lookup to get the Pretty name and insert that into the Smartsheet.  Here’s my challenge. I’ve found that actual SMTP address might end up in the CC line, or even in the BCC.  So my v1 Zap has a lot of Paths.  If the Lookup for the recipients in the To: line returns false, then it does another lookup for the CC: line, etc.  It’s working, but it seems I could clean it up.  My thought for to make this a little more elegant would be to store all recipients in the TO: and CC: li

2
SamB
Community Manager
9 months ago
kentaro
kentaroNew
asked in Troubleshooting

Event A appears in Google Analytics 4 event list, but not showing up in Facebook Conversion.

I want to send the events obtained by GA4 to facebook's conversion APIOnly event A appears in the event list of GA4, but how can the event appear?  

2
SamB
Community Manager
10 months ago
ClintonAtSD
ClintonAtSDBeginner
asked in Troubleshooting

Zapier Custom Event error: Event name can only contain '-', '_', and alphanumeric characters with a length of 2-30

Hi guys. I’m relatively new to Zapier. So I want to set up two automations. 1. I want new subscribers in Stripe to move to Mailchimp so they get an automated email in Stripe (I have done this)I want current subscribers in Stripe to receive a “Thank you for Payment” email when they renew their subscription(which I chose “add/update subscriber” in Mailchimp & “Updated Subscription” in Stripe) - don’t know if I got that right - please kindly let me know if I did or not. The problem now is how to set up the automation email so that when triggers come from Zapier, Mailchimp sends an email. I chose custom automation and chose “API & Integrations” as the starting point then chose Zapier. Mailchimp is asking for a “Zapier Custom event” and I input “Updated Subscription”. I, however, get this error, “Event name can only contain '-', '_', and alphanumeric characters with a length of 2-30.” and can’t proceed. Please how do I set up this automation been at this for days. I’d appreciate any

7
SamB
Community Manager
11 months ago
Shakz
ShakzNew
asked in Troubleshooting

User ID mapping from Google Sheets to ClickUp without using multiple Lookup Tables.

This post was split from the topic: ClickUp error: Failed to create a task in ClickUp > The app returned "Value must be an option index or uuid". I am having the same problem while I am getting dynamically the user ID from Google Sheets in the step before updating a task in ClickUp. I don't want to use a format option with lookup table, because then I need to update this in all my zaps (too much work and not effective). Any solutions for this problem? Thanks. 

1
SamB
Community Manager
11 months ago
L
LukeTHEdukeBeginner
asked in How Do I

How to display lat/long as pin on map via SMS or email?

I have a feed that gives me longitude/latitude coordinates of leads that feed into a google sheet.I would like to be notified by either SMS or Email a image of the location as a map and the pin at the point of the coordinates. Any ideas how I can make this happen?

1
Troy Tessalone
2 years ago
A
AdamZapBeginner
asked in Code & Webhooks

Timeout on SimpleScraper

Hello,I am using an integration of simpleScraper to Sheets - I am a premium member but I am always getting a timeout error. Is there some way around this that I could use?Adam

6
A
2 years ago
Mustapha A
Mustapha ANew
asked in Code & Webhooks

Finding Classes with Quickbooks Online

Hey folks, I’m using the API Request (Beta) in QuickBooks Online action step to query class information in Quickbooks. I seem to keep getting an error and I’m not sure what I’m missing. I’m trying to query by name but I keep getting an authorization error but the action step should take care of all the authorizations. At least, so I thought. 🤔  

4
Mustapha A
9 months ago
P
podcastpartnershipBeginner
asked in Troubleshooting

Passing media file from Dropbox to Descript giving 400 Error.

I am trying to pass an audio file saved in a previous Dropbox Action, as an input to request a transcript in a Descript action. When I try the Descript step, I get the following 400 error:  Error from halted execution: The file pointed by the URL does not seem to be an audio file (Content-Type of https://ucf570eb91d679d62051ae4a9b17.dl.dropboxusercontent.com/cd/0/get/B2Fz76sGvL6Zaq-QWW-PM84rQWADjpL2tkTl8FOl-5szK7QmWKDB5iVVHxx6X8b4WrP5zpjEK3gLJFLEKgc8SXGFj2SRPwmul1EvJ6ytWNauCp2DHtEScrsoWNnaQn96K0zgP3vOzCN3Bq_BwYgI87btKUgxY9dz10h8h861JK1Qw03f9reUOFD7FZZ7S0sqlO0/file was application/json) I confirmed that the link does lead to an MP3, and have tried multiple file link fields from the Dropbox step but all return this error.  Any ideas?    

17
christina.d
1 year ago
A
AmandafNew
asked in How Do I

Connecting Zapier to a form in a commerce page in Squarespace

I have hit a problem trying to link my shop on Squarespace with Zapier.When someone clicks Add to Cart for a product, a form pops up on screen to be completed. I was trying to connect this form with Zapier so that when a sale is finalised my zap will process.So far i have not found a way for Zapier to find this particular form on my website (its only finding the general contact form. Is there any work around to get this to work? Thanks!

3
nicksimard
2 years ago
S
SCMLFNew
asked in Troubleshooting

Find & Update existing lead in Nutshell

 Hello,I need help please with setting up a Find & Update Lead zap.Specifically, what I need to set in the Existing lead field to update the existing lead once found. What do I select so that the lead that’s been found is then updated?  Here’s what I’ve tried:Selecting Existing lead, which works only for that specific lead that I’ve tested in Zapier. But then doesn’t work for subsequent leads so I don’t think this is right?  And then under Custom, I’ve tried these fields listed below, one by one. It either comes up as an error message in Zapier so is clearly wrong, or same issue as above.Wufoo  1.Email AddressNutshell  2. EmailNutshell  2. IDNutshell 2. Zap Search Was Found Status   Full context...The zap is triggered by a form submission from Wufoo. To firstly check if the lead already exists in our Nutshell CRM (Find Lead in Nutshell) and then set a rule to only continue is there is a data match. These parts seem to be working so I think this setup is OK? But if this is the root

2
S
2 years ago
L
LukeSummersBeginner
asked in How Do I

Question about line items where more than one of the same item has been purchased

Hi all,I am using zapier to output WooCommerce orders into a google spreadsheet, but I’m looking for a way to separate quantities into individual line item entries.  So far I have been using the line item feature to separate different products, but I want to go one step further so that each item has its own line.So for example, an order that looks like thisSKU ITEM NAME FIRST NAME LAST NAME EMAIL PHONE ORDER DATE ORDER ID QUANTITY PS03 002 - The King Jonny Rockets me@xyz.ca 1234567789 Jan 1, 2021 14570 3  Would end up being outputted onto my google sheet like soSKU ITEM NAME FIRST NAME LAST NAME EMAIL PHONE ORDER DATE ORDER ID QUANTITY PS03 002 - The King Jonny Rockets me@xyz.ca 1234567789 Jan 1, 2021 14570 1 PS03 002 - The King Jonny Rockets me@xyz.ca 1234567789 Jan 1, 2021 14570 1 PS03 002 - The King Jonny Rockets me@xyz.ca 1234567789 Jan 1, 2021 14570 1  Is there a solution to this?

5
GetUWired
2 years ago
B
Bob Le BobBeginner
asked in How Do I

Trigger - delay - recheck trigger

Hi :) Is there a way to have a trigger, delay, action to check if the trigger is still valid and then trigger again?I want to have an incomplete order trigger on bigcommerce, with a delay of 10-15mins to make sure the customer hasn’t been able to fix it themselves and if its still valid then alert via email.Or is there another way to handle the pause before pulling from bigcommerce?Thanks :)

14
christina.d
1 year ago
G
Garrett
asked in How Do I

Pull from Multiple mySQL tables?

I'm putting together a Zoho CRM connection between my mySQL database. it looks like you can only pull in information from one mySQL table at a time. What I'm looking to do is pulling information from multiple tables into the single Zoho record. Is that possible?

1
jesse
4 years ago
A
A90 - JCNew
asked in How Do I

How do I duplicate/create a new Google sheet and then update that sheet with the client data from my CRM?

Hi all, I am looking to create a zap to send data from our CRM into a Google Sheet. I want the zap to create a new Google sheet (duplicate an existing sheet) then update the duplicate sheet with the client data pulled from the CRM. Does this functionality exist? I am trying to do so but haven’t had any luck at all.  I have attached a screenshot of the snippet of sheet I’d like to duplicate for each client that makes it to this stage. Then have the zap populate those fields. 

1
GetUWired
1 year ago
B
bindiNew
asked in Troubleshooting

ConstantContact Update contact

We trying to setup a Zap to find a contact (or create if not found) and then update the contact. See the screenshots. Only it can’t find the customer when updating.The found user, in the find Zap, is used to Update the user in the Update step. And the main goal is to add the user to the List. Hopefully somebody can help me with the problem!    

6
MohSwellam
1 year ago
A
argilmourBeginner
asked in How Do I

Signed PDF to SQL Server Filestream Column

Hello, I have a zap that sends out documents to be signed by students. Once they have been signed I would like to upload the PDF files to a MSSQL database in a Filestream column. I have tried two options: Signrequest to MSSQL Signrequest to Google Drive to MSSQL Both options fail to upload PDF documents that can be opened from the databse. In option 2 I can see the signed PDF document in the Google Drive but again when I try to upload it to the database the document is then not displaying when we click to open it in our management system.   Any ideas?

2
steph.n
3 years ago
Z
zapjohn
asked in How Do I

Unbounce and SendGrid - Rejecting API Key Login for SendGrid

Attempting to connect Unbounce to Sendgrid. Zapier rejects the Sendgrid Pro Account API Key with the error "not allowed". An API key with admin permission was attempted, then one with email only, neither worked. A new teammate and API Key were also attempted. The error message reports "set to allow or approve", but doesn't say where to do this. My API Accounts are approved in Sendgrid. I can't see the advantage of Zapier compared to Webhooks at this point. Help appreciated.

2
jesse
4 years ago
A
Astro4EarthBeginner
asked in How Do I

Trigger Formidable when new entry created *only if specific form field populated*

Hey all! I was wondering if there’s a way to trigger a new row in a google sheet when a form is filled out via Formidable (a new entry created)… *but* the catch is, the form entry must have a certain field populated appropriately. My overall goal is to only send “approved” data to this google sheet…. so my plan is to have someone fill out the form (create a new entry). Then the “approver” (myself) will go in and check the data. If I approve it, I would duplicate the entry and while doing so, type into a hidden field of the form, viewable only to me, “approve”. This would create a new entry, but with that special field “approve” populated. Is there any way to do this? Or a cleaner way to send only approved form entires to a google sheet? Thank you!

6
A
2 years ago
W
wishstrBeginner
asked in How Do I

How to grant folder access in Google Drive via Zapier without coding?

in zapier when adding G Drive we can only add file sharing preference, not folder.Is coding the only way to add certain people to have access to a certain folder?I saw one java code about it and don’t understand the code.

6
SamB
Community Manager
1 month ago
A
aubreyNew
asked in How Do I

How to update Deleted order in shopify? Im using zapier with shopify to googlesheet

Is there a way where I can update the googlesheet with deleted order in shopify?

3
jesse
3 years ago
Terms & Conditions