I’m wondering if there’s a way to use Cloudflare Access to control access to a Google Sheet that’s shared “publicly”. Sounds a bit weird, I know, but here’s the use case.
We have a Google Sheet (GS) that we’d like to allow certain people access to. If they have a Google account, they can use that and we can use GS’s built-in Sharing permissions.
But there are some people who don’t have a Google account and/or who don’t want to have a Google account.
The only way to give those people access would be to make the GS accessible (doesn’t matter if it’s Edit or View-only) “to the public” (i.e. anyone with the link can access).
But that’s a bit too “open” access for us. So we were thinking that Cloudflare Access could be a good bandaid. i.e. Set Cloudflare Access to send an email to x, y, and z users. And they could use that to “get in”.
Actually, now that I’ve typed everything out, I don’t think this is possible at all. But…is there a way?