Introducing Apps Script Blastoff: My new, free Google Apps Script course

I’m super excited to share my latest free course with you: Apps Script Blastoff!

Go from zero coding knowledge to just enough code to automate your Google Sheets!

Apps Script Blastoff course launch

πŸš€ 100% online video training course

πŸ“š 5 modules | 25 videos

πŸ’» Includes all the templates and source code

πŸ”₯ It’s free!

This course will set you up to:

  • Understand what Google Apps Script is and why you should use it
  • Know the building blocks of Apps Script
  • Have the confidence to write your own programs
  • Build some cool automated tools you can use right away
  • Know your way around the Apps Script developer environment
  • …and much, much more!

Each lesson is taught through bite-sized, action-oriented 5 – 15 minute-long videos, covering practical techniques you can apply to your own business.

This course will teach you the basic foundational techniques in Apps Script, even if you’re brand new to coding.

Best of all, it’s free! That’s right, this one’s on the house. πŸ˜€

Start today, and learn just enough code to automate your Google Sheets.

Check out Apps Script Blastoff! >>

The complete guide to simple automation in Google Sheets, using Macros

Macros are small programs you create inside of Google Sheets without needing to write any code. They allow you to automate repetitive tasks. They work by recording your actions as you do something and saving these actions as a “recipe” that you can re-use again with a single click.

Sound good?

They sure are! Read on to learn how to use them, see some examples, discover their limitations and also see how they’re a great way into the wonderful world of Apps Script coding πŸ˜€

This video is the third lesson from my free Apps Script Blastoff! course: an online course teaching Google Apps Script from scratch.

Contents

  1. What are macros?
  2. Why should you use macros?
  3. How to create your first macro
  4. Other options
  5. A peek under the hood
  6. More macro examples!
  7. Resources

Continue reading The complete guide to simple automation in Google Sheets, using Macros

Automatically issue Teachable course certificates with Apps Script

In this post I’m going to show you how you can setup a system to automatically issue certificates to students who complete an online course on the Teachable platform, using Google Apps.

First, it captures course completion data in a Google Sheet. Second, it creates a PDF certificate based on a Google Doc template. And third, it emails that certificate out to the student via Gmail.

It has the advantage that it’s free and doesn’t involve any other paid third-party tools.

It has the disadvantage that there’s quite a few steps involved to get it all hooked up.

Process

Teachable course certificates Apps Script process

Basic webhook example

Continue reading Automatically issue Teachable course certificates with Apps Script

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

This post shows you how to connect a Google Sheet to GitHub’s API, with Oauth and Apps Script. The goal is to retrieve data and information from GitHub and show it in your Google Sheet, for further analysis and visualization.

If you manage a development team or you’re a technical project manager, then this could be a really useful way of analyzing and visualizing your team’s or project’s coding statistics against goals, such as number of commits, languages, people involved etc. over time.

Contents

  1. What are Git and GitHub?
  2. Access GitHub API using Basic Authentication
  3. Access GitHub API using OAuth2 Authentication
  4. Resources and further reading

Note, this is not a post about integrating your Apps Script environment with GitHub to push/pull your code to GitHub. That’s an entirely different process, covered in detail here by Google Developer Expert Martin Hawksey.

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

How to build a real-time sales dashboard for E-junkie using Google Sheets and Apps Script

It’s day two of a four day product launch. You’ve worked hard all year to create a fantastic product, test your sales systems and tell the world about this amazing offer. You know you’ve sold 100 products so far, but…

…you don’t know whether your ads are effective, which affiliates are really killing it versus which have forgotten about your launch, or even whether your own emails are converting.

Looking at your sales log only, and having to decipher what’s happened since the last time you looked an hour ago, is like trying to drive in the dark without headlights.

Thankfully there is a better way to track your sales, so you can see your data, get insights about what’s working and what’s not, and immediately act to increase your bottom line.

This post looks at how to build a real-time dashboard for the E-junkie digital sales platform using Google Sheets:

Google Sheet e-junkie real-time dashboard
Google Sheet e-junkie real-time dashboard (fictitious data)
Want your own copy of this dashboard?
Click here to access your copy of this template >>

E-junkie is a digital shopping cart, used for selling digital products and downloads. The system handles the shopping cart mechanics, but does not do any data analytics or visualizations.

You can view a transaction log (i.e. a list of all your sales) but if you want to understand and visualize your sales data, then you’ll need to use another tool to do this. Google Sheets is a perfect tool for that.

You can use a Google Sheet to capture sales data automatically in real-time, and use the built-in charts to create an effective dashboard.

You’d be crazy not to have a tracking system set up, to see and understand what’s going on during sales events or product launches. This E-junkie + Google Sheets solution is effective and incredibly cheap ($5/month for E-junkie and Google Sheets is free).

The Write Life ran a Writer’s Bundle sale this year, during the first week of April. It’s a bundled package of outstanding resources for writers, including ebooks and courses, heavily discounted for a short 4-day sales window.

I created a new dashboard for The Write Life team to track sales and affiliates during the entire event. This year’s dashboard was a much improved evolution of the versions built for the Writer’s Bundle sales in 2014 (which, incidentally, was my first blog post on this website!) and 2015.

The biggest improvement this year was to make the dashboard update automatically in real-time.
Continue reading How to build a real-time sales dashboard for E-junkie using Google Sheets and Apps Script