Tables created from Google Spreadsheet are not editable at this moment. If you need to have a data from it in your wpDataTables table and gave your users option to edit our plugin could be used for importing data from Google Spreadsheet into the MySQL and create editable table from it - Documentation
For testing purpose we have sandbox website where you can see and test all plugin functionalities
If I use Google Sheets as a data source, when the user edits/adds data to the wpDataTables table, does it update the Google Sheet source?
Hi Craig,
Thank you for your inquiry.
Tables created from Google Spreadsheet are not editable at this moment. If you need to have a data from it in your wpDataTables table and gave your users option to edit our plugin could be used for importing data from Google Spreadsheet into the MySQL and create editable table from it - Documentation
For testing purpose we have sandbox website where you can see and test all plugin functionalities
sandbox.wpdatatables.com
username: demo
password: demo