> You could use the API to quiry the cell and then send a server side email > based on the returned value. Just run the script via cron. Sorry I don't > have a working code for this but pulling the values is not that complicated. > Basically Auth to the sheet key and ask for the value of the cell.
It is doable but hard to test and debug. I believe a better solution is to do it locally on my server here. It needs a week to configure it to do only that. With an old computer it costs almost nothing, with SIMD it runs fast enough and power consumption is very little. With Windows 7 power efficiency if the task is not running so often it is very inexpensive way to do that. > You could do this with App Engine as mentioned but I am just starting to > play with that so can't be much help. It is harder to test and debug and you have to pay for usage. > It is a pain that the new Sheets Scripts don't have a cron feature. It was > one of the first things I looked for that and auto run on change. Yes - me too ;) Constantine THStart.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" group. To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com To unsubscribe from this group, send email to google-docs-data-apis+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---