

Otherwise, the user will be able to modify your data. *NOTE – Make sure your document is set to ‘can view’ and NOT ‘can edit’.

This will link directly to my spreadsheet in the view state. Select the option “Anyone with the link can view”Ĭopy the link. Update your share settingĬlick the Share button in the upper right-hand corner of the page While this will work, let’s automate this export process. Perhaps your first thought might be that I should select the File menu and choose the ‘Download as’ option.

Now, what I would like to do is create a PDF from this spreadsheet. Create your spreadsheet or documentįor this example, I’m going to be creating a simple price sheet which includes a product name, description, SKU, and price. Wouldn’t it be great to have the ability to update this information on-the-fly from the original source without having to re-upload the exported file? Today, I’m going to show you a very simple way to create dynamic downloadable documents within Google Sheets and Google Docs. These files might contain additional product information, pricing, or other specifications. Most of the websites that we develop include some form of downloadable PDF, XLSX, or DOC.
