acurtis517

/**
 *  ---  Continous Execution Library ---
 *
 *  Copyright (c) 2013 Patrick Martinent
 *
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0

acurtis517

Uploading Multiple Files From Local To Google Drive using Google Apps Script

This is a sample script for uploading multiple files from local PC to Google Drive using Google Apps Script. The dialog, sidebar and Web Apps can be used as the GUI interface.

Sample 1

In this sample, the following flow is run.

1. Select files at browser.
2. Upload the files every file.
3. Save each file in Google Drive.

acurtis517

/*
* Copyright 2017 Mohsen Mesgarpour
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
*     http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software

tanaikech

Executing Google Apps Script with Service Account

Abstract

One day, you might have a situation where it is required to run Google Apps Script using the service account. Unfortunately, in the current stage, Google Apps Script cannot be directly run with the service account because of the current specification. So, this report introduces a workaround for executing Google Apps Script using the service account.

Introduction

mhawksey

// @OnlyCurrentDoc
const FOLDER_ID = 'YOUR_FOLDER_ID'; // OR 'root' if you want your entire My Drive  

/** 
 * Method One: Using built-in DriveApp / file iterator  
*/
function generateFolderFilesDriveApp() {
  try {
    const folderId = FOLDER_ID;
    const parentFolder = (folderId === 'root') ? DriveApp.getRootFolder() : DriveApp.getFolderById(folderId);

unrevised6419

(function bookmarksExportToCsv() {
  /**
   * 1. Export bookmarks from browser (supported any Chromium based browsers and Safari) (chrome://bookmarks)
   * 2. Open exported html file again in the browser
   * 3. Copy paste this entire file in console, and execute it (hit enter)
   * 4. You will be prompted to save a CSV file. Save it.
   * 5. Open Notion. Click Import -> CSV
   * 6. Select saved CSV file. Wait for import
   * 7. You have a new database with all your bookmarks
   */

brucebentley

Userscript Utilities

See brucebentley/userscripts for more information.

alquanna

/** 

A Google Apps script for consolidating data from different sheets
Basically, this scripts copies the contents from all sheets/tabs in a Google Sheet file, then consolidates all data in one tab: CombinedShet

Created by Clara - claracommutes.com :)

Important note:
1. Before using this Google Apps script, make sure that you have a sheet named CombinedSheet in your Google Sheet. This is where the script will consolidate all the data from all the other sheets.
2. CombinedSheet should be the last/rightmost tab in your Google Sheet file.

dsottimano

//functions to parse URLs adapted for easy usage in apps script
//past the code below in the tools > script editor of any google sheet 
//call the PARSE_URI() formula directly from a cell


// PARSE_URI 1.2.2
// (c) Steven Levithan <stevenlevithan.com>
// MIT License
//adapted for apps script by @dsottimano

konard

var duplicates = document.querySelectorAll("div.duplicate");
var i = 0;

setInterval(function() {
  if(i < duplicates.length)
  {
    var firstButton = duplicates[i].children[1].children[0].children[0].children[0];
    var deleteButton = duplicates[i].children[0].children[1];
    
    firstButton.click();