Show & Tell
Show off your Zaps, workarounds, and tricks. Tell others what you’re building with Zapier.
- 288 Topics
- 623 Replies
This article is for you if:You are interested in using AI Want to learn more about how you can use AI Enjoy trying new things to create cool Zaps Looking to avoid trial and error runs with ZapsWhere We Left OffLast week, we gave ChatGPT a little challenge to help us set up a Zap for a small business owner. Here's the scoop: The owner wanted to streamline the process of collecting customer feedback by automatically saving survey responses to a spreadsheet. And, at the end of the quarter, they planned to send a thank-you email with a special discount code to their loyal customers. However, they were too busy to manually manage this process and needed some help setting up a Zap to automate the task.So, we put ChatGPT to the test, and it worked! While there were a few hiccups along the way, we were pretty satisfied with the results. But, there was still some work left to be done. We only tackled the first part of the Zap, and now it's time to finish the job.If you're a small business ow
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] How to Trigger Zaps at ANY Time with Slack Reminders RemindersReminders are great!Reminders get info out of your head and prompt you when scheduled.If you’re using Slack and not taking advantage of their Reminders feature, then you’re missing out!(Read more about Slack Reminders: https://slack.com/help/articles/208423427-Set-a-reminder) AppsThese apps will be covered in this how to guide for scheduling Zaps to process at set dates and times.Delay by Zapier Schedule by Zapier Google Calendar Webhooks (ADVANCED) Slack Use CaseYou want to trigger a one-off Zap on command at a future time. (Slack) You don’t want to trigger the Zap now. (Webhooks) You don’t want to trigger the Zap on a set schedule. (Schedule by Zapier) You don’t want to clutter your GCal with Events that trigger Zaps. (Google Calendar) You may want to have your Zap triggered +/- 30 days in the future. (Delay by Zapier) SolutionSlack Reminders to the rescue!Plus, Slack is free to use.See options below for the differ
I have been trying to figure out how to copy my Zoom recordings to Vimeo and although there were several topics on it, they made it more complicated than it needed to be, and didn’t give you the ability to easily name your Vimeo video something from Zoom. You can do it in 1 Zap. Zap Steps For Google Sheets I created 2 columns, one form the Video DL URL, the other for the Topic from Zoom (which I am actually getting from another Zap with YouCanBook.me and Zoom. Google SheetsI put a delay in just to make sure it is written to Google Sheets before trying to copy it to Vimeo. The last step was to then upload it to Vimeo. I used the Video URL from the above step from Google Sheets, and the Topic I grabbed from Zoom.
As a follow up to the post I want to share my insights.You can integrate your personal Telegram Account and react on messages / group messages by leveraging the Apify platform, which is part of Zapier, and using the Telegram Scraper. Showing the Last Run of the Telegram ScaperShowing the Output in the Zapier previewDisclaimer: I am the developer of this Apify Actor.
Hi, all!I work with Chiefs-of-Staff on teams at VC-backed startups.My clients find creating and sharing meeting minutes can be super time-consuming, so I created a Zapier pipeline that integrates automatically generated Google Meet transcripts with OpenAI to produce comprehensive meeting minutes, including:A summary, Key insights, Top quotes, Requests for help from the rest of the company, and Feedback for the meeting facilitators/participantsThis is then posted to the company Slack.Here’s a tutorial on how to build a Zapier Zap that connect with your own data and automatically creates meeting summaries!There’s so much more I’d like to do with this, including linking directly to video clips of the quotes, storing the transcript in a vector DB like Pinecone so it can be queried discursively later (many via a Slack bot w/ access to the company’s private knowledge repo?), and incorporating context in re the company’s quarterly goals into the prompts…I had a blast creating this pipeline wi
Jesse Parker (Zapier's Community and Expert's Program Manager) and Heather Satterley (Certified Zapier Expert) join Kellie Parks to talk about how to automate and scale your business using systems thinking, process management, and of course, Zapier.Kellie is a session leader at Calmwaters Cloud Accounting and also runs a large Facebook community called "The Workflow Wateringhole" (https://www.facebook.com/groups/TheWorkflowWateringhole) where members discuss apps, systems, processes, workflow automation, and best practices within the realm of the accounting community. Heather Satterley is an Intuit top 100 ProAdvisor and Certified Zapier Expert who helps accounting professionals and small business owners streamline their business processes through her own business, Satterley Training & Consulting: https://satterleyconsulting.com/. If you're interested in streamlining your processes and are interested in working with a Zapier Expert, you can view a Zapier-approved list of professio
Will it Zap? ChatGPT EditionTutorial
This article is for you if: You are interested in using AI Want to learn more about how you can use AI Enjoy trying new things to create cool Zaps Looking to avoid trial and error runs with Zaps The big thing about AIWell, unless you live under a rock (totally possible, no judgements on our end), you’ve probably seen all the chatter on AI. If your initial feelings were doomsday-ish, I’m right there with you. The unknown can be intimidating, scary even. But what if you were able to use AI to make your life easier? You’re already on the way to becoming an automation rockstar, might as well let AI do some of the hard work for you. ChatGPT has now entered the chatOkay, so you’re almost on board, but now you want to know what is ChatGPT? No worries, I’ve got you. It's an awesome chatbot developed by OpenAI that can talk to you like a human would! I’m going to get technical here for a second, it's based on GPT-3.5 technology, which is super impressive (according to the tech people).
Even the most seasoned Zapier user sometimes has a hard time deciding whether to use a filter with multiple Zaps, a single Zap with multiple paths, or a single Zap with a lookup table.We’re trying something a little different and providing a visual guide that hopefully helps to clarify when/why you might choose to use one over the other.Filters Paths Lookup Table Did This Help?FiltersIf you’re trying to have several different outcomes from your workflow, using multiple Zaps with a filter is one way to approach it.Click to enlarge.PathsSimilar to using multiple Zaps with a filter, Paths provide multiple outcomes using only one Zap.Click to enlarge. Lookup TablePerhaps the most misunderstood of all the options, a lookup table is beneficial when you’ve got specific fields that decide an outcome. Click to enlarge.Did This Help?Here in the Zapier community we’re always trying to create resources that are helpful to our members. We’d love to hear whether this helped to make sense of things,
Hi all!I want to share my solution, maybe it will be useful to someone.This post was inspired by this question: https://community.zapier.com/how-do-i-3/adding-a-checkbox-to-a-google-sheet-2059.There are published solutions there, but maybe someone like me will not want to use "auxiliary" Tabs or do manual manipulations to manage checkboxes. Our goal:1. When a new response is received from a Google Form, insert a new row into the Google Sheet2. It should be noted that some fields in the form are checkboxes.Form field:Google FormSheet content:Google Sheet Problems we solve:1. By default, the "Create Spreadsheet Row" event will create a new row AFTER all rows that have a checkbox (even if they are not set to True)2. By default, this event will write text values to cells with checkboxes, and will not set a new checkbox (which is unexpected behavior for us)Example:New row was appended to the end of the Sheet, Checkboxes not set :( Solution:Our final Zap looks something like this in a nutshe
It took me a while to work out the syntax to trigger a zap from a Windows DOS batch file, so I thought I would share it.First, you will need to be sure that you have Windows PowerShell installed. This is open-source software supported by Microsoft. You will find more details and can download the software from the Microsoft Website here.To trigger a zap from a DOS batch, use the following command:powershell -NoProfile "irm ENTER-THE-FULL-ZAP-WEBHOOK-HERE | Out-Null"Thas it. Run the batch file, and your zap will be triggered.
Tips & Tricks for Authenticating or Connecting an App Tips & TricksTry using a private browser Try using a different browser Make sure your browser is updated Articlehttps://zapier.com/help/manage/app-connections/manage-your-app-connections
Hello everyone,Back with another integration. This time inspired by this question and since this feature isn’t supported by the built-in Storage app, I decided to make a custom one.Introducing KV Store, a custom Storage integration that uses the Zapier Storage REST API behind the scenes and supports an instant trigger for when a value is created or updated!Currently, it only supports the following triggers and actions but I will be adding more in the future.Triggers: New or Updated Value Actions: Set Value Invite link: https://zapier.com/developer/public-invite/124310/02e450e492d94e83e4480ba74499384d/ ZAPIER SAYS: This is an invite-only integration, created by a dedicated member of the Zapier Community. It is not publicly available, nor is it created by Zapier directly. Any questions/suggestions should be addressed to the creator, as they would be the best person to act on the feedback Thanks@ikbelkirasan for your hard work and for sharing with the community!
Airtable (PAT) Personal Access Token replacing API Key in Zaps ZapsYou need to update your Zap steps that use the Airtable app.That means you will have to manually convert and configure the Zap steps using Airtable.If you need help converting your Zaps, consider hiring a Certified Zapier Expert: https://zapier.com/experts How to find out which of your Zaps are impacted.Location: Zapier > My Apps > Custom IntegrationsSelect Airtable apps. (version will be in parentheses) Choose the "Zaps" tab. Filter by 'Zap Status' = ON. Airtable Zap AppWhen you connect to the new version of the Airtable Zap app integration, you will likely want to select the option for ALL WORKSPACES.Zapier can access the following bases and workspaces.You can only grant access to bases and workspaces you have access to.All current and future bases in all current and future workspaces AirtableAirtable API keys will be deprecated by the end of January 2024 After this date, API keys will stop working and you wil
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
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
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!
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
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
Hello guys, I saw a post that talks about the same issue that I had, so I tested many stuff to make it work. The issue is that the RSS feed blog post’s image or thumbnail not showing on linked in on the Private profile, the company page it has already an option to show image so we are talking about the private profile here. The steps are: Create your 1st zap’s trigger like this: Trigger RSS > Select your social media > Action > Twitter (its working on twitter without any issue, thumbnails appears) Create a 2nd zap’s trigger: Trigger twitter > action > linked in > set up action: select Entities urls expanded url Basically you are telling zapier to share your blog post on twitter then to take post from twitter and share it to linkedin.
GDrive File Link Formats (GDocs, GSheets, GSlides) Handy ways to format GDrive file links for different use cases. Try this Tool: https://sites.google.com/site/gdocs2direct/ GDrive Files - Download and ExportThe native file viewer is useful but sometimes you may want to bypass the built-in GDrive viewer and force the browser to download the file instead of opening it. GDrive Files - Direct Download Links to Skip the Web ViewerWhen you upload any file in GDrive and share it, the shared link looks like this:https://drive.google.com/open?id=DRIVE_FILE_IDThe FILE_ID is unique for every file in GDrive.If you copy this FILE_ID and use it in the URL below, you’ll get a direct link to download the file from GDrive.https://drive.google.com/uc?export=download&id=DRIVE_FILE_IDIf you wish to open the file in the GDrive web viewer, the viewer URL would be:https://drive.google.com/file/d/DRIVE_FILE_ID/view GDocs - Direct DownloadsAny GDoc in your GDrive has a URL like:https://docs.google.com/doc
The folks over at IPinfo let me test out their new Zapier integration. In a nutshell, you can get geo, company and carrier details from any IP address. Really useful for some filtering and CRM enrichment tasks.Invite: https://zapier.com/developer/public-invite/2936/42c3f87211fcf5065a77be6e40794f06/I also wrote about it on the Luhhu blog: https://www.luhhu.com/blog/ipinfo-io-zapier-get-ip-data-in-your-zapsI mentioned a few different apps that provide IP addresses in their triggers - mainly Wordpress, Shopify and from data input in spreadsheets etc. Anyone know of others?And, anyone have some interesting ideas of what could be done with this? I promised I'd give some feedback to the creators, so interested to hear what others think!
[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
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
Hi everyone!I wanted to share how I use Zapier with the company I work for. The following links are Youtube videos that show 8 different Zaps that I currently use on a daily basis. Video 1: https://youtu.be/EmEflcWo3TYVideo 2: https://youtu.be/UmfvlvSbkv8 I also created other videos on how to make a basic zap and how to use webhooks.
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.