• Home
  • Cloud
    • General
    • SaaS
    • BPaaS
    • PaaS
    • IaaS
    • Other Internet Hosted Applications
      • WordPress
        • WooThemes Canvas
          • WooThemes Canvas CSS
  • About me
  • Why Badly Wired?
  • Contact

Badly Wired

Alan's technical notebook - WordPress and other stuff

You are here: Home / Archives for Cloud / Google Cloud

WordPress REST API retrieve data and email it as an xls using Google Sheets

31st July 2018 by Alan Leave a Comment

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 ) 

Filed Under: Code snippets, Google Cloud, Wordpress  

Putting it all together – authenticate, read and update WordPress from a spreadsheet

16th January 2018 by Alan 1 Comment

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…]

Filed Under: Code snippets, Google Apps for Works, Google Cloud, SEO, Uncategorised, Wordpress  Tagged: Google Scripts Wordpress REST API Google Sheets SEO

How to authenticate WordPress Rest API from Google Sheets / Scripts

15th January 2018 by Alan 2 Comments

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…]

Filed Under: Code snippets, Google Apps for Works, Google Cloud, SEO, Uncategorised, Wordpress  

Getting post meta via WordPress REST API

12th January 2018 by Alan 9 Comments

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…]

Filed Under: Code snippets, Google Apps for Works, Google Cloud, SEO, Uncategorised, Wordpress  

Linking WordPress to a Spreadsheet using WP REST API and Google Sheets scripts

11th January 2018 by Alan 7 Comments

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…]

Filed Under: Code snippets, Google Apps for Works, Google Cloud, SEO, Uncategorised, Wordpress  

5 minute guide to setup process monitoring with MONIT on Linux

30th August 2016 by Alan Leave a Comment

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…]

Filed Under: Cloud, Code snippets, General, Google Cloud, Linux  Tagged: google compute engine, mailgun, monitoring

Adding Swap to Google Compute Engine

15th August 2016 by Alan 1 Comment

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…]

Filed Under: Google Cloud, Linux  

Backing up to gcloud storage from Linux/Virtualmin

5th August 2016 by Alan Leave a Comment

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…]

Filed Under: Google Cloud, Linux, Tech Tips  Tagged: Backups, Google Cloud, Virtualmin

Categories

  • Applications
  • Cloud
    • General
    • Google Cloud
    • IaaS
    • Other Internet Hosted Applications
      • Wordpress
        • WooThemes Canvas
        • WooThemes Canvas CSS
    • SaaS
  • Code snippets
  • Discounts
  • Genesis
  • Google Apps for Works
  • Linux
  • News
  • SEO
  • Server setup
  • Services
  • Tech Tips
  • Uncategorised
  • Useful Images
  • Useful Stuff
  • WordPress Hosting
  • WordPress Plugins

Tags

background jobs beadcrumbs bind brandings Cache canvas Centos chrome css fail2ban Find firefox Flash fraud genesis gocardless godaddy Google google maps hackers internet explorer javascript KashFlow Linus linux Magento mapquest maps microsoft mysql news nohup php plugin plugins queens diamond jubilee replace SED SEO skype Varnish Virtualmin Webmin woothemes Wordpress

 

Affiliate and Privacy Notices

This site is free to use, but hopes to cover some costs through affiliate income, some products and links are affiliates and may earn the site advertising income.

Some affiliates use Cookies to track if you purchase from them, this allows them to apportion revenue to us you will need to refer to their specific privacy notices as to how you are tracked.

This site is a participant in the Amazon EU Associates Programme, an affiliate advertising programme designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.co.uk.

  • Privacy Policy

Copyright © 2021 · Badly Wired