Hi, Chris.

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

I am sorry to disappoint you, but something like this use-case you described is probably not possible in any way,

or maybe if it is, you would need a high level of a custom SQL Query to achieve pulling the data you need.

In regards to then pushing this data to a Google Spreadsheet,

and to have it editable while the same data outputs to a Spreadsheet/ and be synchronized "both ways",

that will not be possible with our current plugin's capabilities.

You can always try to go for a custom solution, but custom work is not possible from our support or our developers.

-

We will explain more about how the data is saved, etc, just to try and clarify in more details.

-How are the tables saved , and what is the format :

• These datatables which are linked to an existing source data, such as Google Spreadsheets/Csv/Excel and others,

are not saved in the database like manual tables with their own columns and rows,

 but instead, their data and settings is stored in database table wp_wpdatatables_rows. 

( wp_ is the default WordPress DB Table prefix, on your site it might be a different prefix)

So, pulling data from the database to get data like this is a very complex because this database table stores data in JSON format, not like manual tables (columns * rows).

Then, if you pull the data you need, 

after that you would have to unserialize the JSON data.

This falls under advanced MySQL, and unfortunately, it will not be covered by our support.

You will have to search for solutions, for example, such as this one from Stack Overflow, i hope it helps.

-

On the other hand,

 If you import the file, the plugin reads the source file and creates a manual table. 

Once the table is created, it is no longer linked to the source file, so changing data in the table will not show up in Excel or Google Spreadsheet, and vice-versa. 

To modify this table, you can edit it right away,  or switch to the Excel-like view, 

and then select and copy the range of cells you want to paste from the source file, and paste it in the Excel-like view, 

or you can import a new/edited CSV to update the table, as well, in the following ways :

• Update manual tables: Replace data within an existing table.
• Update manual tables: Add data to an existing table.
•  Update manual tables: Replace the entire table with new data.

-

You can also make SQL Queries from this data, because each Manual Table has its own columns and rows in the database table.

-Would I be able to make Google sheets query the data from my table :

As far as we are aware, we do not have any solution to achieve this,

it is not possible with our built-in/native options.

At this time, we don't have any built-in solution to achieve this, but you can suggest it to our developers - they will do their best to make a solution in the future.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

-

If you have coding skills and wish to try to make a custom solution now,

you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.

Please be advised that custom solutions with hooks are not included in our support.

You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.

( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)