2.2.27. Google Sheets to Web GIS

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; enter REPLACE to rewrite an existing layer (ID specified above).

Output:

  • Created/updated layer in Web GIS

Watch the video on youtube.

Launch tool: https://toolbox.nextgis.com/operation/spreadsheet2layer

Try it out using our sample:

Download input dataset to test the instrument. Step-by-step instructions included.

Get the output to additionally check the results.