已完成

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.

技能: Excel, 谷歌应用引擎, Java

查看更多: 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

关于此雇主:
( 0个评论 ) Assen, Netherlands

项目ID: #17870440

授予:

sviatsom

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

€16 EUR / 小时
(0条评论)
0.0

9 威客就此工作平均出价 €16/小时

adampohp79

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, 更多

€16 EUR / 小时
(3条评论)
4.4
AlexFaster

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 / 小时
(3条评论)
3.6
dataexplorer

"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 更多

€12 EUR / 小时
(9条评论)
2.9
wonwon424

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 更多

€16 EUR / 小时
(2条评论)
1.4
MistySarker1144

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 / 小时
(0条评论)
0.0
Xiong402Jin

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 更多

€16 EUR / 小时
(0条评论)
0.0
unboltsoft

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 更多

€20 EUR / 小时
(0条评论)
0.0
bogdanbez

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

€12 EUR / 小时
(0条评论)
0.0