#google app script

WordPress Alternate Cron Job Using Google App Script

Have you ever wondered that you can use Google App Script to create an alternate cron for wordpress wp-cron.php ? Most of the websites have issues with running wp-cron.php properly.

Wanna know ? Then read on….

Lots of website developers or bloggers face issues with WordPress cron. If your website has less number of visitors then your wordpress cron may not run.

wp-cron.php is ran…

Summary-  Google App Script are small snippets of code that add custom functions and integrations into your G Suite applications. It has a development environment that may be completely different from what we are used to.

Google App Script is a cloud-based and lightweight app developed by Google to automate simple tasks. If someone is already using G Suite apps for your enterprise, Apps Script comes at no extra cost. 

By using Google App Script

We can develop a browser-based code editor but can choose to develop locally if using CLASP, the command-line deployment tool for Apps Script

We can do coding in a specialized version of JavaScript customized to access G Suite, and other Google or external services.

We can safely ignore writing authorization code because Apps Script handles it for you

Do not have to host the app, it lives and runs on Google servers in the cloud

                                                 Picture Courtesy-Infiflex

Benefits of Using Google App Script

Google App Script is completely a perfect tool for anyone who wants to customize Google Apps for their organization. If someone uses Google Apps Script and if they are looking to automate simple tasks, unlock the potential of other G Suite apps, access data from Google cloud infrastructure, and share scripts with other users as add-ons. Most of the users can get their first experience with automation through the cloud scripting app.

It is based on JavaScript; easy to learn.

Provides a cloud based debugger for debugging App Scripts in the web browser.

We can create simple tools for an organization’s internal consumption.

Used to perform simple system administration tasks.

Community based support model.

What can App Script Do?

Google App Script can do a lot of things like automatically transfer the emails from Gmail to Drive based on the labelling, give deadlines to tasks and sync it with Google Calendar to get notifications. 

Following are the other things which you can do by using App Script-

We can Add custom menus, dialogs and sidebars to Google Docs, Sheets and forums.

We can write custom functions for Google Sheets.

Publish web apps.

We can also interact with other google services that include AdSense, Analytics, Calendar, Drive, Gmail, and Maps.

Build add-ons to extend Google Docs, Sheets, Slides and Forms and publish them to the add-ons store.

Uses of Google App Script

Make bulk changes to services like Google Calendar 

Create Mail Merge to use in your Gmail emails 

Send multiple emails from a spreadsheet.

me: here goes! let's see what the error I get...

Google: ScriptError: Range not found

me: okay, so let's figure out what that is

me: is it in this function?

Google: nope

me: is it here?

Google: LOL nope

me: Surely it's here. Let me change it.

Google: Nope.

me: Let me do this then.

Google: Nope. Also, another thing broke.

me: okay, let me try—

SIXTEEN HOURS PASS

Google: nope. As a matter of fact these are all great. Up until before you enter this particular key.

me:

me: wait a minute...

me: (scrolls up to key definitions)

me: (notices the two stray colons)

me:

me: (lies head on table)

me: oh my god why am I obsessed with getting the hash functions right, you literally used email addresses and unformatted timestamps for it the last time, why can't that work now

me: you're getting bogged down with trivialities Tariq get back to FIXING this shit

me:

me: (goes off to try and fix other things)

A DAY PASSES

me:

me: (goes back to it)

me: (reimplements it pretty damn fucking well)

me:

Google Apps Script: Tracking add-on usage with Google Analytics

Originally published on googleappsdeveloper.blogspot.com on January 7, 2016 By Romain Vialard

Posted by Romain Vialard, a Google Developer Expert and developer of Yet Another Mail Merge, a Google Sheets add-on.

Google Apps Scriptmakes it easy to create and publish add-ons for Google Sheets, Docs, and Forms. There are now hundreds of add-ons available and many are reaching hundreds of thousands of…

Google App Script code editor now gives you info on performance

Google have added a new hints feature in the Apps Script code editor: a light bulb. This is icon will be grayed out most of the time, but when it lights up it means that the Google system has some useful information to share about your script, such as performance improvements or warnings about the use of deprecated methods. Google collect this data as your script executes, so you won’t get any…