Complex array transformed to a multiline cell in a Google Sheets spreadsheet

What is it about?
Suppose a complex data structure with nested arrays. In this scenario Make extracts each of these arrays and transforms it into a multiline string in a Google Sheets spreadsheet.

scenario

How does it work?
By using the map() function and a spreadsheet formula. I almost gave up until I realised that it’s perfectly plausible to write spreadsheet formulas directly in Make!

The template uses this example spreadsheet.

The scenario and documentation is available on GitHub.

I will soon add a video tutorial and a blog post. Meanwhile, I would appreciate your thoughts and feedback. Thank you :slight_smile:

4 Likes

Here is the promised video tutorial and the blog post. :sunglasses:

1 Like