1

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

  • What do you mean by "share Google Sheets"? What do you expect that others be able to do with your spreadsheet? – Rubén Mar 1 '18 at 0:36
  • 1
    That's right, that isn't possible. – Rubén Mar 2 '18 at 0:47
1
+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 thiscase, 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, In thiscase, the shared URL is the URL of your own site.

I think that there are other methods except for my answer, so please think of this as one of several answers. If I misunderstand the situation you want to use, I'm sorry.

  • 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 '18 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 '18 at 22:20
  • 1
    @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 '18 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 '18 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 '18 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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