New feature: grid style
By @ana
JSON API responses typically contain nested tree-like data rather than the flat row-column output used in spreadsheets. Therefore the API Connector add-on provides several built-in algorithms to convert JSON responses into a tabular format for Google Sheets. Today, there is a new addition: grid style.
Grid style differs from the existing report styles in that it adds to the underlying JSON output rather than just changing the way it's displayed in the sheet. It repeats parent elements row by row to match them up with their nested inner elements, thus creating a "grid" that can be very useful for reporting and analysis.
More information is available here: https://mixedanalytics.com/knowledge-base/report-styles/