This article is on Google Spreadsheets, which features a friendly user interface for the Google Apps Script. It is written in a JavaScript subset and lets you integrate with other Google apps and services. It is an excellent tool for enterprises and start-ups due to its flexibility and the improvement of the probabilities are endless with additional App Scripts.

Why Google Spreadsheets as an Application?

Spreadsheets are one of today’s business world’s most common tools. There are a couple of implementations of spreadsheet software with some variations among all, but regardless of which one is used, they are absolutely indispensable for those whose work depends on them. It includes almost all of the same spreadsheet functions—if you know how to use Excel, you’ll feel at home in Google Sheets. You can download add-ons, create your own, and write custom code.

We can use Apps Script to guide users through a better experience in Google Spreadsheets, by adding custom logic and functionalities to receive input from them, and then by taking workflows to build full-function, lightweight web applications.

Another specialty about Google spreadsheets is, unlike a lot of development paradigms, where you have to go out and gather requirements and then go back and build a solution as a developer, then go back to the user and see if it works, spreadsheets can be built using teamwork. Bring the end user in who knows the business process likely as good as you do or maybe better, and you can come up with a better solution.

What is Google App Script?

Google Apps Scripts is incredibly powerful and enables complex systems to be built on top of Google services. It can be a great choice when you need to quickly prototype an idea or design a solution that’s customizable by non-technical users. A great way to make an accessible solution is to build on top of products that users are already familiar with. It comes with a scripting language called App Script to extend its functionality.

Apps scripts work not only with Google Spreadsheets but also with Docs and Slides. The next time you need to find a way to automate some processes or workflows, keep in mind it may be easily achieved with Apps scripts.

more about Google App script:

https://developers.google.com/apps-script/overview

https://developers.google.com/apps-script/

“Hello world” to Build Apps through Spreadsheet

Now is the time for a bit of code to be written. Basically, Apps Scripts combine JavaScript functions — code blocks that perform a specific task. There are often functions, which can be copied and used by themselves with minimal editing.

Let’s Start with the classic “Hello world” program.

To get started, visit sheets.google.com and create a new sheet.

Click on the Script Editor option under the Tools menu in your new sheet.

The new Script Editor tab will be opened with a white script file. By default, it’ll open with a single Google Script file (code.gs) and a default code block, myFunction(), .gs stands for google script.

Write the following code lines in the code window in the curly braces after the myFunction) (syntax function) :

function myFunction() {
Browser.msgBox(“Hello World!”);

}

Your code should now look like this:

Save your code now and set Google Script Editor’s project name:

Now, Under the “Run” menu, click the option for Run function>myFunction(our function name), to run the script. You can do the same by hitting the black triangle button.

Clicking Continue will then pop up another window that shows your application’s permissions.

In this case, the App wants to see and manage your sheets in Google Drive so click Allow.

Google has robust security protections to reduce risk from unverified apps, so we go through the authorization workflow when we first authorize our own apps. To reduce the risk of unverified apps, Google has robust security safeguards, and therefore we proceed via the permission process once our own apps are authorized. So, if you run the app script for the first time, you might see the screen “This app isn’t verified” and warn about Back to safety.

Don’t, worry.

As we are the app’s creator, we know that it is safe, so we want to continue.

As this article does not intend the HelloWorld App project to be made public to other users, we do not need to submit it for review by Google.

So, on the lower left of the viewing permissions, click on the “Advanced” button and, on the bottom of the next screen, click on “Go to HelloWorld(unsafe)“” to continue.

Then click on the next screen in the words “Continue” and finally click on “Allow“, as displayed in this picture :

Next, you’ll see two yellow state messages on Google Apps Script editor, located on the center top area of the screen.

Preparing for execution….

Running function myFunction…

This is the stage when you see a warning message, instead of the yellow message, you get a red box with an error message if anything goes wrong with your code

Now that you have these two yellow status messages and both have disappeared from view without any error, your program is running successfully.

Click back on the browser tab with your spreadsheet (most likely the tab to the left of the one we’re in). You should see your program’s output, a message box with the classic “Hello world!” message.

Click on Ok to dismiss.

Great job it worked! You’ve now written your first apps script program.

If you want to see an example of spreadsheet application in action then try out our Products :

Employee Onboarding App: Link

HR companion app which saves time and automates processes by sending an offer letter to candidates & adding them to online tools.

This Google sheets add-on automates sending an offer letter to candidates & adding them to online tools. Easy Utilize Google Docs, Google Drive, Trello, Mail Merge to simplify your human resources process.

SEOMango: Link

Weekly website traffic reporting, bulk 404 URL checker & add UTM parameters to URLs. Automate marketing analytics and improve SEO.

Conclusion

Spreadsheets are great for prototyping, incubating, validating, showing that this idea is worthy and right and has an organization purpose and need. The way people can build solutions through a Spreadsheet is really somewhat democratized.

There are Hundreds of other things that you can do with Google Apps Scripts— the limit is your imagination. The best way to start is to check and tinker with the documentation. As you become more aware of the methods and attributes available, you will begin to know how much can be done— often without writing additional code.

Thanks for reading, we hope you found it useful.


Yatindra Sahu

Data Enthusiast

0 Comments

Leave a Reply