Step-by-step guide to connect to the Strava API with Google Sheets to retrieve athlete data and display it in a stunning Google Data Studio dashboard.
Source: How to connect the Strava API with Google Sheets and Data Studio
Step-by-step guide to connect to the Strava API with Google Sheets to retrieve athlete data and display it in a stunning Google Data Studio dashboard.
Source: How to connect the Strava API with Google Sheets and Data Studio
This is a popular post from 2018….
In the previous post in the Google Apps Script Pattern series we looked at selectively updating rows of data in a Google Sheet. For this post we will look at a couple of patterns for inserting multiple rows of data into Google Sheets.
Source: Google Apps Script Patterns: Writing rows of data to Google Sheets – MASHe
Jasper Duizendstra provides some Google Apps Script coding tips…
Organise your JavaScript objects in Google Apps Script with the constructor pattern by Douglas Crockford.
Source: Structure and simplify your Google Apps Script – Jasper Duizendstra – Medium
Yuki Tanabe provides some Google Apps Script code that can change the owner permissions of all folders and files in a particular folder in Google Drive
Source: Transfer owner rights under Google Drive folder at once with Google Apps Script-Qiita
Yuki Tanabe gives an overview of how to use Google Apps Script and Data Studio to create a visualization and analysis tool for services that provide web APIs
Source: G Suite x Zendesk API で問い合わせの分析・可視化ツールを作ってみた – google-cloud-jp – Medium
Jasper Duizendstra demonstrates how with a little bit of Google Apps Script you can easily use your Google Calendar to keep a record of how much time you spend on tasks and then query/report this via Google Sheets. The post contains instructions and code for getting started
Source: Record time and activities with Google Sheets, Calendar and Apps Script
Yuki Tanabe shares some strengths and weaknesses of Google Apps Script as well as criteria for choosing Google Apps Script for your coding project
Source: I summarized my own practices on what Google Apps Script is strong and when to use it
Creating BigQuery tables using the GUI can be a hassle. This article describes an alternative way to create BigQuery tables
Source: Create BigQuery tables with Google Sheets and Apps Script
When dealing with matching in sheets, you sometimes need to get close matches. This post shares the “Rough” namespace of the cUseful library
How to measure latency between Google Apps Script project (with UrlFetchApp) and Google Cloud Platform regions (e.g. if you are choosing region for GCP project)