Differences

This shows you the differences between two versions of the page.

--- wiki:publish_from_google [2024/04/02 12:48] – wikiadmin
+++ wiki:publish_from_google [2025/05/25 22:46] (current) – wikiadmin
@@ Line 1: / Line 1: @@
-======How to Publish a Google Doc or Sheet for web viewing, like on this wiki======
+======How to Publish a Google Doc or Sheet for web viewing======
 =====Google Doc=====
-  * Open the Google Doc
+  - Make sure the Google Doc is stored on an FSGW Shared drive, not on a My Drive.
-  * Choose **File** -> **Share** -> **Publish to Web**
+  - Open the Google Doc
-  * A pop-over form will be displayed
+  - Choose **File** -> **Share** -> **Publish to Web**
-  * Under **Published content & settings** near the bottom, make sure **Automatically republish when changes are made** is selected, which it is by default.
+  - A pop-over form will be displayed
-  * If the Google Doc is already published, There will be a "Stop publishing" link just below **Published content & settings** and a Link will be displayed
+  - Under **Published content & settings** near the bottom, make sure **Automatically republish when changes are made** is selected, which it is by default.
-  * Click the **Publish** button
+  - If the Google Doc is already published, There will be a **Stop publishing** link just below **Published content & settings** and a Link will be displayed
-  * A pop-up will ask **Are you sure you want to publish this Selection?** Click on **OK**.
+  - Click the **Publish** button
-  * The pop-over form will briefly (hopefully) display a message saying it's working.
+  - A pop-up will ask **Are you sure you want to publish this Selection?** Click on **OK**.
-  * When it's done working, select and copy the Link that is displayed.
+  - The pop-over form will briefly (hopefully) display a message saying it's **Publishing...**
-  * Paste the link into the wiki where you want it.
+  - When it says **Published**, select and copy the Link that is displayed. Note that the Link text extends well to the right of what is visible, so be careful to select all of it.
-  * If you click on **Embed** next to **Link**, it will display HTML code to display the published doc in an iframe.
+  - Paste the link into the wiki where you want it.
+  - If you click on **Embed** to the right of **Link**, it will show HTML code to display the published Doc in an iframe, which might suit your needs better.
+=====Google Sheet=====
+  - Make sure the Google Sheet is stored on an FSGW Shared drive, not on a My Drive.
+  - Open the Google Sheet
+  - Choose **File** -> **Share** -> **Publish to Web**
+  - A pop-over form will be displayed
+  - Under **Published content & settings** near the bottom, make sure **Automatically republish when changes are made** is selected, which it is by default.
+  - If the Google Sheet is already published, There will be a **Stop publishing** link just below **Published content & settings** and a Link will be displayed
+  - **Entire Document** and **Web page** should already be selected. If not, then select those.
+  - Click the **Publish** button
+  - A pop-up will ask **Are you sure you want to publish this Selection?** Click on **OK**.
+  - The pop-over form will briefly (hopefully) display a message saying it's **Publishing...**
+  - When it says **Published**, select and copy the Link that is displayed. Note that the Link text extends well to the right of what is visible, so be careful to select all of it.
+  - Paste the link into the wiki where you want it.
+  - If you click on **Embed** to the right of **Link**, it will show HTML code to display the published Sheet in an iframe, which might suit your needs better.