It’s not possible to use env variable in awk but we can pass them like this.
export VAR=test echo | awk -v env_var="$VAR" '{print "The value of VAR is " env_var}' > The value of VAR is test