Download the PHP package sectsect/google-spreadsheet-to-db without Composer
On this page you can find all versions of the php package sectsect/google-spreadsheet-to-db. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package google-spreadsheet-to-db
Google Spreadsheet to DB
The "Google Spreadsheet to DB" plugin is designed for WordPress and facilitates the import of data from Google Sheets into a WordPress database using Google's Sheets API (v4). It supports data manipulation before saving and is configurable via a WordPress admin interface.
Features
- Data Import: Pulls data from Google Sheets and saves it directly into the WordPress database.
- Customization: Offers settings for defining constants, spreadsheet IDs, names, and configuring data formats.
- Admin Interface: Provides an admin page for easy management and configuration of the plugin settings.
Requirements
- PHP version 8.0 or higher.
- Composer for managing PHP dependencies.
Get Started
1. Clone this Repo into your wp-content/plugins directory.
2. Remove vendor/ in .gitignore file.
3. Install composer packages
4. Activate the plugin through the 'Plugins' menu in WordPress.
Settings
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 Sheets API.
- Create credentials for a Web Server to access Application Data.
- Name the service account and grant it a Project Role of Editor.
- Download the JSON file.
- Copy the JSON file to your app directory and rename it to
client_secret.json - :warning: Set
client_secret.jsonin a location to deny web access on your server.
We now have a big chunk of authentication information, including what Google calls a client_email, which uniquely represents this OAuth service account.
Grab the value of client_email from your client_secret.json, and head back to your spreadsheet. Click the Share button in the top right, and paste the client_email value into the field to give it edit rights.
Hit send. That’s it! :ok_hand:
-
Set the
define()constants for client_secret.json inwp-config.php. - Go to
Settings->Google Spreadsheet to DBon your WordPress Admin-Panel. - Set the following values and save it once.
- Data format to be stored in database
- json_encode
- json_encode (JSON_UNESCAPED_UNICODE)
- Click the
Import from Google Spreadsheetbutton. :tada:- Spreadsheet ID
- Spreadsheet name (Optional)
- Single Sheet name
- Top Header Row
- Title (Optional)
Filters
Filtering the Array
You can edit the array got from Google API with add_filter( 'google_ss2db_before_save', $function_to_add ) in your functions.php before saving to database.
And also use add_filter('google_ss2db_after_save', $return_array ) to perform any processing with the return value.
APIs
Parameters
| Parameter | Type | Notes | Default Value | ||
|---|---|---|---|---|---|
| where | array | array() |
|||
| relation | string | AND or OR |
AND |
||
| [array] | array | ||||
| key | string | id or date or worksheet_id or worksheet_name or sheet_name or title |
false |
||
| value | int | e.g. 3 / 2020-09-01 12:00:00 |
false |
||
| compare | string | e.g. = > < >= <= <> != |
= |
||
| orderby | string | id or date or worksheet_id or worksheet_name or sheet_name or title |
date |
||
| order | string | DESC or ASC |
DESC |
||
| limit | int | number of row to get | All Data :memo: You can also use -1 to get all data. |
||
| offset | int | number of row to displace or pass over | 0 |
Usage Example
Get all rows
Get 3 rows from the 4th in ascending order by ID
Get the row with specific ID
Get 3 rows with specific Worksheet ordered by ID
Get the rows larger than or equal the specified datetime
Get the rows with multiple conditions
Notes
- Tested on WordPress v6.3.1
For Developers
- This plugin saves Spreadsheet's data to the global area, not to each post. If you want to have Spredsheet data for individual posts, you can link data
IDwith custom fields. -
The data is added and stored in the
wp_google_ss2dbtable as a JSON-encoded array.id date worksheet_id worksheet_name sheet_name title value 1 2021-08-27 00:00:00 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms My Spreadsheet Sheet1 Data-01 {"area":{"a":["brooklyn","bronx","Queens","Manhattan"],"b":["brooklyn","bronx","Queens","Manhattan"]}} - This Plugin does not hosting on the wordpress.org repo in order to prevent a flood of support requests from wide audience.
Troubleshooting
This plugin depends on Guzzle v7, which may conflict with other WordPress plugins or Composer packages using Guzzle v6.
If you encounter errors like:
Uncaught Error: Call to undefined method GuzzleHttp\Utils::chooseHandler()
This is likely due to a Guzzle version conflict. To resolve:
- Update other plugins/packages to versions compatible with Guzzle v7
- Find alternative solutions that don't conflict with this plugin's dependencies
Change log
See CHANGELOG file.
License
See LICENSE file.
✌️
A little project by @sectsect
