It is super easy in Google Sheets to select only specific rows, even if they are not adjacent. Simply hold down the CTRL / command key while making your selections: This can be useful to copy selected rows in another sheet, delete a bunch of rows,… And those selections…

About Mergo: Mergo is a mail merge add-on for Google Workspace. It lets you run email campaigns from Gmail, Google Sheets or Docs. ✍️ You can write your content directly in a Gmail draft, or use Google Docs for advanced formatting and Mergo will automatically convert the doc into an email…

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: Limitations / Known issues | Community Visualizations External images are not supported due to the CSP.developers.google.com Indeed, if Google allows external developers to create new…

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…

Use Google Apps Script and the Google Slides API to create a card game like Dobble. What am I talking about? 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

Upload a few images to Google Drive, press the trigger to start a little Apps Script code and you will get your own Dobble game on Google Slides. — 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…

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…

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…