Google spreadsheet parse gmail to show current equipment status
Ngân sách $30-250 USD
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.
13 freelancer chào giá trung bình$168 cho công việc này
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
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
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!
Hi I am expert in google sheet automation and its integration with gmail using Gmail API. I also understand the requirement as describe in job description. We can discuss further on chat. Thanks
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.
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