Output Sheets as JSON in WebApp

The code below will output content from a Google Sheet – as JSON into a Webapp URL which is perfect to be used from any website to connect via AJAX to get the JSON data. function doGet(e) { const id = ‘1zydy1wJynoC*****7ZFzx1t7B452UdSFqSe0E3I’; const ss = SpreadsheetApp.openById(id); const sheet = ss.getSheetByName(‘data’); const rows = sheet.getDataRange().getValues(); const … Read more

Google Spreadsheet Data API Apps Script Code JSON JavaScript Course

How to use Data in a Google Sheet to output as JSON for your website sharing Google Sheets as JSON get data with AJAX https://www.udemy.com/course/sheet-as-json/?referralCode=30A002EE878D362F522D Explore how you can output and share Google Sheets Content as JSON in a Web app with Apps Script Code JavaScript and Google Apps Script as the backend code to … Read more

Last Chance Promo

Last chance for 2020 to get these top courses of the YEAR. JavaScript DOM Game Blackjack JavaScript Game from Scratch Explore JavaScript Document Object Model web page element updates manipulation using JavaScript code to create a GAME https://www.udemy.com/course/javascript-game-code/?couponCode=LAST2020 API Quiz Game JavaScript Project Google SpreadSheet Data Explore how to connect to a Google Sheet Data … Read more

Practice AJAX get JSON Data

Since myjson.com shut down – and unfortunately I was using it and referring to it in many courses. I’ve now setup some end points that you can use to practice making requests to. They are basic JSON returns on GET method requests. https://www.discoveryvip.com/shared/party.json https://www.discoveryvip.com/shared/quiz.json https://www.discoveryvip.com/shared/list.json https://www.discoveryvip.com/shared/coin.json https://www.discoveryvip.com/shared/person.json https://www.discoveryvip.com/shared/test1.json https://www.discoveryvip.com/shared/people.json https://www.discoveryvip.com/shared/data1.json https://www.discoveryvip.com/shared/peopledata.json https://www.discoveryvip.com/shared/1people.json https://www.discoveryvip.com/shared/books1.json https://www.discoveryvip.com/shared/books2.json https://www.discoveryvip.com/shared/person1000.json … Read more

3 FREE JavaScript Courses

Happy Tuesday – 3 FREE JavaScript Courses ready for you – TODAY ONLY How to create a JavaScript Game Number Guessing Game Project https://www.udemy.com/course/javascript-number-game/ JavaScript 3 practice projects Input form Exercise Generator https://www.udemy.com/course/javascript-project-course/ JavaScript code 3 code mini projects practice coding DOM https://www.udemy.com/course/javascript-example-code/

Free Course List

Title URL Google Apps Script Guide to the New IDE https://www.udemy.com/course/google-apps-script-ide/ Google Apps Script Web App and Client Side Data https://www.udemy.com/course/apps-script-web-app-sheets/ Apps Script OnOpen Trigger new Web URL Project G Suite https://www.udemy.com/course/apps-script-gsuite/ Motivation Increase your productivity How to achieve https://www.udemy.com/course/motivation-course/ CSS Learn CSS Quick Start Course for Beginners Web Design https://www.udemy.com/course/css-course-quick/ JavaScript Learn JavaScript Quick … Read more

AJAX and JSON resources

Text EditorsKomodo Edit is the free and Open-Source counterpart of Komodo IDE.Looking for a powerful editor without all the advanced functionality an IDE comes with?Komodo Edit is for you.http://komodoide.com/Scintilla is a free source code editing component. It comes with complete source code and alicense that permits use in any free project or commercial product.http://www.scintilla.org/Sublime Text: … Read more

Sample Code Google Apps Script

Create a Doc on the fly function myFunction1() {const doc = DocumentApp.create(‘Test 1’);} Create a Doc add some content function myFunction2(){const doc = DocumentApp.create(‘Test 2’);const body = doc.getBody();Logger.log(body);body.appendParagraph(‘Hello World’);} Select a Doc add content to existing Google Doc function myFunction3(){const id = ‘1Rznazp0sPf9eSxFmHRHrWFK0H4lmju6FXDbuI3gZwLk’;const doc = DocumentApp.openById(id);const body = doc.getBody();const para = body.appendParagraph(‘Hello World 2’);para.appendText(‘new text’);Logger.log(para);} … Read more

Google Apps Script Resources

Guide to coding apps script Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, Sheets, and Slides. Apps Script lets you do more with Google, all on a modern JavaScript platform in the cloud. Build solutions to boost your collaboration and productivity. https://developers.google.com/apps-script Google Apps Script Home Apps Script is … Read more

New IDE Apps Script Editor

In December 2020 Google released the ALL new Apps Script Editor. Its got a cleaner look, all in one page navigation menu, and easier than ever to write code. New code hints and options that were lacking in the legacy version. FREE Course Get started with Apps Script https://www.udemy.com/course/google-apps-script-ide/ Better and modern interface Options to … Read more