Descrição do projeto
There are four columns: "Pillar 1", "Pillar 2", "Pillar 3", "Pillar 4"
You need to write a script for Google tab that sends information from the cell "column3" under two conditions.
1)"Column1" = ANNEXE
2)"column2"= not sent
In the "column 4" is the name of the project. There may be different projects in this cell. Each project has its own list of addresses to send (the addresses will be inside the script).
The shipment should be made every hour! I have attached a screenshot file with additional notes!
It is advisable to do the script today/tomorrow. I'm online until 2 a.m. Payment: liaison, kiwi, possibly: webmoney, Yandex.d