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.
send a follow-up email to all undecided participants of a meeting that you’ve scheduled via google calendar using apps script.
here’s a piece of code that you could schedule for every morning (preferably before your official work hours start) to be triggered, such that the script could iterate through every single meeting event that you’ve scheduled (i.e. where you’re the “organiser”) for the day and send an email to all those invitees who’ve neither accepted nor declined (even excluding the maybe’d ones too) to said invites.
Nice post from Sourabh Choraria which covers interacting and using data from your Google Calendar.
Benchmark: Loop for Array Processing using Google Apps Script with V8 – submit.md
Kanshi Tanaike has published some useful benchmarks looking at the process time for various loop methods comparing the old Google Apps Script runtime with V8. Something to keep in mind that while there are performance improvements there is a cost as calls to G Suite services:
The performance story is mixed. Vanilla JavaScript code (looping, math) runs faster, but calls to G Suite services (SpreadsheetApp, etc) run slightly slower. While not ideal, we’ve always recommended that performance-intensive apps are usually a better fit for other platforms.
TeslaGAS is a library that helps writing scripts that communicate with your Tesla – Zzapps/teslagas
Think it is cool to link your #Tesla to your Google Calendar for auto defrosting, or collect statistics into a sheet, or use Hangouts to chat to your car to set the temperature? I drafted a simple library for Google Apps Script! https://t.co/UajCE8KuuE@AppsScriptInfopic.twitter.com/LaWzVW3v9p
Riël Notermans from Zzapps has published the beginnings of a nice little Google Apps Script library that you can use to communicate with your Tesla car.
Historically, Apps Script has been powered by Mozilla’s Rhino JavaScript interpreter. While Rhino provided a convenient way for Apps Script to execute developer scripts, it also tied Apps Script to a specific JavaScript version (ES5). Apps Script developers can’t use more modern JavaScript syntax and features in scripts using the Rhino runtime.
To address this concern, Apps Script is now supported by the V8 runtime that powers Chrome and Node.js. You can migrate existing scripts to V8 in order to take advantage of the modern JavaScript syntax and features.
This page describes the new features enabled by V8 and how you can enable V8 for use in your scripts. Migrating scripts to V8 describes steps for migrating existing scripts to use the V8 runtime.
Developers have been waiting a while for the new Google Apps Script runtime, since 2018 in fact, but it’s now here. The new runtime not only allows developers to use modern JavaScript syntax but when announced in 2018 also comes with a a tenfold (x10) faster execution. Follow the link to the developer docs for the full migration guide.
Come and celebrate Google Sheets at SheetsCon 2020, the world’s first, dedicated online conference for Google Sheets users.
Listen to world-class experts talk about how they craft solutions using Google Sheets and G Suite.
Over the course of two jam-packed days, you’ll hear everything from deep-dive tutorials on specific topics to cutting-edge solutions across different industries. You’ll have the chance to network with other professionals and meet vendors at the forefront of the Google Sheets movement.
Looks like a great event being hosted by Ben Collins for Google Sheets users. Click through to the SheetsCon 2020 website for the full agenda and free registration
Every Monday I send out a Google Sheets tip email and occasionally I’ll include a formula challenge…. It would have been too time consuming to reply to all 150 responses manually from my inbox. Since 95% of all my replies would be the same … it was a perfect case for automation.
Ben Collins expertly shares how he automates part of his Gmail inbox to review emails in Google Sheets and prepare draft replies to be sent as responses. As always Ben provides details of each step and the code.
leverage the power of dialogflow & connect your data sources with simple apps script functions to experience the next-gen approach towards consuming data and shaping insights.
Nice proof of concept from AppsScriptPulse Contributor (and now Editor :)
Sourabh Choraria of the results of a recent hackathon to use Google Sheets as a data source for a Dialogflow agent/bot.
A Google Apps Script and Google Cloud Platform tutorial to learn how to use GCP Service Accounts to scale and protect automations
Examples of Google Apps Script being used in an enterprise setting tend to be few and far between which means this tutorial by Jeffrey Daube is an interesting insight to how script projects can be setup to serve the entire company. In particular, Jeffrey details how the use of service accounts can be used so that G Suite documents can be created with a non-human user allowing you to make calls to Google APIs without the usual authentication flow.
G Suite Admins have started to be notified that App Maker will be shutdown on January 19, 2021. In the turndown notification Google cited ‘low usage’ as the reason for the shutdown. This news comes shortly after the announcement of Google acquisition of no code platform AppSheet and AppSheet is identified as one of the alternative platforms:
Due to the specific source code used for App Maker, you can’t directly migrate your apps to another platform. Depending on your use case, we recommend these alternative tools:
If you use App Maker to automate business processes: Use AppSheet, a new addition to our app development portfolio that has capabilities similar to App Maker. App Maker data is stored in Cloud SQL, and App Sheet supports Cloud SQL databases. This allows you to build an application on the existing database tied to your App Maker app.
If you use App Maker to develop apps: Use App Engine to build and deploy applications on a fully managed platform. App Maker data is stored in Cloud SQL, allowing you to build an App Engine application on the existing Cloud SQL database tied to your App Maker app.
If you use App Maker for data collection: Use Google Forms, which has many new features that were not available when App Maker launched.
Google included the following schedule for turndown:
Today, existing apps continue to work. Though App Maker is no longer under active development, the service will continue to be maintained.
Starting April 15, 2020, you will no longer be able to create new App Maker apps. You will still be able to edit and deploy existing apps.
Starting January 19, 2021, App Maker apps will stop working and you will no longer have access to them. App Maker data stored in Cloud SQL will remain unchanged and continue to follow the policies established by your Google Cloud Platform (GCP) account.
