Import Password Protected Google Sheets Tables
Valentin Kossenko
Currently, WP All Import does not support importing from password-protected Google Sheets. This feature would be extremely useful for handling partially sensitive data.
In our case, we maintain a large Google Sheets document containing COGS (Cost of Goods Sold) and other sensitive information. We do not want to make this file publicly accessible on the internet. Exporting and uploading a new CSV each time is cumbersome, so the ability to import directly from password-protected Google Sheets would greatly improve our workflow and security.
Trey Mills
Valentin Kossenko thanks for the request! By "password-protected", do you mean a sheet that's restricted to certain users? Or are you actually setting a password that's required to access the sheet?
Valentin Kossenko
Trey Mills Hi there. I actually meant sheets restricted to certain users, so it will probably be necessary to have some type of OAuth connection here. As an example, the WP Vivid Backup plugin allows you to connect to your Google Drive by logging into your Google account. It will then backup files directly into a specific drive folder. A connection like this could be used to access sheets that are hidden from the public. There is no password protection feature at the moment afaik. That was a mistake on my end. Sorry!