NOTION to GOOGLE SHEET - MULTI SELECT / MULTI TAG

This community has been very helpful in my learning journey, so I would like to share below two solutions to a problem I encountered.

Context: Synchronizing a NOTION database with a GOOGLE SHEET database.

Problem: Several properties of the NOTION database are of the Multi-value type (they contain multiple tags in the same cell).
The synchronization only considered the first tag…

Below are two solutions to solve the issue and synchronize all the tags from the same NOTION cell into a single GOOGLE SHEET cell.

SOLUTION 1:
Using an ITERATOR + TEXT AGGREGATOR

SOLUTION 2:
Using SET MULTIPLE VARIABLES