send sms from google sheets with address links

#SEND SMS FROM GOOGLE SHEETS WITH ADDRESS LINKS HOW TO#
#SEND SMS FROM GOOGLE SHEETS WITH ADDRESS LINKS INSTALL#
#SEND SMS FROM GOOGLE SHEETS WITH ADDRESS LINKS PLUS#

For this, I turned to one of my favorite text functions in Google Sheets. Wicked simple right? Well, at least the first part is. Find ClickSend SMS for Sheets in the /marketplace by searching ClickSend in the search bar at the top and you’ll see ClickSend SMS Sheets. var sheet SpreadsheetApp.getActiveSheet () var row sheet.getActiveRange ().getRowIndex () var phone sheet.getRange (row, getColIndexByName ('Phone')).getValue () var inventoryLinks sheet.getRange (row, getColI.

#SEND SMS FROM GOOGLE SHEETS WITH ADDRESS LINKS INSTALL#

Install the app and start to send bulk SMS from Google. Now it was just a matter of adding the address and turning the whole thing into a link. Otherwise you can only send to verified numbers // So this script allows me to put my cursor in the row I want to send an SMS. Google Sheet SMS is a free add-on to send SMS directly from spreadsheet. I discovered that if you paste this URL ( ) followed by any address or even a building name like a famous landmark or a name of a school, you will get the Google Maps location for the address. I would not be defeated by a measly column of addresses. So now what?Īt this point, my inner geek started to boil.

Of course, the first thing we did was look for a Google Add-on… no luck…maybe an extension… no luck. So with that rule in mind, I started to think of a way to accomplish this task. From the Insert tab, select Link (Ctrl + K). Particularly if you know you will be revisiting the said task again in the future. Use informative hyperlink text Select the cell where you want to place a hyperlink. Zapiers automation tools make it easy to connect Google Sheets and SMS by Zapier. var sheet SpreadsheetApp.getActiveSheet () var row sheet.getActiveRange ().getRowIndex () var phone sheet.getRange (row, getColIndexByName ('Phone')).getValue () var inventoryLinks sheet.getRange (row. If you are a spreadsheet enthusiast, this powerful sequence of shortcuts will help you deal with links quicker. Set up the Google Sheets trigger, and make magic happen automatically in SMS by Zapier. Here are just a few of the cool features you can access using ClickSend SMS For Google Sheets.

#SEND SMS FROM GOOGLE SHEETS WITH ADDRESS LINKS HOW TO#

After all, those that know me, know my rule of tech: It’s better to spend an hour learning how to automate a task than doing a 5-minute task that may need to be repeated over and over again. Otherwise you can only send to verified numbers // So this script allows me to put my cursor in the row I want to send an SMS. Go to APIs & Services > Credentials, and click Create credentials. Actually, anything over 2 would be annoying to an automated task obsessed maniac like me.

#SEND SMS FROM GOOGLE SHEETS WITH ADDRESS LINKS PLUS#

This is fine unless you have a column of 50 plus addresses. Now we all know that all you need to do is copy and paste the address into Google Maps and when the page loads, the URL at the top of the browser will be the link to that Maps location. She had a Google Sheet with a column of addresses, all of which she wanted to be linked to Google Maps. Well, she called it a dilemma, I called it a challenge. Just the other day a colleague of mine presented me with a dilemma.

Send sms from google sheets with address links