Back up your WordPress posts to Google Drive every week

import csv, io
from datetime import date
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from googleapiclient.http import MediaIoBaseUpload
from clickruntime import on_trigger, credentials, http, notify

FOLDER_ID = "your-drive-folder-id"
WP = "https://blog.example.com/wp-json/wp/v2/posts"

@on_trigger
def run(event):
    out, rows, page = io.StringIO(), 0, 1
    writer = csv.writer(out)
    writer.writerow(["title", "url", "date", "content"])
    while True:
        r = http.get(WP, params={"per_page": 100, "page": page, "status": "publish", "_fields": "title,link,date,content"})
        if r.status_code == 400 or not r.json():
            break
        for p in r.json():
            writer.writerow([p["title"]["rendered"], p["link"], p["date"], p["content"]["rendered"]])
            rows += 1
        page += 1
    drive = build("drive", "v3", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    f = drive.files().create(body={"name": f"wordpress-posts-{date.today()}.csv", "parents": [FOLDER_ID]},
                             media_body=MediaIoBaseUpload(io.BytesIO(out.getvalue().encode()), mimetype="text/csv"), fields="webViewLink").execute()
    notify.email_me(f"WordPress backup: {rows} posts", f["webViewLink"])
    return {"posts": rows}