Are you and your team spending too much time on repetitive tasks? Are you tired of catching silly mistakes after itâs too late?
â
There's a better way, and it's easier than you might think.
â
With workflow automation, you can automate your teamâs tedious tasks and make sure that critical work is done the right way every time â and you donât even need to write a single line of code to do it.Â
â
In this post, weâre going to show you how to dive into the world of automation with one of the most capable and affordable solutions out there.Â
â
Read on to learn how to use Make, formerly known as Integromat.Â
Whatâs in this guide
Weâll begin by briefly explaining what Make is and how it works, and weâll show you how to build your first automated scenario.Â
â
There are three key skills youâll get from following along with this basic tutorial. Youâll learn how to:Â
â
⢠Connect apps together in Make to sync and transfer data.Â
⢠Transform and format data with functions.Â
⢠Control the flow of your automations with filters and conditional logicÂ
â
To demonstrate all of these skills, weâll use the following apps:
⢠Google Calendar
⢠Google Sheets
⢠Slack
⢠And of course, Make
â
To follow along, you can create free accounts for all of these apps â Make included.Â
â
Before getting started, youâll want to make sure you have some Calendar events and a Google sheet that you can use to play around with, as well as a Slack channel to send messages to.Â
â
Whenever possible, itâs best to build your automations and run tests with dedicated testing files, channels, folders, or other material.Â
â
After completing the tutorial in this guide, you'll be ready to build your first automated workflow to start saving time and reducing errors in your daily tasks.
â
Let's get started and see how Make can improve the way you work!
What is Workflow automation, and what is Make?
â
Before you start building in Make, we want to give you a brief overview of what Make is, and what you can do with it.Â
â
Make, formerly known as Integromat, is a no-code automation provider.Â
â
It lets you accomplish tasks in your web apps automatically without needing to write any code at all, leaving you with more time to think and less time mindlessly clicking on buttons.Â
â
â
There are several apps out there designed for workflow automation, like Makeâs main competitor Zapier, but this guide will be focused primarily on Make.Â
Compare automation providers like Make and Zapier on XRay.Tools
If youâd like to compare which tools can be automated on both providers, you can just do a quick search for your apps on XRay.Tools.Â
â
That will show you every trigger, action, and search available for your apps in Zapier and Make, among other options.Â
How automation works in Make
Below, you can see what an automation looks like in Make.Â
â
I
n Make, each automation is called a "scenario". A scenario starts with a trigger event, which is the event that will prompt the automation to run.Â
Then, one or more automated actions and searches will follow that trigger. These actions and searches can be in the same app as the trigger, or in totally different apps.
In most cases, you're probably going to use your Make scenarios to send and sync data across different software.
In the example that we'll be building today, our "trigger" is an event getting added to Google Calendar. Then, data from that calendar event is used to create a new spreadsheet row in Google sheets.
â
â
Finally, information about the event is passed to Slack for an instant alert. However, thanks to a handy little filter, the alert will only run if the event in question is scheduled to start within one week from the current time.
Simple or complex workflows
The scenario weâre going to demonstrate in this guide is very simple and linear, but Make scenarios can get much more complex and sophisticated.Â
You can add dozens of steps, branching paths, loops, and other tools to accomplish whatever you need to automate your workflows.Â
As we build this scenario, we'll show you a bit of formatting and conditional logic, but our main goal for today is to learn the basics so you can start using Make.Â
You can check out other videos in our Make playlist to learn more advanced techniques. These videos cover topics like routers, API calls, automating AI prompts, and more.Â
â
You can also sign up for our workflow design course to learn how to plan, implement, and deliver scalable automated workflows for your team and clients.Â
â
Now, itâs time to get ready to build your first scenario in Make.Â
Getting started with Make
Before we get started, be sure to sign in to all of the apps we're going to be using today: Make, Google Sheets, Google Calendar, and Slack. For this tutorial, free accounts will be fine on all of these apps.
Once you're all signed in, open up Make. Youâll see several options here, but for now, just click on 'Scenarios'.Â
â
â
Then, create a new scenario.
â
Adding a trigger
Every automation needs to start with a trigger, so add one by clicking on the pulsing plus button in the middle of the screen.Â
â
â
For this scenario, youâll want to add a trigger that watches your Google Calendar for new events.
After clicking on the plus button, you should see a long list of apps that Make can automate. There are about 2,000 total (and counting), so don't bother scrolling to try and find one.Â
Instead, just enter a search term (like âGoogle Calendarâ) to pull up an app instantly.
Adding a trigger to your automation
As soon as you enter a term, Make will show you a few options from the best match - in this case, Google Calendar.Â
â
â
But if you donât see the choices youâre looking for, just click on âShow more.â Then youâll be able to see every single choice you have for automating that app with Make.
â
â
At the very top of the list, you should see an option called âWatch Events.â
As you can see from the description, this will watch your calendar for new events and run whenever it finds one.Â
This is a perfect trigger for our automation, so select it to add the trigger to your scenario.Â
Configuring the trigger
Now that youâve chosen a trigger, you need to configure it by choosing an account to use, and adjusting several parameters to control exactly when your scenario runs.
Authorizing an account for automation in Make
The first step for setting up any module in Make will always be to authorize an account in the app you want to automate.Â
To automate one of your apps, like Google Calendar, you need to allow Make to access your account and perform actions on your behalf.Â
Click âCreate a connectionâ to add your first connection for an app.Â
â
â
For most apps, all youâll need to do is provide a name for your account and sign in. Then, youâll be able to authorize Make in your app with a single click.Â
However, sometimes, youâll need to provide additional credentials like a âClient IDâ and âClient Secret.â If thatâs the case, you can click on the âOnline helpâ link for more information.
â
Authorizing Google Calendar
For Google Calendar, you just need to provide a connection name. Be sure to make it unique and descriptive, so you can distinguish between different accounts that you connect.Â
â
â
Then, click âSave.â In the screens that follow, youâll see the permissions Make needs to automate your app.
â
â
The permissions required are extensive, but thereâs no need for concern. Make is a trustworthy application, and it only needs these permissions so it can perform the actions you program it to do in your automations.Â
In spite of requesting the permission to delete data in your account, Make isnât actually going to delete anything in your apps unless you build an automation with a âdeleteâ step.Â
After reviewing the required permissions, click âAllowâ to authorize Make.Â
Now, Make will access Google Calendar through the account you connected.
Choosing trigger settings
Next, letâs configure the key options for this trigger.Â
The choices for configuring a trigger in Make will typically let you narrow things down to get a little more specific about when the automation should run.Â
For this âWatch Eventsâ trigger in Google Calendar, we can start by choosing the specific calendar that Make should watch. You can just pick one from the dropdown.
â
â
Then, you can choose how Make will watch for events - by Created Date, Updated Date, the eventâs Starting Date, or the eventâs Ending Date.Â
For this scenario, go with âCreated Date.âÂ
â
â
You can leave âshow deleted eventsâ unchecked, and you wonât need to add a query. Adding a query would enable your trigger to search for a specific event by its title, like âAll-hands.â
â
â
To make sure your automation runs for every new calendar event, leave the query field blank. Along similar lines, check every event type in the list.Â
Finally, you can choose how many events can be processed at once when the automation runs.Â
â
â
You can set this to whatever number youâd like, but weâd usually recommend keeping it pretty low. That will usually make it easier to sort through the data as youâre running your tests.Â
Enter a number like 1 or 2, and click âOKâ to commit all of your choices.Â
Testing the trigger
Now, itâs time to test your trigger.Â
Testing your Make scenarioâs trigger will retrieve a real piece of data from your trigger app, and confirm that your trigger is working correctly as you configured it. That means that testing this âWatch eventsâ Google Calendar trigger will retrieve an actual event from your Google Calendar.
As soon as you close the configuration window, youâll be prompted to âchoose where to start.âÂ
â
â
If you donât see this pop up, you can always right-click on the trigger module and select âChoose where to startâ instead.Â
â
â
Then, youâll see a few options for selecting a starting point. For testing purposes, weâd suggest using âchoose manuallyâ the vast majority of the time.
â
â
It gets a bit tedious when youâre doing a lot of testing, but this process of âChoose where to startâ > âChoose manuallyâ is the most reliable way to control what test data Make uses, since it will let you pick the data you want from a list.Â
You can use any event you want to test with. In our example, weâll pick this test event that we created earlier in Calendar. Once youâve selected an event, click âOK.â
â
â
Your trigger is now ready to process the specified data the next time it runs, but you still need to make the trigger actually run to finish your test. To do that, just click on the âRun onceâ button to fire it off manually.Â
â
â
You should see a number appear over your trigger module after a successful test.Â
â
You can click on this number to see all the data your trigger retrieved, like the event summary, the start date, the end date, and much, much more.
â
â
All of this data can be referenced dynamically and transformed in subsequent actions in your automation. To see how that works, letâs add an action now to add a new row to Google Sheets containing some of this eventâs information.
Add an action to your scenario
Add a new action to your scenario. Once again, search for the app you want to use - in this case, Google Sheets. Then, click âShow moreâ to see all of the available actions.Â
â
â
Youâll notice that unlike Calendar, the options for Sheets are sorted into âActionsâ and âSearches.â Since triggers can only be used at the start of the automation, those are excluded from this list.
â
â
To add a new row, choose the âAdd a rowâ action. You should be able to use the same Google connection that you added for Calendar, though you will need to update the permissions.
â
â
You can also add an additional account if youâre using a different sign-in for sheets. Once youâve chosen and authorized your account, you can configure the action.
Configuring an action in Make
Whenever youâre creating data like this in Make, the first thing youâll need to specify is where you want to create that data.Â
In this case, youâll need to specify what Sheet the new row should be added to. Under âChoose a method,â the default âSelect by pathâ option will allow you to pick folders and subfolders until you find the file you want.Â
â
â
Weâd recommend switching this to âSelect from all.â
â
Then, you can choose the document you want to use by copying and pasting its ID, which can be found in the URL bar when you have the document open in your browser.Â
â
â
Then, paste the ID into Make.
â
â
Using an ID isnât necessary â you can always identify the doc by its file path if you want â but it helps ensure that everything stays consistent. File names and locations can change, which may require you to update your automations. However, the documentâs ID will always remain the same.
Next, choose the sheet you want to use in this file - in this case, thatâs Sheet 1 for us.
â
â
If your table has headers, like our example does, make sure the âTable includes headersâ option is set to âyes.â That will ensure each column is correctly labeled with its header name, like âStartâ rather than just being âBâ or âC.â
Now, you can map data from the trigger into each column for the new row. Click on each field, and a window will pop up with all of the data retrieved in the trigger, or Step 1 as itâs labeled here.Â
â
â
For example, weâll insert the event summary into âEvent name,â the start and end times into their fields, and so on.
If you want to skip any of these fields and leave them blank in Sheets, just leave them blank here, too. Note that youâll see every column in your sheet, even if it doesnât have a title, so you might want to delete extra columns before going into Make.
Finally, you can choose whether to use formatted or unformatted data.Â
â
â
For this automation, weâre going to stick with formatted data so our URL in the âHangout Linkâ column will still be formatted as a URL. Once youâve configured the action, click âOKâ to close this window.
Testing an automated action
With the action all set up, itâs time to give the scenario another test.Â
Weâd recommend following the same procedure as before to test your scenario: right-click on the trigger, select âChoose where to Start,â âChoose Manually,â and pick the data you want to use for the test.Â
â
â
Then, click âRun onceâ to run the whole scenario.
â
â
You should see the trigger and action modules run one at a time, and numbers will appear over each of them in turn. Again, you can click on these numbers to see the data the module processed.
In the image below, youâll notice there are two âbundlesâ listed in this âoperationâ. Thatâs because our scenario processed two events - the one that we chose to start with, and an additional event that was added to the calendar after our chosen event.Â
This means that our trigger ran once and retrieved two Calendar events, prompting the Sheets action to create 2 rows. Since two rows were created with two different sets of data, weâll be able to show you exactly how dynamic data works.Â
â
â
Next, open up your Google Sheet to see what Make created.Â
â
â
Over in Sheets, there are 2 new rows with data retrieved from the respective events. You should note that Sheets includes the correct, unique information for each event.
Thatâs why we call it âdynamicâ data. Instead of typing out a static title or start date, we told Make to just look for the title and start date of each specific event. The data that gets filled in here reflects each calendar event that runs through our automation.
After running your tests, your first automation in Make is all set. You can save it and turn it on if youâre ready to start using it.Â
In the next section of this guide, weâll show you a few ways to improve this automation, but first, letâs take a look at operations and scheduling.Â
Scheduling your automation to stay within âoperationsâ limits
In Make, youâre limited to how many âoperationsâ you can use on your account each month. Every automated trigger, action, and search counts as a single operation, even if these are run as tests â and even if the trigger runs and doesnât find any new data.Â
On the free plan, youâre limited to just 1,000 operations each month.Â
In the bottom left hand corner, we can see the automation is currently set to run every day and check for new calendar events every fifteen minutes.Â
â
â
That means this automation will use at least 96 operations each day, seven days a week, even if it doesnât find any new events. This is because youâre charged an operation every time the trigger checks for new data. Using webhook triggers will let you circumvent this issue, which you can learn more about in this tutorial, but thatâs a more advanced topic.Â
For now, we can dramatically reduce the operations used by changing the schedule to every half hour, and by only setting it to run during business hours on business days.
Just click on the scheduling button (which will read âEvery 15 minutesâ by default) to change the schedule.Â
â
â
In the menu that pops up, you can set how often the automation will run. By selecting âadd itemâ under âAdvanced schedulingâ, you can also dictate which days and times the automation will run.Â
â
â
After reconfiguring the schedule in our example, the automation should now only check for new events 16 times a day, five days a week.
Your automation wonât start running on its own until you turn it on, but itâs best to set the schedule early on so you donât forget.
Going further with Make: advanced techniques
Transforming data with functions
While the automation that weâve built works fine, the formatting of the dates is less than ideal.Â
â
â
Fortunately, thereâs a very simple way to fix that in Make and reformat the dates however you want.
Go back to your scenario in Make and open up the âAdd a rowâ action. Then, select the start date field.
â
â
As youâve already seen, when you select any data input field in a Make module, a window pops up where you can access data from previous steps in the automation.Â
However, thatâs just one tab in this window. In the other tabs, you can access functions and tools that let you reformat text, dates, and numbers, run calculations, and a lot more.
â
â
Letâs try reformatting this date to make it a bit easier to read.Â
Click on the tab with a calendar icon, then look for the âformatDateâ function down at the bottom of the panel.
â
â
Hover over the function to see a tooltip explaining how it works along with a few examples.
Click on the function to add it to your currently selected input field.Â
Youâll need to put the date you want to format before the semicolon. Then, youâll need to provide the format you want to use after the semicolon. You can always refer back to the tooltip to confirm the syntax of the function.Â
In our example, weâll use this format:
MM-DD-YY hh:mm A
to show the month, day, and year separated by dashes, followed by 12-hour time.Â
To keep things consistent, weâll also use the same function for the end date.Â
â
â
Now, instead of entering the timestamps directly into Sheets, this automation will enter the outputs of these functions, which will be neatly formatted dates and times.Â
Once youâre all set with your functions, close the Sheets action and save your scenario with the floppy disk save icon. Then, give your scenario a fresh test.Â
Check Sheets to see the output. You should see a new row with start and end dates using our new format.Â
â
Conditional logic and filters
Thereâs one last thing we want to show you before we wrap up this beginnerâs guide. In general, one of the best things about automating a workflow is that youâll ensure it runs the same way every time, and youâll avoid all those messy human errors. But with a simple automation like this one, that extreme consistency can become a problem.
Thatâs because real-life workflows are rarely this simple. More often than not, youâll need to allow for at least some variation. Fortunately, Make offers several tools to give your automations some variability, including the ability to add filters before any automated action. The scenario will only continue to run past the filter if its data matches your filter conditions.
Letâs see how it works in action.Â
First, add one more action to this scenario. In our example, weâll add a Slack action to send a channel message. The message will act as an alert for each upcoming meeting.Â
Setting up this action is very similar to configuring the new row in Sheets, so weâll just show you the finished configuration in the screenshot below.Â
â
â
Note that the asterisks weâre adding around some words in the message are a simple formatting trick - theyâll make those words bold in Slackâs markdown syntax. Once your Slack message module is all set, you can add a filter before it.
What weâre going to do is make it so the scenario will only continue to the Slack step if the calendar event is set to start within a week from the current time. If itâs later than that, the scenario will just stop after creating a new row in sheets.Â
Adding a filter
To add a filter to a scenario, click on the dotted line between the two modules where you want to add your filter.
â
â
Youâll then see a little window pop up where you can configure your filter. Give it a brief, descriptive label so you know what itâs for.Â
â
â
Then, you can set the condition. This is what the filter is going to check to decide if it should continue or not.
We want to check when the start date is, so begin by entering the start date from the trigger.Â
Then, set an operator. Look under âdate time operatorsâ for the âEarlier than or equal toâ operator.Â
â
â
Now, you just need a way to specify âone week from now.â To do that, youâll need to ask Make to retrieve the current time, and add seven days to it.Â
Go to the calendar tab again and choose the âAddDaysâ function.Â
â
â
Before the semicolon, insert the variable called ânow.âÂ
â
â
âNowâ will retrieve whatever the current date and time is when the scenario is running.
After the semicolon, enter 7, for 7 days.
â
â
Now, this filter is set up to check if the eventâs |Start date| variable is |earlier than or equal to| |7 days| from now.Â
By clicking on âAdd AND ruleâ or âAdd OR Rule,â you can add more conditions for the filter to check, but letâs just stick with this one for now.
Click OK to close the filter, and give it a test.Â
Testing a filter
Weâd recommend conducting two different tests â one that should pass the filter and one that should fail.Â
In our example, weâll start with an event that starts in 2 days, which should pass the filter.Â
After running the test as usual it looks like all three modules ran, consuming 3 operations.Â
â
â
Below, you can see the new row added in sheets, and the message sent in Slack.
â
â
Now weâll test with this event that starts in 10 days.Â
In our test, the trigger and the Sheets module ran, but the scenario stopped at the filter and didn't send a Slack message. In total, it consumed 2 operations instead of 3.
â
â
Based on these tests, the filter makes the scenario stop when events are more than 7 days away, but lets everything else through. Itâs working exactly as intended.Â
Use routers to do more with filters
To get the most out of filters, youâll usually want to use routers as well so you can set up alternative actions for different conditions. You can check out this tutorial for more information about routers.Â
But for now, your first scenario is all set. You can now automate your apps with custom triggers and actions, transform data with functions, and control the flow of your automation with filters. Youâre well on your way to automating your work and claiming back some valuable time.
Start automating your teamâs repetitive tasks with Make
With automation software like Make, you can remove tedious, repetitive tasks from your teamâs everyday workload, and focus more time on the work that really matters.Â
What weâve gone over today is just the beginning of what Make can do. Be sure to check out some of the other tutorials on our blog or our YouTube channel to learn more and level up your automation skills.Â