Workaround for Retrieving Direct Links of All Sheets from URL of 2PACX-###
of Web Published Google Spreadsheet
This is a sample script for retrieving the direct links of all sheets from the URL like https://docs.google.com/spreadsheets/d/e/2PACX-###/pubhtml
of the web published Google Spreadsheet. This sample script can be used for the following situation.
- The Spreadsheet is published to Web and the URL like
https://docs.google.com/spreadsheets/d/e/2PACX-###/pubhtml
is known - You are not the owner of Google Spreadsheet.
- You don't know the Spreadsheet ID and Sheet IDs.
Under above situation, unfortunately, the direct links of each sheet cannot be directly retrieved. I think that this is the specification of Google side. So in this post, I would like to introduce a workaround for retrieving the direct links of each sheet under above situation.