Show & Tell
Show off your Zaps, workarounds, and tricks. Tell others what you’re building with Zapier.
- 253 Topics
- 596 Replies
I sometimes have situations where an external system sends the same event multiple times to a webhook simultaneously, but I only want one of them to make it through. In other words, I need to throttle all of the events variably so they arrive at different times, then use a logic gate to allow only the first one to make it through. (You can’t use the built-in “delay” option, because this will simply delay all of them an equal amount -- they’ll still arrive simultaneously, just… later.)After continued iteration, this my current solution:Use the JS variable delay trick first suggested by @AndrewJDavison_Luhhu in this post to force every task run to experience a delay between 0 and 10 seconds (exclusive). Use Zapier’s Storage as a simple state manager to quickly shut the gate after the first winning task run. I use Python, but you can also use JS. You want to pick a reference for the incoming event that can be used to identify duplicates (e.g., an external ID of some kind), and some sort o
Have you ever wanted to just hit a button in Airtable to trigger your workflow -- instantly? Learn how in 4 minutes.Most people set up Zaps that have a built-in Airtable trigger. The problem is — these are NOT “instant”. They can take up to 15 minutes to fire depending on your Zapier plan. That’s insane.This video shows you how to do it INSTANTLY, with webhooks. Resources:• Airtable base (read-only): https://airtable.com/shr96FLWu0bQxPrhV• Airtable script w/ instructions: https://gist.github.com/arthurwuhoo/f...• Zapier workflow (read-only): https://zapier.com/shared/32be81f107c...
So read a few people have this problem.I wanted a monday board that everytime it updated to only show the list of ones with the field “ready”. and when that changed to “closed”. delete it.That sheet is then viewed by people. But looks a mess with all the gaps from deletions I wanted to share a work around.I made another sheet using the importrange feature in sheets to pull all the data into this new sheet.Set up a filter on all columns and rows. remove blanks from one of the filters.There you now have a clean list. hope this helps someone in the future
WooCommerce is a very flexible e-commerce tool, and for some of us, that means using a variety of plugins with product options and extra fields that don’t necessarily make it through the usual Zapier interface.Here’s a solution which has worked for me reliably with several sites for several years. I hope some of you will find it helpful:Instead of using the Zapier feed, have WooCommerce send a New Order email to Zapier, and parse the subject line to extract the order number.Use that order number in a Code step along with the WooCommerce API to retrieve the entire order object. It will come in as a JSON string which you can parse and dereference to get everything your plugins provide.Yes, it will take a little exploration of the order object to get all the data, as different plugins structure the data in different ways, but the WHOLE ORDER is there. Nothing is missing, nothing is obscured.Have fun!
As many people adjust to remote working in their businesses we decided to look at different ways Zapier can be used to smooth the process Check them out in our new blog post. If you’re using Slack, you’re going to find this particuarly useful. Things covered include: Keep inbox chaos to a minimum by routing emails through Slack. Keep you Slack status in sync with your calendar. Make sure no one forgets team meetings by sending out Slack reminders. Seamless booking of meetings by combining Zoom and Calendly And, if you’ve got other ideas… we’d love to hear them!
If you are using Airtable and integrating it with Zapier, then you always had the Line Items support problem! In this quick guide I will show you some cool tips and tricks on how to use the Line Items with Looping by Zapier. Previous Issue: A lead comes over from another app (or even from Airtable) and you want to send a text message to 5 of your Sales team so they can process this lead. There was no way to do that in the past (specially before the Looping by Zapier). Current Solution: Setup your Trigger to get the new lead from Airtable (or any other app you are using) Create step “Find Many Records (With Line Item Support) in Airtable” (Finally!!!) to find all Sales people in your Airtable. You will then get all the records that matches your search criteria (you can even use a formula to add more than 1 criteria) Create step “Create Loop From Line Items in Looping by Zapier” . In the “Values to Loop” part, add whatever values you will need from Step 2, such as Name, Phone Number,
Hey, Justin here from the Zapier blog. I thought I’d let you know that you can use Zapier to bring back Twitter’s SMS notifications, if you want to. I’d also like to ask for some help. I try to keep track of features that companies drop to see if there’s some way to use Zapier to bring them back, and this was a great little use case. Can you guys think of any more disappearing features? Maybe we can come up with more ideas like this together.
How to Get the PDF Version of a GDrive File (GDocs / GSheets / GSlides) Did you know GDrive automatically makes a PDF version of the file available? Simply search for “application/pdf” in the returned response data of the Zap step! Example: GDocs Example: GSlides
Hello everybody !I recently wanted to get informations about my reviews in Truspilot.Unfortunately, to get access to the API, you have to pay 120€/month, and it’s really expansive for a beginning company.I recently noticed that, every time I get a new review, Trustpilot sends en email with al the informations.So I decided to create a zap which extracts all important informations in the email such as :Client Fullname Client Firstname (in case your client left a review with "John Doe" pattern) Client Lastname (in case your client left a review with "John Doe" pattern) Rate (as a number) Review (I know that Trustpilot truncate the review, but the review can be really long before being truncated) Review link (the direct link to this review)With this informations, you can do so many things in Zapier. For example :Send a Slack notifcation Populate a custom API via Zapier Webhooks add a new row in Airtable (or Gsheet) Create a new review in Webflow CMS (exactly what i’m using to add instant
If you’ve ever seen this option in a Filter step:… and you’ve wondered what the heck it is, I’m about to tell you :)The More Complex MethodLet’s say you want to see if a field contains one of several possible values. You could use multiple OR operators, but this can quickly become unwieldy and cumbersome.A Much Simpler OptionInstead, you can use (Text) Is In to check whether the value you’ve mapped is in the list of values that you specify. It’s cleaner, faster to create, and easier to maintain :)Hope this helps!
[GUIDE] How to Trigger a Zap from a Twilio Studio Flow WhatHere’s a guide for how to trigger a Zap from a Twilio Studio Flow. Zap StepsTrigger: Webhook - Catch Hook This is generate the webhook URL to place in the Twilio Studio Flow Action: (up to you) Twilio Studio FlowsAbout Twilio Studio: https://www.twilio.com/docs/studioYou’ll need to first configure your Flow in Twilio Studio.ExampleTo trigger the Zap, you’ll use this Widget: Make HTTP Request Configure the WidgetSet the Widget Name Or leave a default value Set the Request Method to POST Set the Request URL as the webhook URL from the Zap trigger step Set the Content Type as Form URL Encoded You can leave the Request Body empty Add optional HTTP Parameters Screenshot below shows 3 that would come from a Twilio Studio Flow that is triggered by an Incoming Message (aka SMS) To From Message NOTESZaps Make sure to test your Zap Make sure to turn your Zap ON Check your Zap Runs to help you troubleshoot Twilio Studio Flow
We recently added a column to a PostgreSQL table using the money datatype. This caused our Zaps to stop working and “We’re having trouble …” messages that also state “(Can’t generate DDL for NullType(); did you forget to specify a type on this Column?)” but not the column name.Problem solved by changing the properties of the Columns from Data type “money” to Data type “numeric” (without specifying any Length/Precision).
Hi Experts, have you noticed our new logo? We're happy to announce that Zapier has a brand new look. If you're interested in our brand updates, you can read the full rebrand story here . We hope you like our new glow-up as much as we do! If you do, feel free to spread the word by retweeting or sharing our news on LinkedIn. What's next: We'll send you an email on July 20 with the link to the rebranded Experts badges so you can update your website and other marketing materials. In the meantime, relax and enjoy Zapier's makeover. FYI: Nothing about the Zapier platform is changing. Your Zaps will keep running like they always have.
Hi Zapier Community,As stated in the title, I’m looking to get an action to trigger after a year. To be accurate, I set up a learning quiz using LearnDash and I’m looking for a way to send an email a year after it gets successfully completed. Because LearnDash works well with Zapier, it would be convenient to find a way to solve my problem using it.Upon reading the documentation from this article, I understand that a delay can only be scheduled for up to a month in Zapier and I should look for another way to do what I want.However, if someone has an idea on how to bypass this or can recommend an alternative solution I would be grateful to hear it.
What is Upsert?UpSert is a Coda.io function that permits to OR create a new row OR to update a row if there is a match. I had a working solution for a while based on a Coda Row ID. The logic was like this:A form of Paperform was filled out and via Zapier the data was injected into a Coda table. When the subcriber wanted to update the info (via a link in an email sent via Zapier - > MailJet ) an Upsert took place based on a hidden field in Paperform that I had injected with a Coda Row ID. The creation of the Row ID and how to prefill the Paperform is not the issue here, I guess the reader knows how set this up.Coda and the RowIDWhen a form with a Row ID came back, the uspert took place. The handy thing was that inside Coda we had an automation running that created a duplicate of the RowID column. Due to this automation it was not a formula driven column so we could used it to set up a Match in Zapier. However after a while this solution did not work anymore. I created two solutions
Storage API AppStorage by Zapier Zap Triggers/Actions: https://zapier.com/apps/storage/integrations#triggers-and-actionsHelp Articles: https://zapier.com/apps/storage/help REST API DocumentationReference: https://store.zapier.com REST API Endpointhttps://store.zapier.com/api/records REST API MethodsGET POST PATCH DELETE
What to do if a Zap app doesn't have the trigger or action you are seeking? Zapier ExpertsOften apps only expose their most popular/useful API endpoints (triggers/actions) and webhook events (triggers) via their Zap app integrations.However, the app trigger or action you are seeking may still be possible to configure by using an app’s API or webhooks.Integrating and automation with app APIs and webhooks is an advanced approach that involves technical concepts.For help configuring, consider contacting a Zapier Expert: https://zapier.com/experts Zapier SupportYou can submit a ticket via Zapier Support for the requested trigger/action to be logged in hopes that it will be included and made available in a future version of the app’s Zap integration.FYI: Most apps on Zapier are built and maintained by the app developers themselves, but Zapier keeps an internal list of app requests. WorkaroundsEmail parsing Parse emails for data points to trigger Zaps CSV files Upload CSV files to trigger Z
[Guide] How to Troubleshoot Zaps - Top Tips & Tricks To troubleshoot like an expert, try these tips & tricks...Check the Zap is ON. https://zapier.com/app/zaps Check the app authentications/connections. https://zapier.com/app/connections Check the Zap Runs. https://zapier.com/app/history/ Check the Zapier Status page for incidents. https://status.zapier.com/ Check the apps Status pages for incidents. Example: https://status.airtable.com/ View the Zap Details to see the Change History. https://zapier.com/help/manage/history/review-zap-details Does the Zap step have to correct app connection selected? https://zapier.com/help/create/basics/set-up-your-zap-action#connect-your-account Will the Zap NOT turn ON? https://zapier.com/help/manage/organize/manage-your-zaps#understand-zap-statuses Does the Zap auto turn OFF? https://zapier.com/help/manage/organize/manage-your-zaps#understand-zap-statuses Does your Zapier account plan have a valid funding source? https://zapier.com/
Searched a lot for this but never found the end to end solution, so I’m sharing here. I have a case where I want to send an employee the results from a SQL Server query (table records) on a regular basis, but haven’t been able to piece it together until now. So here’s an overview I hope is useful for someone else out there: Trigger: Schedule by Zapier - running every week. Action: SQL Server - Find row via Custom Query for the results you want(e.g. SELECT * FROM SALESORDER WHERE Employee=”Betty” For JSON AUTO, INCLUDE_NULL_VALUES). - The trick here is to put “FOR JSON AUTO, INCLUDE_NULL_VALUES” at the end of your query. This returns a single JSON field for Zapier as a result and includes Null values (in case you have blanks).- Note: there is a character limit on this JSON field from SQL Server (~for me it was 2000 characters) so beware this won’t work with large tableset results - you’d need to do multiple queries and concat them later in Zapier - the 2000 character limit was enough
Generate Secure Passwords or Unique Values in Zaps with Password Wolf API If you need to generate secure passwords or unique values in Zaps, then check out Password Wolf. This can be used in a Zap by using the Webhooks (GET) request as an action step. Site: https://passwordwolf.com
GUIDE: Use OpenAI in Slack ZapGet the Zap: https://zapier.com/shared/11d3eaab5b0cf67f33397ba21daab3b239bbb781 PurposeProvide a prompt in the form of a question or instructions as a message in a specific Slack Channel and get an autoreply message as a thread. PrerequisitesZapier paid plan OpenAI paid account Slack Workspace Zap StepsStepsTrigger: Slack - New Message Posted to Channel Action: OpenAI - Send Prompt Action: Slack - Send Channel Message (as Thread) EXAMPLE: Slack Channel MessageUsed to trigger the Zap with a prompt for OpenAI. EXAMPLE: Slack Channel Message Thread ReplyZap sends an autoreply message thread with the results from the OpenAI prompt.
Expert Explains: Scheduled Polling Trigger Definition: A scheduled polling trigger frequently fetches data from an origin app for a given event at set intervals. Use in Zaps:With a polling trigger, Zapier will check for new data from your Zap trigger app.The check frequency depends on your depending on your pricing plan, and can range from every 1 to 15 minutes in order to start your Zap.Think of this as Zapier frequently checking to fetch (aka pull) new data from the Zap trigger app for the desired event. (e.g. Contact Created) Example: The Zap will only process if and when new data is found.:00 - Zap checks for new data, but no new data is found, so nothing happens :15 - Zap checks for new data, and yes new data is found, so the Zap triggers and processes :30 - Zap checks for new data, but no new data is found, so nothing happens :45 - Zap checks for new data, but no new data is found, so nothing happens Learn more: https://zapier.com/help/create/basics/set-up-your-zap-trigger#trigge
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.