Apps Script is basically the equivalent of VBA for Excel. It allows you to connect your Google Sheets with Gmail, Google Docs, Google Drive, Google Calendar, and numerous other services. A TON of scripts can be found online, and even with only a rudimentary knowledge of coding, I have been able to Frankenstein scripts together to accomplish numerous things.

The usage limits are very generous, and it will not end up costing you extra $$ to create very sophisticated automated workflows. If there is specific data you need to get into a Google Sheet from an outside source, I've found most out-of-the-box tools like Zapier to be very limited, whereas Apps Script had the power and customizability to do exactly what I needed. Review collected by and hosted on G2.com.

Apps Script uses some version of JavaScript, and there is definitely a learning curve to get started with it. Getting reliable scripts does take some skill. The time investments have paid off for me, but there's definitely a lot of trial & error, YouTube videos, and StackOverflow searches required to get from Point A to Point B if you're a novice coder. Review collected by and hosted on G2.com.

There are plenty of tasks that can be automated making my day more efficient, reducing time, reducing reminders, or dealing with data format and cleanup that can be managed by code. Review collected by and hosted on G2.com.

Requires coding logic in order to achieve smoothness and accuracy, along with some good understanding of the Host app/app in the google workplace in order to define a handy solution. Review collected by and hosted on G2.com.

Google app script is helpful in working with data automation in Google sheets and Google docs. You could also modify different settings with it Review collected by and hosted on G2.com.

Google App Script could only modify data within the Google workspace. It is not recommendable to use outside the platform Review collected by and hosted on G2.com.

Had been using Google Apps Script for G Suite to automate multiple things for the brands.

It was easy to use as it helped in linking all the Google properties and made it easy to get all the data.

The settings were easy and there was a step to step guide for the same. Review collected by and hosted on G2.com.

There were certain limits on the number of things that could be done.

The limit, if exhausted, led to the issues as the automation would stop and it would exhaust. Review collected by and hosted on G2.com.

Ability to automate processes with different types of documets in Google Suite. Review collected by and hosted on G2.com.

The Google-provided IDE is both subpar compared to other IDEs and has a few bad flaws that are so debilitating that I want to delete Apps Script from my system. Example 1: Getting the "Something went wrong" dialog. Something specific triggered this dialog. Can you at least try to be a little more helpful with information? Worse yet, the dialog blocks me from saving hours of my work. The Dismiss button DOES NOT dismiss the dialog. The dialog blocks is a top-level window that keeps from from working with the editor pane underneath. So I am prevented from trying to salvage my work. Example 2: The API documentation needs work and leaves out important details, leaving users to figure things out on their own via trial and error. For example, for a Sheet's Range, getFormulas() returns a 2D array of Strings representing formulas. An empty String shows that no formula was found in the corresponding cell. Google's documentation doesn't explain what happens when setFormulas() is used with that same 2D array. You might expect that added or edited formulas in the array would update the corresponding cells with new formulas and that blank values in the 2D array would leave existing cell contents alone. Not true and not document. The empty Array values ERASE prior contents of the cells. This is a design flaw but I could have worked around it more easily if it had been better documented. The documentation for Apps Script and its API is far inferior to the API documentation for other platforms, e.g., Java. You leave me guessing and wasting time by searching for answers from other users who have had similar problems. Review collected by and hosted on G2.com.

It's based on JavaScript so is easy to learn and grasp, also no prior hardcore programming knowledge is needed. Because of Google's workspace, it's very easy to set up and work. Moreover everything with it is done on cloud. Selective access is also a great feature with it. Review collected by and hosted on G2.com.

Some limitations are there when manipulating CSS with it. One can't run programs with huge execution time, apparently there's limit of 30 minutes. Review collected by and hosted on G2.com.

Turning statics sheets into user experiences. I appreciate data modeling and creating the different views independently. It is easier to use than PowerApps according to my experience. Review collected by and hosted on G2.com.

I would like to have more data visualization tools. Once I experienced an issue, I updated and couldn't see anything but an error, yet the app was working correctly to the user. Review collected by and hosted on G2.com.

The best part of Apps Script is that it's based on JavaScript so you don't really need to learn anything.

Integration with other G suite applications such as Google Sheets, Docs etc is really smooth. Review collected by and hosted on G2.com.

Code editor can be better, there are no options to control the looks. Dark mode can add charm to it. Review collected by and hosted on G2.com.

Google Suite is very convenient for everyday use. It uses the most convenient platform and is seamless with syncing online through multiple devices. Review collected by and hosted on G2.com.

There are some things that are hard to pick up in the beginning and some of their help desk options are hard to reach. Hard to get help if you are unfamiliar. It is defiantly easier for younger people but might be a more difficult task for older people. Review collected by and hosted on G2.com.