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

• Intro to Google Scripts
• How to get started
• Documentation on the variables available

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)