I created several visualizations for Google Data Studio, to easily display your data exactly as you want, through HTML templates.
Until now, for security reasons, it was not possible to display images inside this type of visualization, as documented by Google:
Indeed, if Google allows external developers to create new visualizations for everyone to use inside Data Studio, they don’t want to put your data at risk 😬 and thus block all data exchange between those visualizations and the external world 😭.
As a developer of a community visualization or as an end user of an existing visualization allowing images…
A week ago Google announced the availability of an improved code editor for Google Apps Script. (note: this new editor isn’t yet available to all — it should be by the end of the year🤞). In this article, I’ll focus on the changes related to Versions and Deployments in Apps Script.
Depending on your needs, you can deploy your Apps Script code in many ways:
The new IDE makes deploying your code one of the primary actions, with the blue “Deploy” button quite visible in…
Use Google Apps Script and the Google Slides API to create a card game like Dobble.
Dobble (Spot It! in the US)
A speedy observation card game. During the game, players have to spot the identical symbol between two cards as quickly as possible.
=> learn more on Wikipedia
This tutorial will guide you into creating your own Dobble card deck with Google Slides, which you can easily print for use in your day to day life.
Google Apps Script is soon approaching its 10 year anniversary 🎉 and
Bruce Mcpherson has written an interesting article about its evolution: 2019 — a decade in Apps Script, concluding that it has become more and more complex to release and maintain add-ons.
The potential for an Apps Script ‘wild west’ has given rise to a more sandboxed, user orientated environment again […] to the extent that many of those that have produced free add-ons in the past have either withdrawn them or have stopped developing new ones.
Thus I thought it would be interesting to:
I attended Google Next last week, filled with many announcements on GCP and G Suite. You can read this post from the G Suite Updates blog for a list of the main announcements related to G Suite.
I will focus on announcements linked to Google Drive, introduced during 3 different sessions at Next, all of them available on YouTube:
This is the third post of a serie (first one is here, second here) going into some technical details about a migration project for G+ communities — if you want to retrieve G+ data, take a look at this tutorial.
Since I started the project to export G+ content to Firebase, several people asked for a way to search those exports (eg: display all posts containing the word “awesome”), which absolutely make sense but is in fact quite tricky with the databases provided by Firebase…
Firebase offers 2 not-so-different databases: The Realtime Database and Cloud Firestore:
In my first post on this subject, I explained how we could use Google Apps Script to retrieve Google+ data before saving them in a Firebase database and display them using Firebase Hosting.
But most Google+ users who wish to export their data are not developers and will need to go through some technical steps:
This is the first post of a serie going into some technical details about a migration project for G+ communities — if you want to retrieve G+ data, take a look at this tutorial.
Google+ will be shutdown for consumers in April 2019. It won’t impact that many people but G+ was (still is…) the main place to discuss some topics, like Google Apps Script. Over the years, some G+ communities accumulated a lot of valuable knowledge which might totally disappear with the shutdown. Google usually provides ways to retrieve content when it is shutting down a product, via the…
Awesome Table has recently joined the very exclusive club of apps that have reached the 10M user milestone on the G Suite Marketplace, like Lucidchart. Perfect time to give a bit more visibility on this number of users and follow-up on my article Add-ons and the Google Apps Marketplace from 2016.
In the G Suite Marketplace, apps can be installed either by admins of G Suite domains or by individual users. When installed by an admin, Google takes the number of G Suite accounts on that domain and add it to your total number of users.
So, to reach 10M…