Google Sheets API Connection Test

Using Service Account Authentication

1. Configuration Check

Spreadsheet ID: ✓ Defined
Credentials Path: ✓ Defined
Credentials File: ✓ Found

2. PHP Extensions Check

OpenSSL: ✓ Loaded
cURL: ✓ Loaded

3. Testing Service Account Authentication

✓ Authentication successful! Access token obtained.

4. Testing Google Sheets Connection

Getting spreadsheet info...

✓ Connection successful!

Spreadsheet Title: Finance Dashboard Database
Service Account Email: finance-api@elite-caster-487006-f8.iam.gserviceaccount.com

⚠ Make sure your spreadsheet is shared with this email!

Available Sheets:

Settings
Master Akun
Pemasukan
Pengeluaran
Jurnal Umum
Akses

5. Testing Read Operation

Reading 'Settings' sheet...

✓ Read successful!

Data retrieved:

Array
(
    [0] => Array
        (
            [0] => periode_mulai
            [1] => periode_selesai
            [2] => nama_perusahaan
            [3] => alamat
        )

    [1] => Array
        (
            [0] => 2024-01-01
            [1] => 2024-12-31
            [2] => PT Maju Jaya
            [3] => Jakarta
        )

)

6. Test All API Endpoints

Dashboard - http://www.finance.sugaacademy.com//api/dashboard.php
Settings - http://www.finance.sugaacademy.com//api/settings.php
Master Accounts - http://www.finance.sugaacademy.com//api/master-accounts.php
Income - http://www.finance.sugaacademy.com//api/income.php
Expenses - http://www.finance.sugaacademy.com//api/expenses.php
Journal - http://www.finance.sugaacademy.com//api/journal.php
Ledger - http://www.finance.sugaacademy.com//api/ledger.php
Trial Balance - http://www.finance.sugaacademy.com//api/trial-balance.php
Income Statement - http://www.finance.sugaacademy.com//api/income-statement.php
Balance Sheet - http://www.finance.sugaacademy.com//api/balance-sheet.php

✓ All tests passed!

Your PHP backend is ready to use with Service Account authentication.

You can now connect it to your React frontend.