I have a column of values that pulls data from GoogleFinance using the =GOOGLEFINANCE function in Google Sheets. When the function is working, the column will return a series of figures. Occasionally, there is an error with GOOGLEFINANCE and the cells in the column will return N/A or other error messages.

I want to generate an email to be sent whenever one of the cells in this column returns an error. The only scripts I can find are triggered by manual edits to cells. How can I generate an email when the change is made automatically through the operation of the GOOGLEFINANCE function?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.