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.

25223 Topics

H
HenrikcoxBeginner
asked in Troubleshooting

MySQL update to Adalo: Failed to create a record in Adalo - The app returned "Not Found".

Hi there, I have replicated a MySQL database that I use for a separate web app to my Adalo records and use Zapier to update and create new records from new MySQL entries to Adalo records and vice-versa. One such interaction that I’m having trouble with is assigning ‘devices’ to ‘users.’ I have a junction table in MySQL to connect these instances, as well as separate ‘devices’ and ‘users’ tables. When a new entry is made in the junction table ‘user_device’ on MySQL, I want to Create a new record in my ‘user_device’ database on Adalo (functionally does nothing but I believe I need to create a new record to use the record ID in Adalo for the next step) Update the corresponding device_id in my ‘devices’ database on Adalo to add the ‘user_id’ to link that device to the user (background info, this is a many-to-many relationship). I can successfully create a new record in Adalo as mentioned in step 1. But to update the ‘devices’ database and add the user to the record, my Zap is displaying th

5
H
1 year ago
M
macmenzyNew
asked in How Do I

Edit body of gmail draft from google sheet

Hi. I just made a zap that creates a draft gmail message when I update a row in google sheets. It’s great, but I want to make a couple of changes to the actual body of the draft message. When I create a draft copy to edit, it only lets me edit the main triggers etc and I can’t figure out how to re-open the body text. Help! MM

5
jesse
1 year ago
R
Rev. KevBeginner
asked in How Do I

How do I create an order in my WooCommerce store from my Clickfunnel account?

I am having creating a zap from my clickfunnels account to create an order in my woocommerce store. Can anyone assist?

5
christina.d
1 year ago
T
TwolakNew
asked in How Do I

Get Public Google Drive Link from Google Form Data

Hello, I’m trying to pull the image file submitted from a google form, then have it added to the task on Clickup. The google form stores the files on a public google drive. I’m trying it this way >Receive form responseCreate task in ClickupUse webhook to get the image file from the URL generated by google forms.Upload image to the task in Clickup. The problem I’m running into is that the link generated by the google form is not working through the app. When I click “Get link” on the image itself, then copy it in the webhook URL, it works fine.What’s the best way to get that image to Clickup? 

5
jesse
1 year ago
P
PictoNew
asked in Code & Webhooks

POST as Form in Webhook always sends as JSON?

I am trying to get Zapier’s POST Webhook to work, but without any success.First, Zapier does an extremely poor job showing what actually gets send to a webhook. I had to use Postman to analyze the body that Zapier is submitting out.What turns out, when you select POST and FORM in Zapier, what being sent is always JSON!! Below is what Postman receives from Zapier:With these settings: 

5
GetUWired
1 year ago
B
bedoyaBeginner
asked in Troubleshooting

Help Creating Zap - Copy Google Sheet Account Name -> Extract Data from Salesforce -> Paste in GSheet

Hi there,I’m new to Zapier and looking to automate a very tedious process (I work in tech sales)--Current process:Have a list of account names on Google Sheets Copy the account name (per row) Paste into the Salesforce search bar Click the account name that matches Get some data from the account Ex. The Account manager name Account manager email Paste this information back into the Google Sheet row to the corresponding columns Repeat for each row (account)--Current zap: --Current error:The ‘Salesforce set up action’ is not working properly. I’m assuming I’m not inputting the correct fields for:Salesforce Object → Account Field to search by → Account Name Search Value → Account Name (from the google sheet)The error I get is either “error 400” or “no search results found” Any help/insight would be greatly appreciated!

5
christina.d
1 year ago
F
FEASTBOTNew
asked in Troubleshooting

Google Business Zap Review and Reply not Working in Live Mode

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.My Zap gets a Google My Business Review and then replies to it as per your documented steps of actions I setup correctly. I then do a test and the review is replied to in Google Reviews for that business location. However, when I published and activated/toggled the Zap to “On”, new reviews arrive and the Zap never executes. I included a screenshot of a successful test. Then I included a screenshot of a filed execution when live. Since that time I executed that failed execution via another Zap test and it worked like the initial test did for another review. We do not believe the Zap is working in live mode and we need help as to why. The Zap is at https://zapier.com/shared/6c6696ed24a874bacf37a21369a455760b0a94a5 First test worked great!So with this one I retested and the test then worked. But in live it did not.

5
Liz_Roberts
1 year ago
R
ryan_toBeginner
asked in Troubleshooting

Salesforce Zap - Unable to find Object

Hello all - i’m currently working on a Airtable to Salesforce zapp.  Most things have been working out but i’m having difficulty finding some of the objects we have in Salesforce in the Zap editor. More specifically, when trying to use action Find Record by Query in Salesforce or  Create Record in Salesforce i’m trying to look for the Salesforce object and it cannot be found. Any guidance would be appreciated!   Thank you

5
christina.d
1 year ago
E
Enter SandmanBeginner
asked in How Do I

How do I setup my Zap so Google Sheets Finds/Updates an event on my Google Calendar?

Good Morning all, I have the most basic Zapier there is so far I need to justify its use and cost to my boss.I have a google sheets spreadsheet with a bunch of trips on it.  I manually import them into Google Calendar.  I know I can Zap them over easy enough but I need to know that it will make ang changes to the calendar that I make on the spreadsheet.   Like if a time was changed on a trip in the spreadsheet will the event in the calendar change too?  will it create a whole new event and leave the original or will it just change the original to the correct time/place/day whatever it was I was changing?

5
Jillian
1 year ago
C
Celiane_JSBeginner
asked in Troubleshooting

Intercom - lead create lead - how to choose the subscription list ?

Hi,I am creating leads in intercom from a typeform form, and I would like these leads to be automatically susbcribing to ONE of my subscription list, but NOT to the other ones. For now, i chose false there, but it subscribe the lead to all lists… Thanks in advance,C 

5
Danvers
1 year ago
D
DavidLEPMANNNew
asked in How Do I

Is there a way to allow Zapier to access a single Excel file instead of full permission into the organization?

I’m trying to use Excel as a Trigger in order to update items in Cascade Strategy. However, I must Connect my Microsoft Excel account to set up the trigger, which requires Admin rights as I'm using my work email (Cascade is a company initiative we are trying to use). This requires my IT team to allow Zapier to have full access to absolutely everything, as identified in the image below. Is there no way to allow Zapier to allow a single excel file? Or does Zapier require access to absolutely everything? If our entire organization wants to use Zapier, it will require use to give Zapier full permission to delete files and update files on all of our accounts? I must be missing something here.   

5
rachael.silvano
1 year ago
F
fernando cordobaNew
asked in Troubleshooting

monday.com error: Zap is likely to be missing a required field, or a field value wasn't in a recognized format: the app may return a 400 error

I am trying to connect Unbounce to a Monday board and Gravity forms to a Monday board. I have all the access in the three of them. Both Unbounce and Gravity forms work on trigger. When I try to test Monday I get error 400, bad requesting:“Your Zap is likely to be missing a required field, or a field value wasn't in a recognized format. For example, if a field in your action step is expecting an email address, but the value given is a name, the app may return a 400 error.”Im trying to create an item everytime a form is submited… It seems to be working with any other board except that one.Whenever I choose the board I only get in display the item name input instead of all the other columns like its supposed to. Definitely its a problem with my board. I have Owner access to the board, I already duplicated it and put it in a personal space and made it sharable and public and it still wont show me the column fields, therefore I get the bad requesting error (I assume).Is there any board conf

5
Reffrigerant Express
1 year ago
A
AnnaNgBeginner
asked in Troubleshooting

Data is not being sent to Basecamp's "Notify to" field

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.Hi,I still get stuck with Data flow 5, no data have been seen in “Notify to” field in Basecamp.Really appreciate any help on this issue.Many thanks! 

5
christina.d
1 year ago
J
JayMNew
asked in How Do I

Adding a filter only to triggers on the checkbox row, but I still can’t get it to work.

Hey guys, I’m fairly new to Zapier, and I am trying to use Zapier to send an outbound email when a Google Sheets checkbox is ticked.I tried the “New or Updated Spreadsheet Row...” trigger and selected the column of the checkbox. I tried adding a filter so the zap only triggers on the checkbox row, but I still can’t get the zap to work.I think primarily, the filter step is not working because I am selecting the wrong filters. Any tips on what to select in the second drop down?  

5
A
1 year ago
R
r0nsenBeginner
asked in How Do I

a limit of tasks for a single zap or in general

I would like the zap to stop when there are more than 100 triggers at once or in a short interval. i have the problem that 5000 contacts are updated often at once. If I forget to turn off the Zap before, Zapier starts immediately and consumes all the task at once. is there a solution?  

5
Danvers
1 year ago
O
Olivier LepageBeginner
asked in Code & Webhooks

Is there a way to put a condition in my Filter when files contain a specific or upper case character?

Hi everyone,I am trying to make a zap work and I've been having some trouble, I need to take information from one place to another, in my zap I have an action to filter out stuff I don’t want, I only want entries to come in when they contain a specific character or an upper case character.I was able to accomplish ¾ of what I wanted with the Filter → Text (Contains) → character I want to keep.But I can’t seem to find a way to also put a condition to also give me when there’s an upper case character (anywhere in the string of text i’m bringing. Thanks

5
Troy Tessalone
1 year ago
B
Ben GraingerBeginner
asked in Troubleshooting

How can I search my Google Sheet using a single line item?

Hey guys,The aim of using Zapier is to import our Shopify orders into a google spreadsheet and have it update any data that get’s updated in Shopify as it happens such as fulfillment status and order notes etc.Zap 1 - Master: This app is working perfectly. It imports orders as they happen. If the order has multiple items it creates multiple rows which is fineZap 2 - Update: This app I’m having issues with. If I fulfill 1 item it will show fulfilled in the ‘Fulfillment Status’ column but not necessarily next to the correct item. If I fulfill a second item it will write in that same cell next to 1 of the items ‘fulfilled,fulfilled. To try fix this I setup a support lookup column so it references either variant title or the sku however when I do this Zapier is looking for the order number as well as all the multiple items on the order in the one cell. Is there a way to make it look up single items instead and update accordingly?Thanks in advance!

5
B
1 year ago
M
MomInRedNew
asked in Troubleshooting

ConvertKit error: Failed to subscribe to tag in ConvertKit, error from halted execution, unexpected status code 400

I’m trying to create a zap as follows: Person comments on my blog and leaves their email address→Their first name, email address, and a tag gets added to Convertkit I keep getting an error when trying to set up this zap. I can’t figure out what’s not working. Really appreciate the help!   

5
jesse
1 year ago
J
jdewasseBeginner
asked in How Do I

How do I add spacing and line breaks into the content of my Cycle doc?

I’m having formatting issues from my zap. In the editor (Zapier), I’m adding spacing and line-breaks to make it clear — but in my response (doc in my app) I can only display the information in a row (e.g. responseAreponseBresponseC). Any ways I can get the html back ?

5
christina.d
1 year ago
X
XsourceITBeginner
asked in How Do I

How do I select a table when connecting JotForm to SQL when no table is available?

Currently using Jotform to capture information for 3rd party database.The configuration between Jotform and SQL via Zapier has been done.  Currently face a challenge when selecting a table the is No choices available.  Could someone please assist if they have had this challenge before and what needs to be done next.  Please  Thank you

5
R
1 year ago
N
NarenNew
asked in Troubleshooting

Send the leads to google spaces in the chat box

Hello,I have google form and if the user summit the form then I will get the  leads on my google sheet and i have send the leads to my google spaces in the chat box.I have connected the google sheet to the zapier and tested. i am getting the leads from my google sheet.Now, I am little bit confused here do i need to connect the zapier to hangout chat  or is there any other apps to connect? I am sharing the screenshot below where i need my leads. I have created the Testing for zapier space in the gmail and i have to send it in the chat.Any idea how to solve this? 

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

Is there a way to cross-reference data and let us know which contacts are on HubSpot but not on RnD?

Hi! I’m trying to build a zap between Scoro and Salesforce. Scoro is a project management tool for a specific team at my company and I’d like to set up an integration FROM Salesforce TO Scoro. So when an opportunity is closed won and matches specific criteria, the zap should create a New Quote in Scoro. We use Products in Salesforce that roll up to the total contract value. I can’t find the Products object in the drop down in the Actions section when creating the Zap. I think it’s likely due to the fact Products are a custom object created in SF. Anyway I can get around this and pull that data into Zapier? I’d like to pull the the Product Name, Quantity, and Unit Price to the corresponding fields in Scoro.  Thanks in advance!

5
jesse
1 year ago
M
molto.contentoNew
asked in How Do I

When attempting to “Upload File in Google Drive” the file being uploaded is a samlsso (SAML POST Binding) file

Hi Zapier Community, I am attempting to create an automation workflow where New Tickets created in JIRA would have their attachments uploaded to Google Drive. (preferably in zip format) At the moment I am able to grab the attachment link - however when attempting to “Upload File in Google Drive” the file being uploaded is a samlsso (SAML POST Binding) file.  Any help would be appreciated!Thanks 

5
Danvers
1 year ago
C
CommOpsBeginner
asked in How Do I

Respond to an automated slack message in the thread

Hello, I want to create a double workflow between Zendesk and Slack, where an open ticket is sent to Zendesk, and once that ticket is solved, a thread is added to the message previously automated.It should look the following:Zendesk ticket changing to status on-hold Slack message sent in a channel Same Zendesk ticket changing to status solved Thread response added to the automated message from number 2It should be able to find the already automated message via the ticket-id.I referred already to this post, and added a step “Find message in slack” but it did not work. I’m aware it is quite complicated, but is there a way to do that? Thanks a lot in advance! 

5
C
1 year ago
W
WilsonBeginner
asked in Troubleshooting

Lookup Google Sheet Row - Zap doesn't stop on failure - Part 2

The linked post details a fix to stop your zap from running following a failed Google Sheet lookup. The purposed solution is to “add a filter checking the value of “Zap Search was Found Status”Can someone please elaborate on how to do that? I can not figure out how to add a filter to check for this value.ModRobotics wrote: 1. switch to setting “Should this step be considered a "success" when nothing is found? “   to true,  2. add a filter checking the value of “Zap Search was Found Status” .

5
W
1 year ago
Terms & Conditions