Google Spreadsheets
Component ID
2899820
Component name
Google Spreadsheets
Component type
module
Maintenance status
Development status
Component security advisory coverage
not-covered
Component created
Component changed
Component body
Read Data from a Spreadsheet
Google API Authentication
Getting Real Data
Insert, Update, and Delete from a Spreadsheet
Updating Cells
Updating Rows
Deleting Rows
Getting Your Spreadsheet Ready for Programmatic Access
By default, a new spreadsheet cannot be accessed via Google’s API. We’ll need to go to your Google APIs console and create a new project and set it up to expose your Spreadsheets’ data.
- Go to the Google APIs Console.
- Create a new project.
- Click Enable API. Search for and enable the Google Drive API.
- Create credentials for a Web Server to access Application Data.
- Name the service account and grant it a Project Role of Editor.