with-google-sheets | order component to retrieve data | REST library

I found a great article with a GAS script for a stock alert system in Google Sheets. It has inspired me to build something more extensive including alerts for daily % moves but that's beyond the point.

The author recommends applying a time-based trigger so the receiver gets a real time email alert when the stock hits the predefined target price. The script works great, but has one problem: it will send an email during every cycle as long as the condition holds true. In other words, you will be bombarded with emails if the trigger is set to every minute.

Here's the basis script.

Is it possible to add notes to cells using Google? Apis.Sheets.v4?

It seems possible in python: Is it possible to use the Google Spreadsheet API to add a comment in a cell? but I've had no success duplicate it to c#, Insert a comment in a Google Sheet with google-sheets-api describes how to add it using an https call, but I would much rather use the google c# library than start sending HTTP calls myself if at all possible. It would be a huge help if anyone know-how, or can point me towards a working example.

Thanks in advance.

Using Rafa Guillermos advice i got it to work.

I need to convert columns of numbered coordinates into a different unit of measurement. From WGS84 Latitude/Longitude to OSGB36 Grid Reference.

Ordinance Survey website have a spreadsheet where you can supposedly "Perform simple ("Helmert" style) coordinate transformations. E.g. between WGS84 and OSGB36 with an accuracy of about 3 metres." But I can't make heads or tails of it.

There are supposedly some scripts on this website that work, but agian I can't understand if any of them will work in google sheets.

There's a ready-made formula which I can plug into the script editor for converting postcodes into coordinates. I would just like to know if there's something similar for WGS84 Latitude/Longitude to OSGB36 Grid Reference.

Here's an example google sheet anyone can edit.

Edit: Here is an example sheet https://docs.google.com/spreadsheets/d/1kBeOvXwWZEFoeqPd0ET_e1HLhoGQPvuHK6JFXFRjMOQ/edit?usp=sharing

If I was smarter, I could probably find my solution based off this other user's question who found their own answer.

Setting a value in a drop down with Google Sheets using a script

I'm trying to do something similar, but here is my situation.

• Cell A1, you choose from a list (drop down)
• Column C data changes based on selection in A1 (uses a filter function to pull a list of dates)
• B3 uses Data Validation to change its list based on C3:C

Every time I change A1 (by manually choosing a new option in the drop down), I want B3 to set to the last non blank value in column C, because they are timestamps from a google form, so they should always be in order (most recent date/time should be last value).

If its not too much to ask, if you have a solution, if you could add some comments in your code to explain what is doing what, that would be AWESOME.

For instance, in the above linked other post, I see where he sets row values, but I don't understand why there are no column values.

I'm doing a combo scatter and line charts (it's a electoral poll tracker) following this example from HC docs: