Google Apps Script for google sheets

On this page, you'll find helpful resources for using Google Apps Script with Google Sheets. Apps Script uses Javascript to extend the functionality of Sheets.

📗 Introductory Course Using Google Apps Script with Sheets From Scratch (FREE) 📗

Getting Started 🎬

• Google Apps Script: A Beginner’s Guide (Ben Collins)
• Automate Google Sheets: An Introduction to Google Apps Script (Zapier)
• 7 REASONS WHY GOOGLE APPS SCRIPT IS A GREAT FIRST PROGRAMMING LANGUAGE TO LEARN (Learn to Code with Me)
• 5 Google Sheets Script Functions You Need to Know (Help Desk Geek)

Tips

• Apps Script Tips and Tricks Twitter Mega Thread (@imthenachoman)

References

• Custom Functions in Google Sheets (Google Reference)
• Apps Script Best Practices (Google Reference)
• Google Apps Script Video Library (Google Reference)

Research

• Apps Script Pulse - Latest Articles from GAS Community

Forums

• Google Apps Script Community (Google Groups)
• Google Apps Script (Reddit)
• Questions tagged [google-apps-script] (Stack Overflow)

Tutorials

• Sheets Apps Script Tutorials (Google Reference)
• How to use Google Sheets and Google Apps Script to build your own blog CMS (Free Code Camp)
• Create a seat booking form with Google Forms, Google Sheets and Google Apps Script (yagisanatode.com)
• Hands-on with Google Apps Script: accessing Google Sheets, Maps & Gmail in 4 lines of code! (Google CodeLabs)

Macros

• Apps Script - Google Sheets Macros (Google Reference)

Automation

• Jobs for Google Sheets (Max Makhrov)

Custom Functions

• Custom Functions in Google Sheets (Google Reference)
• Quickstart: Menus and Custom Functions (Google Reference)

Development

• Some Useful Reusable Functions in Google Sheets Scripts (William Earnhardt)

Libraries

• TSDataTable — Simple, Elegant Data Tables for Google Sheets & Sites (Laura Taylor)

APIs

• How to connect the Strava API with Google Sheets and Data Studio (Ben Collins)
• Build An Entire API in Google Sheets and Google Apps Script (Dana Hooshmand)
• HOW TO SEARCH FOR YOUTUBE VIDEOS INSIDE GOOGLE SHEETS (Aozata.com)
• Accessing NASA API with Google Sheets (Compute Thought)

Projects

• Test sites using WebPageTest (GitHub Repo)
• A URL Shortening service powered by Google Apps Script (GitHub Repo)

Google Photos

• How to backup Google Photos to Google Drive automatically after July 2019 with Apps Script (Robert Ellison)

GMail

• HACK YOUR GMAIL: A QUICK START FOR GOOGLE APP SCRIPTING (HackADay)

Google Sheets

• Copy a Template Sheet as a New Sheet in Google Sheets with Apps Script
• Google Sheets Sort By Color And Google Sheets Filter By Color, With Apps Script (Ben Collins)

Useful Scripts

• Convert Doc to PDF and move into a new folder (Gift of Script)

Google Calendar

• Record time and activities with Google Sheets, Calendar and Apps Script (Jasper Duizendstra)

Web Apps

• Google Apps Script - Web Apps Guide (Google Guide)
• Create webhooks from Google sheets (Danny Hawkins)
• How to Submit an HTML Form to Google Sheets…without Google Forms (David McCoy)

CLASP

• Codelabs - Using CLASP (Google)