How to import a Google spreadsheet to a content?

Modified on Tue, 26 Oct 2021 at 07:15 AM

You can import a sheet created in Google Spreadsheets into a content of the pop-up



Add a Google Sheet block



To do this, in the content editor click on the Google Sheet button:



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



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:




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:




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


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:



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



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 clicking on the Refresh button next to the URL field.


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:



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



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






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



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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article