Automation + extract messages into a table in google spreadsheet

i get messages from different devices into a google spreadsheet. These messages are different depends on source device name and time interval and status..

I need someone with google spreadsheet scripting knowledge (google apps script), to write a script to automate reading the messages in sheet one and put the status in a table in sheet two :

1- search sheet1 in a loop for each of these 4 Devices and get the string.

2- extract from that string The TAG name , STATUS and time interval

3- put status in an existing table in the device row under the correspondent TAG and interval .

The status of a device should then be updated if there is a new message for that device.

4- give color green to positive status and red to negative status.

Taidot: Excel, Google App Engine, Java

Näytä lisää: google sheets add ons, google sheets, google sheets automation, automatically email google spreadsheet, google sheets link, google spreadsheet template, edit google spreadsheet, http docs google com spreadsheets u 0, script extract messages file mail, php mysql data google spreadsheet, google spreadsheet functions manual, extract data table website, zone table google checkout, google spreadsheet data entry, use google spreadsheet access table, google spreadsheet access table, extract data scanned pdf word table excel spreadsheet, google spreadsheet add row php, add row google spreadsheet api php, email add row google spreadsheet

Tietoa työnantajasta:
( 0 arvostelua ) Assen, Netherlands

Projektin tunnus: #17870440

Myönnetty käyttäjälle:


Hi, I have already finished similar projects. I can prepare the Python script for you in a couple of days. Best, Sviat

€16 EUR / tunti
(0 Arvostelua)

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön


Dear Sir. Glad to meet you. I'm Web developer specializing in web scraping crawling and indexing web pages. Skills: python, scrapy, selenium, requests, beautifulsoup, mechanize, lxml, urllib2, automation, bots, Lisää

€16 EUR / tunti
(3 arvostelua)

Hi. I'm professional programmer with experience over 20 years. I need to look to your spreadsheets and discuss another questions. See my completion rate and feedbacks. Regards, Alex.

€18 EUR / tunti
(3 arvostelua)

"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your "Automation + extract messages into a table in google spreadsheet" and able to pr Lisää

€12 EUR / tunti
(9 arvostelua)

Hi, employer. I am a java expert I've read your requirements and I think I can do it. I have been working for 6+ years on this kind of job. I have many previous works in this field and I will complete your project d Lisää

€16 EUR / tunti
(2 arvostelua)

Hi.. I saw your project and want to help with it if you will accept my proposal. Of course I cannot convince you but I can give you an assurance of a good job. Thanks.

€16 EUR / tunti
(0 arvostelua)

Hello Sir . Thanks for your posting good job. I have read your job description. I am a expert in java script and java, and have much experiences in developing google apps . In my opinion it will not take few day Lisää

€16 EUR / tunti
(0 arvostelua)

A young Ukrainian software development company that employs several passionate engineers. Our main direction is the engineering, development and implementation of custom software with a deep scientific focus that requi Lisää

€20 EUR / tunti
(0 arvostelua)

I have bachelor's degree in software development. Moreover, I have skills in scripting google apps. Do not hesitate to contact me.

€12 EUR / tunti
(0 arvostelua)