Posts filtered by tags: Google Apps Script[x]


 

How to Supercharge Your Google Apps with the Script Editor

If you use Google Apps, then chances are you’re not using them to their full extent. With Google Apps Script, you can add custom menus and dialogs, write custom functions and macros, and build add-ons to extend Google Docs, Sheets, and Slides. What Is Google Apps Script? Google Apps Script is a cloud-based development platform for creating custom, light-weight web applications. You can build scalable applications directly inside your browser that integrate effortlessly with Google products. A...
Tags: Google, Crafts, Google Apps, Google Apps Script


Send Multiple Emails From Google Sheets Using GAS

Last updated: 05/01/2019, 3 min read (without the code) Introduction Have you ever wondered how is it possible to send multiple emails to different recipients, without counting on external services, like MailChimp, AWeber, Mailerlite and others? If the answer to this question is yes, then you would probably be surprised to learn that you can achieve this by simply using Google Sheets and some custom code written in Apps Script. In this post, we will assume that you already have the email... ...
Tags: Google, Seo, Christos Samaras, Google Apps Script, MailChimp AWeber Mailerlite


Creating & Customizing Column Charts In Google Sheets

Last updated: 07/11/2018, 2 min read (without the code) Introduction Google Sheets, much like Microsoft Excel, incorporate many different chart types, which can help the user to visualize his/her data. In this post, we will learn how to create and customize a simple column chart in Google Sheets. There will be the “manual way”, the “coding way” – using Google Apps Script – as well a bonus tip for selecting chart colors. The manual way To create a column chart manually just follow these 2... ...
Tags: Microsoft, Seo, Christos Samaras, Google Sheets, Google Apps Script


Triggers & Events In Google Sheets

Last updated: 05/10/2018, 3 min read (without the code) Introduction According to the documentation, triggers let Google Apps Script run a function automatically when a certain event, like opening a document, occurs. Apps Script supports two types of triggers, simple and installable. Simple triggers are a set of reserved functions built into Apps Script, like the function onOpen(e), which is executed when a user opens a Google Docs, Sheets, Slides, or Forms file. Installable triggers, on the.....
Tags: Google, Seo, Christos Samaras, Google Sheets, Google Apps Script


Geocoding & Reverse Geocoding Functions In Google Sheets

Last updated: 28/08/2018, 1 min read (without the code) Introduction In the previous post, we learned the basics about developing and using a custom function in Google Sheets. It is time now to switch to something more advanced compared to our first example. We have seen in the past how to use Google’s geocoding services from VBA. Here we will see how to call these services using Google Apps Script (GAS). The main advantage when developing a GAS function is that, unlike VBA, you don’t need to....
Tags: Google, Seo, VBA, Christos Samaras, Google Sheets, Google Apps Script


How To Create & Use A Custom Function In Google Sheets

Last updated:08/09/2018, 5 min read Introduction Google Sheets, along with Google Docs and Google Slides are a spreadsheet, a word processor, and a presentation program respectively, all part of a free, web-based software office suite offered by Google within its Google Drive service. The three applications are available as web apps, mobile apps and desktop apps (on ChromeOS only). The applications are compatible with the corresponding Microsoft Office file formats, therefore, the user can... ...
Tags: Google, Seo, Google Docs, Microsoft Office, Christos Samaras, Google Slides, Google Apps Script


Geek Reading July 17, 2016 #1150

This is a special Sunday edition of Geek Reading for one simple reason. I am taking a break from posting Geek Reading for a while. Life and work are always very busy and I am hoping to get back to writing again. Maybe in the near future I will post an original article or opinion, and get back to what I really enjoyed but haven’t had time for lately. Geek Reading will probably reappear eventually, but I have to think about the right direction for it. Thanks to everyone who has been reading and s...
Tags: Google, Python, Seo, Java, Ruby, Swift, Apache Spark, Bgp, React, Erica Sadun, Microservices, Scala, JSON, Geek Reading, AI Machine Learning Research, Big Data Visualization SQL


Free Book – Google Apps Script for Beginners

Google Apps Script for Beginners ($10.69 Kindle), by Serge Gabet, is free this morning, direct from Packt Publishing. This week at Packt, get 50% off Cloud Computing eBooks! Book Description Google Apps Script is a JavaScript-based programming language that works on the cloud and is 100% free to use. It provides all the tools necessary for Google services to work. Users can easily transfer any data from one service to another, save their important e-mails as files, save and share files with anyb...
Tags: Google, Free Books, Computers & Technology, DRM-Free, Packt Publishing This, Packt, Serge Gabet, Google Apps Script