Find answers to your questions. Ask the Community for help or hire someone to help you.
Unique rules WPforms to Spreadsheet plus bij adding a new row should automatically continue the formulas.
Hello everyone,Thanks in advance for reading and thinking along!Explanation situation:When ordering through my Website via WPForms, I have set up a Zap that it is added to my spreadsheet. The spreadsheet includes formulas to arrive at enough data to create an invoice.The invoice should be sent via mail with two attachments. The invoice itself and a dimensional drawing of the product ordered.I have two problems that I am running into.Problem 1:Orders through my website via WPForms are passed a unique offer number. When a customer refreshes the page after an order then the order comes through twice. I would like to set up my Zap so that it only adds unique lines. Can you set that a particular column should not appear twice?Problem 2:The data coming through from WPforms needs to be expanded to make a good invoice. I do this using different formulas in 8 different columns. I have looked at Arrayformula but this does not work well enough for my situation. The formulas are all right in the s
Hey everyone. Bit of a confusing problem. I own a running store, and want to import only shoe sales from Shopify - Google sheets. I need to make some sort of filter, telling it to only import when it’s footwear, however, I cant seem to find a unique identifier for footwear. In Shopify there is product category, but that’s not an option within Zapiers Shopify integration. Secondly, let’s say I did get a unique identifier and it triggers the zap, Id need to find a way to exclude the other non shoe items in that order. Hoping someone can make a suggestion on a unique identifier I could use for shoe orders, and a way to exclude non shoe items from those orders as well. Maybe this is too specific to be done. Thanks in advance for the help - this community has been extremely helpful.
I’m trying to create a new invoice in Xero when we create an invoice in Keap Max Classic. I’m unable to map the ‘quantity’ fields for line items. There does not seem to be a ‘quantity’ field option in the KEAP dropdowns when mapping.Does anyone already do this who can shed some light on how to overcome this?Thanks,Rhys
Hi, I have a zap to take a gumroad sale and add customer email to mailchimp list. I’m getting the following error:Required field "First Name" (merges__FNAME) is missing. During gumroad checkout, I have a text field for “First Name” that is required however zap still fails. Please help,Matt
Error: Failed to create an upload video in YouTube, due to spam, video uploads are limited for non-paying accounts.
I’m trying to upload youtube videos from google sheets using the following headers and data. Videos are uploaded to drive (and set to public). I have the following column headers and data. But nothing is transfering to youtube and I get The app returned "Media type 'text/html; charset=utf-8' is not supported.". as an error. I can’t work out what is wrong with the input data? What within the attached data is “not supported”?
Hi, I am trying to connect the WPForm app to the EZ Texting app on Zapier. I have the WPForm connected, account verified, form selected. I have the EZ Texting app account connected and verified. The problem happens when I run a test of the connection. I get the following error:Failed to create a message in EZ TextingThe app returned "Bad Request".I really don’t know what could be causing this error. Any ideas?
I have a zap where every time someone fills out a form it creates a new google spreadsheet. Now, I have created multiple forms connected to the main form (when someone clicks next it redirects them to a new form and so on) How do we pull information from zap 1 to zap 2 (I want to get the google sheet id from zap 1 and add it to zap 2)?
I want to send POST webhook with the result parameter from Postgresql like above,but webhook data send INT value to STRING.Is there any workaround for this ? I tried Custom webhook request, but I coudn’t find out to use previous step(result from Postgrsql)’s variable as input data.
I am looking for a Zap that finds duplicate unique values in an airtable table. Employees participate in meetings and an entry is made in an airtable base. Sometimes the program is completed more than once. I am looking to flag those repeat meetings. I do use DeDupe but looking for something that is more automatic. any help or templates would be great.
I am using forms in Rocketlane and looking to have the forms be triggered by a Form Submission and the data from the form to be positioned strategically in a PDF. I would be using the same form for many customers and the desired result is a PDF containing the template and form data each time the form is submitted.
We are using LearnWorlds for our LMS and after each course, students submit feedback. We usually export the data into GSheet to share with stakeholders/leaders so they can retrieve insight into their learners progress, topics, and learning.Right now, I am automating this process by creating a single zap for each course, by customer. This can range from 6 to 13 courses in our customized programs, which would mean 6-13 individual zaps just to collect course feedback automatically.I’d like to know if we can create 1 zap to pull from a list of course feedback submission forms into a single GSheet, rather than 6 to 13 individual zaps, per customer. If we have 3 customers that is almost 40 zaps just for automating feedback.Is there a way to select multiple submission forms into 1 zap? A better way to do it than manually exporting data from LW reporting suite?
Seeing some odd behavior with creation and enabling Zaps. I have created a new Zap (Pipedrive + Slack) that is published and enabled and triggering just fine. I then duplicated that and changed a few fields in the trigger (different Pipedrive pipeline stage as the trigger), and that new Zap is published just fine, but will not enable providing the following error (only at the Zaps page not on the Zap itself): Error turning Zap on: No valid draft found for ZapCreating the second Zap itself from scratch seems to have the same result as duplication also. Even editing and saving another draft with a draft message yields the same result.Any ideas?
Hello!I have a fairly complex zap logic and in general my zap is working well. The flow of the zap logic is such that after a number of successful steps, I place a filter step, and only those events that filter through successfully get executed further. In my scenario, this filter is applied for 95% cases, with only 5% cases passing through.For example, I receive a list from the source system, and my filter checks if it’s an empty list. If not, then there is a loop (Loop by Zapier) to iterate through each list element, and the destination system is updated with the element value. If the list is empty, of course, then the filter kicks in and the Loop step onwards are avoided. Note, there are a few successful steps executed before this, including one update into the destination system.My annoyance is that in my zap history or status, this zap is showing “Filtered” -- whereas I would prefer for it to show “Success”. After all the logic did execute successfully. Here’s why this matters: in
Stripe Errors: Required field "Contact Reference" (cp_contact_reference) is missing. Required field "Payment Reference" (cp_reference) is missing.
Hi, I’m trying to make my first ZAP with Sage > StripeHow do I set-up my Zap correctly? Any ideas why the test comes back with this error message?I used the Customer Name for “Contact Name”. Required field "Contact Name" (cp_contact) is missing. Required field "Contact Reference" (cp_contact_reference) is missing. Required field "Payment Reference" (cp_reference) is missing.
Hi all, I have a Zap which pulls Hubspot deal properties including owner ID. I am using Find Database Item in Notion to convert this ID to the name of the owner.However, if there is no owner in Hubspot, it gives me an error.Is there a way to convert this “no data” field to a specific number, which I can use in my Notion database as “No owner”?I don’t want to use paths for this to check if the owner ID property exist or doesn’t as my zap has more paths after this step and it would be way too complicated to duplicate these paths. Thank you for the help in advance!
Hi there,I created an event with on my company page (I have Content Admin).And my manager used Zapier to connect the linkedin gen forms to Zoom.I created a workflow on HubSpot with the Event ID.But when people click Going on the event page it does not add attendees to Zoom.What might be the reason for this?Thank you,Can PS: i do not have access to my manager’s zapier account.Would this cause any issue?Thank you.
Hi! I have a problem with a PipeDrive trigger, the “Updated Deal Stage” which is supposed to be instant. Usually it has worked fine, but now it seems to have slowed down. In the case shown in the screenshot, the timestamp on the deal for the stage change time differs almost 3 hours for when the Zap ran. Does anyone have an idea of what could be causing this? Any help is appreciated :)
Hi,I’m doing a zap to compress a bunch of files in a Monday.com column to a zip file. I go fetch the files url from monday.com. The data structure as a file url and a name. The bug is that the zip archive api doesnt use the name field for naming the files inside the zip archive. It uses the url field as a name. Is there a step I must add with the zip archive api or maybe loop through each file somehow and add them 1 by one to the zip.Thanks for any help! Results from Monday.com get file and how I set up the File archive api step:
The app I use has one trigger, but inside the app I can setup trigger on multiple different stages. 5 in total. I have multiple zaps for different stages. Am I able to choose which zap gets triggered when trigger gets sent from specific stage inside the app?
We are doing a giveaway in 4 cities in the US through Facebook Ads. We have added a drop down option in Facebook ads for them to choose out of the 4 cities listed that they live closest to. However, when I am in Zapier it’s not showing as a field to choose from. I need to separate these leads so that the 4 cities show in my MailChimp for future marketing efforts. Aka if someone is from Denver, I need them to be tagged through MailChimp as Denver with the drop down. We previously had 4 separate adds running so it was easy to automate.
Hello, Im new here and i need some help. I’m trying to use Zapier to connect my Wordpress forms, created with Divi Theme, to MailerLite. The zap should start when a web visitor fills the form in Wordpress, and I want to receive his information on my MailerLite accout.Is that possible? I’m trying to start a new Zap but when I choose Wordpress, there is not a trigger of filling a form. Can someone help me? Thanks.
Hi,I am using the “Find User in Jira Software Server” step provided by zapier. I have a property attached to every user in Jira (see screenshot) that I need to get in order to make use of it in another step. Unfortunately I do not see those user properties in the response I get from zapier. Can it be added there or would I need to create my own custom step to get it from Jira directly? CheersAmadeus zapier: Jira:
Log in to the Community
Use your Zapier credentialsLog in with Zapier
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.