phpsheetsv4-nogcp

Introduction

A new way for accessing Google Sheets data , simple yet powerful .

Features

• Access Google Sheets data without GCP API Key
• No limits with G-suite account
• No extra environment needed
• Hiding data source
• Easy to configure
• Ready to use

Usage (Developing)

Prepare Google sheets

1. Publish to web as csv format
   

2. Copy sheets key
   

Applicate to PHP projects

1. Download phpsheetsv4-nogcp.php and place it into directory
   

2. Using the function
   

include 'phpsheetsv4-nogcp.php';
$lines = getSheets('links you get'); 

3. Use the returned data
   Using a foreach , we can print the data out and display it . Data will be returned as an array , with first column be [0] and second be [1] etc . First row will be deleted as reference row in excel . Learn more in /examples/index.php .

(Left : Google Sheet , Right : Webpage)

License

MIT

(C) 2022 ricehung29