Skip to main content

Now Supporting The New Google Sheets: Upgrade Steps for Legacy Users

Howdy.

Just a quick post to announce we recently launched support for the new Google Sheets -- I think they were previously called Google Spreadsheets, but alas, the new name and UI are more aerodynamic...

MapAList has recently been updated to support the new Google Sheets.

To harness these new features, one must re-authorize MapAList's access to one's Google Docs.  (Note: This is only required for legacy users.)

Take no action and only (the old) Google Spreadsheets will be supported. Follow the steps below, to keep up with the Joneses, and  be able to map from the new Google Sheets, as well as the old format.

Steps:
1) Go to mapalist.com and log in
2) Go to MapAList's Google Auth Page
3) Click "Accept" on the Google page to enable MapAList to use your Google Sheets on your behalf
3.5) 10 push-ups, because if you don't have your health...
4) Try creating your map again
5) Let us know how you fared

What you are doing is switching your account from AuthSub (the way we previously accessed users' spreadsheets) to OAuth2 (the new way), and the new way should enable the new Google Sheets to work in MapAList.

Good luck, and please let us know how it goes.

Cheers,
Brian

Popular posts from this blog

New Video Tutorials (Updated)

We decided to experiment and create some video tutorials in the hope they might be more effective instruction and better at getting the word out about what features exist in mapalist and how to utilize them. We hope you find value in the first few we put out. Creating your First Map Using Custom Icons Starting from an Excel Sheet Editing your Maps, Post-Creation Syncing your Map and Google Sheet

Allow your Member/User Base to Add Pins to your Map Using Google Forms

As the MapAList user base has grown over the past couple of years, one of the things we’ve noticed is that we have a ton of organizations leveraging our toolset to map their member/user bases. Religious organizations use MapAList to track their congregations; alumni associations use MapAList to track their members; campaigns and non-profits use MapAList to track their supporters/donors…you get the point. The reason I bring this up is because a few of these organizations have gotten smart and realized that they could push the work of updating their maps out to the user based directly using Google Forms. It’s like self check-out at the grocery store – the users love it because they are empowered (and because it’s a novelty to scan those barcodes) and so does the store because it reduces labor. Sounds cool – right? Well, implementing such a solution on your site with MapAList is not terribly difficult. Those folks at Google have made Google Forms easy to design and feed to a G

Adding Hyperlinks to Your Map Points

What are we talking about here? The ability to visualize a list of addresses on a map is definitely useful - and it's what we're all about here at MapAList.  Leveraging hyperlinks within maps makes them even more interactive for you and your users.   In this first post about hyperlinks, the goal is to show you how to associate a link to a website with a pin on your map.  This will allow whomever is viewing your map to click on a pin and see hyperlinks in the bubble that pops up. Furthermore, it will enable the viewer to click on the hyperlinks to navigate to a URL directly from the map.  Sound cool?  It is.  Sound hard?  Don't worry, we'll walk you through it... What does it look like from a spreadsheet perspective? There are 2 approaches to making this work, one certainly more efficient if you are dealing with multiple address records. In the sample spreadsheet below, you can see a column called Site  which is used to associate the address with a website (URL).