Importing a Google Spreadsheet into a content

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

• Add a Google Sheet block
• Publish Google Sheet to the Web
• Using images in a Spreadsheet
• Using templates

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:

{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:

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.

{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 content 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:

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 have 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.

{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.