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.
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