The standard platform Bulk Send is limited to 1000 messages per CSV send, however if you are wanting to bulk send a more than that you can use our Google Sheet to SMS Integration to send up to 50000 messages. If you wish to send more than 50000 please get in touch with us.

 

How it Works

 

You will need to create a Google Sheet on your Google account & then copy over the contents of the provided template or replicate the Header names & Sheet names as shown below.


Template: https://docs.google.com/spreadsheets/d/1lQk1huCPNMiu5fZF7w8uNlDbTAQsFGs2rQPoNj4elKI/edit?usp=sharing

 

Below, you can see the Header name of each column & the name of each sheet in the Google Sheets template:


Trigger Sheet


Input Sheet






Output Sheet







Replies Sheet

Once the Google Sheet is setup you will need to populate the Input sheet columns with the SMS details, including the From, To & Text information that you want to SMS out to your clients.

 

FoneDynamics Platform:

 

Configuration from this step forward is now done in the FoneDynamics Platform, through the 'Integrations' section.

Please proceed to login to the Platform - https://platform.fonedynamics.com/

 

*If you require a login to the Platform or the Integrations option is not displayed, please contact the FoneDynamics Operations Team or your Account Manager for assistance.

 

Integrations Setup:

 

Once logged into the Platform, select Templates from the Integrations tab & select Google Sheets SMS

 

From the pop out window, select the Project to be provisioned using the dropdown menu & then select Install

 


Once the template is added, it will be visible from the Assets tab within the Integrations tab


Click on the Google Sheets to SMS recipe to start the configuration

 

 

Connection Setup:

 

Now click on the Connections tab on the top bar to configure the FoneDynamics and Google Analytics Connections for this Recipe:

 

 


The FoneDynamics Connection will require your Account SID & API Token details:

 


The Account SID & API Token can be obtained by clicking "REVEAL API CREDENTIALS" from the Home Tab in the Platform:

 

 

Enter a Connection name, then copy & paste the details into their corresponding fields of the FoneDynamics Connection and then click Connect

 

Now select the Google Sheets connection to begin configuration:

 

 

You will need to ensure that the Google Sheets connection is setup with the same Google account that has access to the previously setup Google Sheet.

 

If this has already been setup then select the active connection to continue, otherwise click New connection to create the Google Sheets account connection.

 

New connection

Enter a unique Connection name & click Sign in with Google

 

Sign in with your Google account which has access to the previously setup Google Sheet

 

Click continue

 

 

Click Allow

 

 

Now with the connections established, we’ll need to configure the recipe, which has mostly been done for us already thanks to the template

 

Click on Recipe from the top bar


 

Configure the recipe as follows:


Click on step 1 - Trigger & select Edit

 

 

From the pane on the right-hand side that open up, ensure the correct Google Sheet spreadsheet, Sheet name & Column is selected

 

This is identified so that when the recipe is started, the integration will monitor when you change the status between SendStart, ReplyStart, Completed & act accordingly

 

 

You can skip to Step 5 to ensure the correct Google Sheet spreadsheet is selected & also the correct sheet to pull your input data (Outgoing SMS) from. 

If there are more than 50000 entries, you will need to adjust the cell range also.

 

 

At Step 6 you can check & ensure the correct Site SID details are being used by clicking on the PropertySid datapill & comparing this with the data from the Home tab.

 

 

Select Option 7 & ensure the correct Google Sheets spreadsheet & Sheet are chosen in the pane for the Output Sheet to be updated with the status of the sent SMS.

 

 

At Option 8 ensure the correct Google Sheet is chosen & is pointing to the correct Sheet & Row to identify the Trigger dropdown menu in the Trigger sheet.

 

 

Skip to Option 12 & again check the correct Google Sheet spreadsheet & sheet name is chosen so that Replies can be populated when the ReplyStart is triggered.

 

 

At Step 13, ensure the correct Google Sheet spreadsheet & the Trigger page are specified.

This will ensure the Trigger Sheet is updated to Completed once all rows with data have been processed.

 

 

Now click Save in the top right-hand corner

 

 

Sending SMS


When you wish to start sending the Bulk SMS you have now populated into your Google Sheet, simply select ‘SendStart’ from the dropdown menu in the Trigger sheet of the Google Sheet & ‘Start’ the recipe from the Platform

 

If you wish to check for replies, just select ReplyStart from the dropdown menu in the Trigger sheet of the Google Sheet & start the Recipe from the Platform.