Airtable Zapier Formula

How to Automate Your Life and Everyday Tasks with Zapier

Every day, we perform numerous little jobs. On their own, they don’& rsquo; t take much time. However they can build up, particularly if you consider that time for an entire year. However we’& rsquo; re technologists and it’& rsquo; s 2020. How can we use tools like Zapier to make robots

What can we make with Zapier Zaps?

The dazzling part about Zapier is each app combination makes its API readily available via Zapier to other app integrations providing you a ton of options to link and develop powerful workflows.

Especially, we're going to discover how to do a few things:

Sending out a text every morning if it's going to rain

Set up a weekly print job to keep your ink fresh

Receive e-mails for new jobs on Smashing Magazine's job board

While each of these jobs are little, they wind up saving you a great deal of time. And if you're imaginative, you can build on these workflows to tailor a lot more.

What is Zapier?

Zapier is an automation tool that links all of the apps you like and constructs powerful totally automated workflows. Whether it's automating sending an email or making certain that brand-new blog post gets a tweet, we can get rid of the manual actions of ordinary jobs to focus on other things that art essential.

Each time you develop a brand-new workflow, you're creating a “& ldquo; Zap & rdquo;. It's basically Zapier's method to provide a name to the workflow you create.Getting going with a Zapier account

Before we enter establishing workflows, you'll require an account.

Signing up for Zapier is totally free and you get 5 free Zaps to start, so we do not have to fret about cost here.

Now let's get into the Zaps.

Zap 1: Get a text if it's going to rain with Zapier

To get an idea of how this works, we'll start with something easy. We're going to set up a Zap that will send us a text if the weather forecasts rain.

To get going, click the huge Make a Zap button on the top left of the page when you're logged into your account.

Making a brand-new Zap Here, Zapier wants to know the first app we wish to link. Given that we're going to base our Zap on the weather condition, look for “& ldquo; weather & rdquo; and choose Weather condition by Zapier. Selecting the Weather condition by Zapier combination It will then ask you to select a Trigger Event, where you'll pick “& ldquo; Will It Rain”Today? & rdquo;, then you can click the Continue

button. Choosing the Will it Rain Today? event When selecting Weather condition as an event, it requires a bit of information to give us a personalized forecast. Particularly, it requires your Latitude and Longitude, which we can search for using latlong.net Finding latitude and longitude with latlong.net You can then enter your Latitude and Longitude into the Customize Forecast screen of Zapier, select your Systems which defaults to Fahrenheit, and then click the big Continue button.

At this moment, you can click Test Trigger, which simply ensures it's working, and click Continue once again.

Now we're going to tell Zapier what to do with the information once it understands it's going to rain.

In the Do this ... panel, search for “& ldquo; sms & rdquo; and choose SMS by Zapier

. Picking SMS by Zapier We're going to leave the App and Event as the defaults, so the next screen you can just click Continue.

SMS App and Event Now, for Zapier to send you a text, it needs to confirm that your contact number belongs to you or that the contact number is intentionally registering for these texts. To do that, it sends you a one-time PIN that you'll enter.

So click Sign in to SMS by Zapier, which will open a popup window.

Here, enter your phone number, and pick Sms or Call as the verification method at which point it will call you with a PIN.

Check in to SMS by Zapier and send a PIN With that PIN, enter it into the field and click Continue.

Getting in the SMS verification PING At this point the window will close and move you back to the initial flow. Here, click Continue again.

Now we get to personalize the text that we receive.

In the From Number field, Zapier offers a lot of contact number you can use. You can either pick one number to always send from, which you can set up as a contact so you know it's Zapier, or you can select Random, which will utilize a random number whenever.

Then, click inside of Message, and it will bring up some options. I would like to know whatever possible if it's going to rain, including the probability, max temperature level, and summary, so we can pick all or as much as we desire and again click Continue.

Setting up Weather message Finally we get to check if our Zap worked. At this moment whatever must be set up, so click the Test & & Review button and you should receive a sample text!

Keep in mind: If you select a single From Number, you may be restricted in how frequent you can receive texts, so if you don't get it immediately, that might be why. Setting random helps prevent that concern, but the the number isn't consistent.

And when you're happy with the configuration, you can click Switch on Zap.

Turning on the SMS Zap You'll now get texts in the early morning if the weather is anticipating rain!

Zap 2: Print a test weekly with Google Cloud Print

This one does not sound interesting, however have you ever gone through a long period of time where you didn't print something, only to end up with dried printer heads or worse yet, a now unsalvageable printer?

We can avoid this by merely running a weekly print job that keeps our printer ink great and fresh.

For this, we'll use Google Cloud Print. To make this work, you'll require to already have this configured with your Google account.

Let's create a new Zap and this time for our “& ldquo; When this takes place & hellip;” & rdquo; search for and select Schedule by Zapier.

Picking Schedule by Zapier We can then choose a Trigger Occasion of Each week and click Continue.

Setting Trigger Occasion as Weekly Next, you can pick the Day Of The Week and Time Of Day you wish to print. I personally run this job weekly at 8pm on Sundays right before the start of a new week. As soon as configured, click Continue.

Setting up Zapier schedule At this moment, we can click Test trigger, which just like before makes certain it's working appropriately, and then we can click Continue.

Now, for our “& ldquo;” Do this & hellip; & rdquo; we wish to print, so search for and select Google Cloud Print

. Choosing Google Cloud Print And for the action, choose Submit Print Job.

Setting Submit Print Task as Action Occasion At this moment, you'll need to sign into Google Cloud Print. This will open a window and have you log in through Google so that Zapier can user interface with the service.

As soon as connected, click Continue.

Now we can configure out print job. Here we'll wish to specify what we print.

Setting Up Print Task in Zapier In the above, we're configuring:

Which Printer: the printer we wish to print to connected to Google Cloud Print

Material: this can be a URL to a document, HTML, or plain text. I'm utilizing a URL which is a basic test page I made that has some color in it

Material Type: you'll wish to set this depending upon what you set in Content. If you set a URL like I did, it ought to be URL

Title Of Print Job: the name of the task so you can see it in the print logs

Number of Copies: probably just want 1 so it does not squander ink and paper

Color or Monochrome: you'll wish to clearly set this if you desire color. The idea is to revitalize all of the ink cartridges, so just printing black will not assist the color ink, so in my case, I picked color

The remainder of the fields are optional, feel free to customize to your liking.

With our configuration set, click Continue, and comparable to in the past, we can click Test to see our print job in action and if we enjoy, we can click Turn on Zap!

Test print from Zapier print task If you want to use the same document, you can discover it here:

https://fay.io/printer-test.pdf

Zap 3: Smashing Magazine Job Notifies with Gmail

If we're searching for a job, it can be a pain to need to visit every job board every day (or every hour, am I right?). However we can automate this process when the task board supports it.

Luckily, task boards like Smashing Magazine and a great deal of others offer RSS feeds which we can hook right in to Zapier to automate getting an email whenever a new task is posted.

To begin, let's create a brand-new Zap, and this time, look for RSS and select RSS by Zapier.

Selecting RSS by Zapier For our Trigger Event, select New Product in Feed, then click Continue.

Setting New Product in Feed as Trigger Event At this point, we wish to go into a feed URL. This will be the URL to the XML RSS feed that websites provide. For Smashing Magazine, you can find it here:

So get in that URL above into Feed URL (you can leave Username and Password blank), and keep Different GUID chosen for What Triggers A Brand-new Feed Product. Then click Continue.

Setting RSS Feed URL Like usual, now you can test the trigger to make certain it works. If the RSS feed stands, this will be smooth, otherwise you may see a mistake. The above URL needs to be valid!

Checking the RSS feed Next, we need to choose what we wish to make with the brand-new product. Since we want it emailed, we can pick our email service, which in my case is Gmail.

Choosing Gmail in Zapier For our action, we want to Send out Email.

Setting Action Event as Send Email Next, you want to sign in to your account, similar to what we made with Google Cloud Print. This ought to be your Google account that you utilize Gmail with.

Sign in to Gmail Now when we personalize our e-mail, we wish to include the following:

To: any place you want these sent to, most likely the very same account you signed into Gmail with

From: choose your Gmail account

From Name: can be anything you'll recognize, like I'll utilize Colbybot

Topic: can be whatever you 'd like, but a valuable idea could be “& ldquo; New Task Alert: followed by selecting the title from the dropdown choice

Physique: you can leave as Plain

Body: I would advise consisting of all tokens you'll find helpful consisting of the Title, Description, and Link

Configuring task notice email Once you're done setting up, you can strike continue. Then, similar to previously, click Test & & Review, and you need to get your test e-mail.

Test job alert email Finally if you enjoy with the setup, switch on the Zap, and enjoy your task search!

More Concepts

Here's more ideas to get you moving in the right instructions:

Post Tweets to Slack: each time an account tweets or somebody from a list of accounts tweets, post that tweet to Slack

File Github Bugs to Jira: whenever somebody tags a Github Problem with a label of “& ldquo; bug & rdquo;, develop a brand-new ticket in Jira with that Problem information

Post RSS Products to Twitter: do you compose your own content? Establish an RSS feed to automatically post a tweet with your brand-new article

Not Google Assistant

The only thing that it's missing out on for me right now is Google Assistant, otherwise I would have consisted of some Zap concepts for that.

IFTTT supports Google Assistant for simpler flows, but Zapier can get more effective.

Webhooks

Zapier supports web hooks indicating you can truly do whatever you desire. Though this is a premium feature, you can establish some custom workflows based off of new data Zapier sees or accept demands that you post to activate other automations.

What's your favorite Zap?

Love hearing brand-new innovative ways to use Zapier.

Show me on Twitter!

Airtable Zapier Formula