Including Google documents

You can include various types of files in your texts. A special class are the files created with the Google tools. These files are stored in the cloud, and you can include them without the need to attach them to the assignments. This requires though a little work as you must tell Google that you want to publish these. Here we describe how to include Google Docs documents and Google Sheets spreadsheets. In other help pages it is indicated how to include presentations from Google Slides and drawings from Google Drawings.

Options

The following global options exist:

Google Docs

When you create a document with Google Docs you can go to the File menu. Here there is an option to Publish on the Internet. Select the Link tab and press the Publish button if the document is not yet published. You will now get a link that looks as follows:

https://docs.google.com/document/d/e/2PACX-1vSz4WRx7rewHbPHji7a3RDpQ7VAI-5DcdzqyZlNPiQ0IjltWB5Y1LVAB1MQvFf1CfXhZUtfJLzqdD_8/pub

You can put this whole link in the url parameter or you can use the id instead. The id is indicated in bold above. This will look as follows:

```googledocs
    id: 2PACX-1vSz4WRx7rewHbPHji7a3RDpQ7VAI-5DcdzqyZlNPiQ0IjltWB5Y1LVAB1MQvFf1CfXhZUtfJLzqdD_8
```

Google Sheets 

For Google Sheets spreadsheets, you proceed in the same way. You only need to choose the option to create a web page. You will get a link that looks something like this:

https://docs.google.com/spreadsheets/d/e/2PACX-1vQ2c_8-Z7nRDxApEicK5nzej2fdQxntnVGNfrpoaO6-O0TLl0sfEl-mbNLMwQ7LArgZ4DhDpQ6RsFWP/pubhtml

Again, you can put this whole link in the url parameter or you can use the id instead. The id is indicated in bold above. This will look as follows:

```googlesheets
    id: 2PACX-1vQ2c_8-Z7nRDxApEicK5nzej2fdQxntnVGNfrpoaO6-O0TLl0sfEl-mbNLMwQ7LArgZ4DhDpQ6RsFWP
```

For Google Sheets the following additional options exist:

  • headers. Whether to show the row and column headers. Default false.
  • tabs. Whether to show the tab sheets. Default false.

Still need help? Contact Us Contact Us