Show contents:

• 06:01 - Meeting Spencer and Jonathan

• 12:23 - How to decide if a Google Sheet is the right solution?

• 20:57 - Tips on optimizing Google Sheet data handling including cache strategies

• 26:50 - Resources for learning how to develop Google Sheet solutions

• 31:45 - Techniques for preventing users breaking Google Sheets

• 39:30 - Discussing no code solutions using AppSheet

• 45:45 - Sheet Academy (coming soon)

Broadcast Date: 15 September 2021

Guests:

• Jonathan Butler Software Engineer, Viriya Consulting

• Spencer Farris Google Sheets & Apps Script Consultant

Spreadsheets are the swiss army knife of productivity tools where they are used (and sometimes misused) as databases, workflow engines, project management tools, custom calculators, and oh yeah… spreadsheets. In this episode of Totally Unscripted, we will chat with Jonathan Butler, Software Engineer at Viriya Consulting, and Spencer Farris, a Google Sheets & Apps Script Consultant, about how they are build spreadsheet solutions that range from small problem-solving automations to full blown critical applications.

Resources:

• A curious case of a Chess game!

• Sheet Academy - Preview

• Bruce McPherson's - Squeezing more into (and getting more out of) Cache services

• How to Grow a Spreadsheet into an Application (Cloud Next '19)

• Productivity examples from AppsScriptPulse

  • • How to Request Payments with Stripe Checkout and Google Sheets – Digital Inspiration

    • How to Request Payments with Razorpay and Google Sheets – Digital Inspiration

    • Create personal stock portfolio tracker with Google Sheets and Google Data Studio

    • Create Google Calendar events from sending yourself a Gmail on a mobile device using Google Apps Script

    • Track Customer Subscriptions with Google Spreadsheet & App Script by sending an Email Automatically

    • Google Apps Script for Android Translation