WP Manifestindependent plugin directory
manifest / integrations / google-sheets-reports-wordpress

Google Sheets Reports

Secure Google OAuth2 + Sheets integration for daily & monthly reports.

by Kamil Kamieniarz · github.com/kamilkamieniarz/google-sheets-reports-wordpress

★ 0stars
0forks

Install

No release zip yet. The repository archive installs, but the folder name will carry the branch suffix and updates will not flow:

wp plugin install https://github.com/kamilkamieniarz/google-sheets-reports-wordpress/archive/refs/heads/main.zip
Readme github.com/kamilkamieniarz/google-sheets-reports-wordpress ↗

Secure Google OAuth2 + Sheets integration for daily & monthly reports — no hard-coded paths or domains.
Credentials and token are stored in WordPress options (paste JSON in wp-admin), OAuth callback via REST API.

Features

  • OAuth2 (Google) via REST: /wp-json/gsr/v1/oauth
  • Credentials & token in WP options (gsr_credentials_json, gsr_token_json)
  • Admin page (Tools → Google Sheets Reports): paste creds, set Spreadsheet ID & ranges
  • Manual run: Daily / Monthly
  • WP-Cron: daily & monthly jobs

Requirements

  • WordPress 6.0+
  • PHP 7.4+
  • (Optional) Composer google/apiclient available to autoload

Installation

  1. Copy google-sheets-reports/ into wp-content/plugins/.
  2. Activate Google Sheets Reports in WordPress.
  3. Tools → Google Sheets Reports:
    • Paste your credentials.json content and save.
    • Click Authorize with Google and finish OAuth.
    • Set Spreadsheet ID, Daily range (e.g. Daily!A1:Z), Monthly range (e.g. Monthly!A1:Z).
    • Click Run Daily Report or Run Monthly Report to test.

Customizing reports

Edit includes/class-gsr-reports.php:

  • Put your daily logic into run_daily() (build $rows).
  • Put your monthly logic into run_monthly() (build $rows).
  • Use append_rows($service, $sheetId, $range, $rows) to write to Sheets.

License

MIT