google-apps-script-snippets
google-apps-script-snippets copied to clipboard
oshliaer
Google Apps Script snippets
``` [ "Argentina", "Armenia", "Australia", "Azerbaijan", "Belarus", "Bolivia", "Brazil", "Bulgaria", "Canada (English)", "Canada (French)", "Chile", "China", "Colombia", "Croatia", "Czechia", "Denmark", "Ecuador", "Egypt", "Finland", "France", "Georgia", "Germany", "Greece", "Hong Kong", "Hungary",...
https://gist.github.com/mrkrndvs/a2c8ff518b16e9188338cb809e06ccf1
```js /** * Returns sheet's name by gid * * @param {number} gid The gid of the sheet. * @return {string} The name of the sheet. * @customfunction */ function...
- https://ctrlq.org/code/20500-convert-microsoft-excel-xlsx-to-google-spreadsheet - https://gist.github.com/azadisaryev/ab57e95096203edc2741
https://gist.github.com/mhawksey/1442370
```js /** * @typedef {Object} HTTPEvent * {@link https://developers.google.com/apps-script/guides/web Web Apps} * @property {string} queryString The value of the query string portion of * the URL, or null if no...
```js function copyMultipleSpreadsheet2(){ var sheets = []; sheets.push(SpreadsheetApp.openById('ssssQ').getSheetByName('Sheet1')); sheets.push(SpreadsheetApp.openById('sssso').getSheetByName('Sheet1')); var data = sheets.reduce(function(p, c){ var values = c.getRange('A2:D').getValues().filter(function(row){ return row[0]!==''; }); p = p.concat(values); return p; }, []); SpreadsheetApp.getActive().getSheetByName('Sheet1').getRange(1, 1,...
https://gist.github.com/oshliaer/fdad6b4aab6dca4f0409640e09a4a6e6
[Cookie handling in Google Apps Script - How to send cookies in header?](https://stackoverflow.com/questions/10869932/cookie-handling-in-google-apps-script-how-to-send-cookies-in-header) ```js function example() { Logger.log(getContacts()); } // Some API function getContacts() { auth(); var headers = {...
https://docs.google.com/spreadsheets/d/1ngcuA2xnbHqX2Og7eFUFWmu2YMQ1buY-a6pHy2OLC3M/edit#gid=924246659