Google script for spreadsheet
Budget: $10 – $30 USD
I need a Google spreadsheet to send emails and make some changes.
1) the cell A1 is the subject of the email.
2) the cells from A2 till the last cell with content in column A are the content of the email.
3) the cell B1 indicates if the script is working or not, if the text is "stop" nothing happens, for any other value the script works normally.
4) if the cell B2 = send, the script sends the email, and It doesn't send if there is other value.
5) the cell b3 indicates the destination email.
6) the cell b4 indicates the time interval in seconds that the script will run again.
7) the cell b5 is the counter, it increases 1 unit every time the script runs, even when it run and don't send the email.
8) the cell b6 indicates the time interval in hours to reset the counter to 0.
9) the cell b7 is a log number, the script will copy this number and paste in the last cell without of the column A of the tab "done". It works even it doesn't send the email.
10) the cell b8 is also a log number, the script will copy this number and paste in the last cell without content of the column B of the tab "done". It works even if it doesn't send the email.
The script must work with the sheet closed.
You can find a spreadsheet example bellow:
https://docs.google.com/spreadsheets/d/1L_acC8ZlMPIgV-5dpP9dnK8d6gppGojHrP_vWxV53oo
1) the cell A1 is the subject of the email.
2) the cells from A2 till the last cell with content in column A are the content of the email.
3) the cell B1 indicates if the script is working or not, if the text is "stop" nothing happens, for any other value the script works normally.
4) if the cell B2 = send, the script sends the email, and It doesn't send if there is other value.
5) the cell b3 indicates the destination email.
6) the cell b4 indicates the time interval in seconds that the script will run again.
7) the cell b5 is the counter, it increases 1 unit every time the script runs, even when it run and don't send the email.
8) the cell b6 indicates the time interval in hours to reset the counter to 0.
9) the cell b7 is a log number, the script will copy this number and paste in the last cell without of the column A of the tab "done". It works even it doesn't send the email.
10) the cell b8 is also a log number, the script will copy this number and paste in the last cell without content of the column B of the tab "done". It works even if it doesn't send the email.
The script must work with the sheet closed.
You can find a spreadsheet example bellow:
https://docs.google.com/spreadsheets/d/1L_acC8ZlMPIgV-5dpP9dnK8d6gppGojHrP_vWxV53oo