AI SummaryCopilot instructions for integrating Laravel with Google Sheets using service account authentication and Livewire 3. Helps Laravel developers quickly understand and implement real-time Google Sheets syncing in their projects.
Install
Copy this and paste it into Claude Code, Cursor, or any AI assistant:
I want to add the "google-sheets-project — Copilot Instructions" prompt rules to my project. Repository: https://github.com/invokable/google-sheets-project Please read the repo to find the rules/prompt file, then: 1. Download it to the correct location (.cursorrules, .windsurfrules, .github/prompts/, or project root — based on the file type) 2. If there's an existing rules file, merge the new rules in rather than overwriting 3. Confirm what was added
Description
Copilot Instructions for google-sheets-project
Overview
The Google Sheets Laravel Demo Project is a demonstration application that showcases real-time integration between Laravel and Google Sheets using service account authentication. This project serves as a practical example of how to build applications that can read from and write to Google Sheets using modern Laravel features. Target Users: Laravel developers learning Google Sheets integration, particularly those working with Livewire and modern Laravel stack. Key Features: • Laravel 12 Framework: Latest Laravel features with modern PHP 8.2+ support • Livewire 3 Integration: Real-time UI updates using standard Livewire components (not Volt) • Google Sheets API: Service account authentication for server-to-server communication • Flux UI Components: Modern, reactive user interface with Livewire Starter Kit • Real-time Data Sync: Form submissions instantly appear in both Google Sheets and the application Primary Use Cases: • Learning Google Sheets API integration patterns • Understanding service account authentication workflows • Building data collection applications with Google Sheets as backend • Creating real-time dashboards that sync with spreadsheet data
Copilot Environment Restrictions
⚠️ CRITICAL: Connections to Google APIs (such as www.googleapis.com) will fail in the Copilot environment due to firewall restrictions. • Google Sheets API calls will NOT work in the Copilot development environment • This includes any attempt to use php artisan serve with real Google API integration • The application will fail when trying to connect to Google's servers from within Copilot • Workaround: Use mock data or skip Google API-dependent code when developing in Copilot • Real API testing: Must be done in GitHub Actions, local development environments, or production Development Strategy in Copilot: • Focus on UI development and Livewire component logic • Use the existing mock patterns from the test suite (see tests/Feature/ExampleTest.php) • Work with static/dummy data instead of live Google Sheets data • Test API integration functionality via GitHub Actions or locally outside Copilot Note: The project already includes proper mock testing patterns that demonstrate how to work around API connectivity issues.
Project Structure
This Laravel 12 demo application uses a clean, modern architecture with the following key components:
Main Application Components
• app/Livewire/Sheets/Form.php - Handles the form for adding entries to Google Sheets • Validates user input (name and message fields) • Appends data to the configured Google Sheet • Dispatches events for real-time UI updates • app/Livewire/Sheets/Posts.php - Displays recent entries from Google Sheets • Retrieves and transforms spreadsheet data • Shows the latest 10 entries in reverse chronological order • Updates automatically when new posts are added
Discussion
Health Signals
My Fox Den
Community Rating
Sign in to rate this booster
Works With
Any AI assistant that accepts custom rules or system prompts