It will download an APK file on the phone, install the APK and you are ready to send text messages. User Interface, Button -> For fetching messages from Google Sheets and for sending SMS messages from the Android app. apk) and scan the QR code with your phone. While you are in the design mode, drag the following components on to your app: User Interface, ListView -> For displaying the message list fetched from Google Sheets. Go to the Build menu inside App Inventor, choose App (provide QR code for. Next switch to the Blocks section inside App Inventor and design the blocks as explained in the video tutorial. Social, Texting -> For sending the SMS messages.Refresh the page, check Medium ’s site status, or find something. User Interface, Notifier -> For displaying progress bars and alerts Send SMS from Google Spreadsheets by 46elks 46 thoughts Medium 500 Apologies, but something went wrong on our end.Connectivity, Web -> For making GET and POST requests to Apps Script.2 minutes That’s it More time to work on other things. 15 seconds Step 4: Select the data you want to send from one app to the other. 15 seconds Step 3: Choose a resulting action from the other app. ![]() 30 seconds Step 2: Pick one of the apps as a trigger, which will kick off your automation. User Interface, Button -> For fetching messages from Google Sheets and for sending SMS messages from the Android app. Step 1: Authenticate Google Sheets and SMS Alert.User Interface, ListView -> For displaying the message list fetched from Google Sheets.While you are in the design mode, drag the following components on to your app: Sign-in to the website with your Google account and create a new App. You’d normally need to know programming languages like Flutter or Java to build Android apps but in this tutorial, we’ll use MIT’s App Inventor, a simple way to develop fully functional apps with drag-n-drop. The texts go directly from your phone SIM instead of using any third-party SMS gateway service. Now that our sheets API is ready, we’ll build an Android app that will read the list of text messages and phone numbers from our Google Sheets and send the SMS messages. ![]() ![]() Choose “Me” under “Execute the App” setting and “Anyone, even anonymous” under the “Who has access” setting.Ĭlick the Deploy button and you’ll be presented with a secret API URL that we’ll require in the next step. Next, go to the Publish menu in the Google Script Editor, choose Deploy as web app. Const SHEET_URL = 'YOUR_GOOGLE_SHEET_URL' const SHEET_NAME = 'SMS' const doGet = ( ) =>
0 Comments
Leave a Reply. |