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.

Kemahiran: Excel, Enjin App Google, Java

Lihat lagi: 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

Tentang Majikan:
( 2 ulasan ) Assen, Netherlands

ID Projek: #17870440

Dianugerahkan kepada:


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

€16 EUR / jam
(1 Ulasan)

8 pekerja bebas membida secara purata €16/jam untuk pekerjaan ini


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, Lagi

€16 EUR / jam
(6 Ulasan)

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 Lagi

€16 EUR / jam
(5 Ulasan)

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 / jam
(3 Ulasan)

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 Lagi

€16 EUR / jam
(1 Ulasan)

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 / jam
(0 Ulasan)

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 Lagi

€20 EUR / jam
(0 Ulasan)

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

€12 EUR / jam
(0 Ulasan)