This guide will help you create and configure a custom data source in Mapsly using Mapsly's connector to Google Sheet and import the initial data set to Mapsly. Then, you may use Mapsly API or Zapier to sync data with Mapsly

Step 1: Sign up for a Mapsly account

If you haven't done it already, sign up for a trial Mapsly account by following this sign-up wizard.

Step 2: Create a Google Spreadsheet describing your data source

Create a new Google Spreadsheet.

2.1. Create sheets, one per object you'd like to import

Add sheets to your spreadsheet, one per object in your external system, and name them:

Label[[apiName]]

Here, Label is the visible name of your object, and apiName is the internal name of this object that you will be using in API calls.

For example, if you'd like to sync Leads and Accounts from your IT system to Mapsly, create sheets:

Leads[[Lead]] 
Accounts[[Account]]

2.2. Export CSV files, one per object, and upload them into these sheets

For each of the objects (tables), you'd like to import to Mapsly, export a CSV file from your IT system and upload it into the sheets.

Make sure the first line in every sheet is the names of your exported fields. If you exported data without the field (column) names, insert a line on top, so data starts from line #2.

2.3. Add field types and API names to all fields

Make sure all your columns are named like this:

Label[[type||apiName]]

Here:

  • Label is the visible name of your field that Mapsly users will see in their Mapsly user interface,

  • type is one of the supported field types listed below,

  • apiName is the internal name of the field that you will use in API calls.

IMPORTANT! Column A in every sheet must contain the ID field of the object: a unique value across all records within this object that will serve as a record's identifier in your API calls. If it's currently in another column, move this column to the first place.

Supported field types

  • text

  • integer

  • bigint

  • float

  • boolean

  • datetime

  • date

  • picklist

  • mpicklist

In addition, you can specify length of your fields, for example:

Label[[text[500]]]

Step 3: Connect to Google Sheets with Mapsly

After your sheet is ready the last step left is that you will need to connect to Google Sheets using your Mapsly account. You can find detailed instructions on how to do that in this article.

Now you're ready to set up data sync using Mapsly API or Zapier.

Common issues & solutions

  • If your column has no label it will not be imported to Mapsly. Consider adding a label which should be in the first row (1:1)

  • In case of having duplicate id only the first record will be imported to Mapsly

  • Columns with duplicate names will be ignored

Did this answer your question?