Skip to content

Instantly share code, notes, and snippets.


Miroslav schlos

  • Zagreb, Croatia
View GitHub Profile
schlos /
Created Oct 20, 2020 — forked from Rican7/
Filters Gmail message threads to apply helpful GitHub labels, for organization.
* Labels Gmail email threads
function labelGithubEmails() {
* Gmail label names for GitHub messages
const githubLabelName = 'GitHub'
const githubPullRequestLabelName = 'GitHub/Pull Request'
const githubIssueLabelName = 'GitHub/Issue'
View Google App Script - Replace Slide Content Using Google Sheet Data.js
* Function to replace text in Google Slides with Google Sheet values
* @reference
function generate_featured_image() {
/* get spreadsheet from public view link */
var dataSpreadsheetUrl = ""; //make sure this includes the '/edit at the end
var ss = SpreadsheetApp.openByUrl(dataSpreadsheetUrl);
schlos / outerLoop.js
Created Apr 30, 2020 — forked from peterherrmann/outerLoop.js
outerLoop for Google Apps Script triggered functions is some boilerplate that encapsulates best practice ways to deal with running workloads that may take longer to process that the time available in an Apps Script triggered run.
View outerLoop.js
//load configuration details and start logging - creates and sets up sheets the first time they are run
var CONFIG_SPREADSHEET_KEY = '<ssid_goes_here>';
var Config = SettingsManager.load(CONFIG_SPREADSHEET_KEY); //Add Mafviu9bMfg9xVu21LGfpWnHAGDwXQ1CH in Resources > Libraries
Logger = BetterLog.useSpreadsheet(Config['logSpreadsheetId'].value);//Add MYB7yzedMbnJaMKECt6Sm7FLDhaBgl_dE in Resources > Libraries
// trigger this function
function outerLoop() {
try {
// to calc elapsed time
var isOverMaxRuntime = false,
schlos / detect-patterns.user.js
Created Oct 3, 2019 — forked from sonota88/detect-patterns.user.js
Greasemonkey script which detect patterns in html source.
View detect-patterns.user.js
// ==UserScript==
// @name detect-patterns
// @namespace anbt
// @include *
// ==/UserScript==
if (window != { return; }
schlos / contact-form.html
Created Apr 6, 2019 — forked from sharu725/contact-form.html
Jekyll Contact Form using Formspree
View contact-form.html
After implementing this contact form make sure
1. you have defined "email:" in _config.yml file.
2. you verify your form on
<form class="wj-contact" action="{{}}" method="POST">
<input type="text" name="email" placeholder="Email Address">
<textarea type="text" name="content" rows="10" placeholder="Message"></textarea>
<input type="hidden" name="_next" value="<REDIRECTION LINK> ">
schlos /
Created Mar 17, 2019 — forked from andrewroberts/
A simple wrapper for the BetterLog Google Apps Script Library - GAS Library MqTFuiXcPtS5rVUZ_jC9Z4tnfWGfgtIUb
// 34567890123456789012345678901234567890123456789012345678901234567890123456789
// JSHint: 22 March 2015 08:56 GMT
// Unit Tests: 22 March 2015 08:50 GMT
* Copyright (C) 2015-2017 Andrew Roberts (
* This program is free software: you can redistribute it and/or modify it under
* the terms of the GNU General Public License as published by the Free Software
schlos / google-apps-script-github-burndown.js
Created Jan 16, 2019 — forked from gregorynicholas/google-apps-script-github-burndown.js
google apps script to create a github issues burndown chart
View google-apps-script-github-burndown.js
* Heads to github fetches milestone info, and adds rows to spreadsheet
function updateBugCounts() {
var resp = UrlFetchApp.fetch("");
var jsonStr = resp.getContentText();
var milestones = Utilities.jsonParse(jsonStr);
var dataSs = SpreadsheetApp.openById("YYY");
var sheet = dataSs.getSheetByName('Raw Data');
schlos /
Last active Jan 1, 2019 — forked from rubenrivera/
Question - Answer from Web Applications [Show URL used to edit responses from a Google Form in a Google Spreadsheet by using a script](

Revision 3

Show URL used to edit responses from a Google Form in a Google Spreadsheet by using a script

I'm trying to make the edit URL for a Google Form automatically populate in the response Google Sheet that it's attached to. I've seen this already and want to use it, but I'm having issues trying to figure out where exactly to put the script.

I've tried putting it in the script editor in the Google Spreadsheet that I would like the URL to appear in, but I'm not sure where to go from there. In the script editor I've tried to test it as an add-on but that didn't end up working.

I have little experience with scripts and the script editor in Google Sheets. As a final note I am using one other add-on called AutoCrat in the same Google Spreadsheet.

schlos / google-script-basecrm-api.js
Created Aug 26, 2018 — forked from superstrong/google-script-basecrm-api.js
Retrieve JSON data from the BaseCRM API and add it to a Google Sheet. This example retrieves all users. Stands on the shoulders of
View google-script-basecrm-api.js
function getBaseUsers() {
var options = {
"contentType" : "application/json",
"headers" : {
"Accept": "application/json",
"Authorization": "Bearer <TOKEN>"
var response = UrlFetchApp.fetch("", options);
var ss = SpreadsheetApp.getActiveSpreadsheet();
schlos / google-script-asana-api.js
Created Aug 26, 2018 — forked from superstrong/google-script-asana-api.js
Retrieve JSON data from the Asana API and add it to a Google Sheet. This example retrieves all the users in a workspace. Stands on the shoulders of
View google-script-asana-api.js
function getAsanaUsers() {
var options = {
"headers" : {
"Authorization": "Bearer <TOKEN>"
var response = UrlFetchApp.fetch("<workspace-id>/users", options);
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets();
You can’t perform that action at this time.