Is spreadsheet-url visible in source-code

  • Resolved HennerB

    (@hennerb)


    9 years ago

    Hi,
    before I install the plugin I would like to konow, if the spreadsheet-url is visible in the source-code and visitors are able to modify data with this information.
    Best
    Henner

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Meitar

    (@meitar)

    9 years ago

    That depends on how you set your Google Sheet settings. Nothing to do with this plugin.

    Dustin Tantum

    (@tantumonium)

    9 years ago

    [is] the spreadsheet-url is visible in the source-code and visitors are able to modify data with this information

    The spreadsheet URL is not visible in the source code, however, the spreadsheet id/key is… making it pretty easy for someone to access your publicly shared spreadsheet. As for modifying your data, as Meitar said, that depends on your sheet’s permissions are setup.

    In a previous discussion Meitar and I had about this, the following is the advice I was given.

    You should use a separate Sheet for private data, as that provides actual access control. You can still reference data from a private sheet in a public sheet’s cells, which is how you should re-engineer your Sheets.

    This can be accomplished by using Google sheets IMPORTRANGE function.

    Plugin Author Meitar

    (@meitar)

    9 years ago

    You don’t need a function, or a separate sheet (although I think in your case, that’s what made the most sense), you can also just selectiely publish a single worksheet and then use absolute cell references (!"Sheet 1":$A1 or similar).

    Point is, segment your data the same as you would any sensitive information.

    • This reply was modified 9 years ago by Meitar.
Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Is spreadsheet-url visible in source-code’ is closed to new replies.

  • 3 replies
  • 3 participants
  • Last reply from: Meitar
  • Last activity: 9 years ago
  • Status: resolved