Use Google Apps Script to Access the Pinboard API

I'm creating a spreadsheet in Google Sheets to import my Pinboard links so I can search them. This is just the bit of code I used to get the json version of my latest links. var urlRecent = 'https://api.pinboard.in/v1/posts/recent?format=json'; var response = UrlFetchApp.fetch(urlRecent, { headers: { 'Authorization': 'Basic ' + Utilities.base64Encode('USERNAME' + ':' + 'PASSWORD') … Continue reading Use Google Apps Script to Access the Pinboard API

How to Create a YouTube Tag Planning Tool with Google Sheets

I've posted a video detailing how to create a YouTube Tag Planning Tool. https://youtu.be/Lx9SfQWWnQo Video: Create a YouTube Tag Planning Tool with Google Sheets If you want to skip the video and just get the tool, here is a link to download the spreadsheet to your Google Drive: YouTube Tag Planning Tool This Google spreadsheet … Continue reading How to Create a YouTube Tag Planning Tool with Google Sheets

How to Copy a Sheet to a Different Spreadsheet in Google Sheets

This video tutorial demonstrates how to copy a Google Sheets spreadsheet as well as how to copy a sheet to a different workbook. https://youtu.be/MGNOQz3vcLk Video: How to copy a sheet to a different workbook This is the way to go for the occasional one-off copy. If you find yourself copying the same sheet again and … Continue reading How to Copy a Sheet to a Different Spreadsheet in Google Sheets

Sheets.New and Google Drive – How to Create a New Spreadsheet in Google Sheets

There are a couple of quick ways to create a new Google Sheets spreadsheet and they are explained in this video. Get ready to make new spreadsheets anytime and any place. https://youtu.be/njsyQhi0PS0 Youtube: Creating New Spreadsheets Efficiently In addition to sheets.new, you can use any of the following addresses: sheet.new spreadsheet.new spreadsheets.new Creating a spreadsheet … Continue reading Sheets.New and Google Drive – How to Create a New Spreadsheet in Google Sheets