Your access key

Please enter your Neonto Cloud access key to modify your Google Sheets setup:
Set >
Client key:
This key is used for plugins that send data to a sheet.

Sheets

No sheets. Add one below.

Add a sheet

You can copy this from the web browser's address bar.
Choose a short identifier for this sheet. This will be included in the document id. (If you leave this empty, a random id will be assigned automatically.)
Select a sheet index within your Sheet document. (The default is sheet 1.)
Add this sheet >

Instructions

Enable cloud access in your spreadsheet

To make your Google Docs spreadsheet visible to Neonto's server, you must share it with the following user:

googledocsaccess@neonto-cloud-apibridge.iam.gserviceaccount.com

This email address is not a real person, but a so-called "service account" that represents Neonto Cloud. (When sharing your Google Sheet, uncheck the 'Notify' box -- this service account doesn't care about email notifications.)

If you want your app to be able to write into the spreadsheet, you should give Edit permission when sharing.

Header row

The first row of each sheet is the header, it provides the column names.

The Google Sheets interface supports only lowercase letters and dashes for column names, so other characters will be stripped when importing to Neonto Studio and your app. For example, a column named "Hello World!" will become "helloworld". You should keep this in mind when naming your columns. (This applies only to the header row; your data in all the other rows can of course contain any letters.)

Using images

Google Sheets doesn't support images directly. Instead you can put image URLs in a cell. However the column name must have the prefix "img-", otherwise Neonto Studio won't know that this URL should be loaded as an image!

The "img-" prefix is removed by Neonto Studio when it imports a column. For example, if your Google Sheets column is named "img-profilepicture", the column in Neonto will be called simply "profilepicture".

You can store your images on any service that makes them visible on the web, for example Imgur or Dropbox. To get the URL for an image, just right-click in your web browser and choose "Copy image link" (or similar).

Add your spreadsheet to list of sheets

Once you've shared the sheet, add it to the list of known sheets here. Enter the sheet's URL in the "Add" field above. You can also choose a short identifier for it (this is just for your own reference).

Set up your spreadsheet in Neonto Studio