Show & Tell
Show off your Zaps, workarounds, and tricks. Tell others what you’re building with Zapier.
- 232 Topics
- 557 Replies
How do you find a phone number or a username in the middle of a string? Sometimes you can use the Formatter Split text function, if the item will always be in the same place, but it’s not always that straight forward. That’s where the Extract Pattern function for the Formatter app comes in. You can find the Extract Pattern transform under the ‘Text’ functions for the Formatter. What it allows you to do is to find and extract patterns in text. The Extract Pattern function uses Regex to find the text that you need. Regex is short for ‘regular expression’ and it basically means that you’re giving a sample format for the step to find. You can learn more about Regex, including seeing a few examples in our blog post: How to Extract Email Addresses, Phone Numbers, and Links From Text Regular expression - Wikipedia The post also has some useful resources, like the Regex wikipedia page, which explains the syntax (rules) of Regex. Extract pattern is useful for pulling out user names, specific em
I work at a computer all day - I slouch, I slump, I droop, and I stoop. It’s not long before those cricks add up that only a good stretch can alleviate. I know myself, though - if I have a reminder to stretch at the same time every day, I’ll soon ignore it. So, I set up a Zap to remind me to stretch at RANDOM times of the day so I never know when it’s coming! It’s a lot harder to ignore surprises! This one’s an easy set up. It uses Schedule by Zapier as the daily trigger. Then, there’s a first Formatter step. It uses a pick list to randomize the time of the day - I’ve set it to select a random time between 9 AM and 5 PM. Next, it uses a Delay step to delay the Zap so you’re only notified at the correct time of day. It has one more Formatter pick list to randomly select from a list of exercise links that I found online. Lastly, it sends me a Slack message that includes the exercise links. You can check it out (and turn it on) here: https://zapier.com/shared/c05b3bc173ca41c4dbb40e4267d4
So, the need that we heard about was for Covid 19 screening forms for employees and visitors to US places of business. Every morning at 6 am the plan was to send out the forms to all employees who were on the list. They had to complete the form and if they were high risk based on answers then HR is notified. If they are low risk, they got a pass to show up. Solution: Zapier’s new schedule function as a Zap runs each morning at 6am. This Zap begins a workflow for the HR person to update the spreadsheet and click to run a google script! The google script pulled names and emails from the google sheet and sent over to OnTask. OnTask sent out the forms to all that were on the list to fill out and sign. Conditional routing in OnTask sent them to HR or gave them the all clear and reported this all back to HR. As U.S. businesses reopen, what are you all doing around Covid-19 contact tracing, screening, et cetera? Using Zapier for anything related to your plan?
The Challenge "I want zap that will make a Trello card change date monthly when I have done a task. Like a calendar reminder in emails that comes up every month on the same day every month" What this user wanted was to use Trello like a monthly reminder, without having to keep changing due dates. So the reminder on the 26th of the month would let her know it was due, then be changed automatically to the 26th of next month. She didn't even want the Trigger to be marking that card as complete. Just change it to the subsequent month, recurring. The Solution Trello has a Trigger called New Notification. When you are assigned a card or are subscribed to it, Trello gives you a notification 24 hours before that card is due. So if something is due on August 26th, Trello will tell you on August 25th. That triggers the Zap. We also want to add a filter to make sure the notification is one telling you a card is due soon. We could add a filter for the board or list if we needed to. We t
Now you can use Zapier to send tweets directly to a custom Alexa skill. I just used this to create an Alexa skill that reads out Naval Ravikant's best quotes. Say "Alexa, open Naval bot." https://www.amazon.com/dp/B0894Y2ZJY/?ref-suffix=ss_copy Here are the step-by-step instructions for how to do it: https://shoutworks.com/heres-how-to-automatically-publish-tweets-to-amazon-alexa/
Hey I’ve come up with a few different ways of building line items (e.g. for an invoice) in Google Sheets via Zapier, and I’m sure there are people out there who have done this better than me. Does anyone have any best practices here? If I have a non-standard number of line items, and I’m using line item support to build the invoice from a template in Google Docs what’s the best way you’ve found to do this?
If you're updating a Google Calendar event, any fields that you fill in the Zap editor will overwrite the existing information in the event. Although this is generally what you want to happen when you update something, sometimes you might want to add to a field, rather than overwrite it. A good example is if you want to add attendees to an event in Google Calendar. If you set up your Zap so that it only has the new Attendee/s (see below for an example), then any existing Attendees will be removed!To append to the list of Attendees (to add to it, rather than change it), you need to include both the original Attendees and your new Attendee in the Update Event step. To do that:Add a Google Calendar 'Find Event' search stepEnter the relevant details so that the Zap can find the event that you want to updateAdd the current Attendee/s on one line Click the Plus sign to add another box for the Attendees and add the new Attendee in the new boxIf you do that, both the existing At
When using this trigger you will see the option is "Liked tweet by a specific user":There is not an option for "triggered when anybody likes one of your tweets", which I would imagine is the more popular use case.Then you get to customization and a specific user is a compulsory field:Quick hack: Just insert "@" into that field and you will get all your liked tweets
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.
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
Are you pulling phone number data in through a Zapier trigger and trying to format it before passing it into your Zapier action? I work at a scheduling company and was trying to solve this problem because people use all sorts of characters, like hyphens, periods, parenthesis, spaces, and so forth. To make sure all phone numbers are formatted the same way, we wrote a zap sequence that will work as an intermediary step between any two approved Zapier apps. The python-regex portion of this solution will strip out all the unwanted characters so that only a string of numbers remains. This solution works best if you are formatting phone numbers for a single country. If anyone gets through the article and has thoughts on how that could be improved, I’m all ears. I provide the regex script about halfway down the page, if you want to skip straight to it. Here’s a link to the medium article with instructions, explanations, and screenshots on how to set it up: https://medium.com/@ezra_695
Hello Again!Need to create a new Zap/Doc/Sheet/Slide, but don't want to waste time going to the homepage of the respective site, logging in, and then clicking 'Create a new X' or 'Make a new Zap'?Bookmark these links to auto-generate a new whatever you need and get straight to working!Zapier: https://zapier.com/app/editor/Docs: https://docs.google.com/createSlides: https://slides.google.com/createSheets: https://sheets.google.com/createWhat quick links do you use for other services?
So I made a Zap that reminds me every day at 3pm to stretch. I get a Slack message encouraging me to stretch, and I’ve added a 10-minute yoga video. I’m wondering if folks have ideas for how I can make this better! For instance, I was thinking about integrating my calendar somehow. I was also thinking about using Google Sheets to create a list of short Yoga videos, and have them attach to the Zap randomly. Get some variety in there. I’m curious if others have any thoughts! You can check out the Zap here: https://zapier.com/shared/a61511e8a48d79ccce17ff980e43a1e8eb6330d2
With Slack's new built-in automation tool Workflow builder... Meet Workflow Builder: the simple way to streamline tasks in Slack ...I've been thinking a lot about the ways in which we already automate tasks in Slack and possible new ideas along those lines. With Zapier being a fully remote company we rely on Slack for everything from team-wide announcements and project collaboration to water-cooler chat and sharing pictures of our pets! We use Zaps and webhooks to create bots to help us with tasks and also use third party apps to run things like stand ups and polls. How do you use Slack to automate things in your day to day life?
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!
Hi everyone, I was wondering how Zapier can help people who suddenly need to WFH right now. If you work remotely, do you have any Zaps that help you be a more productive remote worker? Do you have Zaps that help you stay organized? I would love to share these ideas on Twitter. If you share from your own account and tag Zapier, we would love to retweet you! If not, drop a link to your favorite Zap below and we can share it. Thank you!
If you're just getting into Zapier, you might be feeling a little overwhelmed wondering what to automate first. It's best to go for some easy wins - by building zaps that take care of the processes costing your business valuable time and money each day.In our latest blog post, we cover:Content alerts on SlackCreate a zap that triggers on new RSS feed items (from your company blog, or a service like Google Alerts) and posts them in your companies Slack channel so your staff can see what you're up to.Automatic posting to social media networksSpeaking of your blog, another great idea is to create another RSS-triggered zap that sends out your content to social media - by either directly connecting the likes of Facebook, Linked and Twitter, or going through a tool like Buffer.Content curationGet your team to start using Pocket (or similar) and connect it up to a Google Sheet so you have a list of content ideas to explore. After all, a good blog needs good content.Social alert
Try the below tips to help retrieve your Zapier emails:Check your email’s Spam folderTake a look in your Spam folder to see if the email has accidentally been sent there If you locate our emails, simply unmark them as spam and move them to an alternate folder (Inbox, Zapier, etc). This should prevent any future Zapier messages from being flagged by your email provider. You can also ‘whitelist’ the zapier.com domain so that any emails that end in Zapier.com will make it to your inbox. If your email is provided by your company, you may need to speak to your IT team about this.Search all of your emailsUse your email’s search function to look for any emails from an address that ends in ‘@zapier.com’. If you have rules that send emails to different folders, make sure that those from zapier.com are sent to your inbox. Confirm the correct email address is linked to your Zapier account:The email address used when you sign up for Zapier is your account email address. Zapier will send all alerts
Hey everyone!If you're a business owner that's just recently discovered Zapier, you might be looking for some simple, confidence-building zaps you can build that will save you time.In an effort to inspire you, Luhhu just published a blog post rounding up the 5 most interesting ones we could think of.You can read the post here: 5 super simple Zapier automations to save hours for your business each week To summarise:1. Share New Content Across Social Networks AutomaticallyA great way to improve your SEO and drive traffic, minus the hassle of having to switch between profiles all the time.2. Create Trello Tasks from Calendar Events, Typeform Responses and EmailsIf you're the sort of person who likes to see all their incoming action points in one easy-to-manage place, then this automation is for you.3. Advertise New Products in Your Store on TwitterWhy not build a little social hype around your product and drive sales?4. Capture Email Addresses from PayPal Transactions to Gr
Hey guys! I've received this question quite a bit: How do I take something like a lead, and sort it into a specific segment or group based off of something like company size? That's a pretty simple challenge if the groups are single entities like A, B, or C, just throw it into the Lookup table in Formatter!Now, what happens if those groups are arrays like 50-100, 101-250, 251-1000? Then it's suddenly more difficult because the Lookup Table can no longer handle it! In this video, I describe a different method for sorting into arrays that is easy enough for anyone to replicate, while also showing a neat way to test these sorts of situations! Enjoy!P.S. I know that you can use either a Code by Zapier step, or an external call to something like Google Sheets to get this done, but I wanted a solution that was self-contained and didn't required minimal coding knowledge :)
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 :P ).
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.