Skip to content Skip to sidebar Skip to footer
Showing posts with the label Google Apps Script

Convert Date Format Without Timezone - Google App Script (javascript), Google Spreadsheet

I'm working on integration between Google spreadsheet and LINE Message API (BOT) where Google a… Read more Convert Date Format Without Timezone - Google App Script (javascript), Google Spreadsheet

Datetime Error 21-undefined-2014

The code below results in: 21-undefined-2014 Not sure what is missing. Please check and advise. Eve… Read more Datetime Error 21-undefined-2014

Google Script - Get Data From Gmail Into Sheet

I have been looking around here on SO and on Google, but I cannot find anything that is working. … Read more Google Script - Get Data From Gmail Into Sheet

Parsing Xml Data Using Google Script

I have been trying to convert a xml feed into human readable form but have not succeeded . I have t… Read more Parsing Xml Data Using Google Script

Typeerror: Cannot Call Method "getrange" Of Null. (line 9, File "code")

I am using the below filter function to copy data from one sheet to another, filtering out so that … Read more Typeerror: Cannot Call Method "getrange" Of Null. (line 9, File "code")

Passing Information To Server-side Function In A Google Docs Add On

I'm working on a Google Docs Add-On based on Google's Quickstart tutorial. I'm trying t… Read more Passing Information To Server-side Function In A Google Docs Add On