Troop Marketplace
Search
⌃K

Google Sheets Reference

Troop Marketplace: Google Sheet Reference

With Troop Marketplace, you can import/update every piece of information in your map layers by using Google Sheets. This document describes the requirements for your Google Sheet to be compatible with Troop Marketplace and allow it to get the data from it.

Quick start

  1. 1.
    Create sheet.
First, you need to create your sheet on Google Sheets.
  • Navigate to Google Drive.
  • On the left menu, click on New - Google Sheets.
  1. 2.
    Configure permissions.
Secondly, you need to grant Viewer permissions to Troop Marketplace's email.
Permission level
Email
Viewer
  • Click on the Share button at the top right.
example
example
  • Uncheck Notify people.
  • Click Share.
  1. 3.
    Add data.
  • Add the required columns, that are specific to your app subtype (check App subtypes).
  • Then, add custom columns with data for each of your rows, until a maximum of 27.
You can check out our sample Google Sheets:

App subtypes

App Subtype: Geographic Area​

Check out the example sheet.
Required spreadsheet headers
Name
Required
Description
Validation
Example
title
Yes.
Title of your feature.
Non-empty values.
Bangladesh
country
One of country or region.
Country ISO code.
Valid 2-letter ISO codes.
BD
region
One of country or region.
Region ISO code.
Valid region ISO codes. The country ISO code must preceed the region ISO code.
BD-CG
city
No (not supported yet).
City ISO code.
None (not supported yet).
CGP
Custom style
Include certain columns in your Google Sheet to customize how geographic entities appear on your map. More information can be found in the Model Reference.

App Subtype: Geographic Location​

Check out the example sheet.
Required spreadsheet headers
Name
Required
Description
Validation
Example
title
Yes.
Title of your feature.
Non-empty values.
Secure area
type
Yes.
Type of the raw data you wish to represent.
One of the following: - Point - MultiPoint - Polygon - MultiPolygon - LineString - MultiLineString​
- Point - MultiPoint - Polygon - MultiPolygon - LineString - MultiLineString
coordinates
Yes.
Coordinates that represent your data.
Valid JSON string representing the coordinates. Check the specification of each of the previous types in Mapbox.
- Point: [100,0] - MultiPoint: [[100,0],[101,1]] - Polygon: [[[100,0],[101,0],[101,1],[100,1],[100,0]]] - MultiPolygon: [[[[102,2],[103,2],[102,2]]],[[[100,0],[101,0],[101,1]],[[100.2,0.2],[100.2,0.8],[100.8,0.8],[100.8,0.2]]]] - LineString: [[100,0],[101,1]] - MultiLineString: [[[100,0],[101,1]],[[102,2],[103,3]]]
Custom style
You can customize some style attributes of the markers in the map by adding some special columns to your Google Sheet. You can find out more in the Model Reference.
Previous
API Reference
Next
Model Reference
Last modified 30d ago