Using a tutorial I was working on an app that would pull data from a google sheet and send Text messages to contact in that sheet, then update the sheet using MIT App Inventor (full details of what I’m trying to do below if you so care). But since appinvintor only works with android I thought this might be better. I thought it would be the same layout but the components aren’t the same, at least that I can see.
This is the tutorial I worked from. https://www.labnol.org/send-sms-google-sheets-200402
Specifically the sms ap and get request components, I don’t understand what the parallels are in thunkable.
Even If I could use a third party text company like Twillo, that would be fine but I can’t find anything like that SMS app function.
Any help would be appreciated. Or if there is a tutorial about this somewhere I’m happy to research on my own, google search did nothing.
I have a Googel sheet* set up with Names, Phone Numbers, Classes and Volunteers for each class, which a checkbox for each class and a status box for each class. I have it set up so that if the checkbox is marked, the texts will be sent to those numbers using that data: To (phone) “(Class 1) will begin shortly, (volunteers1) get ready.” When the class one text is sent, the app updates status box for class one and the check moves from class 1 to class 2 and so on. The app needs to be simple because it’s very non-computer literate people that will be using it. I can’t expect them to update any code. My current app has a Refresh button and a Send button. So they Refresh, visually verify the class name, then press Send. and repeat for the next class.
*The google sheet gets data from a form people fill out for volunteering so I can’t just download a static form each day. I need it to update as someone submits the form to volunteer.