Google Script to read a WordPress REST API endpoint into a Google Sheet and then email it ( no titles in this one, see other tutorials for titles )
Putting it all together – authenticate, read and update WordPress from a spreadsheet
This is my fourth post in my series of how to build a script to manage WordPress data via the API and a spreadsheet. If you have arrived here without looking at the others you probably should start at the beginning here. In this tutorial I’m going to handle updating and then pull it all [Read the full article…]
How to authenticate WordPress Rest API from Google Sheets / Scripts
This is the third tutorial in my series relating to integrating Google Sheets and WordPress using the REST API. The first post covered reading basic post information into a spreadsheet. The second post was about getting meta data from the REST API, which can be a little tricky. This one covers authentication. Basically as an [Read the full article…]
Getting post meta via WordPress REST API
This the second post post in my series about getting and updating WordPress data via a spreadsheet. The first post focused on the basics of Google Apps Scripting and the API call to the WP REST API – if you haven’t seen it you can read it here. This post is about meta data. In [Read the full article…]
Linking WordPress to a Spreadsheet using WP REST API and Google Sheets scripts
This post shows you how you can link a Google Spreadsheet to a WordPress website to extract data. I will write some further posts covering authentication and updating too. However a little warning, this is a programming task and a basic understanding of javascript is really required to follow what is going on. WordPress is [Read the full article…]
5 minute guide to setup process monitoring with MONIT on Linux
If you are running a VPS, for a production server, it is very useful to have a process that monitors, and restarts if failed, and notifies you of key processes, like apache, mysql, postfix & ssh. Monit is a free open source tool that does the job. Took me a little while to get my [Read the full article…]
Adding Swap to Google Compute Engine
By default Google Compute Engine (Debian) doesn’t come with any swap space. If you have periodic programs that eat a bit more memory (like my backups do) then instead on just adding more physical memory you can add a swap file. Swaps files are much slower than physical memory, so should be avoided except when [Read the full article…]
Backing up to gcloud storage from Linux/Virtualmin
Using Google Cloud Storage as backup for your linux server is inexpensive if you use the nearline storage option. This is cheaper that Amazon Web Services (at the time of writing) The process I use is as follows. Backup locally Create storage bucket / folders, set lifecycle Script to move backups find way to execute [Read the full article…]
