Action to open a Google Sheet

[James_Potter]

I am trying to open a Google Sheet with an Action (External: Open a File). I can to do this if the file I want to open is a pdf or jpg by using the file name in the expression below. However, the expression does not work if the file that I want to open is a Google Sheet.  I can only open the G Sheet if I use its URL in an Action(External: go to a website). Is there anyway to use the G Sheet file name in an Action in order to open it?

CONCATENATE(

"https://www.appsheet.com/template/gettablefileurl?appName=", CONTEXT(AppName),
"&tableName=", "PAYMENT",
"&fileName=" , [File Name]
)

[Steve · Accepted solution]

A Google Sheet is not a file. You'll need to use an action of type External: go to a web site.