Expanding on my Google App Scripts text formatter

This post is a follow up to “Programmatic text formatting in Google Sheets with Google Apps Script”

Starting from where I left off in my last post, I had just started getting the basic bits and pieces wired together for this. A few months on, I’ve built out the concept into a more maintainable project.

Nothing much has changed in the Google Apps Script, aside from it no longer ignoring blank cells. A lot of work has gone into the internals of the Node JS based API it uses. I’ve nicknamed the API loquor meaning “I speak” in latin, as this project originally was to be used for generating translation request files for our multi-lingual products.

I changed a few things to make unit tests a bit easier to work with, however the I/O hasn’t changed. It still accepts a string of values and returns indices of substrings that should be formatted by the Google App Script. The API is generally more stable now, fully unit tested, and has had its internal logic broken into “rule-sets” to make maintenance a bit easier.

const input = ["<p>Cat</p>", "{{ dog }}", "% Parrot %"];
 
const results = await fetch(
  `https://loquor.herokuapp.com/parse`,
  {
    'method': 'post', 'payload': {
      'entries': JSON.stringify(input)
    }
  }
)
.then(response => response.json())
.catch(error => console.log('error', error));
 
console.log(results);
// [ [[0,3],[6,10]], [[0,9]], [[0,10]] ]

Check it out and let me know what you think: https://github.com/jamesrwilliams/loquor/