Easy-to-use Free PHP Library for Google Spreadsheets Data API v3.0, latest and updated



  • Step-1) Download zip file and extract contents (2 files) to the same folder Click here to Download Files
  • Step-2) Modify the "sodso-google-spreadsheets-api-test.php" file and execute it to view results
  • This API library supports the following Spreadsheet functions:
  • 1) Backend Login to Google with ClientLogin Authentication with Emailid / Password
  • 2) Retrieving a list of Spreadsheets which have matching title / exact matching title / matching author / updated during certain timeline / with starting index / max number of results per page
  • 3) Retrieving a list of Worksheets within a Spreadsheet which have matching title / exact matching title
  • 4) Adding a new Worksheet to a Spreadsheet with Title / Rows / Columns
  • 5) Modifying a Worksheet with new Title / Rows / Columns
  • 6) Deleting a Worksheet within a Spreadsheet
  • 7) Retrieving a list of Rows with structured query on specific columns on specific values / full text search query / ordered by row position / ordered by specific column / with ordering in ascending or descending order / with starting index / max number of results per page
  • 8) Adding a new Row with column data
  • 9) Updating a Row with new column data
  • 10) Deleting a Specific Row
  • 11) Retrieving a list of Cells with full text search query / with or without empty cells / within range of cells / search within subset of cells / with starting index / max number of results per page
  • 12) Updating the contents of a Cell
  • 13) Updating multiple cells with a batch request









Leave your Comments here (Confidential & Visible only to Us)