The article is an overview of the workflow covered in the author’s presentation along with install instructions for trying it out in your G Suite domain.
The task of building a Google Hangouts chatbot can often seem daunting due to the diverse technology options and approaches. What is often not always known is how relatively easy it is to build chatbots by simply using Google Apps Script.
Here’s a step by step guide on how to build your first Google Hangouts chatbot using Apps Script.
Have you ever thought that it might be useful to connect a Google Apps Script to your ServiceNow instance? Perhaps you’d like a new way to quickly download a list of configuration items from your change management database to a sheet, or you’d like to upload a selected range of cells from a sheet as new records in SNOW, one record per row?
This guide is focused more on the coding than how to configure your identity provider and ServiceNow.
Back in January, Google widely launched G Suite Add-ons to allow third-party integrations across products like Calendar and Drive. Adobe today announced a plug-in that lets Gmail users quickly access Creative Cloud.
“While new collaboration channels are all the rage, business email is actually on the rise with individuals sending and receiving more emails every day. Bringing Creative Cloud into G Suite enables our mutual user base to simplify routine tasks while staying productive in their inbox,” says Sid Arora, Product Manager, Adobe Creative Cloud.
Always nice to see well established third parties using Google Apps Script.
Two years ago, our team began building custom software to automate the multi-stage and highly manual team staffing process. Building internal software has allowed the same-size Staffing Operations Team (3 members!) to enjoy a 60x reduction in time spent staffing each role.
The Apps Script ecosystem has emerged as the most critical component in our toolkit for building this internal software, due to its versatility and ease of deployment. We want to share how one piece of the staffing process has evolved to become more powerful over time thanks to Apps Script. Ultimately, we hope that sharing this journey enables all types of teams to build their own tools and unlock new possibilities.
A bit of a monologue about various syntax changes and adjustments in learning and using the tool.
On the G Suite YouTube channel you’ll find a new playlist for “why organizations build with Google Apps Script” which contains contributions from Cleo Espiritu, Ivan Kutil, Niek Waarbroek and myself. Hopefully these clips are useful in encouraging users to look at Google Apps Script as a powerful and agile development solution.
One of the key things that V8 has sorted out is the scope of variables. Using var to declare variables meant that anything declared within the scope of a function could easily be accidentally overwritten, causing hard to track down errors. ES6 (since it’s commonly known as V8 in Apps Script – I’ll be referring to it as V8 from now on), has added const and let to the variable declaration vocabulary to help prevent these kind of problems.
In this episode of Sheets to Apps, we will show you how to track your work time on projects via Google Calendar. More importantly, he’ll be showing you how you can sync Calendar events to Google Sheets, creating a spreadsheet that shows you the total time spent on your projects.
Gathering inputs from multiple sources and then taking action on each becomes taxing when the task needs to be realized with frequency and with multiple stakeholders. An example is quarterly or annual budget approvals for a finance team.
In this article the author will share how to use an Apps Script in a Google Sheet to automatically create a budget submission form that you can share with end users, and when their responses arrive in the sheet, you can collaborate with other reviewers to send emails in bulk depending on whether you are approving, rejecting, or asking for more information about their request. The emails use a Google doc as a template that pulls information from the sheet such as a user’s name, the budget values they entered, or special comments.
Companies, organizations, households, students, etc all benefit from budget planning in order to optimize savings, because you forecast your total expenses, and then closely monitor the true cost in order to course correct and you reach a savings goal.
In this article the author walks us through how to create our own custom function so we can prepare our annual household budget by entering our expenses in one row and marking their frequency in another (ex: annual, monthly, weekly, daily, or only one time). When we have rows and rows of expenses with different time periods, creating our own formula with a Google Apps Script helps us save a lot of time.
AutoSlides is a Google presentation template powered by Apps Script code design to be used in unattended information points, although it can also be used as an informational element, linked or embedded, on any website.
Google presentations have a publishing feature that facilitates their dissemination. In this way they can be linked or embedded in web media with ease. However, if the presentation slides are modified it is necessary to reload the page that contains its versions published in the browser so that these changes are manifested. AutoSlides is capable of generating a self-hosted slide show, visible using a browser, that automatically refreshes at predetermined intervals without reloading the web page manually in the browser.
You may be exporting data from an accounting tool into an .XLS format (Excel spreadsheet) every month, and then manually searching, cleaning, and replacing values. More specifically you probably spend a lot of time finding and replacing duplicates, and performing advanced operations such as a VLOOKUP or a QUERY function in order to pull data from other sheets or digging through records that use unfriendly date timestamps.
In this article TechandEco walks us through how to automate this monthly task by using a Google macro and a custom menu, and invite you to try it out yourself. In the future, you can convert your Excel into a Google Sheet by dragging it or uploading it into a folder in your Google Drive>then second click the file to view its options > open as > Google Sheet.
Manage training or event registration with Apps Script, Google Forms and Google Calendar.
Using Google Calendar to setup a meeting is really easy and works like a charm for business or personal needs. But sometimes you want to manage event registration for an event, a training and in this case you need to share a form and register the participant after the submission. Hopefully Google Apps Script is at the rescue.
Why not make it a proper library? Because to make it a drop-in replacement, needs to have access to global scope, which a library doesn’t.
The V8 runtime changes how the Logger class works, which has shown much slower load times for simple Logging statements. This snippet writes all Logger.log calls to a spreadsheet when invoked, greatly speeding up development time.
Drop-in replacement for Logger.log, because outputting to a spreadsheet is way faster.
Sure could make additional improvements, but this is good enough for me for now.
I’m a public school teacher writing Apps Script projects to manage documentation and to make life easier in general. You can read more on my blog, blog.ohheybrian.com or follow me on Twitter, @bennettscience.
Learn how to scrape data from any subreddit on Reddit including comments, votes, submissions and save the data to Google Sheets
Here’s Google script that will help you download all the user posts from any subreddit on Reddit to a Google Sheet. And because it’s using pushshift.io instead of the official Reddit API, the script will no longer be capped to the first 1000 posts. It will download everything that’s ever posted on a subreddit.