🔍 Business Card System - API Diagnostic Tool

Test your Google Sheets API configuration and diagnose 403 errors

⚠️ Before running tests: Make sure you've followed the setup guide and configured your Google Cloud project with Google Sheets API enabled.

Step 1: Enter Your Configuration

Google Sheet ID

From your sheet URL: docs.google.com/spreadsheets/d/[THIS_PART]/edit

Google API Key

From Google Cloud Console → APIs & Services → Credentials

Sheet Name (Tab Name)

The name of the tab in your spreadsheet (usually "Sheet1")

Pre-Flight Checklist

Google Sheets API is enabled in Google Cloud Console
API key exists and is copied correctly (no extra spaces)
API key restrictions include "Google Sheets API"
Google Sheet is shared as "Anyone with the link can view"
Google Sheet is published to web (File → Share → Publish to web)
Sheet has data in it (at least headers in row 1)
Waited 5 minutes after making API key changes

Quick Fixes for Common Issues

403 Forbidden Error:

Check API key restrictions in Google Cloud Console
Set "Application restrictions" to "None" (for testing)
Make sure only "Google Sheets API" is checked under API restrictions
Verify Google Sheet is public ("Anyone with link can view")
Make sure sheet is published to web

404 Not Found Error:

Double-check Sheet ID is correct
Verify sheet name matches exactly (case-sensitive)

CORS Error:

Use a local web server instead of opening file directly
Deploy to actual hosting (GitHub Pages, Netlify, etc.)