Skip to content

Instantly share code, notes, and snippets.

Avatar

Prasanth Janardhanan prasanthmj

View GitHub Profile
@prasanthmj
prasanthmj / entry-client.js
Last active Aug 12, 2019
Simple Vue SSR without Vuex and Router.
View entry-client.js
import Vue from 'vue';
import { createApp } from './main.js';
const app = createApp();
app.$mount('#app');
@prasanthmj
prasanthmj / messages.html
Last active Oct 12, 2020
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
<!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
prasanthmj / apps-script-form-example.js
Created May 9, 2019
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
function onOpen()
{
var ui = SpreadsheetApp.getUi();
ui.createMenu('Form')
.addItem('add Item', 'addItem')
.addToUi();
}
function addItem()
{
@prasanthmj
prasanthmj / google-apps-script-send-email-attachment.js
Created May 9, 2019
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
function onOpen()
{
var ui = SpreadsheetApp.getUi();
ui.createMenu('Automation')
.addItem('send PDF Form', 'sendPDFForm')
.addItem('send to all', 'sendFormToAll')
.addToUi();
}
function sendPDFForm()
@prasanthmj
prasanthmj / google-sheets-send-email-based-on-date.js
Created May 4, 2019
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
function onOpen()
{
var ui = SpreadsheetApp.getUi();
ui.createMenu('Invoice')
.addItem('mark Overdue', 'doOverdueCheck')
.addItem('show Overdue Info', 'showOverDueInfo')
.addItem('send Emails', 'sendOverdueEmails')
.addToUi();
}
View send-html-email-apps-script.js
function onOpen()
{
var ui = SpreadsheetApp.getUi();
ui.createMenu('Process')
.addItem('Approve', 'doApprove')
.addToUi();
}
function doApprove()
{
@prasanthmj
prasanthmj / get-cell-value.js
Created Apr 27, 2019
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
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
prasanthmj / addcontacts.js
Last active Dec 23, 2019
Apps script sample adding contacts from google sheets
View addcontacts.js
function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu('Contacts')
.addItem('add Contacts', 'addContact')
.addToUi();
}
function addContact()
{
var sheet = SpreadsheetApp.getActiveSheet();
You can’t perform that action at this time.