Read a Google Sheet in Laravel

How do you read a Google Sheet in Laravel?

Point Http::get() at a JSON endpoint backed by the sheet and cache the response. That is the entire integration — no google/apiclient, no service-account JSON in your repo, no Cloud project to keep alive.

The Google client library is the right call if you need to write to the sheet. For reading content, config, or listings into a Laravel app, it is a lot of machinery for a GET.

The whole integration

Connect the sheet to PasteSheet, then read it like any other JSON API:

use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\Http;

public function active(): array
{
    return Cache::remember('listings', now()->addMinutes(5), fn () => Http::get(
        'https://pastesheet.com/api/your-endpoint-id',
        ['status' => 'active', 'sort' => '-created', 'limit' => 100],
    )->json('data'));
}

Why cache twice?

You do not have to — PasteSheet already caches, so the endpoint is fast on its own. A short local cache simply saves the network hop when the same page renders repeatedly, which matters more on a busy route than on a cron job.

The values arrive typed. Because the column schema is inferred when the sheet is connected, a number comes back as a number and a date as a date — not the strings a CSV export would give you.

What it costs

MCP is included on the Free plan. Connect any public endpoint over MCP with no Google Cloud project and no credit card. Private endpoints and the account-wide workspace server need a paid plan (from Starter ($9/mo)) for the keys and OAuth they authenticate with.

Pro adds full-text search and aggregation (count, sum, avg, group_by) that your AI agent can call through query_rows.

Frequently asked questions

Sources

• Authorize requests — Google Sheets API — Google
• Usage limits — Google Sheets API — Google

Related guides