Find answers to your questions. Ask the Community for help or hire someone to help you.
How to prevent Zap from triggering when Google Sheets when rows are sorted?
I’m an “amateur” Zap user so I hope this doesn’t sound like a simple/stupid question :-) I have a Google Sheet with many columns of data, including some that have dates.I’m trying to create a Zap that sends Emails when I change the Date in one particular column. That’s the easy part. What I can’t figure out is how to make it so that if/when I re-sort/re-order the lines on the spreadsheet, the system doesn’t think I’ve changed the Date in EVERY row.EXAMPLE: Sheet is sorted in Alphabetical order, so the Line I change is Row 10. I understand how to make this action occur.But if/when I re-sort the Sheet by the order of a different column, ALL the rows are reordered and the system then thinks I’ve changed the Date in ALL of the rows and the action is triggered for every row. I just need the action linked/tied to that one row regardless of re-sorting and so the system won’t respond every time I re-sort the Sheet. Does that make sense?Any help you can provide is appreciated.
How to sync Jira statuses to Salesforce and vice versa
I’m syncing the Salesforce Opportunity into a Jira Epic, mostly the workflow statuses for both are the same. In case there is a demand to change the statuses in workflows to be equal I can make that change, (but I would rather keep the modified Jira workflow as I have automations based on it).Priority 1: How do I create a Zap to sync the change in Jira Epic to reflect the status change in Salesforce.Priority 2: Make bi-directional status changes=>in addition to Priority 1 change the Salesforce status change in Jira Epic.Hope this is possible with Zapier.
Stop to split value in WooCommerce product attribute?
Hi,I connect bubble with Woocommerce by zapierI have Product Attribute “Photographer” and full name as value “Jonny Prezz”But when I create Zap I get a product with 1 attribute “Photographer” and 2 values “Jonny”, and “Prezz”I even try to add “line-item to text” before WooCommerce action. But the same mistake…Do you have any idea?Thanks in advance
How to create a record in CRM and then open that record in CRM in new tab via URL
Hi we are now using a system for our leads that has the ability for webhooks.I can trigger a webhook and I am able to create a lead in our other CRM using zapier app integration.What I want to be ale to do is once created I want to open the crm page as a new tab in broswer on the newly created lead so we can fill in more data and process that lead into member in new system. is there an app or something I can use to do this in in zapier? or is there a way to call a webhook to do this?I just want to call a url in a new window with the response returned from CRM app.Calling a url should be easy so I am sorry if I am missing something very straight forward.Thanks
Is there any way to continue a zap where a step fails, and pull the information it found?
This is very specific, but there is no employee ID look-up for Quickbooks Online.I have found that when creating a “New Time Activity” the Zap step CAN see the employee ID that is hidden in the QBO UI when you select an employee name from a dropdown.My goal is to use the “custom” tab and enter a variable that contains the Full Name, read the Employee ID reference, then pull that Employee ID reference into the “real” New Time Activity and populate the Employee Name field with that value. The Zapier “Employee Name” field takes a name, however the QBO portion will fail unless it is the Employee # found below said name. Is there any way to run a step “halfway” then continue and use that data in another step?Thank you,
Remove links and phrases, using Text Formatter?
Is there a way to remove links, or anything after a trigger phrase like “https”, from a text string using Text Formatter?For example, I am trying to create a Twitter > Discord automation. Tweets with “.,” at the end will be posted by Zapier, however I’d like to remove the “.,” and the the “t.co” link at the end before it reaches Discord.
How to filter out weekends events on Google Calendar?
Hi follow Zapers, I have created a Zap that, everytime I create an activity in my private calendar, it will send an invite to my work calendar. I placed a filter in between, so that it will only process activities between 9am and 5pm. So far so good, but I need some assistance with the following: I’d love to be able to filter on days of the week, in order to filter out weekends and my part time day off. Unfortunately, google calendar does not include the specific day in their API export, that would have been easy.Any thoughts on how to do a work around? Thanks!
How to get Zoom link into Simply Book Me calendar invitation?
I use Simply Book Me for client appointments, and love everything about it - EXCEPT the fact that it doesn’t include my Zoom meeting room link in the calendar invite. I’ve heard it’s possible to do this though Zappier, but so far can only get Zappier to make a zoom event based on a client booking in Simply Book Me. Anyone have any idea on how to get the calendar invites to clients to INCLUDE the Zoom link??
Formatter: Split Text not including blank values
I am trying to use Formatter to split a string of 6 test responses and have encountered the problem that if a test is not complete, the value is empty. So a typical response might be: clear, clear, , ,clear, clearI need the response to be:0: clear1: clear2: 3:4: clear5: clearBut instead I just get 1-4 = clearAny ideas on how to solve for this within formatter, or is there a code alternative (am not really a coder!)
How to use http HEAD request in Zapier? (webhooks or other)
How does one simple mortal fire HTTP “HEAD” requests (as opposed to GET, POST, PUT etc.) and use the header response for next steps in Zapier?I’m on a Premium plan, so there’s Webhooks; but those will only give me either pre-defined GET/POST/PUT, or, in custom command, GET/POST/PUT/PATCH/DELETE - neither of which is HEAD.For the life of me, I couldn’t find the answer here in the community, so I’m most probably missing something vital about Zapier or something?Either way, i’d like to HEAD a url and work with the response, thus putting less GET load on the receiving server. Any ideas how to do this? Any help appreciated!
New Google Ads Lead Form Entry - missing data
The data sent from Google AdsData received on Zapier Hi!As recommended in an email from Zapier, I’m trying to change from Google Lead Form Extension to the new Google Ads Lead Form Entry option, but the new integration does not receive data from important fields that I have in my Lead Form, like “COSTUMER_TYPE” and “EXISTING_COSTUMER”. I’m trying to send new test data from Google Ads but it doesn’t work, it only shows up in Zap history but not in the “Test Trigger” part. Has anyone been through the same problem? How can I solve it? Thank you
Line item search and replace null value with 0
HiI try to set up a Zap between Shopify and accounting.I have one line item “Discount application index: null, , null” and one line item “Discount application: 10”I want to create a new line item using the first line item where null is replaced with 0 and  with the value from the second line item. How can I do that?
How to create journal entries from Jotform submissions?
I would like to use a Jotform to create a beekeeping journal on my website, I use google sites. I would also be ok using a blogger or whatever I need to, to automate this process. I created one, but it’s a lot of work to update manually! I have bee hives spread out through the city at different host homes, and my host families love to see what their bees and other hives are doing. If I could enter the info in a form every time I visit the bees, and have it automatically load with formatting into a website, blog, etc, that would be simply amazing! I am willing to pay for a new service if need be.
Assign a label to newly contact created via Zap in Google contacts
Hi All, I am creating a Zap which gets triggered when a new contact is created in my CRM (Podio) and the Zap creates a new contact in Google Contacts with the mapped fields. I also wanted to assign a label to the contact that is created by the Zap. Is there a way I could do this? Any help would be much appreciated. Thanks in advance.
Adding People to a Recurring Calendar Event
Need some additional brainpower on this one. I have a recurring calendar event that has 300+ people on it. Id like to be able to add new people to it so that they are added to all recurring instances of it. With Google Calendar - when you add one person, it removes all the other people. If you add ALL the people every time a new person is added then every time anyone is added, all 300+ will get a new calendar invite. Anyone have any suggestions?
Weird "OBJ" in GCal list of guests
Any idea what may be causing these three OBJ icons to appear?Results from a GCal Action step with static email addresses (not references to previous steps)There’s nothing fancy going on in the Google Calendar Action step - just a group of emails added as guests in a “Create Detailed Event” action. Of note, the e-mail addresses are entered via static text, not dynamic references to previous steps.Possibly something to do with the “OBJ” e-mail account (it’s a gmail business account). It doesn’t show up like that in other GCal events.Of note, the picture isn’t showing up but the other two e-mails are from the same business domain and their pictures do show up.I’ve double and triple checked that there are no leading or trailing “ “ whitespaces...Thanks!
When replacing a google sheet with a csv, some of my data changes to dates (and it's a problem).
I have a csv file which is saved to my hard drive on a regular basis. The folder where it is saved is linked to my google drive. When a new file is added to this folder, ZAP triggers for the file. My next zap takes that file and replaces an existing GoogleSheet.My problem is that when it replaces the google sheet, some data is irreversibly changed into dates. For example 3-0011 is changed to display 3-2011 and is recorded in the field as 3/1/2011.I have tried both true/false for the option to turn it into a google document and neither changes the outcome.The file has 30K+ lines so making formatting changes per line would probably be cost prohibitive.Any ideas on how this can be achieved utilizing only zap, google sheets, and google drive would be appreciated.
Hosting Zaps on Clients' Behalf
Hey there! I’m wondering if anybody hosts Zaps for their clients for a small monthly fee. I work with very small businesses on limited budgets and many of my clients could really use one or two multi-step Zaps to make their automated systems work really well. But I feel bad saying, “You’re going to need a $20/month account to make this one thing happen.” I’m thinking I’d offer Zap hosting through my own Professional account for...maybe $5/Zap/month. Has anybody tried this? Are there any unexpected issues you’ve encountered?
Test trigger stripe "we couldn't find new order"
I am trying to set up a zap between Stripe and Thinkific. I’ve added Stripe and the API key is live and works. But when I click test trigger, I don’t get any data. I’ve done a new order to test, but it is still not showing. When I go back to the previous step Set up trigger, Zapier retrieves data from my Stripe account. I can see the email addresses from my clients. So it should work. Any ideas why it’s not working?Thanks!
How to send letter via Gmail with details from amoCRM
Please help with the solution of such a problemWhen you create a new contact in Amocrm (previously registered) and indicate in it the NAME and WORKING E-MAIL, a letter with the following content should be sent to the created mail in Gmail:Sender: Box registered in the first stepSubject: New contact + (transfer to the subject of the contact's email from AMOcrm), for example: New contact firstname.lastname@example.orgText of the letter: A new contact has been created. His name: + (transfer the name from AMOcrm), his email: + (transfer the email from AMOcrm) I made a trigger like this and the action like this but it doesn't work, what am I doing wrong?Or should this system work with Google Sheets?
Already have an account? Login
Use your Zapier credentialsLog in with Zapier
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.