Every night, we run a batch that sends data from a point of sale service that sends data to Google Sheets, with the hope that we can trigger a Mailchimp automation or add subscribers (the POS software doesn't have an integration :().The data is sent as an array value, which outputs like this...The data is sent in single cells, nightly. This day in particular, 82 records were added as a single row, with commas separating the values.What we need is to take those 82 values, and have them as separate rows in a different sheet automatically. Once that's done, we can use Zapier to send each new row to Mailchimp as a subscriber.Pic below for desired effect...Hope this makes sense!
Splitting up comma separated values in a single cell to new rows
google spreadsheets