DEV Community: Viktor H. Morales

Export spreadsheet data to a Google presentation

Viktor H. Morales — Wed, 25 Jun 2025 17:47:53 +0000

In order to avoid human error and optimize the workflow at the hotel reception where I work, I developed an application that allows exporting data from a spreadsheet (Google Sheets) to a Google presentation (Google Slides).

🇪🇸 Read this article in Spanish on my blog: viktormorales.com

🤔 The Problem

We use a Google Sheets document to record information about guests who will use the hotel’s spa day service. Since the voucher is valid for 15 days, we also needed a column that calculates the voucher’s expiration date.

This information then had to be transcribed (copy/paste) into a separate document that has a predefined design.

After that, the document had to be exported as a PDF to be sent to the customer.

Among these steps, the copy/paste moment was especially critical, as we could accidentally copy incorrect information — or even make mistakes calculating the expiration date manually.

💡 The Solution

I created a Google Apps Script that allows the following steps to be done automatically with the click of a button:

Populates a Google Slides template with data from the spreadsheet.
Exports the Google Slides file as a PDF and saves it to a specific folder in Google Drive.

The Spreadsheet

This sheet contains the relevant information, including issue date, expiration date (calculated automatically with a formula: issue date + 15 days), guest name, and more.

In the top menu, there’s an option labeled "Create Voucher" — clicking it automatically exports the latest row in the spreadsheet to a PDF.

The Presentation

This is the voucher template created using Google Slides.

The template has two text fields with the variables {{NAME}} and {{DUE_DATE}}, which are automatically filled in using data from the spreadsheet.

The script replaces those placeholders and saves the final file as a PDF in a Drive folder.

The Final Voucher

This is the resulting PDF voucher, complete with the guest’s name and the expiration date automatically calculated from the spreadsheet:

The Code

Without further ado, here is the script:

⚠️ Make sure to update the IDs for the spreadsheet and the presentation.

JavaScript: Create an Excel file from another Excel file

Viktor H. Morales — Sun, 30 Oct 2022 20:53:27 +0000

Why should I want to create an Excel file from another Excel file?

If you work with tons of Excel files every day and need to share some information to some people/agency/company and other information to some other people/agency/company and you are tired of wasting time copying and pasting... here's how you can take advantage of web development.

Using this HTML Form:

Go from this:

To this:

I won't make a whole speech about this as I am way better demonstrating results than wasting words. Enjoy!

Cheers!

HTML Input: add plus and minus buttons with JavaScript (or jQuery)

Viktor H. Morales — Thu, 28 Jul 2022 02:22:00 +0000

This is a translation from my spanish version written on my personal blog: https://viktormorales.com/diseno-y-desarrollo-web/html-input-agregar-botones-mas-y-menos-con-javascript/

A customer asked me to add plus (+) and minus (-) button before and after an HTML Input of type "number" for his WooCommerce store.

Add plus and minus buttons with jQuery

As the customer website is running on WordPress and as this platform has the library jQuery on it, I developed a solution using that library:

Add plus and minus buttons with JavaScript

So I was happy with the result but I wanted to code it in plain JS as well:

🍻 Cheers!

HTML + CSS +JS = Aplicación funcional

Viktor H. Morales — Mon, 27 Dec 2021 02:01:00 +0000

🎉 En mi primer posteo en esta comunidad quería compartir una aplicación funcional desarrollada en HTML, CSS & JS para el Hotel en el cual trabajo en mi ciudad Ushuaia, Argentina.

🤖 Una de las tareas repetitivas que quería automatizar durante mi turno es la de enviar mensajes con novedades a los huéspedes del hotel. Para ello desarrollé esta mini aplicación que ya tiene información y un diseño predeterminado.

Actualmente esos mensajes se imprimen en papel y se envían departamento por departamento, práctica que de a poco estamos reemplazando por mensajes por WhatsApp. Pero eso es otra historia.

En codepen.io dejo el código completo y cada uno con sus comentarios para que lo analicen.

Usé:

HTML para la maquetación del diseño
CSS y Bootstrap para ponerlo bonito
JS para que cuando se haga click en el botón "Continuar", muestre la página de impresión y procese la información del formulario.

Esta aplicación es la base de una aplicación un poco mayor, ya que la idea final es que cuando se hace click en "IMPRIMIR":

Imprima el mensaje,
Lo guarde en una carpeta,
Y también guarde el registro en una base de datos para consultas posteriores.

🙋‍♂️ Este artículo es un servicio para aquellos lectores que están iniciando en estas tecnologías puedan ver un uso sencillo y aplicable a la vida real.

¡Saludos!