Do you store your customer’s information in an excel or Google Sheets spreadsheet? Wouldn’t it be handy to be able to send SMS to your customers directly from Google Sheets? With this guide we’ll show you how to integrate SignalWire API with Google Sheets API to track and contact customers regarding payments that are due. We’ll be using Google’s version of Javascript which is called Apps Script. You can modify this code however you need to fit your particular use case.
View the full walkthrough on our developer site here!
This guide uses Google Sheets so you'll need to have an active Google account.
You will need a SignalWire phone number as well as your API Credentials (API Token, Space URL, and Project ID) which can all be found in an easily copyable format within the API tab of your SignalWire portal.
-
Copy the code from the Javascript file and paste it into the Apps Script Editor in Google Sheets.
-
Input your SignalWire credentials in the custom 'Credentials' menu.
-
Run the script from the custom 'Send SMS' menu.
If you would like to test this example out, you can create a SignalWire account and space here.
Please feel free to reach out to us on our Community Slack or create a Support ticket if you need guidance!