wishmesh.comWishMesh – Real men don't make backups

WishMesh Real men don’t make backups High quality consulting service for Google Apps Script and Workspace Marketplace Do you have an Apps Script project that needs to be maintained, or have an idea for a new one? We have just launched our Apps Script consulting service with the first demo app— Random Slides . Just check it out and you will be stunned by the quality and beauty of the app. The user interface naturally fits into the existing Google Slides interface. It looks and feels native—as if Google made it. Every aspect of the app is crafted with passion and experience. It’s perfect and bug-free. We don’t take every project that comes our way, but fully commit to those we do and engage. If you want a quick result and are satisfied with mediocre quality then most probably we won’t take it. We just can’t release an app or project that isn’t perfect. Every creation of ours must be superb! Check out our other apps at the official docu.monster website. For business inquiries, contact me at: Click to reveal email! Besides doing Google Apps Script / Google Workspace Marketplace (G Suite) projects, we are also experts in developing custom Windows and Web apps. Posted by Maris June 23, 2022 Posted in Web Tags: App Script , Apps , Google Workspace Add-ons How to get historical download data for Google Workspace Marketplace? Google Workspace Marketplace (Google Apps, Google Apps Script, G Suite) does not offer historical data access. Moreover, the most popular apps shows (limited to) 10,000,000+ downloads, and there is no way to access the real download count. But there is a solution. A service called AppMetrics.info allows you to access all historical data. Besides the historical dataset they also offer: Historial rating information. Competitor price monitoring. Release monitoring. Downloads monitoring by day, month, year, any custom time range. If you are not monitoring and analyzing your competition, that does not mean that they are not monitoring your apps’ performance on the Google Marketplace. Analyzing competitors has many benefits, and here are few of them: Spotting of declining market, or a buggy release (maybe it’s time to speak to competitor’s customers?). Finding a new market for you app idea, by spotting new growing markets. Knowing who’s app is performing better by revealing real download count behind 10,000,000+ downloads. P.S. I am affiliated with the service ;) Posted by Maris August 20, 2021 August 20, 2021 Posted in Web Tags: Apps , Workspace How to automate repetitive tasks in Windows? 1. Automate using Windows built-in Task Scheduler 2. Task Scheduler on steroids 3. Find and Replace a word or phrase in many files 4. Rename files in bulk 5. Convert, resize, flip, and rotate images with ImageMagick 6. Record and playback mouse clicks 7. AutoHotkey scripts 8. PowerShell and script files Doing the same task every day may be boring. Especially if you feel you are doing the same boring stuff again and again. But there is good news — a lot of this work can be automated. I am covering only the most popular problems people have (ordered by popularity from the support department at my company). There are literally a gazillion tasks or workflows that can be automated, and this article is only an introduction to the world of automation. I love open source software! Therefore most of the listed apps here are open source (or freeware tools). If you know others please let me know via Twitter . 1. Automate using Windows built-in Task Scheduler Windows Task Scheduler is a built-in tool that comes with every installation of Microsoft Windows. It is a free addon that allows you to create some basic tasks that are started on a schedule. It has a graphical user interface, and for the most part you don’t need any programming knowledge. As an example of task automation in Task Scheduler I will show you how to open your Gmail every time you start your computer. 1.1. How to launch Task Scheduler? Click on the start button or Cortana search and type Task Scheduler” Start Task Scheduler 1.2. How to create a task? Click on the Create Task…” or Create Basic Task…”. Both are basically the same. One uses the wizard form (Next, next, finish), the other brings you right to the properties with multiple tabs. If you are using Task Scheduler for the first time, I recommend using the Create Basic Task…” feature. 1.3. Give a name Give your task a name. It can be anything — for example Start My Gmail”. 1.4. Choose when to start the task You can start your automated repetitive tasks on a schedule (daily, weekly, monthly, one time, etc.) or when you start your PC or log on a computer. For the purpose of example I will choose the When I log on” option. 1.5. Run a program The most widely used option is Start a program”. This option allows you to start any installed app on your computer to automate repetitive tasks in Windows. We will start Google Chrome Browser with this action. 1.6. Open your Gmail on computer start First browse to the location where Chrome Browser is installed. The default app location is: C:\Program Files\Google\Chrome\Application\chrome.exe Program arguments are optional. If you leave them blank then Chrome will open with your default homepage which usually is an empty tab. You can type in any webpage URL or address as an argument, and Chrome will open it on launch. Let’s type https://mail.google.com/mail/u/0/#inbox to open your Gmail inbox. If you have multiple Gmail or Google Workspace accounts, change 0” (zero) in the URL to 1”, or 2” if you have more than two inboxes, and so on. 1.7. Done! Click finish! 1.8. Conclusions Congratulations! You have created your first automated task. This is a huge step to task automation! From now on, every time you log on, the Chrome browser will be automatically launched with your Gmail opened. To edit or delete your task, go to Task Scheduler again, click on Task Scheduler Library” and look for the task we have just created Start My Gmail”. To edit it, click on Properties”. Have fun! 2. Task Schedulers on steroids Microsoft is fairly good at creating basic functionality, but when you want to automate computer tasks in the pro level, there’s a lot of choices. One particularly easy to use app is Automation Workshop. It has paid and free plans and they proudly call it a no-code solution . Basically it means that you never (or rarely need any programming knowledge or command line usage). 2.1. Let’s automate email sending Automation Workshop can automate more than 100 things, but for the purpose of this example I will show you how to automate email sending. I created a folder on the desktop called Mail Me!”, and I will create an automated job that will send an email once a file is dropped on the folder. The click-and-point user interface allows you to do this with some simple clicks. 2.2. How to create an automated task? The process of creating a task is very similar to the Task Scheduler tasks . Click on the New Task” and proceed with a task creating wizard the same way it is done in Task Scheduler. 2.3. Triggers There are two types of tasks in Automation Workshop. The ones you start by clicking your mouse (manual start), and the ones that start automatically or on a particular event (automated start). To automatically start a task, you need to add a trigger to the task. As we want to send an email when a user drops a file in the folder, we need one particular trigger – File & Folder Watcher. Click Add…” to add a trigger. 2.4. Triggers everywhere There is so much more you can do with Automation Workshop compared to Windows built-in Task Scheduler. There are triggers for every automated job. You can automate PC startup and shutdown, or log on / log off. You can schedule tasks using Task Scheduler that allows very simple and very complex schedules (Microsoft can learn here how to create a GUI). And there are many file watchers that can act on various file events, on a local computer, or on remote servers, and more. To not...