4

Is there a way to share Google Sheets(programmatically or otherwise) without revealing the Owner's name/Email address to the public/link receivers?

Improve this question
0

2 Answers 2

Reset to default
3
+500

If you want to give the permission of viewer and editor to users for the shared spreadsheet, you are required to share the endpoint like https://docs.google.com/spreadsheets/d/### fileId ###/edit?usp=sharing. In this case, users can retrieve your information including name and email from file ID using GET https://www.googleapis.com/drive/v3/files/### fileId ###?key={YOUR_API_KEY} of Drive API. Namely, it means that the method using the file ID gives the owner information to others. So how about this workaround?

  1. When the spreadsheet is published to web, the URL is like https://docs.google.com/spreadsheets/d/e/### Not fileId ###/pubhtml. In this case, users cannot retrieve the file ID. So users cannot know the owner information.
    • In this case, the shared URL is like https://docs.google.com/spreadsheets/d/e/### Not fileId ###/pubhtml.
  2. Display the spreadsheet using Web Apps. In this case, users cannot retrieve file ID, because the owner information cannot be retrieved from the Web Apps URL.
    • In this case, In thiscase, the shared URL is like https://script.google.com/macros/s/### Not fileId ###/exec.
  3. Display the spreadsheet using Google Visualization API and API key. In this case, users cannot retrieve file ID, because the owner information of the API key cannot be retrieved.
    • In this case, the shared URL is the URL of your own site.

I also think that there are other methods other than that mentioned in my answer.

Improve this answer
14
  • 1
    @I'-'I I had tried to convert from it to file ID before. But I couldn't do it. So I thought that this can be used for the situation you need. If you want to publish a special sheet, you can do it by selecting the sheet when it publishes. If you want to select from the published whole sheet, the file ID is required to be used. The URL is like https://spreadsheets.google.com/feeds/cells/[file ID]/[sheetId]/public/values?alt=json.
    – Tanaike
    Feb 28, 2018 at 22:20
  • 1
    @I'-'I And if you don't want to be cached by search bot, how about using Web Apps? In this case, you can use googlebot and robots of meta tag. Is my understanding for your comment correct?
    – Tanaike
    Feb 28, 2018 at 22:20
  • 2
    @I'-'I Yes. When the spreadsheet is published to web, you can access to it using the file ID of spreadsheet. But the URL which is retrieved by publishing spreadsheet doesn't include file ID. So only users who know file ID can use it using the URL with file ID.
    – Tanaike
    Feb 28, 2018 at 22:33
  • 1
    @I'-'I I could know it from ref1 and ref2. Although I might see other site, I forgot about them. I'm sorry. I also think that Google's manuals are a bit difficult for me. There might be some users who feel the same with me.
    – Tanaike
    Feb 28, 2018 at 22:43
  • 1
    @I'-'I I couldn't notice about it. So I had never seen about it yet. If I found it, I will tell you.
    – Tanaike
    Feb 28, 2018 at 23:20
0

If you use the Google Sheets sharing option, people able to access the spreadsheet is able to find it on Google Sheets (https://sheets.google.com) and on Google Drive (https://drive.google.com). There they will be able to see the spreadsheet owner and the spreadsheet collaborators either by the file listing or by the file information panel.

One alternative is to publish the spreadsheet to the web but this will limit what spreadsheet features are available to your spreadsheet users.

Another alternative is to use Google Apps Script, the Google Sheets API or a tool like Awesome Tables to publish the spreadsheet data but also, this will not include most of the the Google Sheets features.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.