Google spreadsheet parse gmail to show current equipment status

Đã Đóng Đã đăng vào 1 năm trước Thanh toán khi bàn giao
Đã Đóng Thanh toán khi bàn giao

I have a google email address that receives automated emails from intercom systems when speaker circuits go down, and again when they are restored. Email's can contain a single or multiple lines. If there's a network outage at the site, a hundred or so emails will come in. After the email is read, it needs to be archived. Information received includes location, extension number, extension name, time and date, up or down. I would like this information added to seperate sheets as a list of equipment that is down for each location. Sheet names will be status, location 1, location 2, location 3, etc. There needs to be a be a "clear" button on each location sheet to manually remove all items from the list in case for some reason the restore emails are not sent out from the intercom. On the "status" sheet, for each location, a cell will show all the location name, and fill green if the associated list is empty, red if there is at least one extension on the list. We need the ability to easily add more locations at a future date.

Google Sheets Google Apps Scripts Xử lý email

ID dự án: #35842384

Về dự án

12 đề xuất Dự án từ xa 1 năm trước đang mở

12 freelancer chào giá trung bình$162 cho công việc này

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you Thêm

$220 USD trong 4 ngày
(8 Nhận xét)
5.4
Giovanni704

Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I'd love to work together on your project editing your sheets. I'm so responsible and kind, I will always send you Thêm

$30 USD trong 1 ngày
(15 Nhận xét)
5.3
aruls1962

I’m a professional Engineer who has spent the past 7 years building, developing, and perfecting systems (from the ground up) through Google Sheets. With over 30 years of experience in the industry, I’ve not only learne Thêm

$200 USD trong 7 ngày
(19 Nhận xét)
4.2
subinpvasu

Hi, I'm interested in your requirement. I have good experience of web development with Google Apps Scripts and Email parsing using the apps scripts We can discuss further on chat. Thanks!

$200 USD trong 2 ngày
(4 Nhận xét)
3.5
Ice65

I create Custom Scripts/Automations in Excel and Google Sheets to make repetitive/Time taking work done very easily with just one click, I also create Custom Extensive formulas, Dynamic Dashboards, Browser Automations Thêm

$140 USD trong 7 ngày
(0 Nhận xét)
0.0
Kriyansh2022

I want this job because am looking for tjis kind of job and will surely completed it with all dedication.. And not let you down.

$140 USD trong 7 ngày
(0 Nhận xét)
0.0
sajanverma035

Do you need data entry or copy paste job done? You are in the right place. I'm here to help you with any kind of copy paste data entry work. I am an established data entry operator who provides excel data entry work, W Thêm

$140 USD trong 7 ngày
(0 Nhận xét)
0.0