About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Apps Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Home
Learn and Share
Show & Tell

Show & Tell

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

278 Topics
624 Replies

When you subscribe we will email you when there is a new topic in this category

278 Topics

Recently active

Most replies Most views Newest first

Troy TessaloneZapier Expert

asked in Show & Tell

Recently Added Zap Apps

Recently Added Zap Apps See the list of Recently Added Zap Apps here: https://zapier.com/apps?sort=CREATED

Troy TessaloneZapier Expert

posted in Show & Tell

Premium Zap Apps

Premium Zap Apps See the list of Premium Zap Apps here: https://zapier.com/apps?filter=premium NOTE: Premium Apps require a Zapier paid plan.

Troy TessaloneZapier Expert

posted in Show & Tell

Most Popular Zap Apps

Most Popular Zap Apps See the list of Most Popular Zap Apps here: https://zapier.com/apps?sort=POPULARITY

Troy TessaloneZapier Expert

posted in Show & Tell

Beta Zap Apps

Beta Zap Apps See the list of Beta Zap Apps here: https://zapier.com/apps?filter=beta

Troy TessaloneZapier Expert

posted in Show & Tell

All of the Zap Apps by Zapier

All of the Zap Apps by Zapier Ever wanted to see all the Zap apps available from Zapier? Search the list of Zap apps here: https://zapier.com/apps/categories/zapier-tools

RisoSystemsBeginner

posted in Show & Tell

How to get the entire order object from WooCommerce

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!

donovanwattsTinkerer

posted in Show & Tell

Another 2.5 minutes saved per Zap

A colleague asked for my help to reduce the amount of steps it takes for those on the her team to setup an environment for new projects. These steps currently take about 2.5 minutes each time they get a new project. The steps include...1. Open appropriate Google Drive folder2. Name the folder by copy/pasting the project name3. Create a shortcut pointing to the original Quote Request sheet provided by client4. Create an internal version of the Quote Request prefaced with [INTERNAL] in the nameSo, I got to work and created a Zap which is triggered via an Alchemer form that the point person on her team fills out with the following information...1. Project Name2. Project Code3. Link to Quote Request Sheet4. Team member's emailZapier monitors Alchemer and once a form is submitted, it then does all of the above work on behalf of the form submitter. An email is sent to the submitter once the bot is done which includes a link to the new folder.Here's the diagram of the workflow…

posted in Show & Tell

How to add Zoom recording info to a Guru card automatically with Zapier

We do a biweekly demo days meeting where our engineering team shows off what they have been working on. You might do something similar at your company.The engineering manager in charge of the meeting keeps all the Zoom recordings on one Guru card so that anyone who missed a meeting, or wants to review a previous one, can see them together.Over time, this manager found that he didn’t enjoy being nudged by coworkers when he forgot to upload the recording link right away, and he asked for my help. So I made this Zap! Hope it helps you, too.Guru does have a connector for Zapier, but it can’t update an existing card. You need to get a little fancy with Guru’s API for that. That’s why I’m making this post instead of a Zap template.You’ll need:A Guru API user token (if you’re not a Guru admin, your manager can request one) The ID of the card you want to update (which you can find with a different API call) A Zapier connection to Gmail To be the person who receives the recording from Zoom noti

Jeviko LolorieNew

posted in Show & Tell

Auto-Generate Instagram Graphics For Your New Shopify Products

This tutorial will teach how to auto-generate promotional graphics each time you add a new product to your Shopify store.ContentsWhat does this integration do? Example Image Select a template in Supportivekoala's template library Edit Template Get your Supportivekoala API key Make a Zap Set Trigger Create Image in Supportivekoala Publish photo to the Instagram feedThis tutorial will teach how to auto-generate promotional graphics each time you add a new product to your Shopify store.Promotional images can be a very valuable asset to your Shopify online store. You need some good creative content to advertise your products. If used correctly, they're a golden opportunity to showcase your products and get more sales!What does this integration do?This tutorial will teach how to auto-generate promotional graphics each time you add a new product to your Shopify store.You will send info between Bannerbear and Shopify automatically using Zapier. As your Shopify product catalog grows, Bannerbea

Buttercup813New

asked in Show & Tell

Mojo and Teams Integration?

Hi, Anyone on here integrate Teams and Mojo? Interested in learning more about how that works and looks. Thanks in advance!

SamBCommunity Manager

published in Show & Tell

How to stop single quotes causing "Syntax" and "Malformed query" SQL errors

When text with a single quote ' is passed in a query to an app using SQL (or a similar query language) it can cause an error. This is because strings in SQL queries are delimited with single quotes. So, if a text string in a query contains a single quote, it will end the query early and result in a "Syntax error" or "MALFORMED_QUERY” error. Like this one from Salesforce:How to prevent these errors? There are a few ways to help prevent these errors: Option 1: Replace any single quotes used with two single quotes ''. Option 2: Escape the single quote using \'. Option 3: Remove the single quote if it's not essential to the meaning of the string. Option 3 isn't ideal by any means so let's just focus on the other two!Option 1Using '' escapes the second single quote so that it is viewed as an actual single quote in the text, instead of being an end to a SQL string. So you would escape the single quote like this:And if the value has two consecutive single-quotes, each one has to be escape

NateZapier Expert

posted in Show & Tell

Qualification process for rental real estate

I’ve recently worked on a workflow for a couple of my clients in rental real estate and figured it’s worth sharing for inspiration. The typical qualification process with the agencies I’ve worked with were as follows: 100+ leads came in through StreetEasy, Zillow, and other popular websites each day. Every morning employees responded manually to each email that had come in with a series of questions to vet leads. Once the responses came in, employees rechecked numerous emails to see if any leads were qualified, many were not.This process worked to some degree, but it also wasted hours of valuable time, and the company lost qualified leads because of the time delay from inquiry to outreach. After all that effort, the many lost and unqualified leads hurt employee morale. Here’s how the agency works now after automating this workflow:Their system captures lead information (Parseur) and sends an automatic form with qualifying questions minutes after submission (Keap). The system capture

ikbelkirasanZapier Expert

published in Show & Tell

[Integration Update] "Advanced Utilities" will allow you to find all matches for a RegEx

In this post, I’m happy to announce some updates to my Advanced Utilities integration. If you haven’t read my previous post where I introduced this integration, feel free to check it out here.The new update introduces a new action called Extract Pattern (RegEx) which as the name states, allows you to find matches for a regular expression in an input text.Unlike the built-in Formatter → Extract Pattern which will only return the first match, this action will find and return all matches. I noticed this feature was requested by many users so I thought it would be nice to add it to this integration.Extract Pattern setup allows you to toggle RegEx flags as wellExtract Pattern action returns all matches for the given regexMatch information as can be seen on Regex101 website for the same regexAlso, this update includes some improvements to the Run JavaScript Code action. In my previous post, I mentioned that there was an issue with code highlighting, this issue has been fixed with this update

NAYEN-conferenceNew

posted in Show & Tell

From NeonCRM event registration, add new attendee to Whova?

Goal: When a person registers for a NeonCRM event, I would like to automatically create the person as an attendee in Whova.I set up a workflow in NeonCRM to create a new, completed activity in the person’s individual account record in NeonCRM when the register for an event. When creating the zap, I can see my test activity and a few additional fields for the activity. I also authenticated to Whova & can see the current event.Issue: But, the ‘zap’ does not seem to be able to see the first name/last name/email field from the account that is associated with the activity; this is stopping the required fields from being passed to Whova to set up the new attendee in the event app.The first name/last name/email 1 fields are selectable in the field drop down, but they say ‘no data’.Question/roadblock: Can the zap not read the account fields the activity is tied to? How do I pass the account fields through to Whova?Solution:Between activity trigger step, and create/update in Whova step, add

FrancesBeginner

posted in Show & Tell

SQL Server Results (Table) -> JSON -> Google Sheet (multiple line items)

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

AndrewJDavison_LuhhuZapier Expert

published in Show & Tell

How to add TransferWise to your Zapier automations

Update:We previously offered access to a custom TransferWise Zapier integration we built.Due to financial regulation issues, Transferwise has required us to discontinue that version of the integration.If you’re an existing user of said integration, it will cease to work at midnight on Jun 30th 2021.We’re still able to install a private version of the integration in your Zapier account for your own exclusive. If you’re interested in that, you can find more details here.

SamBCommunity Manager

published in Show & Tell

How to use webhooks to access missing fields in apps

Hello friends! There can be times when an app integration doesn’t support certain types of fields (usually Custom Fields). Or sometimes fields are missing from the data we receive. While it’s not ideal, it’s not always the end of the world. In some cases you can use a Webhook action to access those fields. Freshdesk is one such integration, its Create Ticket action doesn't support custom fields. But we can get around this using a Webhooks by Zapier step.Obtain an API Key Double-check the custom field names Setting up a GET request Setting up the POST Request Further reading Wrapping up!Obtain an API KeyHow and where you’d find the API Key differs between each app. For this example I’m going to be using Freshdesk. To find your API Key in Freshdesk you’d need to go to the Profile Settings page and it will be listed on the right-hand side: Freshdesk - How to find your API keyDouble-check the custom field namesThe next thing we’ll need is the name of our custom field(s). I’ve set up a cust

PaulKortmanZapier Expert

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

booselicBeginner

posted in Show & Tell

Codemap's 1st funding round & a showcase of 100s of Zapier projects

Hey all 👋, we're really thrilled to be able to share this with you - we've just raised our 1st funding round at Codemap! We want to say a huge THANK YOU to the Zapier community for all the support over the past year since our launch - what a journey this has been! Our story so far is just another proof of how game-changing no-code is - keep on building! 🙌With 2021 soon coming to an end, we also wanted to share a helpful resource and a showcase of what our community on Codemap has been working on over the past year and beyond - last week we released the largest curated database of 800+ no-code projects built by experts & teams on Codemap. The builds are categorized by types, stacks, and many more others key parameters, so you can discover what others are building with Zapier and how! Check out the showcase here to get ideas for your current or next build! Don’t hesitate to share any thoughts or feedback with us.Wishing everyone a great remainder of the year, happy holidays, and an

Troy TessaloneZapier Expert

posted in Show & Tell

GUIDE: How to DELETE an Airtable Record with JavaScript or via API

GUIDE: How to DELETE an Airtable Record with via API or with JavaScript APIHere’s how to use it in a Zap with the Webhooks app: https://zapier.com/apps/webhook/helpNOTE: Make sure to add the Authorization header with your API Key.NOTE: Make sure to replace these values in the URL including the encased brackets []BASE_ID See reference: https://support.airtable.com/hc/en-us/articles/4405741487383-Understanding-Airtable-IDs TABLE_ID See reference: https://support.airtable.com/hc/en-us/articles/4405741487383-Understanding-Airtable-IDs RECORD_ID This should a dynamically mapped variable from a previous step JavaScriptHere’s the JavaScript Code for using in a Run Script action of an Airtable Automation: https://support.airtable.com/hc/en-us/articles/360051792333-Run-a-script-Action- INPUTSTable The Name or ID of the Table RecordID The variable for the ID of the Record let config = input.config();let Table = config.Table;let RecordID = config.RecordID; // Record ID// Delete a record in t

Troy TessaloneZapier Expert

posted in Show & Tell

Zap Apps - How to Browse, Find, Search, Sort, View

How to Browse and Search Zap Apps Browse Apps by Name or Title: https://zapier.com/find-apps/0-9/ Search Apps: https://zapier.com/apps Sort Apps by:Most Popular: https://zapier.com/apps?sort=POPULARITY Premium: https://zapier.com/apps?filter=premium Beta: https://zapier.com/apps?filter=beta Recently Added: https://zapier.com/apps?sort=CREATEDView Apps by Top Searches and Trending: https://zapier.com (bottom of homepage) Find Apps by Category: https://zapier.com/apps/categories/app-families Tips and Inspiration contributed by: Troy Tessalone - Automation Ace

Troy TessaloneZapier Expert

posted in Show & Tell

How to pronounce Zapier?

How to pronounce Zapier QuestionHow do you pronounce Zapier?AnswerIt rhymes with happier.“Zapier makes you happier.” Tweet: https://twitter.com/zapier/status/674080383764455424 Tips and Inspiration contributed by: Troy Tessalone - Automation Ace

Troy TessaloneZapier Expert

published in Show & Tell

[GUIDE] How to Troubleshoot Zaps - Top Tips & Tricks

[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/

christina.dCommunity Manager

posted in Show & Tell

SalesLoft workflows with Webhooks by Zapier

Hi all!I wanted to show you a few ways to integrate SalesLoft into your workflow. While there isn’t an “official” SalesLoft integration at the moment, we’re big fans of the workaround. And as it turns out one of the best ways to get a workflow up and going when an “out of the box” solution isn’t readily available is by using Webhooks by Zapier. Here are a few resources for brushing up if it’s been awhile or if you’re just getting started: What are webhooks? Trigger zaps from webhooks New lead in SalesLoft to Slack notification Create new lead in SalesLoft from a formLet’s get into it!In order to achieve this, we’ll be using SalesLoft API. There are a variety of ways to implement their API and you can make it as fancy as your heart desires. Today we’re focusing on some more straightforward workflows. New lead in SalesLoft to Slack notificationFirst off, say you’d like to be notified anytime a new lead generates in SalesLoft. Trigger - Webhooks by Zapier - Retrieve PollThe initial set

CraigNet3Zapier Expert

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

1
...
4
5
6
7
8
9
10
...
12

Page 7 / 12

About ZapConnect

ZapConnect is Zapier’s one-day virtual event designed to help you unlock the possibilities of easy automation. With full access to our community, you’ll join automation leaders and users of all levels on an adventure to reimagine a single everyday task—or your entire business.

When is it happening?

It's taking place on October 20, 2022. It starts at 9 a.m. PT and runs until 1:30 p.m.

Where can I learn more about it?

You can check out https://zapier.com/zapconnect for more details.

Powered by Gainsight

Terms & Conditions

Sign up

Already have an account? Login

Use your Zapier credentials

Log in with Zapier

Log in to the Community

Use your Zapier credentials

Log in with Zapier

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

Pricing
Help
Developer Platform
Press
Jobs
Zapier for Companies
Transfer

Follow us

Zapier

© 2023 Zapier Inc.

Legal
Privacy