Apps Script Examples

Find the Apps Script code you’re after with these examples and tutorials. Click the link to view the article.

Want to see a specific example? Drop me a line here.

New to Apps Script?

> Guide to getting started with Apps Script (for absolute beginners)

General Apps Script Examples

> Saving data in your Google Sheets with Apps Script

> How to set up time-based triggers to run your Apps Script code

> How to add a hyperlinked index sheet to your large Google Sheet workbooks

> How to add a hyperlinked index into a sidebar of your Google Sheet workbooks

Integration Apps Script Examples

> Guide to getting started with APIs using Apps Script

> Google Sheets Slack bot: how to push data from your Google Sheets into the popular messaging app

> Google Sheets and D3 charts

> How to extract email addresses tagged with a specific Gmail label

> How to reply to Google Forms survey responses quickly with Sheets & Apps Script

> Connecting to the Crunchbase API with Google Sheets

> Google Sheets and Mailchimp integration using Apps Script

> How to get data from E-junkie into Google Sheets

> Show data from the GitHub API in Google Sheets, using Apps Script and Oauth

Data Visualization Examples

> How to automatically create waterfall charts using Apps Script

> How to automatically create funnel charts using Apps Script

> Recreating Tufte’s famous temperature chart with the Google Chart API

> Animated temperature chart using the Google Chart API

> One way to animate a chart in Google Sheets

Data Studio Examples

> Community Connectors: Access all your data in Google Data Studio

Find me on GitHub here.

10 thoughts on “Apps Script Examples”

  1. Hello, Ben

    Thank you for the info shared on scripts for Google Sheets, was really helpful to get me stared on getting a few things fixed in my sheets.

    By the way, do you perhaps have a fix to have Grouped Columns and Rows as available in Excel for Google Sheets/


  2. Dear Ben,
    Very interesting post and useful. I want to know is it possible to build web app that act as database with webpage at front end and spreadsheet at back end. Something similar to ms access?

    Thank you

  3. Hi Ben,

    I want to create a script that forwards an email to my evernote email address when I add a label and then changes the label to completed when done so.

    Does anything exist like this I can amend. Or where do I start?

    Many thanks for your cool info.



    1. I don’t know if this specific example exists anywhere, but it sounds totally plausible. Looks like people have done something similar before though, so this might be a place to start:

      The Gmail Service docs will be pretty helpful for this too:

      Hope that helps!

  4. Dear Ben,
    I need a script to know from Sreadsheet if a file exist in drive. for example in column “b” i have “123.pdf” and i need that a script looking for that name into drive and if it exist put on column c “yes”, else put “Not”
    maybe can u help me?


  5. Hi Ben

    Great site and article, thanks for this!

    I need to scan a lot of sheet files looking for data in cells.
    Is there a way to read (or write) sheet files without them having to be open in the browser?


Leave a Reply

Your email address will not be published. Required fields are marked *