Dave Sottimano – Automation with Apps Script

Description

Dave Sottimano – Automation with Apps Script download , Dave Sottimano – Automation with Apps Script review , Dave Sottimano – Automation with Apps Script free

Dave Sottimano – Automation with Apps Script

Learn by example and by building mini applications to automate your daily workflow. This course focuses on practical skills and touch on theory when it is required.

Understanding what’s possible, where to find information, and understanding general concepts are more important than memorization, therefore no prior programming experience is required.

Advanced concepts will be broken down into manageable chunks and make sure you’re confident before heading into the next phase of learning.

Introduction video (4 minutes)

Skills you will master
API Apps Script Automation Google Sheets JavaScript Marketing automation

After taking this course you’ll…

• Develop a file explorer in Google docs that allows access to your entire organization’s repository.
• Understand the basics of Google Apps Script, where it can be used, it’s limitations, and how you can use
• Apps Script to automate your workflow.
• Since Apps Script is JavaScript, you’ll learn the basics of this programming language as well. We’ll go through data types, functions, object, methods and more.
• You’ll learn how to approach a problem with a developer mindset. Programming isn’t about memorization, it’s about problem solving and being able to find the answer.

About the expert

David Sottimano 
David’s marketing career has taken him from sales/PR all the way to technical SEO and development. He’s worked and lived in 3 continents for prestigious clients and agencies across the world, specializing, but not limited to technical SEO. For the past 3 years, he’s dedicated most of his time to self-teaching development to automate most of his work and deliver better results for clients.

Notable roles: Senior consultant with Distilled/DMG, previous Moz associate and has been running his own consultancy for the past 5 years.

Your course curriculum
Automation with Apps Script

1 What is Apps Script?
For the beginner, we take a look at what Apps Script is, what it can do, where it lives in the Google Workspace environment, and talk about permissions. Topics covered: What Apps Script is, where to write Apps Script code in Docs, Sheets, Slides and ho …

2 Your first script
We’ll write our first function that checks if a cell contains any word in a list. Topics covered: Write your first Apps script function in SheetsLearn how to run the function as a custom function from a Sheet cell and in the web IDELearn basics of Java …

3 First look at the Apps Script Documentation
Being able to read and understand the documentation is the key to success, also, being able to describe your problem accurately so you can search stackoverflow will be essential. We’ll go through some lingo and explore the documentation together. Topic …

4 Writing pseudocode and pulling data from an API
The goal is to pull data in from an API and output to a sheet. Before we even start writing code, we’ll correctly step through the problem first and write code last. Topics covered: Understand the basics of an API, HTTP request, JSON, and how to pull t …

5 Refactoring our first function
Refactoring (or rewriting) our first function to include error handling, logging, JS DOC and more. Topics covered: Understand all the weird ways you can declare a function in Apps Script (JS) , subtle differences of ES6 including variable types and exp …

6 Storage, caching and permissions in Apps Script
We’ll go through how to store data efficiently in Apps Script while exploring how roles/permissions affect storage of data and how to share scripts securely. Topics covered: Learn how to store/retrieve data in Properties ServiceLearn how to use the cac …

7 Create a bookmarking service
We’ll create our first mini application that will allow you to turn a spreadsheet into a bookmarking service Topics covered: How to create a web appCreate a useful application using more advanced Apps Script featuresMake an application you’ll use every …

8 Building your first add-on
We’ll look at the mechanics behind building a Sheets add-on, what the necessary components are and how to communicate between the client and server side. Topics covered: Write your first sheets add-onUnderstand how to communicate between the add-on and …

Frequently Asked Questions:

1. Innovative Business Model:
   • Embrace the reality of a genuine business! Our approach involves forming a group buy, where we collectively share the costs among members. Using these funds, we purchase sought-after courses from sale pages and make them accessible to individuals facing financial constraints. Despite potential reservations from the authors, our customers appreciate the affordability and accessibility we provide.
2. The Legal Landscape: Yes and No:
   • The legality of our operations falls into a gray area. While we lack explicit approval from the course authors for resale, there’s a technicality at play. When procuring the course, the author didn’t specify any restrictions on resale. This legal nuance presents both an opportunity for us and a boon for those seeking budget-friendly access.
3. Quality Assurance: Unveiling the Real Deal:
   • Delving into the heart of the matter – quality. Acquiring the course directly from the sale page ensures that all documents and materials are identical to those obtained through conventional means. However, our differentiator lies in going beyond personal study; we take an extra step by reselling. It’s important to note that we are not the official course providers, meaning certain premium services aren’t included in our package:
     • No coaching calls or scheduled sessions with the author.
     • No access to the author’s private Facebook group or web portal.
     • No entry to the author’s exclusive membership forum.
     • No direct email support from the author or their team.

   We operate independently, aiming to bridge the affordability gap without the additional services offered by official course channels. Your understanding of our unique approach is greatly appreciated.

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, Item do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank you for choosing us! We’re so happy that you feel comfortable enough with us to forward your business here.