Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Show & Tell

Show off your Zaps, workarounds, and tricks. Tell others what you’re building with Zapier.

  • 367 Topics
  • 769 Replies
367 Topics
nicksimard
nicksimardZapier Staff
published in Show & Tell
About the Show & Tell Forum

Posts in this category should be conversational in nature, meaning that you’re not looking to get help from anyone or ask questions. It’s meant to offer a place to share tips, tricks, use cases, best practices, and workflows with your fellow Community members.You might be thinking…But, I don’t know enough to bother sharing.Not true! Everyone is capable of providing information, because nobody else has the precise experience and ideas that you do. Also, there will always be someone who is less experienced with Zapier than you and who could benefit from your knowledge  Share something you could have benefited from last week.Everyone else probably already knows what I’m thinking of sharing.There is SO much to know about Zapier, combining different apps, using advanced features, coming up with clever workarounds, etc. Don’t assume that your ideas are common knowledge. You might be surprised at how many people you can help by sharing!What if what I share isn’t accurate?That’s not the end of

4300
nicksimard
ikbelkirasan
ikbelkirasanZapier Solution Partner
published in Show & Tell
[New Integration] Advanced Utilities

Hey everyone, I would like to share a custom Zapier integration I built to solve a few problems. The integration provides the following action steps. I hope you find it helpful. :) --- Run JavaScript Code: This is kind of a clone of the regular Code Step. Nothing fancy, it just comes with some useful tools available in the global scope. It also supports modern JavaScript async/await. The global scope includes the following utilities: moment: The well-known moment.js library that helps when dealing with date/time. _: Lodash library that makes it easier to work with objects and arrays. JSON: this replaces the built-in JSON.parse function with the more advanced JSON5 library. toCSV: A function that converts an object to CSV.   --- Export to CSV: This action makes it easy to convert JSON data or line items to a CSV string or file.   --- If you’re interested in trying it, here’s the invite link: https://zapier.com/developer/public-invite/112461/039174f595539444ce5c14e114c1dc1e/

635539
Troy Tessalone
Zapier Orchestrator & Solution Partner
BlakeBailey
BlakeBaileyConnector
published in Show & Tell
Testing an Action Zap without Needing a Trigger!

Hey guys!If you're like me, you find yourself testing new zaps and zap ideas constantly. One common problem though, if you are just trying to test an Action, is that you still need a trigger! If you try and test your Action step without a trigger, you'll be hit with one of these: Instead of going through the hassle of setting up a trigger from an actual integration, simply use the 'Schedule by Zapier' utility as your trigger, and keep moving with your Action!You can set it up with any day and any time, so you don't have to waste any time figuring things out, also the test will always work, so it's a very quick fix. It might seem straightforward, but it can save a lot of time. Let me know what you use in these situations! :)

790726
AndrewJDavison_Luhhu
AndrewJDavison_Luhhu
AndrewJDavison_LuhhuZapier Solution Partner
published in Show & Tell
Dealing with zaps that trigger multiple time simultaneously with random time delays

Non-instant trigger zaps poll their respective APIs once every 5 or 15 minutes depending what Zapier plan you're on.When multiple new items are found, this results in multiple zap runs triggering at the same time.This is often fine, but occasionally other apps in your zap might not be able to handle being inundated by new data all at the same time, causing zap errors.This happened with two clients of mine:The first has a Shopify store that at peak times can receive anything from 5 - 15 orders in a 5 minute period. One of their zaps creates Trello cards for each order and at times Trello would not be able to handle creating so many cards at once and would throw errors.The other had a zap that watches quite a busy RSS feed and sends the articles to Buffer. They found buffer would often throw errors when trying to post multiple articles at once.Auto-replay for failed zaps is a great feature, but not suitable for everyone - so I looked for a way to space out zap runs.A simple code ste

1264322
jesse
Danvers
DanversZapier Staff
published in Show & Tell
Having fun with the new Google Assistant integration?

Has anyone had a chance to play with the new Google Assistant integration? If so, how have you found it? What workflows have you created? More importantly, how has it saved you time?! We'd love to hear your success stories, if you share yours you could be featured in our blog!

476118
pedroespecial
ikbelkirasan
ikbelkirasanZapier Solution Partner
published in Show & Tell
Zapier Utils: Find Zap by Webhook URL [Chrome Extension]

Hi everyone,I have recently answered a question about finding a zap that is associated with a webhook URL without having to open every single zap to look for which one contains the webhook URL. So I wrote a script that can actually scan all the zaps and then outputs the zap URL that is associated with webhook URL provided by the user.This obviously requires the user to open the Browser dev tools then paste the script and replace the webhook URL before executing the script. I thought this had to be simpler, so I went ahead and built an open source Chrome extension for it.I hope this can be helpful for anybody who might need it.LinksThe script: https://gist.github.com/ikbelkirasan/601dd8a51f458bf09d5ce44a102b9fd0The extension repository: https://github.com/ikbelkirasan/zapier-utils

534018
SamB
Community Manager
ikbelkirasan
ikbelkirasanZapier Solution Partner
published in Show & Tell
[New Integration] Pause and Resume

Happy new year!Have you ever wanted to pause a zap (let's call it zap A), trigger another zap (zap and wait for it to finish before resuming the zap A? I don’t know what techniques you might be using to build this kind of workflow but I know that one way of building it is to split the zap A into 2 zaps and have the second zap trigger the second half once it finished its work.While this might work fine, having a way to pause a zap and resume it at a later time would be nice!Pause and Resume is a custom integration I built just for that. If you would like to give it a try, you can find an invite link at the end of this post.Usage:Assuming that you have 2 zaps: A and B where A triggers B at some point. The trigger for the zap B has to be Webhook by Zapier.1. In A, when you want to trigger the zap B:Add a Pause Zap step. Set the webhook URL to be the webhook URL for zap B. Set the payload to whatever you want, it will be sent to zap B. Test this step and add the steps that would run when

132117
L
Danvers
DanversZapier Staff
published in Show & Tell
Select a random row/value in a Google Sheet

Let's say you want to send yourself a random motivational message each day, and you have a collection of inspirational quotes in a Google Sheet. We want to build a Zap that will trigger each morning and choose one of the quotes to send to you on Slack. Here's how you can do that.First, create your Google Sheet. For the first column, add the header 'Has quote' and have your quotes in the second column. In the first column, add this formula:=if(ISBLANK(B2),FALSE,TRUE)This will return the Value 'TRUE' if there's a quote in the quote column 'FALSE' if there isn't. You can copy this formula into every row - whether or not there's a quote in there now. Add your quote in the second column, and then add a third column called 'Row ID'. This third column will tell the Zap which Google Sheets Row each quote is on, which we'll need. Then create your Zap. In this case we're using Schedule as a trigger so that I can get an i

1052413
P
Liz_Roberts
Liz_RobertsZapier Staff
published in Show & Tell
Zapier Community Wrapped 2022

2022- what a year. For all its ups and downs (and inbetweens), we were here. We chatted, shared, and got answers to some tricky questions. So as the year draws to its end, we wanted to share a special shoutout for our top contributing members. From all walks of automation, these folks comprise the caramel core of our Community; making it the collaborative, useful, insightful space that we all use. Join me in celebrating these familiar faces and Zapier-pros. Troy Tessalone (AutomationAce) Mohamed Swellam (GeekyAir) The GetUWired Team Rob Schmidt (Outliant) Satya Raju Todd Harper (WeddingTechBFF) Daniela Paulo (@Daniela_Paulo) Ryan LaBarge (@RALaBarge) Scott Halgrim (@shalgrim) Marina Hand (@MarinaH)And special thanks to our Zapier Community moderation team @jesse @Danvers @christina.d @SamB @jammer.solijon.⚡Thank you all for your Zapier Community contributions! Just wait until you see what we have in store for 2023! 

30312
A
AndrewJDavison_Luhhu
AndrewJDavison_LuhhuZapier Solution Partner
published in Show & Tell
Good Zapier tutorials (video or blog posts)

Hi all!I'm putting together some blog posts - a roundup of decent Zapier tutorials out in the wild. I already keep a spreadsheet with links to good ones I find, but I'm sure I've missed a few (and maybe some of you want to plug yours).What I'm looking for:Either video tutorials or well-written, good-length blog post guides (with screenshots).Can be beginner, intermediate or advanced level (I'll do a few different posts).Can be focussed on just Zapier or "How to use Zapier + X app to do Y thing".Excited to see what people have! 😀

495312
AndrewJDavison_Luhhu
Malcolm Colman-Shearer
Malcolm Colman-ShearerZapier Solution Partner
published in Show & Tell
Copper CRM: Getting around the limitations of the built-in integration

Hi all, if you're a Copper CRM user then this one's for you! Zapier's built-in integration with Copper doesn't support updating custom multi-select fields at the moment. So here's a post on how to get around that limitation, by using webhooks.https://www.optimi.co.nz/blog/2019/10/11/copper-crm-how-to-update-custom-multi-select-fields-via-zapier This gist of our post is this recipe which does most of the work with the native integration and the rest with web hooks:Set up your zap with a trigger and a Copper action stepGet your custom field definitions from the Copper APIHook up the Copper API to Zapier (via webhooks)Add a code step to format your multi-select data

691912
AndrewJDavison_Luhhu
Lionel_Selie
Lionel_SelieZapier Staff
posted in Show & Tell
Make a Zap Work Between Mon - Sat, from 8am to 6pm (Otherwise Delay)

Last updated: May 28, 2025.Hi everyone! Leo here from Zapier Support, hope you're doing well today!Occassionally, we get a question whether it’s possible to make a Zap work between certain hours and certain days, otherwise delay.There are a couple of options available, but when it gets complex, it will often involve using Paths by Zapier. Now, we know that not everyone needs a Pro plan (or higher), so we set out for a fun challenge to create a Zap that can do the following, without using Paths, in the leanest way possible:1/ Allow the Zap to continue, if the Zap is triggered between Monday and Saturday, 8 AM and 6 PM2/ Before 8 AM on Mondays to Saturdays > delay until 8 AM today3/ After 6 PM on Mondays to Fridays > Delay until 8 AM the next day4/ After 6 PM on Saturday, or the entire Sunday > Delay until next MondayThe Solution:Trigger: use the trigger of your likingAction: Formatter > Date / Time > Format.Use input: {{zap_meta_human_now}}Output: custom value: ddd HHMode

426812
Lionel_Selie
terbiy
terbiyBeginner
published in Show & Tell
What Zaps made your life better?

Hello!In this tips and inspiration part of the community, I'd like to ask you about inspiration. The problem I have is that I do not know where to introduce automation. I certainly can see some proposals in most popular tasks on Zapier website, but too many of them look like the increasing of entropy in my life.Could you please write here about Zaps that indeed made your life better? I guess I and readers of this topic will find the inspiration while reading your stories.🙂Beforehand thank you!

696912
SimonJP
A
andrasBeginner
asked in Show & Tell
Using checksums to prevent Zap loops in Jira and Google Calendar

How to avoid a Zap loop works well with creations but not with updates. In my case, if I create a Jira ticket which gets propagated to Google Calendar as an event, I'd like to know I can ignore a trigger from Google Calendar since that update was issued by Zapier.This means that the question we're trying to answer is “Was this zap triggered by a user or by Zapier?”The easiest way to do this is by attaching a checksum to the update. Just like cryptographic signatures. Say we are propagating from Jira to Calendar:Date: 2025-01-02Description:Hello World!Concatenating those values and then attaching a checksum (e.g. crc32) you could propagate the Calendar event like this:Date: 2025-01-02Description:Hello World!CRC32=9C 12 95 FAIf Calendar sent back an update to Zapier, Zapier would parse the description field, extract the checksum and concatenate the date and the actual description. This way it would be able to see that the checksum hasn't changed, thus, this was a Zapier triggered update

8811
A
AndrewJDavison_Luhhu
AndrewJDavison_LuhhuZapier Solution Partner
posted in Show & Tell
Which zap are you most proud of?

What's your magnum opus of Zapier? A zap that's really interesting and/or a real time saver.For me it's a zap I've built that taps incoming tweets for mentions of Zapier, filters for a bunch of things (did you know, "zapier" means something in Polish) and then consolidates them into a morning digest spreadsheet for me to look at. For added bonus points I've added a path that alerts me on Slack to any tweets that contain a question mark. The idea being that these are people that might need help with Zapier that I can try and convert into customers.I'm interested to get some inspiration from others!

749610
BlakeBailey
A
ameurjBeginner
posted in Show & Tell
HubSpot deal triggers no longer include contact ids

Hello Guys i have found a way to associate deals with contacts (update : December 2020)

103910
N
Troy Tessalone
Zapier Orchestrator & Solution Partner
Troy TessaloneZapier Orchestrator & Solution Partner
posted in Show & Tell
PROOF: Delay For Less than 1 Minute with the Delay For Action Step

PROOF that it is indeed possible to delay a Zap for less than 1 minute using the Delay For action step! CreditsTroy Tessalone is a Certified Zapier Expert at Automation Ace. CHANGESInfo: https://help.zapier.com/hc/en-us/articles/33303435847821-Enhance-delay-functionality-for-seamless-workflowsMinimal delay: From January 13, 2025, the shortest delay you can set for a Zap is 1 minute.  Automatical adjustments: If you have any existing Zaps with delays shorter than 1 minute, they will automatically adjusted to 1 minute to prevent any performance impact. NOTE: There is a workaround using Code by Zapier to do a Delay for 1-30 seconds. ### Don’t believe everything you read, and when in doubt, test it out! Screenshot below shows the Zap Run history with a timestamp created before and after 30 second delay.(Note: The time difference between the 2 timestamps shown is a bit longer than 30 seconds because of the time it takes to process the other Zap steps.) Notice below the field Time Delayed Fo

371410
Troy Tessalone
Zapier Orchestrator & Solution Partner
nicksimard
nicksimardZapier Staff
published in Show & Tell
Looking to get website screenshots or generate images from templates? Check out these apps!

This week’s Workflow Wednesday article is going to be a little different. Rather than dive into a particular workflow I’m going to highlight some interesting apps I found in our directory. More specifically, these are triggers and actions that enable you to do some pretty nifty things with images/screenshots.NOTE: I haven’t necessarily tried all of these extensively, it’s not an endorsement of these particular apps, and this is by no means an exhaustive list. I just thought these could be handy for some of you.CloudConvertCloudConvert converts files between more than 200 supported formats: documents, image, spreadsheet, presentation, audio, video and more!Capture a WebsiteCreates job to capture a website as PDF or create a website screenshot as JPG or PNG.No advanced features here but when I’ve used this in the past it’s worked well. PikasoPikaso is a tool that lets you screetshot tweets.Screenshot TweetTakes a screenshot of a tweet.Providing a tweet’s URL, you can then produce images

17469
A
BlakeBailey
BlakeBaileyConnector
published in Show & Tell
Starting a YouTube Channel on Automation / Tech / Productivity - Feedback Welcomed!

Hey experts! This is something I'm sure all of you can connect with. I'm looking to help as many people as possible to leverage technology, automation, and good strategy. Therefore, I've recently started a YouTube channel to summarize some of the concepts I've been teaching for years. I really look up to all of you in this group, so it's your ideas and suggestions that I value most. This is my first (actual) video, so any and all feedback or suggestions from you guys would be very much appreciated.I'll also be making content specific to different tools, comparisons, concepts, and specific integrations (as long as I can keep myself on track and focused 😛 ).

45129
rimisen46
CraigNet3
CraigNet3Zapier Solution Partner
posted in Show & Tell
How to Retrieve the HTML Version of a Google Doc for Dynamically Editable Email Templates

One of the best ways to send automated emails in Zapier is using an email template. This template can be hardcoded HTML in a send email action step using a Zapier email app such as Gmail or Outlook.However, having this email message hardcoded would be a pain to maintain since the Zap would have to be deactivated if a change to the template was required. Futhermore HTML isn’t user friendly. The person creating or editing the template would have to know how to write HTML code.Wouldn’t it be easier if this template was a beautiful Google Doc instead of HTML?But how do you get that Google Doc to spit out HTML when you need to send it as an HTML email? Here’s how.The first step is to ensure the Google Doc has a publicly viewable URL by sharing it with at least “Anyone on the Internet with this link can view”.  Next copy the link. It should look like:https://docs.google.com/document/d/1-P9leFZWlzw93Rq5M4Gmsa5UinOgRp6wj7tpP6k7tXA/edit?usp=sharingFinally replace everything from and including t

21499
CraigNet3
Troy Tessalone
Zapier Orchestrator & Solution Partner
Troy TessaloneZapier Orchestrator & Solution Partner
posted in Show & Tell
How to get a PDF version of a Google Drive file such as Google Docs, Google Sheets, or Google Slides?

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 

42559
Troy Tessalone
Zapier Orchestrator & Solution Partner
PaulKortman
PaulKortmanZapier Solution Partner
posted in Show & Tell
Error Handling For A Specific Step (aka Automatically Repeat A Step If It Fails)

I’ve run into this often and have a decent work around so by posting it here hopefully this can help others. The issue: Zapier steps that “depend” on the output from a previous step will fail if the previous step fails or has an issue. This can happen for a number of reasons, like the webhook step had an error, or (and this has been happening A LOT lately) an app like Google Sheets responds with an error like 500 “Server Error time out”. Or a search step fails and you don’t want to create a record Or the application doesn’t give you that option. I want to make my zaps smarter and to work around these issues. As you’ll see below It takes a number of extra steps and paths to do this, so I only do it on critical zap steps or where failures are common. For example if I try to post to a Google Spreadsheet and I get a time out error I want the zap to take a delay and then make another attempt. Or if there was a failure in finding a row or a contact or whatever the search was I want the zap t

108369
A
calebgonzalez
calebgonzalezZapier Staff
posted in Show & Tell
Try out this Shared Zap to make sure you always see emails from our Support Team!

Try out this Shared Zap to make sure you are always notified when Zapier Support replies to your emails!     https://zapier.com/shared/58a6872b96952a8f62ab96a26628a7fc12da873f  

42728
M
Troy Tessalone
Zapier Orchestrator & Solution Partner
Troy TessaloneZapier Orchestrator & Solution Partner
posted in Show & Tell
Zapier Interfaces - RESOURCES

Zapier Interfaces Location: https://interfaces.zapier.com Help: https://zapier-interfaces.zapier.app/home What are Zapier Interfaces?Instantly build dynamic interfaces that connect to Zaps and a data source (like Tables).Interfaces gives you a drag-and-drop way to build visual workflows for any business process, without writing code.Sign up - Zapier Early Access: https://zapier.com/early-access  

8628
ECHO125
AndrewJDavison_Luhhu
AndrewJDavison_LuhhuZapier Solution Partner
published in Show & Tell
Easy edit round robins using a Google Sheet

Mod Edit: 03-23-2022Round robins are pretty popular with my clients and I'm sure many others - usually used to assign leads evenly across a team when creating deals/contacts in CRMs like Pipedrive, Salesforce, Hubspot etc.While it's quite easy to create them using a lookup table in your zap, adding/removing/reordering means editing your zap each time which isn't ideal.I set out to find an easy solution to this - and managed to build a round robin zap that can be managed directly from a Google Sheet.It's starts with this template:Round Robin Template Column B and C are obvious, and more could be added as needed.Column A is the start of the magic - it marks that person's position in the RR using the formula "=ROW()-1"Notice what happens if you move someone from below the black bar into the RR - the positions remain correct:You'll also notice the count changes - this is achieved using another formula: "=COUNT(A2:A6)"The extra blank black row acts a buffer - when you move rows up into that

152138
AndrewJDavison_Luhhu
Terms & Conditions