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

Google Sheets Reports

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

★ 0stars

Install

Download source zip No release zip yet

This is the repository archive. It installs, but the folder name will carry the branch suffix and updates will not flow.

Install straight from GitHub with WP-CLI:

wp plugin install https://github.com/kamilkamieniarz/google-sheets-reports-wordpress/archive/refs/heads/main.zip
No built-in updater. New versions won't appear under Dashboard → Updates. Install new releases yourself, or let Git Updater track the repository.

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