Account

• Connect to Google Sheets

  Click on the Connect button, you will be redirected to Google's authentication screen. Use your regular Google account to connect your store to Google Sheets and Google Drive. Important Safety scope: The Sheets app will be allowed to : create, edit and delete only the spreadsheets it manages. It means that the Sheets app has a restricted scope, it can only download, edit or delete the documents it creates. Sheets cannot access any of your Google Drive documents under any circumstancFew readers

• Generalities

  All Sheets Red sections in Google Sheets are non editable sections. Auto-Sync Data is sent from your store to the sheet on Google Sheets, in one way, every 30 minutes.Few readers

Products

• Import

  Once signed in to your Google Account, you will be able to send or update data from your store to the Sheets app. The data is sent to the cloud and then synchronized. It allows you to create and update your Google Sheets.Few readers

• Create your Sheets

  From this tab you can create your worksheets. Depending on the amount of products and variations, this operation may take some time. Once created, open the spreadsheet which will be divided into 3 sections: Products, Variants and SEO. Editable data will be displayed in green, non-editable in red.Few readers

• Sheets

  Product sheet The product sheet allows you to modify the following elements: Title Description Seller Product type Tags (separated by a comma) Handle Variant sheet In the variant sheet, you will be able to modify all the green cells. This tab is useful for updating your data in bulk mode (green zone). You can use the power of Google Sheet formulas as shown in the example below: (https://storage.crisp.chat/users/helpdesk/website/-/3/f/a/8/3fa8ee645cd13200/imagehyFew readers

• Sync

  Clicking on Update will send the data you edited to your store;Few readers

• Examples

  You can edit the data directly in the sheet itself, but for analysis purposes, we recommend that you create a new sheet, in this way, in case of an update of the application or if you have the intention to delete your sheet to recreate a new one, you will be able to move your formulas from the old sheet to the new one. Here are some samples with VLOOKUP formula and pivot tables; https://docs.google.com/spreadsheets/d/1BgQyH-W8u5pleURtG68zUc7bRP-f316WFEsLpJO4Qh8/edit?usp=sharingFew readers

• Video tutorial - how to communicate and share with your team

  Sheets for Shopify App allow you to talk with your team directly in the Sheet itself! You can add notes and comments. Here is a video sample about comments; Conversations in Sheets And more detailed, we share a pivot table and communicate about it; Pivot Table and conversationFew readers

Customers

• Notice

  You can download here your entire customer file, Please note that this spreadsheet cannot be synced with the store, this is a read-only section for information purposes only.Few readers

Orders

• Operation

  Here you can upload your orders up to 2 months earlier. Please note that the red area of the spreadsheet cannot be synced with the store, this is a read-only section. To update the order status and tracking number in your store, you will need to complete this section; Then, click on Update; YouFew readers

• Some examples

  You can edit the data directly in the sheet itself, but for analysis purposes, we recommend that you create a new sheet, in this way, in case of an update of the application or if you have the intention to delete your sheet to recreate a new one, you will be able to move your formulas from the old sheet to the new one. Here are some samples with VLOOKUP formula and pivot tables; https://docs.google.com/spreadsheets/d/182mO42ySYhZnrRpLw8Xl8D1WGSuzIMtWizwoHUxZM/edit?usp=sharing How to createFew readers