Read about creative workflows, awesome app tips and interesting use cases.
- 296 Topics
- 487 Replies
Welcome back, Zappers! This is our 5th installment in the Formatter Features series and today we’re going to be looking at how to use Formatter to alter date formats. Missed the first five? You can check them out here:What We’ll be CoveringFixing dates that are in the wrong formatDates aren’t always sent from one app in a format that other apps are expecting, which can cause the day and month values to be swapped around!Custom Date FormatsThere may be times when the date format you need isn’t one of options available to select, so you’ll need to use custom date variables to create a custom date format.Extracting the time from a dateSometimes we’ll receive both a date and time value in a field, but we only need the time. With a Formatter step we reformat it to extract just the time.Converting Unix timestamps into readable datesUnix timestamps are a nice way for a computer to reference a date and time in seconds, but for us humans, they aren’t so easy to understand!How to use Formatter t
Hey friends! This week I want to show you a neat way to use a Zap to help streamline the process of finding new content ideas on Twitter.The challenge The Solution In a hurry? Setting up the Trigger Setting up the Digest Setting up the Notifications Wrapping UpThe challengeWe’re all busy people and Twitter is...well to be honest, all social media can be a noisy, distracting place. It’s so easy to get sucked in and end up spending hours looking at other people’s tweets on Twitter only to realise it’s now the end of the day and you’ve barely ticked two items off your to do list today.Instead of scrolling hundreds of tweets on Twitter looking for content inspiration or things to share to your other social media accounts wouldn’t it be great to have a Zap do all the leg work for you and send you a list of relevant tweets to review? Yep, that’s what I thought too.The SolutionFor this challenge I’m going to go over how to set up a Zap that runs a search for new tweets matching specific s
If you’ve been around the Zapier Community, you’ve almost certainly come across our first member spotlight guest, Troy Tessalone. Troy is one of our community’s most beloved and active members, along with being a top Certified Zapier Expert!We sat down with Troy to learn more about how his company, Automation Ace, has scaled with Zapier and how he views community engagement:—----------------------------------------------------------------------------How did Automation Ace come to fruition? What's the story behind Troy?I've always been interested in technology, the internet, and puzzles, but didn't expect to get into online freelance consulting. I had been working in technical product management at startups for 10 years, and was ready for a change.While taking some time off to travel, I thought about what capabilities I had that I could offer while crafting a lifestyle career. I knew I was good with learning how to use apps, applying logic, and optimizing operations.I clued into the no-
Deb here, from the Zapier blog. I use Coda for my organizational documents (is that what you call them?), but I'm starting to think I might have jumped on the wrong bandwagon, because Team Notion is gaining a ton of steam. Last week, I had three freelancers pitch me "How I run my business on Notion." Earlier this week, we published an article by someone who actually uses Notion as her to-do list. Apparently that's not the best use of Notion, but she came up with a template that works for task management, and she was kind enough to share it with us:How to use Notion as a to-do list (with template)Whether they're using Notion for their to-do list, their personal projects, or to run their entire business, Notion users seem to agree: set some Zaps up. Here are a few ideas to get you started, along with a Notion expert's take on what's worth automating. How to use Zapier to automate Notion How a Notion expert automates his workspace Are you Team Notion? What do you use it for? And how do
Hi, I’m Clint, a Customer Champion at Zapier! I’m obsessed with Google Sheets, Zap loops, and automating all the boring parts of life. This Wednesday, I’d like to discuss using Digest to save small updates, and then releasing them once per month as a larger newsletter.The ChallengeThis was actually a personal goal - I have a lot of silly little creative projects, and most of them are in totally different places. What I would like to do is to save all of these small things into one spot, then let folks know about all of them at the beginning of the next month.The problem is that I am very forgetful! So instead of trying to remember everything I did in a month, I would like to be able to save all of these as little bullet points as soon as I am done with them. Then I can use a Zap to put it all together into a single newsletter.The SolutionIt’s Digest! Digest is one of our internal apps, and a very interesting one indeed. It lets you save multiple pieces of information over time, then re
A couple of members of the Zapier Community team (myself and @Danvers) recently partnered with Asana to run a joint webinar about how to make use of the two apps together. The following goes into more detail than the brief overview we gave during the webinar.Here are some ways you can take your Asana to the next level by using Zapier :)1) Add tasks to projects/sections dynamicallyWe’ve had members ask us in the past if there’s a way to add tasks to specific projects/sections based on something that comes through the trigger step. I remember one example where the trigger was Typeform, and depending which option was selected in one of the form fields, they wanted to create the tasks dynamically in the appropriate area.There are a few ways to accomplish this:Option 1: Using 2+ Zapsclick to enlargeWhen using multiple Zaps with Filters, you decide which conditions you want to set, and each Zap has a different outcome. In the example above, one of the could be for when firstname.lastname@example.org is an
We recently had a community member who presented us with a bit of a tricky issue:I would like to have weekly zapier rollups created using the information in this view but ONLY for items which are currently in the view – NOT for items which may have passed into and then out of the airtable view sometime over the course of the week. So, in other words, they’d like to get a digest of items that are in a particular Airtable view at the time of rolling up those digest items to send.This one stumped me at first because we’re not able to remove items that have been added to a digest. So triggering on a record being added to a view won’t help us because once it’s in the digest, it’s there permanently, regardless of whether it has since left that view in Airtable.My next thought was to use Storage by Zapier, adding child values for each record, then removing the value when that record entered another view (that would, by definition, mean it had exited the other view). This didn’t work out becau
Hi there, it’s Deb from the Zapier blog. It’s Thanksgiving week, and it’s gonna be a tough one for almost everyone. I’m feeling especially grateful this year that I’ll be able to spend time with my husband, kids, and dog; that we’re all healthy; and that we can have a meal all together.Lots of folks aren’t as lucky—and not just at Thanksgiving. At the beginning of the pandemic, Rhiannon Menn was looking for a way to support the families in her community while still following stay-at-home orders and keeping her family safe. She decided to deliver meals to local moms who were struggling. From there, thousands of other volunteers joined in to help—and now her nonprofit, Lasagna Love, is delivering meals to families all over the country. In order to scale, Rhiannon used Zapier to automate a lot of the tedious work. Learn more about Rhiannon, Lasagna Love, and Zapier here:How a one-woman nonprofit scaled to deliver thousands of meals to people in needWe have lots of other customers using au
Hey hey! Welcome to another Wednesday, and another workflow. This one consists of multiple ways to accomplish the same thing. Let’s say you want to run an action at random times, whether that’s throughout the whole day or even within a range of hours.Why would you want to do this? I can think of a few reasons:You want to create social media posts and make it look more natural and random You’re reposting from one platform to another and you don’t want the other accounts to repost right away You want to send someone messages (maybe love notes) throughout the day but not always at the same time. You want to receive a random cat GIF everyday, again at unexpected times You want the actions to take place during certain hours (maybe 9 to 5) even though the trigger could be earlierNOTE: these techniques can be used regardless of whether you’re using a Schedule by Zapier trigger or triggering your Zap from another app.Method 1: Use a Spreadsheet-Style Formula to Generate a Random NumberOur Form
Hi there! Tim here from the Zapier Support Team with a workflow idea. Background I’ve seen many users write in and ask for a Zap that can do the following: Trigger on a Schedule, like once per week, for example Pull in multiple rows from a Spreadsheet Check each row for a particular condition Run some actions for each row if that condition is met An example might be checking to see if there are any leads in a spreadsheet that haven’t replied to you and generating notifications saying that they need another reach out. I’ve also wanted a Zap that can do this from time to time, but it was a tricky problem that didn’t seem to have a solution. Recently I did find a way to do this that I’d like to share with you. This method works by leveraging the Airtable API in a Code Step, so to use it, your rows would need to be in an Airtable. If you’re not familiar with Airtable, it works and feels a lot like a Spreadsheet app, and also has database features for linking records to each
We have all sorts of diversity and inclusion (D&I) efforts going on at Zapier. Everything from unconscious bias training to allyship keynote speakers to KRs that reflect our D&I goals.Since we spend all our days thinking about how we can make apps work best for us, my colleague Dannielle thought about how folks could use Slack to help promote inclusive language. These days, most of us are living on Slack or another team chat app, so it’s a great opportunity to take advantage of its features to add to D&I efforts.Take a look at this article she wrote for details on how it works—and why.Promote inclusive language on your team with a simple SlackbotNow we’re on the hunt for other apps that have features that might help with D&I efforts. Any suggestions? Drop them in the comments so we can check them out!
Hi! Deb here from the Zapier blog with some thoughts on two apps that, until recently, very much confused me: Google Drive and Google Photos. Why are there two apps that do the same thing? Answer: there aren’t. They’re very different. I know this because I asked our staff writer Justin to write about them. Google Drive vs. Google Photos: What’s the difference?What I found super helpful about his explanation was that Google Drive is best for professional use and Google Photos is best for personal use. There’s more nuance than that, of course, but it was a helpful first step to figure out what should go where.Because Google Drive integrates with Zapier, it ends up extending its professional benefits too, making hs argument even stronger. For example, if you have a designer who emails you assets, Zapier can automatically upload them to Drive. Or you can automatically save all your business’s Instagram posts to Google Drive so you have them backed up. Which do you use? Google Drive or Goog
Hi! Deb here from the Zapier blog with a concept I’m really into right now.The best apps are really good at what they do—you don’t rely on them to solve all your problems, and you can just connect all your specialized apps with Zapier.But sometimes apps have uses you might not think of—and they’re worth trying out. For example, I use Google Sheets as my to-do list. Our staff writer Justin just wrote about another example: using Typeform for memos and tutorials. Take a look.Why you should use Typeform for memos and tutorialsWhat apps do you use for off-use tasks? Let me know in the comments!
Hey, folks! Janine here from the blog team, to share another automation inspiration tip for you. CRMs help people get work done. They organize and manage leads and contacts, help you track deals as they advance through the pipeline, and make it easy for team members to see information in one place. But keeping them updated can be a daunting task, and if you’re manually entering data, there’s always the chance for human error. Automation can help!Writer Chris Hawkins put together a piece about ways to use Zapier with your CRM to improve your team’s productivity and efficiency. Read the piece for ideas, and to see a hand-selected list of valuable Zaps you can use to:Improve sales workflows by automating parts of your contracting process, tracking leads, and creating contacts Strengthen marketing efforts by connecting your CRM with marketing automation, webforms, and social media Reduce information silos by streamlining notifications in team chat or connecting your CRM with task and proje
Hi! I’m Deb, one of the managing editors of the Zapier blog. I recently had the pleasure of chatting with some folks at Bonjoro, a video email app that helps you connect with leads and customers. I knew about Bonjoro—I’ve gotten video emails from businesses using it, and they’re awesome—but what I didn’t know was that the MVP for the app itself was built using Zapier.Check out CEO Matthew Barnett (aka “Papa Bear”) talking about how Bonjoro came to be, and how one simple Zap helped create their booming business.How one simple Zapier workflow created a multimillion-dollar businessIt continues to amaze me how many projects and apps are powered by automation. Are there any other apps you know that started with a Zap? Let me know in the comments, and maybe we can feature them on the blog!
Hey, folks! Janine here from the blog team. I wanted to share an article that feels timely, at least in my own life. We’re balancing work-from-home and school-from-home, and are entering a very busy celebration and holiday season for our family.It all feels like a lot. But there are some techniques I’m using to help keep me focused on what needs doing. Our writer Krystina Martinez put together a collection of useful Zaps aimed at fighting burnout. Included in the collection are Zaps that can:Set your status so your team knows when you’re available Tie your Philips Hue bulbs in with your calendar Schedule breaks and remind yourself to actually step away Remind you to take vacation time Filter information so you’re able to stay focusedAutomate healthy work habits and fight burnout One tip that’s not included in that piece is my favorite Zap to combat burnout: A bot that tells me to sign off Slack.Are there any Zaps you use for things like this?
If you’re one of the 2 billion people that use Google’s productivity suite, G Suite, then chances are you’re probably looking to be more productive, save more time, reduce stress, and otherwise maximize your usage of the products. Luckily, the Zapier blog has got you covered! Google Suite is comprised of Gmail, Docs, Calendar, Drive, and Meet. Below you’ll find links to blog posts about each of those. And if you make it to the bottom of this article you’ll find a little bonus :) 4 time-saving Gmail settings you didn't know you needed Deb Tennen, Denior Editor at Zapier, offers four quick Gmail tweaks you can make that will help you to shave off a few clicks here and there. Who doesn’t love tips about how to better use email? In this blog post, she outlines how to: Send and archive with one click Default to reply all Enable the reading pane Use templates to create auto-replies Check out the full post on the Zapier blog. How to create Google Docs templates based on form respon
Hi! I’m Deb, one of the Zapier blog editors. The other day, I called into a meeting for the first time in almost three years. By called in, I don’t mean that I logged into Zoom on my phone and looked at everyone’s tiny faces. I actually dialed a number and used my phone as an actual phone to participate in the Zoom call.It was amazing. Give your video brain a break: Join Zoom by phoneNow that Zapier has a trigger for New Recording in Zoom, you can always have someone record the meeting, and it will automatically upload the recording to Google Drive or another app. That way if someone shared their screen or something, you can easily go back and take a look later. There’s really no downside.Have you tried calling into a Zoom meeting? How did it go? Any mishaps I didn’t think about? Let me know in the comments!
IntroductionHi there, this is Erin Oz from the Zapier Support Team with another workflow idea to share. Background InfoHave you ever wanted to create a Delay in your Zap that lasted longer than 30 days? Or, have you ever wanted to make changes to your Zap but you can’t, because you’ll break Tasks that are currently in a delayed status?Here’s how you can use Google Calendar to create better, more flexible Delays. Workflow ExampleA Zapier user would like to send a followup email to their clients booked through Acuity. They’d like to email to go out 45 days after the appointment took place, in order to prompt their client to book again. The user has created a calendar on their Google account called “45 Day Followup Email Calendar” that will only handle the events created for this workflow. This helps keep the Zap from triggering on other events by mistake and cluttering other calendars. This set up will require two Zaps: Zap 1Trigger - Acuity, Appointment StartFormatter - Set the Event St
Hi y’all! I’m Krystina, a content writer for the Zapier blog. I write about automation tips and tricks using our product. I know we’ve got quite a few Google Sheets power users in the house, so I wanted to share some helpful in-app functions you can use to save yourself a Zap step. I must confess, I am bad at formulas, so anytime I can use something like Formatter to handle something in a spreadsheet, I’ll go for it. However, if you’re trying to be economical with your tasks, or just want to simplify a complex Zap a little, my colleague Justin wrote about six functions that already exist in Google Sheets. From fixing capitalization errors to fetching data from other Google Sheets, check out these handy functions: 6 Google Sheets functions that do more than math
Hey, Community members!Janine here from the blog team with another idea for you, this time for how to use Zapier to help wrangle your short URLs.People use URL shorteners for the obvious reason—getting a short, clean link that’s easy to share—but there’s more you can do, especially when you connect your URL shortener with other apps using Zapier. We put together a blog post about Zaps you can use to help with things like:Automatically creating shortened URLs for new content you publish or products you add to your store Send all shortened URLs you create to a Google Sheet or other database for easy tracking Notify your team of new short URLs so everyone uses the same links Monitor link activity, like referrers or clicks Automatically share shortened URLs to social mediaCheck out the article for Zap templates you can use to get started with these workflows!Get more ROI out of your URL shorteners with these 4 workflowsAre there any things we missed in this article? Let me know in the comm
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.