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.

25242 Topics

Randor
RandorBeginner
asked in Code & Webhooks

Python if statement not working

Hello, I am trying to write a simple python code in Zapier but for some reason the if statements fail even though they are exactly the same.Here is my code:output = {}if operator.eq(input_data['step1'], '500-Mb-USD') or input_data['step1'] == '500-Mb-USD-Monthly' or input_data['step2'] == 'NIA_TURBO_500': output['speed'] = 'NIA_TURBO-500'elif input_data['step1'] == '1-Gig-USD' or input_data['step1'] == '1-Gig-USD-Monthly' or input_data['step2'] == 'NIA_INSANE_1000': output['speed'] = 'NIA_INSANE_1000'elif input_data['step1'] == '2-Gig-USD' or input_data['step1'] == '2-Gig-USD-Monthly' or input_data['step2'] == 'NIA_SUPREME_2000': output['speed'] = 'NIA_SUPREME_2000'return outputI have 2 input variables sent in, i KNOW that step1 is equaling ‘2-Gig-USD-Monthly’ and when i print step 1, it shows exactly what it should, but these statements fail, can someone point me in the right direction? I know Zapier uses a scraped down version of python, but I would think that basic if elif

1
Randor
9 months ago
ivy_t
ivy_tBeginner
asked in Troubleshooting

Unable to create a Trello card for new orders with the same item Googe Sheets.

Hi everyone,I am currently using zapier to create a trello card if a new row(s) is added/updated on a shared google spreadsheet.  It will work as our order intake platform.Our spreadsheet will be automatically cleared when new orders come in. However, I just realised that if the new order has the same item as the previous one, Zapier does not generate any Trello cards for that specific order. Can I have advice on this issue please?Many thanks, 

1
Troy Tessalone
9 months ago
arin
arinNew
asked in How Do I

How do I use the SQL update row step?

I have a zap that triggers on a new or updated SQL row.  The first step sends the data to woo.  The second step should take the output of the first step and update the original row.  I have an Upddate SQL server row.  There are two fields at the bottom, Row and ID Column.  How do I use those two fields?  I assume output from the first step will allow the update to identify the correct row to update, but I can find no documentation on the fields in this step.

1
Troy Tessalone
9 months ago
Camw
CamwNew
asked in Troubleshooting

Zap is not creating contacts in Quotient despite successful runs in Zap history.

I have set up a Zap with the action when form submitted on squarespace website create new contact in quotient.It’s not working, according to history in zapier it is working successfully. But contact is not being created in quotient, when looking at zapier settings in quotient zap log says no recent zaps triggered yet.Thanks

6
Troy Tessalone
9 months ago
R
Rob_AubreyBeginner
asked in How Do I

Zoom Meeting Registration

Hi,  I am trying to connect a Gravity Form to a Zoom Meeting Registration.  It appears that only a Zoom Webinar Registration can be connected.   Does anyone know anything about this and is there a work around?   Thanks

59
zap3
9 months ago
T
TenerifekiwiBeginner
asked in How Do I

How do I use my own email domain with Zapier to prevent emails from going to spam?

I have a couple of zaps that send emails. A couple of the recipients have seen these emails go to spam / junk etc. Question: Can I get zapier to use my own email domain?  Properly authenticated of course.  I know that my domain is very rarely blocked. 

3
T
9 months ago
Zamichel
ZamichelBeginner
asked in Code & Webhooks

Python compare previous row from StoreClient

Hello all - I’m quite new to using Zapier’s store and StoreClient but understand python at a mediate level. My use case is to alert of any new messages from external users (customers) within a five minute window per channel. I am trying to create a zap that is dynamic as we have an infinite combination of external channels at any one time. So far my zap is as follows:Gather all new messages Filter out any internal user messages Using Zap Store, set values for Channel Id and Ts Time Get Storage Secret Use Python to compare timestamps of current and most recent messages within a channel and return true if within five minutes of each other.This is where I’d like to be able to compare the row prior for each channel. I would normally use pandas but I’m unsure if that’s overkill, but most importantly I’m not sure if/how StoreClient.get_many handles the values. It’s really unclear even when I return the data as output. Any tips in the right direction greatly appreciated!EDIT: I found using ht

1
Zamichel
9 months ago
meganvrw
meganvrwBeginner
asked in Troubleshooting

Zapier formatter issue: Can't pull in own data to test private note comment split

Hi there!I’m making a Zap that adds a row to gsheets when a private note is added to a Freshdesk ticket. It works great when I put it live but the problem is that I can’t pull in my own data to test with, the only option is the Zapier dummy data. I want to use the Zapier formatter to split the comment field but I can’t test this with the dummy data. I’ve tried making it a public note but that doesn’t change anything. Can anyone help? :)   

9
shalgrim
9 months ago
A
Anonymous
asked in How Do I

How do I create a Zap that creates an Asana task from a JotForm submission with a custom task name and due date?

I need my Zap to doA JotForm gets filled out. A task gets assigned to Asana, front desk tasks the task name should be "(CLIENT NAME) (NAME OF THE JOTFORM FILLED)" - the due date is the day it was filled out. I am completely lost, please help!

3
Troy Tessalone
9 months ago
toneweaver
toneweaverBeginner
asked in How Do I

Is it possible to have Zapier save a Google Doc as a PDF?

Hello, folks!I’m a newbie and just finished testing one of my first successful Zaps, to save Google Forms information to a Google Doc for a therapist who’s supervising pre-professional therapists. The Google Form is set up as a quiz, so that the supervisor therapist can “grade” the quiz and add feedback to the supervisee’s entries. My first question is this: Is it possible to (or how can ) take that Google Doc and convert it to PDF? I’d like to either save that PDF to a folder the supervisee can access or email it to them. I know that the Google Doc can be set so that the supervisee can view but not edit it, but the supervisor therapist wants an extra layer of security around her notes. Second question: The Zap transfers the supervisee’s responses, but not the feedback from the supervisor. Is there a way to include that feedback? Thanks in advance for any help or advice! Brent Weaver  

3
toneweaver
9 months ago
Mathis Timo.
Mathis Timo.New
asked in Troubleshooting

Why does Zapier create fake data when given empty field

Hello,One of the action in my zap is a Create/Update user in a third party app. In this action if an ID is provided the app will update the user according to the ID. If no ID is given it will create a new user.My issue is that when the ID field is empty (it should create a new user) but Zapier is sending a string that looks like this : {{202001719__Id}}Even tho I give it no data  : So when the third party app receive this it tries to update the user “{{202001719__Id}}” witch of course does not exist so it sends back an error.I even tried to create a code action that set the ID to null if no ID is given, it does output me an empty field that looks like this :And again when given and testing this output send this {{1722784624__output}} to the app… How can I leave the Id field empty if there is no id ?Thanks in advance. 

1
Troy Tessalone
9 months ago
A
arianeBeginner
asked in Troubleshooting

Zaps continuously firing when not supposed to

Hi I have an issue with this zap, it is in an infinite loop. I received one email that match the trigger, and the zaps runned indefinitely, sending hundreds of emails. What can I do to make the trigger happen just once?Thank you

1
Troy Tessalone
9 months ago
dan110
dan110Beginner
asked in Troubleshooting

Failed to create a record in Adalo: The app returned "Forbidden"

When I test adalo x zapier connection, it says connection successful, when i try to set up a zap to trigger an update in my adalo records for “calendar events” after a new calendar event is created on google calendar, when i hit test, it gives me the error: “Forbidden”. the adalo x zapier connection says it works, and I am using the right owner/admin account, it just wont work properly without throwing an error.

9
rachael.silvano
9 months ago
SteveVK
SteveVKBeginner
asked in How Do I

Multi-step Zap - Combine Google Sheets row/lookup data/email results weekly

Hi All, Relatively new to Zapier and trying to solve a problem thats fairly convoluted. Hoping with all the new features this is possible in Zapier, rather than getting something custom built. BackgroundWe have several Shopify stores that create custom portraits. As there are unique requests for each order, we have an app (lets call it App #1) that manages that. This app is not integrated with Zapier. The devs of that app have set up an export for us into Google Sheets (triggered when the order is paid), where some of the order metadata is sent. We also use another app (lets call it App #2) that manages the portrait approvals by the customer (this app IS integrated with Zapier with a current active zap).BUT we only pay the artists when the portrait is approved by the customer, and that notification is what is exported by App #2, because it can be some time after the order was placed/paid for. Both apps export to Tab #1 and both reference the same order ID, so we end up with 2 lines for

5
rachael.silvano
9 months ago
Andyshn
AndyshnBeginner
asked in Troubleshooting

Only continue if is getting stuck on test step

Tried to build several times, different zaps, different browsers.  

3
rachael.silvano
9 months ago
Harvoir
HarvoirNew
asked in How Do I

New Trello Card from email with Particular subject

Hopefully and easy one. I would like to forward emails and use a particular subject so that it creates a card. I.E for Enquiries. I’ve set up a zap for all outlook email to create a card but can’t seem to refine the subject? I hope that makes sense?

14
ken.a
9 months ago
Ouwia
OuwiaNew
asked in Troubleshooting

Survay monkey field not entering data

Hello, I created a survey on Survey Monkey and trying to link it to my Dovetail. But when I tried the test, I entered all the information but it’s not showing on the reponses collected on Zapier, so the “People” created on Dovetail is also blank. Is there a reason why for this problem? Thank you for you reply. 

1
ken.a
9 months ago
crz-123
crz-123New
asked in How Do I

How do I attach files to an email from private Amazon S3 bucket?

Hi! I need to get some file from my private S3 bucket and attach it to a email and send it.I see there is an option to upload files to S3 but there is no predefined way to download it (it’s an image smaller than 4MB). I have tried using the AWS SDK but it has been impossible to get the file content. (The bucket is private so it cannot be downloaded from an URL as you may think)Am I doing something wrong? is this possible to achieve? what do you recommend?

6
Ashar Malik
9 months ago
W
Wellow123Beginner
asked in Troubleshooting

Zap does not receive a response from Google Sheets

Hello Everyone, I have a Zap triggered when a row is added in a google sheet table. In step 4 of my Zap I do a look up in a google sheet table, but I get this error “This usually happens when the Zap does not receive a response from Google Sheets within 30 seconds confirming we could access the spreadsheet data successfully.” The connexion is right, this table only has 700 rows, the sheet and table IDs are right, and there is the value in the google sheet. I tried replaying them but it’s not working.. When I replay a zap, will it replay with new data it the google sheet has been updated? Or only the one the triggered the zap? Thanks for your helps!  

2
W
9 months ago
RJE
RJEBeginner
asked in How Do I

How do I create Google Drive folder and insert link into Asana task when moving to a specific section?

Hi,Hope someone can help! When I move an Asana task to a specific section, I want to automatically create a Google Drive folder and place a link into a field inside the Asana task. I am goofing somewhere and would appreciate help getting around this bottleneck. Thank you.

7
ken.a
9 months ago
FGT
FGTNew
asked in Troubleshooting

Zapier won't recognize PhoneBurner app login credentials

I’m trying to connect PhoneBurner (a power dialing app) to MaximizerCRM.  Both of these apps are part of the Zapier ecosystem.Zapier won’t acknowledge my PhoneBurner login credentials and fails to connect.  I’ve tested them 10 plus times by logging into PhoneBurner directly and they work every single time.  Why won’t Zapier acknowledge?   

5
ken.a
9 months ago
Seaney Shell
Seaney ShellBeginner
asked in How Do I

How to find the root message in a thread in Slack using an @mention in the comments?

Is there a way to find the root message in a thread in slack?functionally I would like to be able to use an @mention in the comments of a thread to grab the top level post of that thread.I have the thread T which is the same as the top level post’s T value so i think I should be able to find the top level post somehow, but I am unsure how to do this.thank you in advance 

3
ken.a
9 months ago
BettyTester
BettyTesterBeginner
asked in Troubleshooting

Zap not updating Excel, history showing zap working correctly

New to Zapier so please bare with me. I have set a up a Zap from our CRM, when a stage in the process is updated, a new row with data from the CRM is added to Excel.This worked in the test however is now not working when the stages are reached within the CRM.Excel is only showing two lines of data, which are from when the tests were run. From the below example, the action should have been completed seven times therefore seven new lines added to excel. I have check the connection to the CRM and excel is correct.  Note due to company policy, I cannot state the CRM system we use.     

9
Troy Tessalone
9 months ago
Testzing
TestzingBeginner
asked in Code & Webhooks

Zap Not Collecting File Upload in Webhook

This issue appears recently as of July 11. The main question and issue is have is around why a Webhook through a Zap would stop reading / accepting a file upload.Configuration:WordPress site using the Forminator Forms plugin Zapier grabs the new form entry via webhook CATCH The Zap transfers all webhook data to SQL ServerIssue with screenshot below:Webhook not recognizing image upload file field path Webhook recognizes the file upload but provides no file path to connect to a DB field This issue also started on existing forms not just new ones.Testing scenarios:Cleared browser and website cache Attempted across Firefox and Edge browsers Recreated Webhook link to Forminator Form Recreated file upload field, recreated form, working with new formScreenshot of UI for not recognizing File Upload (upload-1): Anyone else have a similar configuration or issue?

8
jeremyclicks
9 months ago
craibuc
craibucBeginner
asked in Code & Webhooks

How do I define an "instant" trigger in a Zapier integration

I’ve built an integration that interacts with a vendor’s API.  One of its POST endpoints includes the ability to register a callback URL, which I supply the URL that’s generated by a Zap’s “Webhook by Zapier” step.  Currently, this  architecture works fine.I noticed that the Formstack app has a “New Submission” trigger that is marked as “instant”.  How this defined in the app’s code?  Is there a way to generate a callback URL (https://hooks.zapier.com/hooks/catch/X/Y/) in the integration that is available to be registered with the vendor’s API?

0
craibuc
9 months ago
Terms & Conditions