Q:

Finder go to Clipboard

I’d like to create an Apple script that will use a text path in clipboard and open a new Finder window and go to that path

A:

If you can use the Terminal, do
open "`pbpaste`"

A:

Assuming that the clipboard contains a string of the form /Users/username/path/to/file, this should work:
tell application "Finder" to reveal (get the clipboard as string) as POSIX file

The use of the verb reveal ensures that, if a path to a file is supplied, the Finder will display that file in its containing folder rather than launching an application to open the file. If this isn't desirable, replace reveal with open.

