Skip to main content

Posts

Showing posts with the label Google Apps Script tutorials

Google Apps Script tips and tricks

When working with Google Apps Script, there are some tasks that I need to perform quite often. For that, I create a list of snippets that I can easily copy whenever needed. In this post, I share my useful snippets and my tips and tricks when working with apps script. If you have any snippet/tip/trick, you can share in the comment section. Effective use of the GOOGLEFINANCE function to get historical prices of stocks in a spreadsheet (Sheets, Apps Script) Clean empty cells for a sheet (Sheets, Apps Script) Get letter for a column index (Sheets, Apps Script) Copy a sheet as HTML table (Sheets, Apps Script) Add a menu on opening a spreadsheet (Sheets, Apps Script) Hide a sheet by name (Sheets, Apps Script) Show a sheet by name (Sheets, Apps Script) Create a new sheet or clear content of an old sheet if exists (Sheets, Apps Script) Effective use of the GOOGLEFINANCE function to get historical prices of stocks in a spreadsheet (Sheets, Apps Script) As I manage my stock port