thanh01pmt

Learning Google Apps Script

Find the best resources for learning Google Apps Script, the glue that connects all GSuite services including Gmail, Google Drive, Calendar, Google Sheets, Forms, Maps, Analytics and more.

A good place to learn more about Google Apps Script is the official documentation available at developers.google.com. Here are other Apps Script resources that will help you get up to speed.

1. Google Apps Script Code Samples by Amit Agarwal
2. Google Apps Script Development - Create Google Apps Script projects locally inside VS Code - video tutorial
3. Awesome Google Scripts by Amit Agarwal
4. Google Developer Experts - Follow Apps Scr

thanh01pmt

// Note that this script will remove all permissions of all files and subfolders
// (including files in subfolders) of the given folder

// https://drive.google.com/drive/folders/abcdefgh
const id = "abcdefgh";

function start() {
	const folder = DriveApp.getFolderById(id);
	getSubFolders(folder);
	// At the end, reset for parent folder

thanh01pmt

#include "Arduino.h"
#include "esp_camera.h"
#include "ESPAsyncWebServer.h"

typedef struct {
        camera_fb_t * fb;
        size_t index;
} camera_frame_t;

#define PART_BOUNDARY "123456789000000000000987654321"

thanh01pmt

// Unity C# Cheat Sheet
// I made these examples for students with prior exerience working with C# and Unity. 
// Too much? Try Unity's very good tutorials to get up to speed: https://unity3d.com/learn/tutorials/topics/scripting

thanh01pmt

// Setup Firestore. Note that all of these will be asyncronous tasks and can have a .then attached. Write in a config process for Firebase. Include the necessary process.env files and instructions how to make a .env file.

***************************************************************
	
// Add data - C
firestore.collection("CollectionName").add({
	key: value,
	key: value,
})

thanh01pmt

Firebase

Set up firebase and Deploy

• Head over to firebase. Sign in and create a project.

• Copy your project settings under Firebase SDK snippet into your local project (ie your project's api key, auth domain, databaseURL, etc)

• Create a file (firebase.js or config.js Any name that suits you is fine)

thanh01pmt

Copying Data from a Google Sheet into Firebase Realtime Database in real time via Apps Script

If you're trying to do this, you came to the right place!

Watch this code work in real time: https://twitter.com/CodingDoug/status/942576182276497409

See also this gist for copying in the other direction: https://gist.github.com/CodingDoug/ffc4f050cc489a0280eb7f4cbe36af07

Setup

thanh01pmt

Copying data from Firebase Realtime Database to a Google Sheet in real time via Cloud Functions

If you're trying to do this, you came to the right place!

Watch this code work in real time: https://twitter.com/CodingDoug/status/940022568089554944

See also this gist for copying in the other direction: https://gist.github.com/CodingDoug/44ad12f4836e79ca9fa11ba5af6955f7

Setup

thanh01pmt

import cv2 as cv
import numpy as np
from urllib.request import urlopen
import os
import datetime
import time
import sys

#change to your ESP32-CAM ip
url="http://192.168.1.149:9601/stream"

thanh01pmt

/******************************************************************

L'ESP32-CAM présente une page web qui permet de prendre des photos
et de les enregistrer sur une carte SD, de visionner les photos 
déjà présentes sur la carte, et de supprimer les photos non-désirées.

Pour plus d'informations:

http://electroniqueamateur.blogspot.com/2020/07/esp32-cam-gestion-distance-de-la-carte.html