Embedding a Google Sheet into a size chart

You can embed 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 into the layout and on the right side, you'll see the parameters 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 embed, 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 embedded!

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 automatically appear in the layout.

Using images in a Spreadsheet

If you want to use images in the spreadsheet 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} Please note that you need to insert your images in cells for correct displaying

Using templates

Also, 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 need 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 public link as described in the previous steps.

{info} Note, that the spreadsheet will be directly loading from the Google servers and any changes will automatically appear in your size chart. According to the Google documentation, changes will appear with a delay up to 5 minutes