Skip to content

Latest commit

 

History

History
16 lines (13 loc) · 1.62 KB

README.md

File metadata and controls

16 lines (13 loc) · 1.62 KB
Raw

Automation with Google Scripts

Do you spend time on mundane, repetitive tasks in Google Docs, Sheets, etc.? Automate them!

This repo contains example Google Apps Scripts (a form of Javascript) that will help you automate tasks within Google Apps and other platforms (connected via API).

Setting up Google Apps Scripts

Types of Automation Included

  • Make a copy of a spreadsheet, copy certain text from a document into it, and format spreadsheet to your specifications (document_to_spreadsheet.js)
  • Re-format a spreadsheet with translations into a three column format (translations_to_table.js)
  • Search a spreadsheet for certain keywords and replace with specified strings of text (find_and_replace.js)
  • Copy text from a document, make a Trello card, and insert the text into it (document_to_trello.js)
  • Send an email to specific people from a spreadsheet with a preformatted message (email_from_sheet.js)