Google Apps Script

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.

Gclid adwords auto-tagging
Google Ads gclid tester ads

Test auto-tagging in your ads programatically.

Install Readme
Protection ranges
Protection ranges manager sheet

Add/remove email from multiple protected ranges in Google Spreadsheet by one click.

Install Policy
Media Image 01
Duplicate words finder docs

Find all duplicated words in Google Doc and underline them.

Install Policy
XML parser - currency exchange rate

Script parses xml files with currency exchange rates and values inserts into spreadsheet. Target file is available under this link.

Rakuten API - orders

Script fetches Rakuten orders through the API in JSON format and appends them into spreadsheet.

Protection ranges manager

Add new email address to multiple protected ranges in Google spreadsheet by one click.

Duplicate words finder

Find all duplicated words in Google Doc and underline them.