Do you want to send your current address or geocoordinates to a phone number that is shown in a GoogleSheet by sending a Text to that phone number? Follow @GuiM_Haes 's advice and use code similar to this to select the phone number:
Retrieve location specific Phone Numbers (or other data) from an appropriate Google Spreadsheet
Then send an sms (Text message) using the Texting component to that phone number.
Is that what you want to do (send a Text to a phone number that is stored in a Google sheet) or do you want to do something else? If something else, please explain what you want to do in more detail and tell us what you tried so far. Thanks.
Regards,
Steve