How to create JSON feed from Google Sheets Data

Create a Google Sheet Under File Menu Select ‘Publish to the web” Select under Link Sheet and as Web Page – Click Publish Check the URL provided to ensure page is visible on the web Copy Sheet ID Place the id in the JSON URL ‘https://spreadsheets.google.com/feeds/list/’+id+’/1/public/values?alt=json’; const id = ‘1H2xq8J5uZKDABgu1JlvV-nVWKqZoV8_UpB_D_snOrLo’; const url = ‘https://spreadsheets.google.com/feeds/list/’+id+’/1/public/values?alt=json’; 7. … Read more

Learn JavaScript FREE Course JavaScript Learn JavaScript Quick Course Beginners

https://www.udemy.com/course/javascript-learn/?referralCode=ACDDDD610F7B5821266E Fast Paced JavaScript Introduction course designed to get you started quickly – Core fundamental JavaScript Syntax Perfect course to have a quick start or refresher to JavaScript. Warning this is a fast paced courses covering a lot of concepts quickly!  – Source code is included and its suggested that you try the code between … Read more

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

WP Twitter Auto Publish Powered By : XYZScripts.com