Hi, my name is Edward and I use Google Apps Script for G-Suite automation.

On this site you can find my add-ons and videos, related to this programming language.

Few words about my experience: I started to write scripts in 2016 within my hobby and next joined one company as a full-time Google Apps Script Specialist. During this time I wrote a lot of different scripts, mostly for Google Spreadsheet, Google Docs, Gmail, Google Drive. I connected various marketplaces and services with G-Suite through the API (eBay,Amazon,Cdiscount,Rakuten, UPS,DPD etc.) and extended functionality of Google Services according to the business needs. I use html/css/bootstrap and angular.js for front-end mixing it with Google Apps Script and git for control version.

Currently I also work with Python/Odoo and other technologies, but this site is dedicated to Google Apps Script only.

My activity on stack also provides some information about my experience.

Covid-19 Data Studio Connector ds

Import covid-19 data into Data Studio from covid19api.com

Policy Code

Campaign URL Builder (UTM) sheet ads

This tool allows you to easily add campaign parameters to URLs so you can track Custom Campaigns in Google Analytics.

Policy

Folder structure sheet drive

Generate folder structure report of Google Drive.

Install Policy

Hash calculator sheet

Lets you calculate the cryptographic hash value of a string (MD2,MD5,SHA1,SHA256,SHA384,SHA512).

Install Policy

Example of web-app based on Google Apps Script. web-app

Catalog, which allows end-user to specify the quantity of items manually and submit the form. Items are appended dynamically to the page based on gSheet data. Form submissions are also stored in gSheet.

Web-app