Repository files navigation

• 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.

• PHP version 8.0 or higher.
• Composer for managing PHP dependencies.

cd /path-to-your/wp-content/plugins/git clone git@github.com:sectsect/google-spreadsheet-to-db.git

cd google-spreadsheet-to-dbnano .gitignore

- vendor/

cd functions/composer/composer install

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.

1. Go to theGoogle APIs Console.
2. Create a new project.
3. Click Enable API. Search for and enable the Google Sheets API.
4. Create credentials for a Web Server to access Application Data.
5. Name the service account and grant it a Project Role of Editor.
6. Download the JSON file.
7. Copy the JSON file to your app directory and rename it toclient_secret.json
8. ⚠️ Setclient_secret.json in a location to deny web access on your server.

We now have a big chunk of authentication information, including what Google calls aclient_email, which uniquely represents this OAuth service account.
Grab the value ofclient_email from yourclient_secret.json, and head back to your spreadsheet. Click the Share button in the top right, and paste theclient_email value into the field to give it edit rights.
Hit send. That’s it! 👌

1. Set thedefine() constants for client_secret.json inwp-config.php.

define('GOOGLE_SS2DB_CLIENT_SECRET_PATH','/path/to/your/client_secret.json' );

2. Go toSettings ->Google Spreadsheet to DB on your WordPress Admin-Panel.
3. Set the following values and save it once.

• Data format to be stored in database
  • json_encode
  • json_encode (JSON_UNESCAPED_UNICODE)

4. Click theImport from Google Spreadsheet button. 🎉

• Spreadsheet ID
• Spreadsheet name (Optional)
• Single Sheet name
• Top Header Row
• Title (Optional)

You can edit the array got from Google API withadd_filter( 'google_ss2db_before_save', $function_to_add ) in your functions.php before saving to database.

add_filter('google_ss2db_before_save',function ($row,$worksheet_id,$worksheet_name,$sheet_name ) {// Exampleif ($worksheet_name ==='My Spreadsheet' &&$sheet_name ==='Sheet1' ) {// Do something.return$something;  }return$row;},10,3 );

And also useadd_filter('google_ss2db_after_save', $return_array ) to perform any processing with the return value.

add_filter('google_ss2db_after_save',function ($data ) {if ('My Spreadsheet' ===$data['worksheet_name'] ) {// $id              = $data['id'];// $date            = $data['date'];// $title           = $data['title'];// $value           = $data['value'];// $work_sheet_id   = $data['worksheet_id'];// $work_sheet_name = $data['worksheet_name'];// $sheet_name      = $data['sheet_name'];// $result          = $data['result']; // `int|false` The number of rows inserted, or false on error.// Examplemy_callback($data );  }});

newGoogle_Spreadsheet_To_DB_Query();

$sheet =newGoogle_Spreadsheet_To_DB_Query();$rows  =$sheet->getrow();foreach ($rowsas$row ) {$id   =$row->id;$date =$row->date;$val  =json_decode($row->value );}

$args =array('orderby' =>'id','order'   =>'ASC','limit'   =>3,'offset'  =>3,);$sheet =newGoogle_Spreadsheet_To_DB_Query($args );$rows  =$sheet->getrow();foreach ($rowsas$row ) {$id   =$row->id;$date =$row->date;$val  =json_decode($row->value );}

$args =array('where' =>array(array('key'   =>'id','value' =>3,    )  ),);

$args =array('orderby' =>'id','order'   =>'ASC','limit'   =>3,'where'   =>array(array('key'     =>'worksheet_name','value'   =>'My Spreadsheet','compare' =>'='    ),  ),);

$args =array('where' =>array(array('key'     =>'date','value'   =>'2020-08-01 12:34:56','compare' =>'>=',    )  ),);

$args =array('orderby' =>'id','order'   =>'DESC','limit'   =>10,'offset'  =>10,'where'   =>array('relation' =>'AND',// or 'OR'array('key'     =>'date','value'   =>'2020-08-01 12:34:56','compare' =>'>='    ),array('key'     =>'worksheet_name','value'   =>'My Spreadsheet','compare' =>'='    ),  ),);

• Tested on WordPress v6.3.1

• 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 dataID with custom fields.

• The data is added and stored in thewp_google_ss2db table 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 thewordpress.org repo in order to prevent a flood of support requests from wide audience.

To enable debug mode, add the following constant to yourwp-config.php:

define('GOOGLE_SS2DB_DEBUG',true );

When debug mode is enabled, importing a spreadsheet will return a detailed JSON response instead of the usual redirect. The response includes the following information:

• result: A boolean indicating the success or failure of the process
• data: Details of the saved data
• post_data: Sanitized post data
• referer: The redirect URL

Note: Always setGOOGLE_SS2DB_DEBUG tofalse or remove the constant in production environments.

This plugin depends onGuzzlev7, which may conflict with other WordPress plugins or Composer packages using Guzzlev6.
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:

1. Update other plugins/packages to versions compatible with Guzzle v7
2. Find alternative solutions that don't conflict with this plugin's dependencies

SeeCHANGELOG file.

SeeLICENSE file.

✌️

_{^{A little project by@sectsect}}