Transforms the data of a given Spreadsheet Sheet to JSON.
- The frozen rows are taken as keys for the JSON.
- The data taken for the values is only that after the frozen rows
exportJSON(Spreadsheet)
- transforms the data in the given sheet to JSON.
function doGet(e) { | |
Logger.log(e); | |
var op = e.parameter.action; | |
var ss = SpreadsheetApp.open(DriveApp.getFileById("YOUR_SPREADSHEET_ID")); | |
var sn = "YOUR_SHEET_NAME"; | |
var sheet = ss.getSheetByName(sn); | |
if (op == "insert") | |
return insert_value(e, sheet); |
package com.example.jsonparsing; | |
import androidx.appcompat.app.AppCompatActivity; | |
import android.app.ProgressDialog; | |
import android.os.Bundle; | |
import android.view.View; | |
import android.widget.ImageView; | |
import android.widget.TextView; | |
import android.widget.Toast; |
/** | |
* This function retrieves all your latest instagram posts from the Instagram API and saves it to a Google Sheets spreadsheet. It | |
* replaces all the previous data (Run hourly for up-to-date data). | |
* | |
* You need to register a new app at https://www.instagram.com/developer/clients/manage/ and generate a access token to use this. | |
* (http://bobmckay.com/web/simple-tutorial-for-getting-an-instagram-clientid-and-access-token/). | |
* | |
* This can be used to build a Google Data Studio report of your Instagram data. | |
*/ |
// DISCLAIMER: I'VE ONLY RUN THIS SCRIPT ON MY OWN ACCOUNT ONLY. PROCEED/USE WITH RISK! I MADE THIS SCRIPT IN 20 MINUTES SO BE WARNED! | |
// On the other hand, I've deleted 50,000 comments in a matter of minutes so it's been pretty damn handy | |
// 1. Go to Activity feed, like facebook.com/<username>/allactivity | |
// 2. Navigate to specific section of FB, like "Likes and Reactions" or "Comments", | |
// like https://www.facebook.com/<username>/allactivity?privacy_source=activity_log&log_filter=cluster_<clusterid> | |
// 3. Navigate to year that you want to batch delete. You may need to scroll a little bit to let it load | |
// 4. Once you enter this there's no going back!! |
function doGet(e){ | |
Logger.log(e); | |
var op = e.parameter.action; | |
var ss=SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1UUBGKGvm4b9LOhqbdh0UDG6vYz9Phr1DqGyg8DvCiUc/edit?usp=sharing"); | |
var sheet = ss.getSheetByName("Sheet1"); | |
if(op=="insert") | |
return insert_value(e,sheet); |
// ==UserScript== | |
// @name Youtube HD | |
// @author adisib | |
// @namespace namespace_adisib | |
// @description Select a youtube resolution and resize the player. | |
// @version 2025.04.13 | |
// @match https://*.youtube.com/* | |
// @noframes | |
// @grant GM.getValue | |
// @grant GM.setValue |
package com.example.Surajit.dialog; | |
import android.app.Activity; | |
import android.app.Dialog; | |
import android.content.DialogInterface; | |
import android.os.Bundle; | |
import android.support.v7.app.AlertDialog; | |
import android.view.Menu; | |
import android.view.MenuItem; |
[ | |
"https://chrome.google.com/webstore/detail/ballloon-for-chrome/kbmligehjhghebleanjcmenomghmcohn", | |
"https://chrome.google.com/webstore/detail/shine-for-reddit/acoiihnnfofnpbnofdcgcapbjlcopifa", | |
"https://chrome.google.com/webstore/detail/tag-assistant-by-google/kejbdjndbnbjgmefkgdddjlbokphdefk", | |
"https://chrome.google.com/webstore/detail/highly-highlighter/hjpahjhcglfdopbholajmhpamgblhjhg", | |
"https://chrome.google.com/webstore/detail/screencastify-screen-vide/mmeijimgabbpbgpdklnllpncmdofkcpn", | |
"https://chrome.google.com/webstore/detail/sms-from-gmail-facebook-m/iffdacemhfpnchinokehhnppllonacfj", | |
"https://chrome.google.com/webstore/detail/wot-web-of-trust-website/bhmmomiinigofkjcapegjjndpbikblnp", | |
"https://chrome.google.com/webstore/detail/mega/bigefpfhnfcobdlfbedofhhaibnlghod", | |
"https://chrome.google.com/webstore/detail/time-is-money/ooppbnomdcjmoepangldchpmjhkeendl", |