Importing a Google Spreadsheet into a size chart

You can import a sheet created in Google Spreadsheets into a size chart layout


Add a Google Sheet block

To do this, in the size chart layout editor click on the Google Sheet button:


Add Google Sheet Block - Prikid Size Charts App for BigCommerce


A new empty block will be added to the layout and on the right side, you'll see an editor for this block:


Google Sheet block parameters - Prikid Size Charts App for BigCommerce


You can start from scratch or use one of the templates.

Publish Google Sheet to the Web

If you already have a spreadsheet you want to import, open it in another browser tab, go to the File menu and click Publish to the Web:


Publish Google sheet to the Web - Prikid Size Charts App for BigCommerce


{info} Please note that only the very first sheet of the spreadsheet book will be imported!

In the opened window click Publish and copy the appearing link:


Click publish button - Prikid Size Charts App for BigCommerce


Copy public link - Prikid Size Charts App for BigCommerce


Return to the app tab and paste the link into the Link to the published spreadsheet field:


Paste public google sheet link - Prikid Size Charts App for BigCommerce


The published spreadsheet will be loaded and appears in the layout.

Using images in a Spreadsheet

If your spreadsheet contains images you also need to Share access to the spreadsheet for public view. Click on the Share button and then click on the Get sharable link:


Share google sheet - Prikid Size Charts App for BigCommerce


Click Done. Now you can use images in your spreadsheet.

{info}Note that you have to use the URL that you got from the Publish to the web dialog, not from the Share dialog

If you already inserted this spreadsheet into the size chart you need to reload it by click on the Refresh button next to the URL field.

{info} Please note that images must be inserted in cells for correct displaying

Using templates

You can use templates for a faster start. Click the Templates button and select one of the prepared templates:


Using google sheet templates - Prikid Size Charts App for BigCommerce


The selected template will be inserted into the layout. To edit it you need to copy it to your Google Drive.


Copy template to the google drive - Prikid Size Charts App for BigCommerce


To do this click the Copy to my Google drive button, the new tab will be opened where you have to confirm copying:


Confirm copying to the google drive - Prikid Size Charts App for BigCommerce


Make any changes and then publish this sheet to the web and copy/paste the public link as described in the previous steps.

{info} Please note, that every time you made changes to the spreadsheet you have to reload it to the size chart layout by clicking the Refresh button. According to the Google documentation, changes may appear with a delay of up to 5 minutes, so you have to continue refreshing until your changes appear.