Get coordinates from location sensor

Can you show your script URL??

By the way , to send data to gsheet using script URL Pls try to follow the method as suggested in this tutor