1

The goal is to send the same message to many people (volunteering reminders) but in an automated fashion. The only difference between messages would be the name at the beginning and the target phone number, which would come from a CSV file or Google Sheets directly.

Languages I would be comfortable using (in order):

  • Java
  • Python
  • JavaScript
  • Something new and not too hard to pick up

The end goal would be click a few buttons (convert Google Sheet to CSV, add to a folder, run a .cmd command) and then everything is sent out within 5 minutes from a personal phone.

A sample CSV file would be:

Bob,5555555555,other unimportant information 
Dave,6666666666,other unimportant information
...

Message: Hi Bob/Dave, We have a volunteer event on Thursday. Can you make it?

This would be on Windows 10, probably 8 GB of RAM or more. Let me know if any more details would be helpful.

  • Use Twilio to send text message using an API. twilio.com – Chloe Jan 8 at 23:12
0

Google Apps Script has Spreadsheet Service, Mail Service and Gmail Service and also could easily enable the use of the Google Sheets API so parse data from Google Sheets and to send emails.

Also it has HTML Service to create a custom dialog or even a web application as simple as a web page having a couple of buttons and using well known front en libraries like Bootstrap.

References

|improve this answer|||||
  • The title asks for text messages, which I guess means SMS ? – Mawg says reinstate Monica Jan 8 at 12:50
  • In such case my this is a partial answer address the first part of the question (parse a CSV or Google Sheet) and the third part, creating a user interface. – Rubén Jan 9 at 1:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.