Popular automation app Tasker today received a new plugin, called AutoSheets, that will let you easily automate spreadsheet editing on Google Sheets. The new plugin comes a few weeks after Tasker received an update on the beta channel that introduced a new feature to help users create custom sleep trackers.
As per a recent blog post by Tasker developer JoГЈo Dias, the new AutoSheets plugin will let you automate just about anything in Google Sheets. The plugin supports a wide variety of actions at launch, including:
- Add Rows: append rows of data to the end of a sheet or insert them somewhere in the middle of the sheet
- Add Sheet: add a new Sheet (tab) at the bottom of your spreadsheet
- Create Spreadsheet: create a whole new spreadsheet
- Delete Cell Content: clear the contents of cells without actually removing lines of columns from the sheet
- Delete Rows/Columns: remove rows and columns from sheets along with their content
- Duplicate Sheet: Create a new sheet inside a spreadsheet which is a copy of an existing sheet
- Format Cells: change the appearance of cells on your sheets like background or text color
- Get Cell: a simple way to get the value of a single cell on your sheet based on its location or the value of a cell on a different column (great for Cloud Variables)
- Get Data: get multiple rows/columns of data at the same time. Optionally name the output data as multiple arrays for easier data parsing
- Get Spreadsheet: get info on a spreadsheet itself like its ID, sheet names, etc
- Insert Empty Rows/Columns: Simply insert new rows/columns with no content
- Update Cells: update the content of cells without inserting any new rows/columns
The following video shows how you can use the aforementioned actions to log events in a spreadsheet automatically:
You can use the AutoSheet Tasker plugin to log notifications from specific apps on your phone automatically. For example, you can use it to log notifications from your banking apps to keep track of your daily expenditures. It can also be used to automatically log fitness data, home automation data, and location data. Furthermore, experienced Tasker users can utilize the new plugin to store Tasker Variables in a spreadsheet.
Want to give it a shot? Check out a few sample AutoSheets projects to get a feel for the plugin by following this link. If you’re new to the automation app, make sure to check out our Tasker forums for tips and tricks that will help you make the most of it.
- General Development
- Head Units
- Android Auto General
- Mar 26, 2019 at 12:01 AM
- Mar 26, 2019 at 12:54 AM
- Mar 26, 2019 at 3:48 PM
In my case, here the sequence :
1. Car BT detected
2. Data ON > Hotspot ON
3. Car BT not connected
4. Hotspot OFF > Data OFF > wifi ON
In details. quoted on XDA
In tasker :
1. New Profile -> State -> Net -> BT Connected
2. New Task -> Plugin -> Toggle Tethering -> Click Config Pencil -> Enable Tether -> Open setting buttons below -> Toggle Allow modify system settings
3. Go back, don’t worry about clicking Install app to system and go back again, and back one more time -> Click the play button at the bottom left to test to see if it works. Prosper! (Don’t turn tethering off just yet)
4. Go back to profiles, and long press on the Toggle Tethering Enable tether task and click Add Exit Task
5. New Task -> Plugin -> Toggle Tethering -> Click Config Pencil -> Click Disable Tether radio button -> go back 2 times -> click the play button at the bottom left to test to see if tethering has been turned off.
- Mar 26, 2019 at 10:30 PM
I dont want to use BT, I made it. is not full tested but think its works. With that I turn off BT after hotspot is on and again turn on BT and he dont reconnects more.
Enviado desde mi Pixel 2 XL mediante Tapatalk
- Mar 29, 2019 at 2:23 PM
Very good thread. By reading it I discovered that I can make my life easier.
I have a new peugeot 3008 with android auto and the next setup :
– my main phone (not rooted) is in my pocket, with bluetooth on, paired with the car. I don’t use it for android auto, just for calls and media streaming. When I’m in the car I just keep it in my pocket. When I start the engine it automatically connects to the car’s bluetooth.
– my “entertainment” phone – always connected via usb to my car’s media unit. It’s a rooted phone without any sim inside. I have wireless on all the time, and I make a hotspot from my main phone to have internet on this rooted phone. Being rooted – I’ve disablet the bluetooth completely, because android auto would have forced the bluetooth connection to my car from this usb connected phone. And I don’t want that, I want to connect to the car’s bluetooth just with my main phone, from my pocket (because I want to benefit from hands free voice calls from my main phone – where I have my contacts and a sim card, plus other reasons . the car sends trip statistics after every engine shut down). Off course, on this rooted phone I have installed carstream and aa mirror.
Until now, everytime I entered the car, when I needed internet on my “entertainment” phone I had to reach from my pocket phone and manually activate hotspot, and than, in about 15 seconds my “entertainment” phone automatically connected and all was ok.
After reading this thread I’ve discovered a little app called “Automate” and I’ve used it to automate the process of activating hot spot.
So now I don’t even need to reach out to my pocket phone . I just enter the car, start the engine and that’s it.
The logic of the flowchart is :
– check if the bluetooth is connected to my car ; if yes – than enable hotspot ; if not – disable hotspot.
The automation is running on my main phone, and I use the fact that when I go into my car – the main phone connects automatically to the car’s bluetooth (I off course have to keep bluetooth on all the time on my main phone, but I had it on anyway).
The result is that I start the car (actually the multimedia unit of the car is the trigger) – my main phone auto-connects to car’s bluetooth, the automation flow immediately senses that and enables the main phone’s hot spot – and than the “entertainment” phone from the car connects to this hot-spot in about 15 seconds or less.
I turn off the car, I’m disconnected from car’s bluetooth – and the automation flow senses and auto-disable the hot spot.
Today, you can see everywhere is automation. We love when anything happens automatically without putting our manual labor. There is a wonderful app that automates tasks on your Android smartphones. You can use the Tasker app to automate your settings or actions. This article lists down the Tasker app tricks to automate your Android phone.
You might find the Tasker app a bit complex. This is because it does a very complex work. This guide will show you the best automation tasks or settings you can set with the Tasker app.
But, before we begin with the article, you must download the Tasker app from the Google Play Store. Use the below link to download and install the Tasker application on your Android smartphone. The Tasker app is available for INR199.99 or $3 at the Play Store.
Now, let us dig deep more into the best tips and tricks for the Tasker app but before doing that you may want to check out our older Tasker tutorials:
Automate Tasks on Android with Tasker
Now, below is our list of the tasks you can automate on your Android device with the help of Tasker app.
1. Silent Mode When Face Down
Whenever you are in a museum, theatre or in a dark place, fumbling with your phone to silent it can be annoying. You might also accidentally damage your phone. But, with the Tasker app, you can easily set this task for automation and silent your phone when you put it face down.
Follow the below steps to first set up a profile in the automation app;
- Open the Tasker app and go to the Profiles tab.
- Click the Plus symbol to add a new profile.
- Select State, and tap on Sensor. Then choose Orientation.
- Under the Orientation tab, tap the Face Down button. Then click on the “
When it comes to Android automation apps, Tasker has never had much competition. But considering how difficult it can be for a novice user to get the hang of things, and factoring in Tasker’s drab and complicated interface, there’s definitely room for another developer to step in with a Tasker alternative.
Enter MacroDroid by ArloSoft. With its Material Design UI and step-by-step approach to automating common smartphone tasks, it’s the Tasker competitor we’ve all been waiting for. So if you’ve always found Tasker to be more trouble than it’s worth, I’ll take you through the easy process of using MacroDroid below.
Step 1: Install MacroDroid
First things first, you’ll need to install the free app. The free app limits you to five macros, which may be enough depending on what you need, and displays ads, but you can fix both of these with pro version available in the app for $2.99.
Step 2: Create a Macro & Select a Trigger
When you first launch the app, you’ll be greeted by MacroDroid’s simple and intuitive interface. To start automating smartphone tasks, tap the “Add Macro” button here.
Next, you’ll be asked to select a trigger for your macro. This is an event that will kick off your automated action when it occurs, and options here range from incoming calls to changes in the weather. Once you’ve selected a trigger, you may be asked to specify additional options, but this should be self-explanatory.
Step 3: Choose an Action or Set of Actions
After selecting a trigger event, you’ll be prompted to add an action or set of actions that will be executed automatically. Simply choose any action from this list, then verify your choice. When you’re done there, you can even add more actions if you’d like. Either way, make sure to tap the check mark at the bottom of the screen when you’re done adding actions.
Step 4: Add a Constraint (Optional)
Next, MacroDroid will give you the option of adding a constraint to your macro. These are conditions that can either allow or prevent your macro from running in certain circumstances—for instance, when your battery is running low. This step is purely optional, so if you don’t need it, simply tap the check mark at the bottom of the screen.
Step 5: Name Your Macro
After you’re done with the “Add Constraints” menu, you’ll be prompted to name your macro. You can also put your macro into a category to keep things organized, but when you tap “OK” on this popup, you’ll be done with your first macro. To view the macro you just created, head to the “Macros” section from the app’s main menu, where you can easily turn the macro on or off.
Step 6: Use a Macro Template (Optional)
Next, take a moment to browse through the “Templates” section from MacroDroid’s main menu. This is a list of user-created macros that are preconfigured to perform many different tasks. If you find one that interests you, simply select it from this list, then MacroDroid will let you make a few tweaks if you’d like before importing it.
Step 7: Kick Back & Let Your Phone Do the Work for You
With everything set up, your macro will automatically kick in when the trigger event occurs, and you don’t even have to interact with your device when this happens. Ultimately, MacroDroid will automate mundane tasks to make your phone behave exactly how you want it, and it does all of this with an incredibly simple interface.
Keep Your Connection Secure Without a Monthly Bill. Get a lifetime subscription to VPN Unlimited for all your devices with a one-time purchase from the new Gadget Hacks Shop, and watch Hulu or Netflix without regional restrictions, increase security when browsing on public networks, and more.
There are many automation apps for Android on Google Play Store, but nothing comes close to the Tasker app. It is an application that provides total automation for Android devices. It automates everything on your device, from Settings to SMS, making life easier for Android users. For a small fee, you can use the Android Tasker app to trigger specific actions to run when the conditions are met.
There are so many things you can do with the Tasker app. You can launch your favorite music app once your earphones or speakers are plugged in. You can also send out a pre-composed message whenever you get to your office or school in the morning, lock your applications with a password, turn on Wi-Fi when you get home, set up Google Home Alarm, or even create weather notifications that will pop up every few hours. The possibilities are endless, and there are actions that you can do for rooted and unrooted phones.
The Tasker app works like an electrical circuit. When designing a circuit, everything has to be connected and defined to make it work. It is the same with the Android Tasker app. Certain conditions have to be met before a specific action is triggered. If one of these conditions is missing, then the task will not run.
You can create your tasks using Tasker, or you can handle other functions that have been shared with you using an XML file. These XML files can be easily imported into the app and can be used immediately without any need for further setup. You can download profiles for everyday tasks via Menu > Browse Examples.
You can download the Tasker app directly from Google Play Store, or you can get the one-week free trial first to gain an understanding of how the app works.
How to Use Tasker App
Tasker works by performing tasks or a basic set of actions based on certain conditions or contexts. These contexts can be time, date, application, location, state, event, gesture, voice command, shortcut, widget press, or timer expiry. The contexts are grouped into profiles, and once these contexts happen, the Tasker responds by executing the task.
For example, you want to set up a reminder whenever your phone’s battery runs out. You want to set up an action that notifies you when your battery is down to 10% so you can charge your phone. The notification task will only run when the phone’s battery is at 10%.
You can make these conditions more specific by adding other factors like time (between 6 AM to 6 PM) or location (when you’re at home). Only when these conditions are met will the task be executed.
This task is just one of the many things the Tasker app can do. There are many conditions you can choose from and more than 200 built-in actions you can trigger with those conditions.
The conditions are also categorized into different sections namely Application, Day, Event, Location, State, and Time. It means that you can add conditions like when you arrive home or you are in the office. When the display is on, or the display is off. When you missed a call, or when your email failed to send, or when you open an app, or when you connect your phone to another device and many other situations.
Once the conditions are connected to a task, these conditions are grouped into a profile. These profiles are tied to functions that you want to run when the conditions you have chosen are met. You can also run multiple actions that are grouped when a task is triggered.
You can create or disable a profile without affecting all the other profiles you have created on the Tasker app. If you want to stop all automated tasks or stop all your profiles from running, you can disable the app by clicking Disable Tasker.
Tasker is a handy app that lets you automate phone tasks even without any technical knowledge or without rooting your phone. However, to make sure the app runs smoothly, clean out your phone’s junk first with Android cleaner tool, so your applications will run smoothly and efficiently.
- 1. What it does
- 2. Where to find it
- 3. Guide
- 3.1. Events
- 3.2. Actions
1. What it does
Tasker and Automate are automation tools for Android.
After setup, you can react to events that happen in Sleep as Android (such as alarm was dismissed), and you can call actions (such as start sleep tracking).
2. Where to find it
Sleep as Android → Settings → Services → Automation → Tasker
You need to have either Tasker or Automate installed.
This page offers a guide for Tasker.Automate has a little different interface but the concepts are the same.
To react to an event in Sleep as Android, do the following:
Go to Profile tab and tap (+) button
Give a name to your profile
Tap Event > Plugin > Sleep > Configuration (pencil) > [your chosen event]
Select the task that should be run when the event happens
You can use any of these events from Sleep as Android and link them to any actions on your phone:
the user has snoozed a ringing alarm
the bedtime has just occured
the user has dismissed a ringing alarm AND solved the CAPTCHA if present. This event will also be fired when alarm has been dismissed while snoozed
alarm has been dismissed while snoozed
the REM phase has been detected. More on REM phase detection here.
Sleep as Android has detected one of the supported sounds: snoring, talk, coughing, laughter, baby crying. The maximum frequency of the event is once per 30s. Audio recognition has to be active for this event to work.
Sleep as Android has detected snoring and executed an anti-snoring action (vibration or tongue click or both). Anti-snoring has to be active for this event to work.
fires 45 minutes before smart period starts (to gather data for the smart period)
To triger an action in Sleep as Android, do the following:
Go to Tasks tab and tap (+) button
Give a name to your task
Tap (+) button > Plugin > Sleep > Configuration (pencil) > [your chosen task]
Nov 19, 2017 · 4 min read
My wife loves me so much that she wants to know where I am occasionally (read: often). Unfortunately there are times when I can’t always respond promptly, especially when I’m on the road. I’m a big advocate of not texting while driving, so today I wanted to share a Tasker profile that automates sending your GPS location while you’re on the go.
Before we start setting up a profile in Tasker, we will want to open up Secure Settings and ensure that the System+ Module is enabled.
From the Tas k er app, we’re going to create a new event triggered by an incoming text message. We can choose to filter the event based on the sender or type of text (SMS/MMS). For this profile, we’re going to choose to accept Any type of text from any sender. In the Content field, we’ll use the keyword #location to trigger the profile.
Pressing the back button will create our profile and prompt us to create or select an Enter Task, which is a task that will run whenever we receive any text message with #location as the text content. Select New Task and name the task Send Location.
We want our task to perform the actions defined below:
- Plugin > Secure Settings
We can hit the edit button to the right of Configuration to get to System+ Actions > GPS > On > Save. This will ensure that our GPS is enabled before any of the following actions run.
- Variables > Variable Set
LOCSPD is a Tasker variable that we can access in order to get our speed in meters/second. Full list of available variables can be found here. Since I prefer to report my speed in miles per hour, the To field is simply doing the conversion with the Do Maths option checked.
- Phone > Send SMS
For this action, we’re going to utilize two more Tasker variables called SMSRF (the text from number) and LOC (the latitude and longitude of the last GPS fix). SMSRF will be the number that we reply to and LOC will be part of the message response. We are also adding our locspdmph variable to show the current speed in MPH.
- Alert > Flash
The final action we will create is just a simple toast notification that tells us that we have sent our location.
With all of our actions set up, our Send Location task should look like this:
Hitting back takes us back to the Profiles tab where the Send Location task that we have just created should be the enter criteria for our profile (named #location in this case).
With our profile set up, all that’s left is to test it!
Everything’s working as expected and the wifey now knows where I am at all times. I swear this sounded like a good thing when I started… but as the saying goes, “Happy wife, happy life!”
Home Tech for Home Owners
This post was originally published on July 27th, 2017.
Android enthusiasts have been tinkering with Tasker for years- and with good reason. Tasker is a versatile app that is capable of creating a personalized Android experience like no other. It’s described as a way to automate your phone, but when you consider the sheer amount of plugins available, it’s way more than just that. Tasker can use your phone’s apps, files, sensors, and network signals to automatically make your phone behave a certain way- adjust the volume, turn WiFi/Bluetooth/GPS on or off, control the screen brightness, etc. Plugins can extend this functionality, allowing you to use your phone to control other things too, like controlling your home’s lights . It works best with root, but there are a lot of things you can do without root too. None of my devices are rooted, and there’s still plenty I can do with Tasker.
This post is focused on how you can use Tasker on an unrooted Android phone or tablet to control your smart home devices using SmartThings. This will require two apps, Tasker ($2.99 Google Play Store) and a Tasker plugin called Sharp Tools (free to download from the Google Play store, but SmartThings integration will cost $2.49 – $3.49).
If you’ve never used Tasker before, it can be a little overwhelming at first. This post will offer an introduction to pseudo-programming using Tasker, and a step-by-step tutorial to integrate your SmartThings devices.
Before we get to that, we need to discuss what I’m trying to accomplish. I have a wireless charger for a Samsung S7 Edge that I use to charge my phone while I sleep. If my phone is on that particular charger, then I assume I’m going to bed. Thus, I should turn off all the lights in the house, turn off the TV, make sure doors are shut/locked, set my home security alarm, etc. Likewise, when I wake up, I want to turn on lights and unset my alarm. We’ll see how easy it is to use Tasker to do this.
There are plenty of Tasker tutorials out there, such as Pocketable’s Tasker Beginner Tutorials . Basically, you need to create a profile based on a context. A context is a trigger that causes the profile to run. Profiles are made up of tasks. When all the tasks are completed, the profile is done running and it waits on the next trigger before it will run again.
Tasker allows the use of variables. There are two types of variables: system variables and user-created variables. System variables are things like battery level, display brightness, and bluetooth status. You cannot set a system variable, you can only read its value. However, system variables can be copied to user-created variables and manipulated that way.
All variables in Tasker are preceded by a % sign. System variables are in all caps, such as %BRIGHT for display brightness. You could also make a user-created variable called %Bright, but you might want to avoid reusing system variable names so you don’t get confused. Also, variables are case-sensitive, so %BRIGHT, %Bright, and %briGHT are all different variables. A variable in all lower-case, %bright, means the variable is a local variable visible only to the current task. In other words, it won’t be able to be used in another task.
By default, Tasker starts in “Beginner Mode”. Beginner mode makes Tasker easier to work with, but you will be prevented from using variables to change parameters. See below for a demonstration:
Whether or not your place of employment requires that your cellphone be placed on silent or not while in the office, it’s simply a common courtesy to prevent interruptions and distractions to your co-workers when your twenty-seven different social media, email, phone, voicemail, and shopping applications that are installed on your phone constantly chime or play your favorite song every thirty seconds.
The problem is, who can remember to silence their phone after arriving in the office before it makes a half dozen or so of these sounds and while a half dozen notifications may not sound like a big deal compound them by a hundred or more people in the office and it has become a major problem in society, especially when your co-workers within hearing distance are on business calls with customers.
The solution is to automate the task of silencing your phone when arriving at work. On my Android phone, I use a program named “Tasker” to setup this sort of automation and it’s capable of all sorts of automation. The app is $2.99 in the Google Play store (I paid for Tasker personally and no one sponsored this blog article).
Open Tasker on your Android phone or tablet and click the “+” at the bottom of the application:
Enter the name of the access points you connect to at work. In the following scenario, two possible networks are available, one with the SSID of network1 and another with network2. If your employer doesn’t allow connections to their network but networks are available, you can select “Wifi Near” in the previous step. You can also optionally narrow down the scope of the wireless network by selecting specific MAC or IP addresses of the access points:
Enter a task name. I entered “Vibrate” since that’s what mode this task will place my phone in:
Click the “+” at the bottom of the application:
The profile to automatically place your phone into vibrate mode anytime it’s connected to a wireless network with the SSID of network1 or network2 is now complete:
You’ll need to create another profile to turn the ringer of your phone back on anytime you leave work. Repeat the same process again except check the “Invert” checkbox:
Create another new task:
Name this one “Ringer” or something descriptive:
Set the mode to Off for this one instead of Vibrate (it turns silent mode off):
Be sure to save your profiles before exiting Tasker:
Once you’ve saved the profiles and exited Tasker, you’ll see an icon for Tasker in the top left corner of your phone that looks like a lightning bolt. You can also see active profiles in the notifications section of your phone or by opening the Tasker application:
This is just the tip of the iceberg as far as automating your Android phone goes.