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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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

Featured Articles Show & Tell AI Hub Zapier Tools 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.

Show & Tell

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

  • 307 Topics
  • 643 Replies

307 Topics

Troy Tessalone
Troy TessaloneZapier Expert
posted in Show & Tell

Ask AI: Debug & Troubleshoot Code Steps

Ask AI: Debug & Troubleshoot Code Steps PURPOSEUse AI to debug and troubleshoot code in Zap Code steps. APPSChatGPT By OpenAI https://chat.openai.com Code by Zapier Works with JavaScript or Python https://zapier.com/apps/code/help  PROMPTDebug the code:[CODE] EXAMPLE 

0
Troy Tessalone
1 year ago
Troy Tessalone
Troy TessaloneZapier Expert
posted in Show & Tell

Ask AI: Document Code Steps with Comments

Ask AI: Document Code Steps with Comments PURPOSEAdd documentation to your Zap Code steps with comments generated by AI. APPSChatGPT By OpenAI https://chat.openai.com Code by Zapier Works with JavaScript or Python https://zapier.com/apps/code/help  PROMPTINSTRUCTIONSAdd inline comments to the code.Include a summary comment at the top.Keep existing comments.CODE[CODE] EXAMPLE 

0
Troy Tessalone
1 year ago
Troy Tessalone
Troy TessaloneZapier Expert
posted in Show & Tell

Ask AI: Zap Steps for your Apps

Ask AI: Zap Steps for your Apps ABOUTQ: Need automation inspiration for your apps?A: Ask AI for Zap step suggestions! APPSChatGPT by OpenAI https://chat.openai.com  PROMPTOutline the possible steps for 3 different Zap automations between these apps: [APPS] EXAMPLE 

0
Troy Tessalone
1 year ago
Troy Tessalone
Troy TessaloneZapier Expert
posted in Show & Tell

GUIDE: Use OpenAI to replace multiple Formatter Steps and save Zap Tasks

GUIDE: Use OpenAI to replace multiple Formatter Steps and save Zap Tasks PurposeUse OpenAI to replace multiple Formatter Steps to save Zap Tasks PrerequisitesZapier paid plan OpenAI paid account EXAMPLE: Zap StepAction: OpenAI - Send PromptThe values after “Text: ” seen in the screenshot should be converted to use a mapped variable in order to make the Zap dynamic. NOTE: You will likely have to do some testing and fine-tuning to get predictable and repeatable results. ResultsYou can map the “Choices__1__Text” variable into following Zap action steps. 

0
Troy Tessalone
1 year ago
Troy Tessalone
Troy TessaloneZapier Expert
posted in Show & Tell

GUIDE: Use OpenAI in Slack

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) Step 3 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. 

4
Troy Tessalone
1 year ago
R
rnbpartyNew
posted in Show & Tell

Action marks

Hello, I'd like to share an idea about mark dependences of zap actions. Working in zap we delete and edit its actions . Deleting or editing an action will delete or change its output. To easily find out which actions depend on the output of a particular action, it would be helpful to have some indication of this relationship. For example, we could include a mark next to the action's title that shows the numbering of actions that use the output of that action. Similarly, it would also be useful to see which actions provide input to a particular action. Please see the screenshot attached. For instance, if action #8 depends on actions #1 and #3, and actions #9 and #11 depend on the output of action #8, this relationship could be shown visually on the interface. So, as soon as you will delete the output of action #8 from actions #9 and #11, at the output block of action #8 there would be nothing. Also it would be convenient to mark actions, where some hardcode is used, because we used to f

2
Liz_Roberts
1 year ago
W
WaelBeginner
posted in Show & Tell

Webhook action add reactions in Slack

Hi Community!I thought I would share here how to create a Zap that can add reactions to messages filtered through keywords using Filter and Webhook actions. The Zap can be more complex but for the example I made in 3 steps: Summary ViewStep 1: Trigger; I went ahead and used New Message Posted in Channel in SlackStep 2: Action; Here I selected the Filter action with the option to “Only continue if...” Step 3: Action; Here I went with Webhook by Zapier; Custom Request in Webhooks by Zapier Steps 1 and 2 are simple, so I will expand a bit more on Step 3 which for me was the trickiest part. Step 3 Details  App & event: App: Webhooks by Zapier Event: Custom RequestStep Details: Method: POST URL: https://slack.com/api/reactions.add Data: channel=ChannelID&name=EmojiName&timestamp=MessageTs Unflatten: False Headers:  Authorization: Bearer xoxb-your-personalized-slack-token Content-type: application/x-www-form-urlencoded   Action Details Finally, here are a couple of links to reso

1
Danvers
1 year ago
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! 

28112
A
1 year ago
GetUWired
GetUWiredZapier Expert
posted in Show & Tell

Instant Gmail (or Outlook email) Triggers

 Triggering Zapier from an email can be an effective way to integrate with systems like Realtor.com, Venmo, Airbnb, or any other app that doesn’t have a Zapier integration yet. Often times, lead response time is critical and all of the Gmail Zapier triggers are scheduled (1-15 minute delay depending on your plan). This walk-though will show you how to set up Gmail forwarding to instantly trigger Zapier (bonus: since this solution uses Zapier Email Parser you may also be able to parse the email content at the same time)*The below guide walks you through how to set up a forwarder in your Gmail account. However, you can set up forwarding rules for all different types of mail clients and the premise of the guide is the same. Here are details on how you can set up forwarding rules with an Outlook account: https://support.microsoft.com/en-us/office/use-rules-to-automatically-forward-messages-45aa9664-4911-4f96-9663-ece42816d746 Step 1: Create Your Parser account and Mailbox- Create a Parser

0
GetUWired
1 year ago
Troy Tessalone
Troy TessaloneZapier Expert
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  

8
ECHO125
1 year ago
dominicw
dominicwNew
posted in Show & Tell

Zapier vs. Make vs. Airtable Automations (take the quiz)

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.How do you choose between Zapier and Make for your automations?xxxxxxxxxxxCurious if this resonates or if you see the tradeoffs differently (specifically around pricing and complexity of the automation)There's also a free quiz you can take if you don't know much about each platform!

0
dominicw
1 year ago
G
GeroKeilNew
posted in Show & Tell

Tutorial: Classify your customer support tickets by language and send them to the right agent with Levity + Zapier

Do you want to revolutionize the way your Customer Support team works?Let automation expert Luc Meijer show you how to automate your workflows with Levity and Zapier! 🙌In this 10-minute tutorial, Luc will guide you step-by-step through creating automated flows that classify your incoming customer support tickets according to their language and then send them directly to the right agent via HubSpot.With AI-powered language detection, you can save time and ensure that your customers get their issues addressed quickly.Don't miss out on the power of automation! Tune in to Luc's tutorial now and learn how to use Levity and Zapier to take your Customer Support game to the next level ⤵️  

0
G
1 year ago
M
Magdalena WilhelmBeginner
asked in Show & Tell

Outlook

Hi ,  I have just one technical question. Maybe you can answer them for me? I once created an interface with Outlook with my Outlook account, I would like to add more Outlook accounts, but this is somehow not possible. Can you give me a tip here?

3
MohSwellam
1 year ago
M
Michael SchmidtBeginner
posted in Show & Tell

Your wishlist needed: Vacation management, out of office and auto responder integrations

What happens when you go on vacation but all your collaboration tools keep running and expect input from you? How do you escape from the stress of notification floods? We feel that there’s a lot to do in terms of integrating productivity applications to shut them down or silence them when we decide that we need to rest. And it’s not just about the notifications, but about having simple processes that can deflect work to a colleague or warn customers that you can’t answer in time, just this one time.Which productivity apps would you like to put behind an Out of Office assistant? Task managers like Asana, trello, or monday.com? Marketing and sales platforms like HubSpot or Salesforce? We’re actively collecting feedback to understand this pain point better and help the Zapier community.About meHi there! I’m the product owner for Out of Office Assistant for Jira cloud. It’s a plugin that allows to A) automatically reassign work away from users who are out of the office to colleagues who ar

0
M
1 year ago
Lionel_Selie
Lionel_SelieZapier Staff
posted in Show & Tell

Facebook Lead Ads not triggering for new leads, pulling in sample or other issues? Here's a guide to help you!

Hi everyone! 🖐Do you have a Facebook Lead Ads Zap no longer triggering, a page not showing up and/or are you not able to pull in sample data? Then this post is for you!Permissions Manage Page access Manage Ad Account Leads Access CRM Access Business Tools New Connection Page still not showing up? Other tipsPermissionsFacebook Lead Ads permissions can be complex to navigate. While we have dedicated help documentation for this, it can still prove a challenge to set it up. Below you’ll find the needed permissions to use the Facebook Lead Ads integration (please note this is different for the Facebook Lead Ads for Business admins app integration!).Manage Page accessLocation: https://business.facebook.com/settings/pages/Manage Ad AccountLocation: https://business.facebook.com/settings/ad-accounts/Leads AccessLocation: https://business.facebook.com/settings/leads-accesses/CRM AccessLocation: same as Leads AccessNote: The Facebook Page Owner or Business Manager can assign the “Zapier”

2
Lionel_Selie
1 year ago
MohSwellam
MohSwellamZapier Expert
posted in Show & Tell

Tutorial: Use "Find Many" Action with Looping by Zapier

A quick tutorial on how to utilize Find Many actions for Airtable and Google Sheets to send separate emails. Part of my Automate your Airtable and Google Sheets seriesLet me know your thoughts!

2
MohSwellam
1 year ago
MohSwellam
MohSwellamZapier Expert
posted in Show & Tell

Tutorial: What Value is Zapier Expecting in Any Field

Hey Everyone, In this quick video Im gonna show you how you can determine what value Zapier is expecting in most fields.    Hope this was helpful and easy to follow. 

0
MohSwellam
1 year ago
C
ConvertAPINew
posted in Show & Tell

How to process a multi-file conversion result from ConvertAPI

The ConvertAPI app on Zapier is becoming highly popular, and many customers are extending their workflows using our service that offers a broad file type conversion support.It is super easy to set up and requires no development skills at all. However, there are some nuances that may be taken into consideration to take full advantage of our service. In this article we will explain how to process multiple files returned by the ConvertAPI conversion.Conversions that result in multiple filesSome conversion endpoints may return multiple files as a result of the conversion, and you may wonder how to process each file individually.Some common examples that return a file array as a conversion result would be:ZIP to EXTRACT PDF to PNG PDF to SPLIT DOCX to JPGAnd so on. Zapier aggregates such results into a single field joined by a comma delimiter. But worry not! There is a solution for iterating those files one by one. It involves a single step that is easy to set up and is completely free.Proc

0
C
1 year ago
MohSwellam
MohSwellamZapier Expert
posted in Show & Tell

Tutorial: How to Map an Empty Field in Zapier

Hey everyone,  Here is a quick demo on how to map a field in Zapier dynamically even though that particular field is empty in the trigger / previous action(s) results. Hope it is helpful!  

0
MohSwellam
1 year ago
W
Wim.GUNew
asked in Show & Tell

How do you find the max value in a spreadsheet row?

I was wondering if there is a way to search for the max value in a spreadsheet column and then create a variable that is (max number +1). So if the max value in a spreadsheet column is 93 it would give the value 94. (Title should say column)

1
Troy Tessalone
1 year ago
D
danbradyBeginner
asked in Show & Tell

Download a document from an email link URL to use in a zap

I’m posting this as a solution as no one else has (as far as I could tell).My use case is below, but this approach will work for anyone who wants to use Zapier to download a file from a URL in an email, i.e. in the email you receive, the file is NOT an attachment but is available to download via a link in the email. Using the Zapier mail parser you can grab that file and use it in zaps to do what you want with the file (e.g. forward as an attachment in an email, save to Google Drive, etc).The basic overview is this:Auto forward email → Email Parser by Zapier → Zap My problem was with Stripe invoices and receipts – I want to auto-forward the invoice and receipt PDFs on to Dext as attachments in emails (Dext automates the receipts getting to my accounting software, automating much of our bookkeeping). As Stripe doesn’t attach the documents to their receipt emails, I have to manually download them and forward to Dext – which, to me, is not acceptable in 2022.To start, you need to use Emai

3
D
1 year ago
M
mattcrailNew
posted in Show & Tell

How to build a Twitter and Instagram bot

I often find myself exploring faraway places on Google Maps. Sometimes I’ll land on a beautiful natural resource like the Grand Canyon or Half Dome in Yosemite, and I’ll notice a bunch of one-star reviews. Something about people who take the time to leave bad reviews of natural splendor is amusing to me. I thought perhaps others might find it funny as well.So, I decided to find a way to curate these bad reviews and share them with the world. Given I spend most of my social media time on Twitter, I landed on building a Twitter bot that tweets out my favorite of these bad reviews twice per day. I later on decided to throw an Instagram account into the mix since it’s a more visual medium.I am non-technical, so I needed to find a way to do it using low-code/no-code tools. When I dove it, it turned out to be surprisingly easy. Here’s how I did it.Collecting the reviewsThe most manual part of the process is finding and collecting the bad reviews from Google Maps. I created an Airtable spread

1
T
1 year ago
MohSwellam
MohSwellamZapier Expert
posted in Show & Tell

[GUIDE] Using Airtable newly introduced Line Items Support

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,

0
MohSwellam
1 year ago
K
KometBeginner
posted in Show & Tell

Use Gmail to communicate with cleaning lady on Airbnb

GUIDE: Use Google Mail API to Create personnalized email to cleaning lady on Airbnb, Booking.com, HomeAway RESOURCESGoogle Mail Integrations :https://zapier.com/apps/gmail/integrationsZapier formatter :https://zapier.com/apps/formatter/integrationsZapier filters :https://zapier.com/help/create/customize/add-conditions-to-zaps-with-filters CONFIGUse the Gmail app in the search way in the email received fro your OTA Action Event: Custom Request in order get the information about the date of guest in the mail Method: In the Body plain field, get the several data about the arrival and departure date of the guest with the function Truncate Filter the zap with the function Only continue if with a filter on the date of the day and the date of the departure of the guest Send an automatic and personalised email to the cleaning lady with the information of the date of the departure of a guest

0
K
1 year ago
K
KometBeginner
posted in Show & Tell

Use Gmail to communicate with guests on Airbnb

GUIDE: Use Google Mail API to Create personnalized email to Guests on Airbnb, Booking.com, HomeAway RESOURCESGoogle Mail Integrations :https://zapier.com/apps/gmail/integrationsZapier formatter :https://zapier.com/apps/formatter/integrations CONFIGUse the Gmail app in the search way in the email received fro your OTA Action Event: Custom Request in order get the information about the guest in the mail Method: In the Body plain field, get the several data about email and name of the guest with the function Find, Sub numbers and Truncate Formatting the data with the function  Lowercase and Capitalize Send an automatic and personalised email to the guest with the data information

0
K
1 year ago
Terms & Conditions