I'm retrieving Shopify API data using the query below in Google Sheets. The query retrieves Shopify products and their delivery profile. But all products are being displayed in a single row based on their delivery profile? For instance, if 10 products are in delivery profile ($100 Shipping) then all 10 products for that delivery profile would appear in a single row together with their delivery profile data like first example below. But I want each product to be displayed on separate rows with the delivery profile data in the columns beside it like the second example below *I am also not sure of how to setup the proper pagination for this query to pull 'all products'.
Solved: If you are using the API Connector (Add-On) for Google Sheets to import data from Shopify AND you are using a GraphQL Query you have to go into the API Connector's [Output Options] menu and change Report style to [Compact] to display the individual records on their own rows.