Is it possible in google sheets to give a specific email access to view individual columns?

Question

Google Sheets

Is it possible in google sheets to give a specific email access to view individual columns?

Answer 1

No. The user who is granted access can view the entire table.
Make a separate document with one sheet. Use the IMPORTRANGE function to place data from the main document on it. Then make the new file available to those who should only see this data.
In this case, the main file will be inaccessible to them, but the new document will always contain up-to-date data from the main one.

Answer 2

In IMPORTRANGE there is a link to the document, it is more reliable to do this: File-Publish on the Internet , and you can also select a data format, for example pdf or csv