Toolbox

Google Sheets to Web GIS

Web GIS
Tool downloads shared table from Google Drive, creates or updates layer in Web GIS.
Demo
URL of your Web GIS, e.g. https://demo.nextgis.com and login/password if necessary
Web GIS layer resource number to replace, or keep empty to create new layer
Resource ID of the group in Web GIS. Specify it when creating a new layer if you want it to be placed into a particular group right away.
Link to Google Sheets or its ID. Spreadsheet should be accessible for data reading and has lat, lon fields.
ADD
Use REPLACE to replace all objects in a layer or ADD to append to a layer.

Docs

Tool creates or updates point vector layer in NextGIS Web using Google Sheets. Spreadsheet must be accessible for reading via shared link.

There are two ways to store coordinates for this tool:

  1. Coumns ‘lat’ and ‘lon’, Coordinate reference system - WGS84.

  2. Google maps links to locations.

Input:

  • Web GIS link, example: https://sandbox.nextgis.com.

  • Web GIS user login. User must have writing access.

  • Web GIS User password.

  • Vector layer ID to update. Leave blank to create new vector layer.

  • Resource group ID. Specify the group to upload layer to. Use only if creating a new layer.

  • Google Sheets ID (e.g. ‘1cKvjCMBZajaortAkdQqVwQ_06LuLm3bHyvybJgmAeQg’) or URL. This link should be accessible for data reading.

  • Mode: by default the tool appends data to existing layer or creates a new layer (ADD mode); select REPLACE to overwrite an existing layer (ID specified above).

Output:

  • Created/updated layer in Web GIS

Watch the video on youtube.

Try the tool in action

  1. Click on the Demo button above the tool form. The fields are filled in with demo values.

  2. Click on the Run button.

Related tools

Web GIS