AppsScriptPulse

Syncing Data from Coda to Google Sheets And Vice Versa with Google Apps Script [A How-To Guide] | Hacker Noon

Last year I published a tutorial on how to sync data between two Coda docs and data between two Google Sheets. What was missing from the tutorial was how to sync data between a Coda doc and a Google Sheet.

A step-by-step walk-through by Al Chen on syncing data from Coda -> Google Sheets and from Google Sheets -> Coda

Source: Syncing Data from Coda to Google Sheets And Vice Versa with Google Apps Script [A How-To Guide] | Hacker Noon

Thoughts on building a custom connector for Google Data Studio

While looking for a solution to my problem, I landed with Google Data Studio (GDS). Have you ever heard of GDS? Lucky you! Many people don’t even know that such a powerful tool exists and that it’s for free. Some years ago I was playing around with GDS for analyzing our Google Analytics data that we had gathered from the usage of our Android App. That’s exactly where GDS originates. It was designed as a simple but handy tool to dig through your Google Analytics data.

This article will explain some common use cases of data inside Google Data Studio and elaborate on how they impact your code and how data is being retrieved from your custom API. It may help you to decide whether to stick with your current solution or start implementing a custom connector for Google Data Studio.

Source: Thoughts on building a custom connector for Google Data Studio

Cleaning up Plex with Google Apps Scripts

Using the UrlFetchApp library and the fetch method we call the Plex media server to retrieve all the contents of our library. We parse the XML response to JSON using a method that you can find here. You can add the parsing method to the same file, if you want.

This tutorial is going to cover what it takes to automatically cleanup a Plex media server, using Google Apps Scripts.

Source: Cleaning up Plex with Google Apps Scripts

Google doc as rest api using Apps Script

After a fight with wordpress, I said to myself: Can I use google doc as content management? .. Join me in this attempt

A simple yet elegant approach to using Google Docs to manage structured content using Google Apps Script.

Source: Google doc as rest api using Apps Script

Add a Google Meet to Calendar Events with Google Apps Script

My small team relies on automation to make things run. Part of our PD process is a Google Form workflow that kicks off calendar events, document creation, and email notifications. Since we’ve moved to online learning, we wanted to update that process to automatically add a Google Meet link for any PD that doesn’t have to be in person.

There are some official Google guides that show how to attach a Meet event to the Calendar, but nothing from the perspective of Apps Script specifically, so that’s what is shown here.

Source: Add a Google Meet to Calendar Events with Google Apps Script

TSChatWise — A Google Chat Education Tool

I like shortcuts! I’m in constant search of what I deem to be the most simple, efficient and effective shortcuts. I consider any tool, system or methodology which helps me streamline workflow and save precious time a shortcut. When I believe I’ve discovered (or perhaps created) a shortcut, especially a G Suite shortcut, I like to share that shortcut with others.

Take your G Suite organization’s education to the next level with TSChatWise … a Google Sheets and Apps Script powered Google Chat tool for teaching and learning. 🚀

Source: TSChatWise — A Google Chat Education Tool

Moving Card Game using Google Sheets & Apps Script

Moving Card Game using Google Sheets & Apps Script

One popular method to get your students to learn is to categorise things or to put them in order. Here, we’re going to look at making a card sorting game, which could be used for both.

Source: Moving Card Game using Google Sheets & Apps Script

Structure and simplify your Google Apps Script (with) V8

Apps Script now supports the V8 runtime. Time for an update to the story “Structure and simplify your Google Apps Script Apps script”. The V8 runtime brings modern ECMAScript syntax to Apps Script. So we can now use arrow functions and destructuring assignments. No more hoisting with let and const and my personal favorite, template literals.

In this story Jasper Duizendstra shows the added value of the changes made in the constructor pattern using the factory functions. It also shows how to implement chaining and a builder pattern in Apps Script.

Source: Structure and simplify your Google Apps Script (with) V8

Build Local Links with Google Apps Scripting

Building up a solid link profile is a cornerstone of local SEO, but it can be a time consuming and tedious process. In this post I’ll show you how to automate this quickly and efficiently with Google Sheets.

This Google Sheets tool uses Apps Scripting to combine the Google Maps and Mozscape APIs into an all-in-one link finder. Type in a search term and a lat/long, and the tool will find the top Google maps results. Once we have those results, we can discover who is linking to them, and produce a “link intersect” report.

Source: Build Local Links with Google Apps Scripting

Building a Gmail Add-on with Apps Script

I recently sent an email where I typed code inline in the message body. I spent a good 15 minutes going through and formatting each line of code to look like, well, code. I wanted an extension like Code Blocks that would instantly format my text to a specific preset style.

A well chronicled article by Kelsey Kripp on how to dive right into Apps Script for G Suite to build your own Gmail add on!

Source: Building a Gmail Add-on with Apps Script