SCENERIO: You are admin of a G-Suite set up. You upload training videos for your organization members on Google Drive/Team Drive. To increase productivity, you want to ensure all members watch the videos you upload.
SOLUTION: You utilize this amazing GSuite Reports API and use Google Sheets as your dashboard to view all details about your MP4 videos.
Source: Google Apps Script —Track videos viewed on Google Drive within your organization
Google App Maker allow you to create responsive web-app fast in your company. What about create an internal challenge ?
In this post Jérémy Dessalines highlights the benefits of using Google App Maker to rapidly develop a web based game and all in a couple of lines of code:
The app benefits from Google App Maker to authenticate the user, create a responsive application that allows the visualization of good practices in the form of cards. … Access is secure and restricted to a small group of users via a Google Group.
Source: Create a game web-app fast with Google App Maker ? Challenge accepted.
Just putting it out there for some one who forgets syntax of RESTful API call in Google Apps Script.EVERY.SINGLE.TIME. This one is for AirTable API
I’ve not come across AirTable before but it looks like a nice service for creating database interfaces and in this post Urwa Shabir covers how you can access the AirTable API.
Source: Google Apps Script — AirTable API – Urwa Shabir – Medium
In my last post, I wrote about publishing device telemetry from Cloud IoT Core to Cloud SQL. The natural thing to want to do after this is to plot that data and I have found using Apps Script with Google Sheets to be a great way to get this working quickly.
In this post you’ll find some helpful advice on connecting to Google Cloud SQL server with Google Apps Script.
Source: Accessing Cloud SQL from AppsScript to plot data from IoT Core
It actually is really easy to add the Virtru SDK to your project, as I’ll demonstrate through the construction of a “Protect & Share” Google Docs add-on.
I’m not familiar with Virtru but in this post from Trevor Foskett (Senior Solutions Engineer at Virtru) shows how their product can easily be integrated into Google Docs as an add-on. You’ll hopefully find this post useful to find out about Virtru as well as how client side and server side processing can be handled using Google Apps Script.
Source: Use Google Apps Script to Securely Share Google Docs
Google Apps Scripts are very powerful yet relatively unknown. In this post Fran Galarza shows us what we can do with them & IoT as a use case.
You could have a sensor regularly measuring the humidity of your garden’s soil and posting that value to your GAS (yes, you can make POST requests). Then your GAS could log that measurement in a Google Sheet and send you an email if the soil is too dry. It can even set an event in your calendar to remind you to water your garden.
Source: Google Apps Script & IoT
Take it off your weekly to-do list — learn how to automatically create a new tab, clear a designated range, and delete an old tab in Google Sheets.
Source: Google Script Automation: Create New Sheets Tabs Automatically
Where should I store my data? Should I sync Cloud SQL and Big Query? How to publish my app,… Read on Jérémy Dessalines’s (@Gr3m) thoughts on working with App Maker.
Now you can get the Action Items (AIs) delivered right to your inbox! Joanna Smith’s (@dontmesswithjo) custom solution to integrate Google Docs with Apps Script allows you to send everyone a personalized list of their AIs at the end of every meeting.
Manage, verify and approve transactions in your application using cloud functions and Google Apps Script.
Nice little tutorial showing two communication between Google Sheets and Firebase using Google Apps Script.
Source: How to use Google Spreadsheet as Admin Interface for your Firebase project
