Current Issues, FAQ and Feedback

Current Issues

'Authorization is required' OR 'You do not have access/permissions' errors, when using multiple Google accounts

There is a persistent and annoying old issue that happens when you are using (logged in or not) multiple Google accounts in the same browser session

When doing anything from the add-on sidebar, you would get one of the following error messages:

  • "ScriptError: Authorization is required to perform that action"

  • "Exception: You do not have access to perform that action. Please ask the owner of this item to grant access to you."

  • "Exception: You do not have permissions to access the requested document."

This issue should disappear,

  • If you log in with just the intended Google account, or

  • If the intended Google account is the Default (the first one you logged in) among the others

Alternative, you can use multiple profiles/people, as described on this Google post

This way, each account will run in an isolated browser session, avoiding this and many other potential issues

p.s. This error is related to a very old issue at Google side (since Nov. 2017) as detailed in this post. You can star it to get some more attention from Google support.

There are no other current issues in the add-on at this time

FAQs

How many locations can I plot on a map?

If using the Basic Free Plan, you can only build a map with up to 50 locations, while with the Advanced Premium Plan you don't have that restriction (cap).

However,

  • It might take from a few clicks to a few days to build a large map (on the thousands), depending on the type of Google account you are using, due to daily Geocoding quotas

  • Also, we have found some practical limits on the very many thousands of locations

See more details on this question, as well on how long it takes to BUILD a large map, on this post.

What about those required headers for Mapping?

Among the many columns you can have in your datasheet, there are 3-key required columns that plays a special role in your map: Title, Filter, and Location.

  • You would have to select those three column headers from the add-on sidebar as the first step to build your map

See more details about these required columns and the roles they play on your map on this post.

Can I trust this add-on? Is it safe to use?

Our short answer: yes. The Mapping Sheets add-on is safe to use. You can trust this add-on.

  • But that's not enough. As a user, you have to do your own research about the developer/organization behind any application and come to your own conclusions.

  • Trust in the Cloud is critical. It requires time and transparency. Learn more about us and what we do on this post and under our Privacy and Terms.

How To ...?

How to use custom icons (colors, shapes, etc) on my maps?

You can choose your own custom icons, colors and shapes, associated with each unique value of the column you select as Filter

  • But also define alternative properties to your icons based in other column's values, from the add-on Preferences > Icons section

  • You would also need to create a new sheet with the name Icons to further customize your marker icons

Learn more about how to customize your icons on this post

How to share my map with others?

Your map is a URL (link) in the browser with a parameter passing your map data file ID in your Google Drive, to our Mapping web app for loading

To share your map or in other words to give others access to your map URL and map file, just do as follows

  • First, share the .json file for view access, with anyone you want to give access to your map. You can do this from the add-on sidebar > ⋮ menu > Share my map.

  • Then, send them the full link (URL) to your map so they can open it.

See full details, procedure and background notes on this post

How to avoid that "Service invoked too many times for one day: geocode" warning?

The add-on calls the Google Geocoding service from your Google account to convert your location addresses into map coordinates

  • There is a daily quota limit on the number of calls to the Geocoding service that depends on the type of Google account you are using

  • If/when you hit that quota limit you would get the following warning: "Service invoked too many times for one day: geocode." until it resets within 24 hours

Learn more about Geocoding Service quotas and what to do about it on this post.

How to fix that "Problem loading the .json map data file" warning?

This error happens when the Mapping web app is loading the .json data file from Google Drive. The cause could be among the following

  • You don't have access to that file (ask the map owner to share it with you for view access)

  • You are using multiple Google accounts in the browser and the default account account doesn't have access to that file (switch to the account with access)

  • There might be something in your browser (computer or network) blocking the Mapping app from accessing that file (check the browser error console for details)

Please read this post for more details on how to solve this issue.

How to set the Location (full address) for Geocoding combining several columns?

If you have the full address split across several columns, you can combine them into a Location template using those column's headers as {{placeholder}},

  • You can even add some static content if required

  • For example: {{Address}}, {{City}}, {{Postcode}}, Canada

See full details and procedure on this post.

How to use my own map coordinates (Latitude and Longitude)?

If you already have a set of numeric map coordinates (Latitude and Longitude) for some or all your data

  • You just need to have those numeric coordinates under a pair or columns with names Latitude and Longitude

  • Those coordinates must be valid numbers: Latitude between -90 and 90 (excluded) and Longitude between -180 and 180 (included)

See full details and procedure on this post.

How to update my map automatically when the data changes?

After you BUILD the first map in your datasheet, you would be able to set a time-based trigger (under Preferences > Document)

  • That will do an Unattended BUILD to update your map, if the spreadsheet file has changed since the last BUILD

See full details and procedure on this post.

How to set a custom Infowindow?

By default, the Infowindow shows all the datasheet headers and data in a tabular format, with the Title column values as a header and dimensions as 250*300 pixels

Under Preferences > Infowindow you can customize several options as follows

  • Dimensions width and height, as well as locking height or let it be flexible to fit the content

  • Select the headers to show and their order in the standard tabular format

  • Define a full custom markdown template content with data placeholders

How to use Markdown for a rich content template in the Infowindow and Listing

You can use Markdown as a simplified markup language when creating the templates for a rich content format in your Infowindow and Listing

  • Those rich text templates can be defined and tested under Preferences for both Infowindow and Listing

See more details and examples on this post.

How to use custom labels for icons on my maps?

This feature is not yet available, though it is under consideration and partial development as an extended custom feature (∗)

  • The content of each icon label would come from your datasheet values under a selected header

  • Other options could be the position related to the icon and the label style (available css properties)

Please let us know if you are interested into be part of this project by submitting your feedback.

Submit Your Feedback

We value your feedback and are always working to make the Mapping Sheets add-on better for all our users.

Please submit your feedback by filling out this form.

We are aiming to reply within one (1) business day, however it might take longer, depending on current communication volume and available resources.