GitHub Actions (weekly cron)
 ├── search_console_tracker.ts → search-console-latest.csv
 └── ga4_tracker.ts → ga4-pages-latest.csv
 ga4-acquisition-latest.csv

import { google } from "googleapis";
import { writeFileSync, mkdirSync, existsSync } from "fs";

const SERVICE_ACCOUNT_JSON = process.env.GOOGLE_SERVICE_ACCOUNT_JSON ?? "";
const SITE_URL = process.env.SEARCH_CONSOLE_SITE_URL ?? "";
const OUTPUT_DIR = process.env.ANALYTICS_OUTPUT_DIR || "./analytics";

function getClient() {
 const credentials = JSON.parse(SERVICE_ACCOUNT_JSON);
 const auth = new google.auth.GoogleAuth({
 credentials,
 scopes: ["https://www.googleapis.com/auth/webmasters.readonly"],
 });
 return google.searchconsole({ version: "v1", auth });
}

async function main() {
 const client = getClient();
 const now = new Date();
 const endDate = new Date(now.getTime() - 3 * 86400000); // 3 days ago (data lag)
 const startDate = new Date(endDate.getTime() - 28 * 86400000);
 const fmt = (d: Date) => d.toISOString().split("T")[0];

 const res = await client.searchanalytics.query({
 siteUrl: SITE_URL,
 requestBody: {
 startDate: fmt(startDate),
 endDate: fmt(endDate),
 dimensions: ["query"],
 rowLimit: 500,
 },
 });

 const rows = res.data.rows ?? [];
 if (!existsSync(OUTPUT_DIR)) mkdirSync(OUTPUT_DIR, { recursive: true });

 const csv = [
 "Query,Clicks,Impressions,CTR,Position",
 ...rows.map((r) =>
 `"${(r.keys?.[0] ?? "").replace(/"/g, '""')}",${r.clicks},${r.impressions},${((r.ctr ?? 0) * 100).toFixed(2)}%,${(r.position ?? 0).toFixed(1)}`
 ),
 ].join("\n");

 writeFileSync(`${OUTPUT_DIR}/search-console-latest.csv`, csv, "utf-8");
 console.log(`Saved ${rows.length} queries`);
}

main();

import { google } from "googleapis";
import { writeFileSync, mkdirSync, existsSync } from "fs";

const SERVICE_ACCOUNT_JSON = process.env.GOOGLE_SERVICE_ACCOUNT_JSON ?? "";
const PROPERTY_ID = process.env.GA4_PROPERTY_ID ?? "";
const OUTPUT_DIR = process.env.ANALYTICS_OUTPUT_DIR || "./analytics";

function getClient() {
 const credentials = JSON.parse(SERVICE_ACCOUNT_JSON);
 const auth = new google.auth.GoogleAuth({
 credentials,
 scopes: ["https://www.googleapis.com/auth/analytics.readonly"],
 });
 return google.analyticsdata({ version: "v1beta", auth });
}

async function main() {
 const client = getClient();
 if (!existsSync(OUTPUT_DIR)) mkdirSync(OUTPUT_DIR, { recursive: true });

 const res = await client.properties.runReport({
 property: `properties/${PROPERTY_ID}`,
 requestBody: {
 dateRanges: [{ startDate: "28daysAgo", endDate: "yesterday" }],
 dimensions: [{ name: "pagePath" }],
 metrics: [
 { name: "screenPageViews" },
 { name: "averageSessionDuration" },
 { name: "bounceRate" },
 ],
 orderBys: [{ metric: { metricName: "screenPageViews" }, desc: true }],
 limit: 100,
 },
 });

 const rows = res.data.rows ?? [];
 const csv = [
 "Page path,Views,Avg engagement time (sec),Bounce rate",
 ...rows.map((r) => {
 const path = r.dimensionValues?.[0]?.value ?? "";
 const views = r.metricValues?.[0]?.value ?? "0";
 const time = parseFloat(r.metricValues?.[1]?.value ?? "0").toFixed(1);
 const bounce = (parseFloat(r.metricValues?.[2]?.value ?? "0") * 100).toFixed(1);
 return `"${path}",${views},${time},${bounce}%`;
 }),
 ].join("\n");

 writeFileSync(`${OUTPUT_DIR}/ga4-pages-latest.csv`, csv, "utf-8");
 console.log(`Pages: ${rows.length} rows`);
}

main();

name: Analytics Tracker
on:
 schedule:
 - cron: '01**1' # Every Monday
 workflow_dispatch:
permissions:
 contents: write
jobs:
 track:
 runs-on: ubuntu-latest
 steps:
 - uses: actions/checkout@v4
 - uses: actions/setup-node@v4
 with: { node-version: '20' }
 - run: npm ci || npm install
 - run: mkdir -p analytics-output
 - name: Search Console
 env:
 GOOGLE_SERVICE_ACCOUNT_JSON: ${{ secrets.GOOGLE_SERVICE_ACCOUNT_JSON }}
 SEARCH_CONSOLE_SITE_URL: https://your-site.com
 ANALYTICS_OUTPUT_DIR: ./analytics-output
 run: npx tsx search_console_tracker.ts
 - name: GA4
 env:
 GOOGLE_SERVICE_ACCOUNT_JSON: ${{ secrets.GOOGLE_SERVICE_ACCOUNT_JSON }}
 GA4_PROPERTY_ID: ${{ secrets.GA4_PROPERTY_ID }}
 ANALYTICS_OUTPUT_DIR: ./analytics-output
 run: npx tsx ga4_tracker.ts
 - run: |
 git config user.name "bot"
 git config user.email "bot@example.com"
 git add analytics-output/*.csv
 git diff --cached --quiet || git commit -m "data: update analytics"
 git push

npm install googleapis tsx