Airtable To Google Sheets Zapier

How to Automate Your Life and Everyday Tasks with Zapier

Every day, we carry out numerous small tasks. On their own, they wear’& rsquo; t take much time. However they can build up, particularly if you think about that time for a whole year. But we’& rsquo; re technologists and it’& rsquo; s 2020. How can we use tools like Zapier to make robotics

What can we finish with Zapier Zaps?

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

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

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

Establish a weekly print job to keep your ink fresh

Get e-mails for new tasks on Smashing Magazine's job board

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

What is Zapier?

Zapier is an automation tool that links all of the apps you enjoy and develops effective totally automated workflows. Whether it's automating sending an e-mail or making sure that new post gets a tweet, we can eliminate the manual actions of ordinary tasks to concentrate on other things that art important.

Each time you produce a new workflow, you're producing a “& ldquo; Zap & rdquo;. It's essentially Zapier's way to provide a name to the workflow you create.Getting going with a Zapier account

Prior to we get into setting up workflows, you'll need an account.

Signing up for Zapier is complimentary and you get 5 totally free Zaps to begin, so we do not have to fret about expense 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 simple. We're going to set up a Zap that will send us a text if the weather predicts 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 new Zap Here, Zapier wishes to know the first app we want to connect. Considering that we're going to base our Zap on the weather, search for “& ldquo; weather condition & rdquo; and choose Weather by Zapier. Picking the Weather condition by Zapier combination It will then ask you to pick a Trigger Event, where you'll choose “& ldquo; Will It Rain”Today? & rdquo;, then you can click the Continue

button. Selecting the Will it Rain Today? occasion When picking Weather as an event, it needs a bit of information to provide us an individualized forecast. Especially, it needs 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 Units which defaults to Fahrenheit, and after that click the huge Continue button.

At this moment, you can click Test Trigger, which merely makes sure it's working, and click Continue once again.

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

In the Do this ... panel, look 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 verify that your phone number comes from you or that the phone number is purposefully signing up for these texts. To do that, it sends you a one-time PIN that you'll enter.

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

Here, enter your telephone number, and select Sms or Call as the confirmation approach at which point it will contact 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.

Going into the SMS confirmation PING At this moment the window will close and move you back to the initial circulation. Here, click Continue again.

Now we get to tailor the text that we get.

In the From Number field, Zapier gives a lot of telephone number you can use. You can either choose one number to constantly send from, which you can set up as a contact so you know it's Zapier, or you can choose Random, which will utilize a random number each time.

Then, click within Message, and it will raise some choices. I wish to know everything 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 once again click Continue.

Configuring Weather condition message Lastly we get to test if our Zap worked. At this point everything need to be set up, so click the Test & & Review button and you ought to receive a sample text!

Keep in mind: If you select a single From Number, you might be restricted in how frequent you can receive texts, so if you do not get it right now, that may be why. Setting random assists prevent that issue, however the the number isn't constant.

And once you enjoy with the configuration, you can click Switch on Zap.

Switching on the SMS Zap You'll now get texts in the morning if the weather is forecasting rain!

Zap 2: Print a test weekly with Google Cloud Print

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

We can prevent this by just running a weekly print job that keeps our printer ink good and fresh.

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

Let's create a new Zap and this time for our “& ldquo; When this happens & hellip;” & rdquo; look for and choose Schedule by Zapier.

Choosing Arrange by Zapier We can then select a Trigger Occasion of Weekly and click Continue.

Setting Trigger Event as Each Week Next, you can choose the Day Of The Week and Time Of Day you want to print. I personally run this job weekly at 8pm on Sundays right prior to the start of a brand-new week. As soon as configured, click Continue.

Configuring Zapier schedule At this point, we can click Test trigger, which just like in the past ensures it's working effectively, and after that we can click Continue.

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

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

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

When linked, click Continue.

Now we can configure out print task. Here we'll want to specify what we print.

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

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

Content: this can be a URL to a file, HTML, or plain text. I'm using a URL which is a simple test page I made that has some color in it

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

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

Variety of Copies: most likely just desire 1 so it does not lose ink and paper

Color or Black and white: you'll wish to explicitly set this if you want color. The concept is to refresh all of the ink cartridges, so just printing black won't assist the color ink, so in my case, I chose color

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

With our configuration set, click Continue, and comparable to before, we can click Test to see our print task in action and if we're happy, we can click Switch on Zap!

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

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

Zap 3: Smashing Publication Task Informs with Gmail

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

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

To begin, let's produce a new Zap, and this time, search for RSS and select RSS by Zapier.

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

Setting New Product in Feed as Trigger Event At this point, we want to go into a feed URL. This will be the URL to the XML RSS feed that sites make available. For Smashing Publication, you can find it here:

So enter that URL above into Feed URL (you can leave Username and Password blank), and keep Different GUID chosen for What Sets off A New Feed Product. Then click Continue.

Setting RSS Feed URL Same as typical, now you can check the trigger to make sure it works. If the RSS feed stands, this will be smooth, otherwise you may see an error. The above URL ought to be valid!

Evaluating the RSS feed Next, we need to select what we wish to do with the brand-new product. Because we desire it emailed, we can pick our e-mail service, which in my case is Gmail.

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

Setting Action Event as Send Out Email Next, you want to sign in to your account, comparable to what we finished with Google Cloud Print. This must be your Google account that you use Gmail with.

Sign in to Gmail Now when we personalize our email, we wish to include the following:

To: wherever you want these sent to, probably the very same account you signed into Gmail with

From: choose your Gmail account

From Name: can be anything you'll acknowledge, like I'll use Colbybot

Topic: can be whatever you 'd like, but a helpful idea might be “& ldquo; New Task Alert: followed by choosing the title from the dropdown selection

Body Type: you can leave as Plain

Body: I would recommend consisting of all tokens you'll find handy including the Title, Description, and Link

Setting up job notification email Once you're done setting up, you can strike continue. Then, similar to before, click Test & & Review, and you ought to get your test email.

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

More Ideas

Here's more ideas to get you relocating the right direction:

Post Tweets to Slack: whenever 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 Issue with a label of “& ldquo; bug & rdquo;, create a new ticket in Jira with that Concern details

Post RSS Products to Twitter: do you compose your own material? Establish an RSS feed to immediately post a tweet with your new blog post

Not Google Assistant

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

IFTTT supports Google Assistant for easier flows, however Zapier can get more effective.

Webhooks

Zapier supports web hooks indicating you can actually do whatever you desire. Though this is a premium feature, you can set up some custom-made workflows based off of new data Zapier sees or accept demands that you publish to activate other automations.

What's your favorite Zap?

Love hearing new innovative methods to use Zapier.

Share with me on Twitter!

Airtable To Google Sheets Zapier