Add launchd ETL scheduler (30min auto-refresh); use homebrew python3 with google libs

fa600899ecaf48aa3b3b95d2ed1480fcc747fcf7 · 2026-08-04 14:01:55 -0700 · Steve Abrams

Files touched

A com.steve.ga-allsites-etl.plist
A etl.err

Diff

commit fa600899ecaf48aa3b3b95d2ed1480fcc747fcf7
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Aug 4 14:01:55 2026 -0700

    Add launchd ETL scheduler (30min auto-refresh); use homebrew python3 with google libs
---
 com.steve.ga-allsites-etl.plist | 17 +++++++++++++++++
 etl.err                         |  6 ++++++
 2 files changed, 23 insertions(+)

diff --git a/com.steve.ga-allsites-etl.plist b/com.steve.ga-allsites-etl.plist
new file mode 100644
index 0000000..51198bd
--- /dev/null
+++ b/com.steve.ga-allsites-etl.plist
@@ -0,0 +1,17 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
+<plist version="1.0">
+<dict>
+  <key>Label</key><string>com.steve.ga-allsites-etl</string>
+  <key>ProgramArguments</key>
+  <array>
+    <string>/opt/homebrew/bin/python3</string>
+    <string>/Users/macstudio3/Projects/ga-allsites/etl.py</string>
+  </array>
+  <key>WorkingDirectory</key><string>/Users/macstudio3/Projects/ga-allsites</string>
+  <key>StartInterval</key><integer>1800</integer>
+  <key>RunAtLoad</key><true/>
+  <key>StandardOutPath</key><string>/Users/macstudio3/Projects/ga-allsites/etl.log</string>
+  <key>StandardErrorPath</key><string>/Users/macstudio3/Projects/ga-allsites/etl.err</string>
+</dict>
+</plist>
diff --git a/etl.err b/etl.err
new file mode 100644
index 0000000..d5d9611
--- /dev/null
+++ b/etl.err
@@ -0,0 +1,6 @@
+Traceback (most recent call last):
+  File "/Users/macstudio3/Projects/ga-allsites/etl.py", line 123, in <module>
+    raise SystemExit(main())
+  File "/Users/macstudio3/Projects/ga-allsites/etl.py", line 44, in main
+    from google.analytics.admin import AnalyticsAdminServiceClient
+ModuleNotFoundError: No module named 'google'

← e780b00 Inject boot data server-side for instant first paint + crede · back to Ga Allsites · Multi-view app: left icon-tab sidebar (Sites/Visuals/Country 997f94a →