Google Sheets SMS

The Vonage Messages API allows you to send and in some cases receive messages over SMS, MMS, Facebook Messenger, Viber, and WhatsApp. In this project, you will create a website that enables you to send bulk SMS messages to numbers stored in a Google Sheet. This project uses Vonage Cloud Runtime, removing the need to manage servers and hosting. Visit the developer portal to view documentation on how it works.

Steps

Before you can get started with the project, you first need to complete some setup with the Google API.

1. Create a new Google Cloud Project.

2. Enable the Google Sheets API.

3. Create a new Service Account.

   1. Give the Service Account a name, then click "Create and Continue".
   2. Click "Done" to skip the optional steps.
   3. Keep note of your Service Account email address.

   

4. Click on the Service Account you created. Then Click on "KEYS" and add a new key. Choose the JSON key type. This will download a json file to your machine.

5. Open the Google Sheet you are using for this project.

   1. Ensure you have a column called "Number" in rows A-Z in your spreadsheet.
   2. Share the sheet with the email address for the Service Account you created with Editor permissions.

   

   3. Keep note of the name of the sheet (e.g. "Sheet1") and the spreadsheet ID which is in the URL. E.g. /spreadsheets/d/<SPREADSHEET_ID_HERE>".

   

After completing the Google Sheets API Setup:

1. Ensure you are signed into your Vonage developer account. If you do not have an account yet, you can create one here.
2. Go to ‘Get Code’ and click ‘Create a new development environment’.
   1. You will see a pop up prompting you to choose a region, enter a workspace name and assign your Vonage number to the application - you will be able to buy one here if you do not have one already.
   2. Click ‘Assign a number’ to select your number from the list.
   3. The popup will also ask for your spreadsheet ID and sheet name. Fill them in then click continue to launch the workspace.
   4. When the workspace opens, you will see a README detailing how to edit, debug, run and deploy the project.
   5. Once your project is deployed, you can use the URL in the terminal output to access your application.