Skip to main content

Get Help

Find answers to your questions. Ask the Community for help or hire someone to help you.

28277 Topics
mzsadiek
mzsadiekZapier Expert
asked in How Do I
Some help in choosing Survey app

Hello everyone!A client of mine is working with SurveySparrow, in which she has a lot of different question types. One of the most common types of quizzes is a list of statements, and the user has to choose between ‘Strongly Agree’ and ‘Strongly Disagree’. The user has to see those labels, but eventually, it has to output a number based on those choices.What makes it a bit harder is that the scoring can differ from statement to statement (sometimes from 1 to 7 and sometimes from 7 to 1) and differs from quiz to quiz. Mapping this in Zapier took me a lot of time, and every time you change some small thing in the survey, you’ll have to change the Zap.In SurveySparrow, there is no way to assign a numeric value to those answers, only with more specific question types.Do any of you know some survey software that does offer this kind of functionality? I appreciate any help you can provide. If I need to provide any more details, I would be happy to provide those.

1
Troy Tessalone
2 years ago
P
princysainiBeginner
asked in How Do I
How to setup trigger when specific column is updated on Google Sheets

I want to send a message to Slack every time I mark the task as “Done” on google sheets for any person.  

2
Troy Tessalone
2 years ago
M
mmitchellNew
asked in How Do I
Xero transaction - “JSON for post data was invalid, Error converting value” error

I’m trying to set up a zap between Excel and Xero to make it easier to enter them on a monthly basis.  The Excel side works, and finding/creating a contact in Xero works, but when I try test the creation of the bank transaction I get an error saying that the JSON for post data was invalid, Error converting value (Contact value) to type ‘System.Guild”.  Does anyone have any suggestions? 

3
Troy Tessalone
2 years ago
K
Kevin HNew
asked in How Do I
“invalid id” error when moving a Trello card to a new list

My flow involves creating a Trello card when a user signs up to a 3rd party app (teamup). The users first and last name from the sign up process are used to create the Trello card name. After a period of time I want to move this card from one list to another. I have added the step to move the card from one list to another and in the action section I am using the first and last name variables of the user to id the card but it doesn’t seem to be working as when I test the step it returns the error: The app returned "invalid id".I assume it requires me to explicitly select the card from the list but I want it to be variable based on the name of the card and I cant see a way of doing this. Is there any guidance on if this is possible?

4
K
2 years ago
P
ProsperNew
asked in How Do I
New entry in Google Sheets, searching several rows ahead of populated data

Good day, We have had zapier running on an extisting sheet for a few months. Recently the ZAP gives error that the email address field is empty. We also use Zapier to create a customer and invoice in quickbooks - this one too says that the full name field is empty even though there is data.  When creating a new zap, the test data indicates that the zap is looking for data at least 5 rows ahead of where we have data. Can we reset the zap to look in prior rows or do we have to abandon the sheet and create a new one? Prosper 

2
SamB
Community Manager
2 years ago
D
David HenryNew
asked in How Do I
Woocommerce meta data field for Brand taxonomy

We need to import our Brands taxonomy to populate the Vendor field. How do we do this? When setting the Vendor zap I can see the meta field option but that will pull in tonnes of data which makes no sense, so how do we limit this down to just one. See: https://prnt.sc/22spywx The brand Taxonomy meta data is “tax:product_brand”. Any ideas how to do this? D

5
jayeshkumarbhatia
2 years ago
L
LucasLopesNew
asked in How Do I
How to add client info to Shopify?

This post was split from the topic: Add multiple products with Create Order in Shopify actionHi @christina.d. First off, thanks for the help. I was strugling hard to add multiple products with Create Order in Shopify action. Only after this thread I was able to do so, but there’s still one thing I haven’t figured out how to solve. It’s the client’s info.In the “set up action” there isn’t a box specifically to add the client’s info, when the order gets to shopify I only have shipping info.This is the only thing blocking me from having this action running. Do you know how I can solve this?Thanks Christina :)

1
SamB
Community Manager
2 years ago
R
RossellNew
asked in How Do I
Error trying connecting WPForms with Zapier "authentication failed: ('Connection aborted.', gaierror(-2))"

Hello, I´m running a wordpress local site and I´m trying to connect wpforms plugin with zapier, but when i try to establish the first conection I receive this error message,  authentication failed: ('Connection aborted.', gaierror(-2)) Any suggestion?? Thanks in advance

2
R
2 years ago
M
mvkbizNew
asked in How Do I
“Authentication failed: The Username and/or password you supplied is incorrect” error

This post was split from the topic: Trying to connect Wordpress to Zapier, getting an "Error parsing response" errorSame error, preventing us from moving forward with project. 

2
SamB
Community Manager
2 years ago
I
IngiMBeginner
asked in How Do I
Formatter split text not feeding back into Mailchimp

I set up and tested to take split text in mailchimp (the full name is fed from teachable into FNAME field, ) but how does it feed back to mailchimp after the split data is correct to update FNAME?I can’t see this in the tutorialsThanks!

1
mzsadiek
2 years ago
W
WeAreDevelopersNew
asked in How Do I
Is there a COUNTIF function in Zapier?

Hello I am looking for a way to make the following happenStep 1: New Spreadsheet Row gets addedStep 2: Count the number of times the company name shows up in the sheet (I am currently doing this with COUNTIF in Google Sheet but since I want to automate this whole thing this formula would also need to be done automatically)Step 3: Grab the value of how many times the company name showed up in the sheet and check if the company domain that is associated with the company (all in the same row) exists in HubpostStep 4.1: If the company domain exists in Hubspot replace the current value of a selected propertyStep 4.2: If the company domain does not exist in Hubspot do nothing What I struggle with is Step 2.How do I count the number of times the company name showed up in the list without having to manually extend the COUNTIF formula?Appreciate any help!

1
SamB
Community Manager
2 years ago
W
whiterhino123Beginner
asked in How Do I
Move email into specific Outlook folder - using shared folder makes rule forwarding not work

If I were to use Zap, would there be a way to do  make it so all emails go to a certain folder if they have a certain keyword, something I cant do with the rules in outlook due to the permissions Id like every email I get from outlook to go to zap, and then see if I can better sort the emails / look for keywords in them with zap. How complicated is this to set up?  

3
SamB
Community Manager
2 years ago
C
CasaraNew
asked in How Do I
Amazon Seller Central Integrations - What customer fields are available?

There are a number of Amazon Seller Central (ASC) integrations on zapier that I simply don’t understand how they would work without access to customer information, which Amazon doesn’t give: https://zapier.com/apps/amazon-seller-central/integrationsIgnitepost  - send handwritten notes after a (ASC) order Salesforce - create salesforce leads from a new (ASC) orderFiveoak - send review request after a new (ASC) orderFacebook - add emails to Facebook Custom Audiences with new ordersDo all of these just not work?  Or do they have an integration where we still don’t have access to customer data?  I’d be happy with simply getting a list of the available data points from ASC so I can better understand. I’ve asked my client to test a couple integrations, and they simply tell me theres no way these will work.. I’d love to be able to show them what is possible. 

2
SamB
Community Manager
2 years ago
L
LemollonBeginner
asked in How Do I
How to post Discord photo to Instagram for Business?

I’m tying to trigger from a discord channel to post a picture to my instagram business page and it’s not working. what am I missing? is there a how to vidoe all the attention is around IG → discord but there is nothing out there that explains Discord - > IG business in detail 

1
robschmidt
2 years ago
D
DarrenNew
asked in How Do I
Pass info from Twilio "Gather Input on Call" widget to mySQL

I want to use info gathered using Twilio in a custom mySql query, but I can’t seem to find info entered during Twilio phone call. The only info that is showing up in Zapier is info about the call ie caller id, location of call, zip code etc., not the info the customer entered using their phones keypad.  

1
robschmidt
2 years ago
S
StressLessBeginner
asked in How Do I
Setting a specific time to email after an event has occurred

I set up a zap so when an event “ends” in my calendar and email is sent when it ends BUT I would like to be able to send out that email say one hour or 4 hours after the event ends…. I don’t see a way to do this. Any suggestions? Thanks in advance.

2
S
2 years ago
Schizzo
SchizzoBeginner
asked in How Do I
How to create a Google Docs invoice from a Google Docs Template, with Line Items or Looping?

Hi, Google Docs allows {{viarable}} to fill a template.So how can I create an invoice from a form service (like Cognitoforms)? Knowing that an invoice randomly requires one or more lines…How to use Line Items or Looping by Zapier to fill a {{viarable}} field with several values?   Thanks for your help! 

10
Schizzo
2 years ago
A
ArmenBeginner
asked in How Do I
Convert 9 digit numerical value to Md5 HASH

Hello fellow Zapiers.Need help in converting a 9 digit numeric value to MD5 HAsh to use in the follow-up steps. I have tried almost all formatting options but could not find any options for it. Any help will be much appreciated.

3
A
2 years ago
R
raynimatorNew
asked in How Do I
How to format value (100,000) as 2 different versions (100,00 and 100000)

With Webhook and Leadconector i am getting the price  as 100,000 I want to make 2 instances of the number,1-   100,0002-    100000 if i use formatter to replace text, it will make only 100000 I have set up 1- Catch webhook2- formatter3- Leadconnector (update opportunity)How do i make a duplicate field before using formatter to replace , and delete it The  reason i am doing this, i need to have 2 fields, one for customer to see nice formated text (in the emails etc)and also for system to format URL with  lets say .com?price=100000.   

1
Troy Tessalone
2 years ago
T
trin.vhBeginner
asked in How Do I
Update Trello Card from Google Sheet: index board instead of list?

I am having a whole lot of trouble with this Zap.What I am trying to do is to “when row in google sheets is updated > find trello card > Update Trello Card”.I thought this would be simple, but clearly, it is not.  I would like it to, every time I update a row in google sheets, find the appropriate Trello card in a workspace (or create one) and update it accordingly.  I would even be happy if it just indexed one board.The problem I’m running into is that it’s requiring a list name to index.  I need it to index the whole board, not just one list.Property Name Contact Name Contact Phone Contact Email Job Type Trello List State # Units bldg Type Quarter City Date Added Due Date Job Month Unweighted $ Probability Weighted $ Description Management Maint Name Maint Phone Maint Email AP Name AP Email AP Phone AP Software Alexan at 20th St Jerri Doe 123.456.7890 asdf@abc.com Int Dryer Vents 🎯 Re-Market CO 354 Highrise Apt

3
Troy Tessalone
2 years ago
D
Dennis - LPNew
asked in How Do I
Connect 123formbuilder to monday.com

Hi thereI would like to connect 123formbuilder to Monday.com. so the data of our clients will be available in monday.com. But when I do that i get an api error: invalid value, please check our API documentation for the correct data structure for this column. https://api.developer.monday.com/docs/change-column-values  Does anybody know how to solve this, below you can see my input and the error:  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. 

4
GetUWired
2 years ago
J
JayX8Beginner
asked in How Do I
Gravity Forms to Monday.com - Location Field

Hi Everyone! I’m loading leads from a Gravity Form into Monday.com and I’ve gotten all of the fields populating great with a single exception.We have a location field dropdown on our Gravity form to select a major city where one of our teams is located. (approx 10 options) For whatever reason, the field will not populate the location field on Monday.com on our board.The tests run successfully and everything else gets loaded in just fine.Any suggestions?

4
GetUWired
2 years ago
M
MMARNew
asked in How Do I
Import from CSV, export spreadsheet, email as attachment

I want to import data from a CSV and:Create a spreadsheet with data imported from the CSV Attach the spreadsheet to an email Email the attachment to a distribution email addressI have the utilities step set up to import from the CSV file but I’m not sure what triggers to set up next. Help?

2
M
2 years ago
H
HaybemorevintageNew
asked in How Do I
Sending Email Reminders for Gmail-Events I'm Invited To? (not ones I've sent)

Hey there, I currently have Zaps set up to send an email reminder to all participants in Google Events I create and manage. I would LOVE to have it set up to where events that I’m invited to also send out those reminders (i.e. A sales call that someone sends me a calendar invite to on their end). All of these events I’m invited to show up in my Google Calendar and have emails associated from the sender.Is this possible? 

1
Troy Tessalone
2 years ago
F
fluittsolutionsNew
asked in How Do I
What does the error "(lookup_value) missing error code" mean?

Hello,I’m a new Zap user and I’m having so much trouble.My zap is:Trigger: New event in Stripe Action: Find or create rows (Google Sheets) Action: Update Spreadsheet Row in Google Sheets.I continue to have successful tests on my Zap but, keep receiving emails from Zapier with this:Error Message: Google Sheets: Required field "Lookup Value" (lookup_value) is missing.  Here is what is in my Find or Create Row Action.Can someone explain to me why I keep getting Lookup Value missing messages? Thank you for your help.

1
Troy Tessalone
2 years ago
Terms & Conditions