Send an SMS Message or Hangouts Message with Last Row of Spreadsheet Range

Google Apps Script – SMS Or Hangouts Message Last Row of a Spreadsheet Range from Gmail Attachment

1) Filter Emails from a specific sender; Get Most Recent

2) Save All Excel Attachments to Google Drive: FolderID; Either xls or xlsx

3) Convert Excel Attachment to Google Sheet

4) Get Header Files, (C3, C4, C5, C6)

5) Get NonEmpty Data MD, INC, AZ, TVD, VS, NS, EW, DLS, Build, Turn, Temp

6) Check Last NonEmpty Row and check if MD is between range MD-Low and MD-High

7) Plot (x,y) = (VS, TVD)

a. Y Axis: Positive Downwards

8) Plot (x,y) = (EW, NW)

9) Send Email of Both Plots

10) Send SMS to distribution list of Last Row

a. MD = NUM

b. INC = NUM

c. AZ= NUM


e. VS= NUM




i. Build=NUM

j. Turn=NUM

k. Temp=NUM

l. C3,C4,C5,C6

m. Note

Taidot: Google APIs, Google App Engine, Google Sheets, Google Docs, Python

Näytä lisää: send sms email address, send sms mms web site, smpp client tool send sms, google apps script, google sheets script editor, google apps script gallery, google sheets script api, what can you do with google scripts, google script bold text, google sheets script, transfer messages from hangouts to messages, send sms addcreditsphp, send sms ringtones, ajax send sms, send sms distribution list, script send sms message, send sms mms message, iphone cocoa objective send sms message, send sms text message server, j2me code send sms text message

Tietoa työnantajasta:
( 6 arvostelua ) San Antonio, United States

Projektin tunnus: #22879915

Myönnetty käyttäjälle:


Hello, There is an easy way for converting XLS/XLSX to Google Sheet: upload to google doc, and it will be automatically as Google Spreadsheet. And the rest of requirement you described here would be easier following t Lisää

$150 USD 2 päivässä
(3 Arvostelua)

6 freelanceria on tarjonnut keskimäärin 109$ tähän työhön


Hi, how are you? I am a senior website app and mobile developer who has 7+years of experience. I have a great interest in your job as I have so many experiences in building large scaled web applications and mobile apps Lisää

$140 USD 7 päivässä
(1 arvostelu)

I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in programming and development I Lisää

$30 USD 7 päivässä
(2 arvostelua)

Hi there. I have seen your job post carefully and have ability to finish it by your guidance within your deadline. I like to go over new challenge what convert my client's idea to perfect project. I promise I will fini Lisää

$150 USD 5 päivässä
(2 arvostelua)
$155 USD 3 päivässä
(0 arvostelua)

Hi, I'm competent in task, I have experience in GAS , bulk sms sending platforms and integration, I'm sure I can help you with this project as well, do drop a message for more info :).

$30 USD 7 päivässä
(0 arvostelua)