YoVDO

Batch Create Reports with App Scripts

Offered By: LiquidBrain Bioinformatics via YouTube

Tags

Google Apps Script Courses Google Sheets Courses VLOOKUP Courses COUNTIFS Courses

Course Description

Overview

Learn how to automate report generation using Google Apps Script in this 39-minute tutorial. Discover techniques for batch creating reports based on raw data from the CDC EU, including simple text replacement, inserting tables, and creating line graphs without third-party add-ons. Follow along with step-by-step instructions on working with Google Sheets, utilizing functions like VLOOKUP and QUERY, and implementing Apps Script for efficient data manipulation and report creation. Access provided resources, including example spreadsheets, scripts, and datasets, to enhance your understanding and apply these skills to your own projects.

Syllabus

Intro
What is App Script
Report Template
Clean Up Data
App Script
Print Code
Get Time Date
Get Body
Get Table
Build Chart
Recap


Taught by

LiquidBrain Bioinformatics

Related Courses

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera