You can achieve this by creating a global variable "Gauge" and use nested 'IF' statement and "Thickness" to find out the sheet metal gauge. Then you can create a custom property in the part document and link that custom property in the drawing.
Here is a detailed explanation: SOLIDWORKS 2016 - The sheet metal gauges - May 2016 - YouTube
Thanks for the information
What I am looking for is something like Nilesh described, but automated with a simple API.
The thing is that I'd like it to work with different type of gauge tables, such as Steel, Aluminum, etc. therefore I want to avoid embedding a long IF statement string because it would be very long to manage (my guess).
Is there any way to use something similar to a Lookup excel command?
Then I would trigger the API once a sheet metal part is created, or else for a solid part it might end with an error for the global variable as it will search on an empty value of thickness
Thanks for your support