The First step will be to authorize use of the two your Google account as well as your Shopify shop. This is a safe method which allows the increase-on to study data from Shopify and create it into your sheet. Pivot Tables are arguably the strongest aspect for spreadsheet https://www.integrationatlas.com/integrations/google-sheets-shopify/