Skip to content

Latest commit

 

History

History
33 lines (23 loc) · 1.8 KB

README.md

File metadata and controls

33 lines (23 loc) · 1.8 KB

apps script

Those are relatively simple ready to use scripts that everyone can use just by copy pasting to google sheets apps script. Most will have full comments explaining code blocks and prerequisites.

Most assume basic knowledge about Apps Script

Link to example video on how to enable some things.

Some of this code is slowly moving into dedicated repositories, links here will be updated and code removed.

You can see all of those under apps-script--

1. Custom Functions for Google Sheets

  • Adds custom menu to sheets OnOpen
  • Add different SHA function with instructions and description
  • Indentation function

2. Web app that will receive POST, ingest JSON and post data to sheet.

  • Public Web App
  • Receive Webhook stream
  • Simple JSON manipulation
  • Find first empty row and add data to correct cells

3. Send SMS from sheets using Twilio

Mostly updated code that Twilio is showing on their page. Uses PropertiesService to access tokens there instad of puting them in code.

4. Generate Google Workspace chrome polict for uBlockOrygin

5. Mail Merge for Google doc's

  • Works exacly as you would expecy.
  • NOTE - I'm 99% sure this code it based mostly on someone's else script with some features added by me but I can't find it anymore. If it was yours please let me know so I can credit you properly.