Google Sheets | Select Spreadsheet

To create the app, you have the option to use a Spreadsheet file from your Google Sheets account.

When selecting the file, a corresponding "guest-link" will be generated. This does not mean that your file is publicly available!

Access to the spreadsheet will be granted only to the app you created, and (optionally) to users you have invited to this app.

In this article:

• Google Sheets spreadsheet
• Authorization
• Safety
• OAuth

Use Google Sheets spreadsheet as the source file

Your data will be treated confidentially and used only for this purpose. The connection will be encrypted through an https certificate.

1. Select "Google Sheets" from the 'Connect external service' section.
2. The Google website opens in a pop-up window.
3. Log into your Google Sheets account.
4. Select the desired Excel file.
5. Click 'select'.

The Open as App Wizard immediately begins analyzing the file structure and will automatically redirect you to the next step of the app creation process.

Please note that some browsers prevent the website to open "pop-ups". Check your browser settings and allow www.openasapp.net to open pop-up windows permanently or only this time. (In some browsers, you can try it with another click on the cloud icon.)

Authorization

On first use, you must grant access rights to the application. Open as App needs authorization to run.

You can revoke access in your Google Account settings at any time.

Safety

When using files from your cloud, only the initial app creation process takes place in the Open as App Cloud. In this case the source file will be encrypted and stored temporarily for the creation process only.

Future changes to your spreadsheet are communicated to your mobile devices by your cloud directly. This communication is never taking place via the Open as App cloud.

OAuth

We are currently working on a solution where guest access is not necessary. The authentication will take place on the user's device. The created app can only be opened if the user has already access to the file with his cloud account (e.g. if the file has been shared with the user, or his team on Dropbox Business) AND verified his account on the mobile device.