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
My Google Apps Script Notes Cheatsheet
This is just an embed of my Google Apps Script notes. If you want to view the document in Google Docs, click HERE.
How to Print a Selection in Google Sheets
This video details printing a selection in Google Sheets to a printer or pdf. https://youtu.be/apJD1J-IaWk Video: Print a Selection in Google Sheets Google Sheets Printing Tips: You can make text bigger choosing narrow in the margins drop down in the print dialog.You can choose to add specific information to the header/footer in the print dialog … Continue reading How to Print a Selection in Google Sheets
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
Using Drop Down Lists in Google Sheets
I've uploaded a video to the Google Sheets Training Youtube channel detailing using a drop down list. It covers data validation with a list of items and a range of items. https://youtu.be/OhTSR3dBXZk YouTube: Using Drop Down Lists for Data Validation Drop down lists in Google Sheets help to speed up data entry and eliminate errors … Continue reading Using Drop Down Lists in Google Sheets
