Brainstorming Google Sheets to maps website

There are websites that let you turn a Google Sheet into a complete website. Such tools are great if you have a spreadsheet of content and want to create an online listing for said content without having to go through a lot of hoops (set up a website, figure out how to import your content, import your content, etc.).

When a friend says that they are travelling somewhere I have been, I usually link to my coffee shop map of that place, provided I have made one. An example of a map for Berlin. I enjoy making these maps, both as a way to keep track of what coffee shops I have had and as a resource for friends who are travelling. My maps pages show both a map of a place as well as the full list of locations, and then have dedicated pages for each location. These dedicated pages are where I have a ~1 sentence review of the location, as well as a map that focuses on the location.

It would be amazing if there were a Google Sheets to maps website that provided this as a service. The workflow would be:

1. Create a spreadsheet;
2. Add metadata about a place to the sheet (latitude, longitude, a star rating, a description, place name -- really, anything you want);
3. The service makes a page for your new row, and then;
4. You can link to an aggregate map as well as the map for a specific location.

I like to make maps for coffee shops but this same principle could apply to anything for which you want to make a map: restaurants, photography spots, and more. Curated maps to share with your friends. This site could use a tool like OpenStreetMap for embedding the maps like I do, since there are a range of programmable extensions that enable you to customise maps.

Such a service could automatically generate tag pages according to tags you have added in a column in your spreadsheet (i.e. "San Francisco diners" or "New York photography spots").

Some previous brainstorms:

• Throwbacks and Brainstorming Timehop for Blogs
• Brainstorming a coffee label reader application
• Brainstorming a daily scavenger hunt game
• Brainstorming Email to RSS