-
WordPress REST API retrieve data and email it as an xls using Google Sheets
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 […]
-
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 […]
-
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 […]
-
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 […]
-
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 […]