Link to plugin page: https://zeroqode.com/plugin/google-sheets-+-offline-1509350236406x505745806120976400
This API allows reading and writing data to google sheets of any authenticated user. Once user allowed access to their sheets the token will not get expired and will keep renewing automatically.
Google Sheets + Offline - Append Rows To a Sheet
Google Sheets + Offline - Update Row
Google Sheets + Offline - Clear Range of Values
Google Sheets + Offline - Delete Rows
Google Sheets + Offline - Delete Columns
Google Sheets + Offline - Insert Empty Row
Google Sheets + Offline - Insert Empty Column
Google Sheets + Offline - Read Sheet Values
For using the plugin you'll need to get the API credentials for Google Sheets. Go to https://console.developers.google.com and enable the Google Sheets API
After you've enabled the Google Sheets API, access the it by clicking
Manage where you'll create your credentials for the application.
Create Credentials to access the credentials creation API Key and App Secret
Note: OAuth authentication type is used in Plugin Demo setup.
After you've installed the plugin in app set your API keys from Google:
1. Create an authorization Event on your page for your Sheets.
2. Authorize your Google Sheets account and grant access.
3. Working with Google Sheets after authorization.
Use Read Sheets Value action to display a sheet on page:
Use Update Row action to update a row in a sheet with new values:
Use Append Rows To a Sheet action to append the rows in sheet with new values:
Use Delete Rows (for columns deletion use Delete Columns action) action to delete entire row of a sheet: