Using a button to Open Google Maps referencing an address from a worksheet cell

Hello - Have done a lot of searching trying to find a simple way to do the following:

- Have a button (or inserted shape that looks like a button) called "Map It"
- User clicks on "Map It"
- The click action opens a new browser window in google maps
- The action also uses a previously entered address from the worksheet cell to automatically map that location

I have tried inserting a shape as button and assigning a google maps url. That works great and opens a new browser window with Google maps, but I cannot find a way to reference the address cell from the worksheet and insert the address in google maps automatically.

Any specific guidance for a simple way to do this would be much appreciated. This seems like a fairly simple thing to do, but I can't seem to bring it across the finish line.

You might find the Google Maps Developers Manual insightful. There is a section about modifying the URL to set parameters (like displaying an address, map, etc.). An excerpt from this document is quoted below:

Launch Google Maps and perform a specific action

To launch Google Maps and optionally perform one of the supported functions, use a URL scheme of one of the following forms, depending on the action requested:

Search — launch a Google Map that displays a pin for a specific place, or perform a general search and launch a map to display the results:
https://www.google.com/maps/search/?api=1&parameters

Directions — request directions and launch Google Maps with the results:
https://www.google.com/maps/dir/?api=1&parameters

Display a map — launch Google Maps with no markers or directions:
https://www.google.com/maps/@?api=1&map_action=map&parameters

Display a Street View panorama — launch an interactive panorama image:
https://www.google.com/maps/@?api=1&map_action=pano&parameters

Important: The parameter api=1 identifies the version of Maps URLs this URL is intended for. This parameter is required in every request. The only valid value is 1. If api=1 is NOT present in the URL, all parameters are ignored and the default Google Maps app will launch, either in a browser or the Google Maps mobile app, depending on the platform in use (for example, https://www.google.com/maps).