I need to read and update a google Sheet
the sheet link is : https://docs.google.com/spreadsheets/d/1T-VvSUn18Jlq4ssSYZPyHN9g0I3wEIvh8UcTuZ_Az5o/edit#gid=125831703
1) You have to copy a row from sheet "Planilla" col B to the end of the row and paste it on the textarea in [login to view URL] and then click on "formatear"
2)You will receive "LOOPBACK","RED LAN DATOS" you have to check if "LOOPBACK" exists on "Wan" sheet and is not red and "RED LAN DATOS" on "LAN" sheets and check the same(exists and is not red)
3) Finally when you click "Generate" on provisionador page you have to change the previous background color
I prefer Java and JS
12 威客就此工作平均出价 $28
Dear Client, I ensure I will complete the task successfully and within the specified time. I love perfection in work. So I ensure the work will be spot on. Your satisfaction is my success. Kindly contact me.