Prasanth Janardhanan prasanthmj
prasanthmj
/ entry-client.js
Last active
August 12, 2019 11:48
Simple Vue SSR without Vuex and Router.
View entry-client.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import Vue from 'vue'; | |
| import { createApp } from './main.js'; | |
| const app = createApp(); | |
| app.$mount('#app'); | |
prasanthmj
/ messages.html
Last active
April 17, 2023 04:17
Parse and extract data from Gmail to Google Sheet. Read full article here: http://blog.gsmart.in/parse-and-extract-data-from-gmail-to-google-sheets/
View messages.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <base target="_top"> | |
| <title>Message Display Test</title> | |
| <link rel="stylesheet" href="https://ssl.gstatic.com/docs/script/css/add-ons1.css"> | |
| </head> | |
| <body style="padding:3em;"> | |
| <h1>Messages</h1> | |
| <ul> |
prasanthmj
/ apps-script-form-example.js
Created
May 9, 2019 10:38
Show a form in Google Sheet and collect input from the form. Read full article here: http://blog.gsmart.in/google-apps-script-html-form/
View apps-script-form-example.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function onOpen() | |
| { | |
| var ui = SpreadsheetApp.getUi(); | |
| ui.createMenu('Form') | |
| .addItem('add Item', 'addItem') | |
| .addToUi(); | |
| } | |
| function addItem() | |
| { |
prasanthmj
/ google-apps-script-send-email-attachment.js
Created
May 9, 2019 08:38
Send emails with attachment from a Google Sheet using Google Apps Script. Read full article here: http://blog.gsmart.in/google-apps-script-send-email-with-attachment/
View google-apps-script-send-email-attachment.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function onOpen() | |
| { | |
| var ui = SpreadsheetApp.getUi(); | |
| ui.createMenu('Automation') | |
| .addItem('send PDF Form', 'sendPDFForm') | |
| .addItem('send to all', 'sendFormToAll') | |
| .addToUi(); | |
| } | |
| function sendPDFForm() |
prasanthmj
/ google-sheets-send-email-based-on-date.js
Created
May 4, 2019 07:29
Send emails from a google sheet when a due date is crossed (overdue invoices for example) article: http://blog.gsmart.in/google-sheets-send-email-based-on-date/
View google-sheets-send-email-based-on-date.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function onOpen() | |
| { | |
| var ui = SpreadsheetApp.getUi(); | |
| ui.createMenu('Invoice') | |
| .addItem('mark Overdue', 'doOverdueCheck') | |
| .addItem('show Overdue Info', 'showOverDueInfo') | |
| .addItem('send Emails', 'sendOverdueEmails') | |
| .addToUi(); | |
| } | |
prasanthmj
/ send-html-email-apps-script.js
Created
May 3, 2019 09:46
Send HTML email from Google Apps Script. Full article here: http://blog.gsmart.in/google-apps-script-send-html-email
View send-html-email-apps-script.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function onOpen() | |
| { | |
| var ui = SpreadsheetApp.getUi(); | |
| ui.createMenu('Process') | |
| .addItem('Approve', 'doApprove') | |
| .addToUi(); | |
| } | |
| function doApprove() | |
| { |
prasanthmj
/ get-cell-value.js
Created
April 27, 2019 05:28
How to get cell value in Google Sheets using apps script. See article here: http://blog.gsmart.in/google-sheet-script-get-cell-value/
View get-cell-value.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function onOpen() | |
| { | |
| var ui = SpreadsheetApp.getUi(); | |
| ui.createMenu('GetValues') | |
| .addItem('get current', 'getCurrentCellValue') | |
| .addItem('get by row col', 'getByRowAndColumn') | |
| .addItem('get by address a1', 'getByCellAddressA1Notation') | |
| .addToUi(); |
prasanthmj
/ addcontacts.js
Last active
December 23, 2019 01:15
Apps script sample adding contacts from google sheets
View addcontacts.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function onOpen() { | |
| var ui = SpreadsheetApp.getUi(); | |
| ui.createMenu('Contacts') | |
| .addItem('add Contacts', 'addContact') | |
| .addToUi(); | |
| } | |
| function addContact() | |
| { | |
| var sheet = SpreadsheetApp.getActiveSheet(); |