Hi Shane

Thank you for reaching out to us.

Can you please give us some more details about the issue, do you have any error messages or any other indications the tables are broken? Can you provide us some screenshots or a screen recording or better yet please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

Hi Shane and Satwik,

Can you pelase tell me are your Google spreadsheets published and shared like is explained in our docs?

Best regards.

Hi Satwik,

Sorry for inconvenience,

Yes we improved logic with old method for getting data from Google spreadsheets(no more caching issues- when you change data in Google sheet it will be reflected in wpDataTables after refresh or page load)

This option requires to sheets be SHARED (in your sheet File -> Shared-> Shared with others or you need to click on the button Share from the top right corner of your sheet.) and then in Shared popup on Get link section to change status to Anyone with the link. 

Google team change they sheets logic without shared information about that, like before 6 months they release update that requires to sheets need to be Published and Shared to be able to access it as you can check in our docs https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/#create_the_table

After that they revert those changes and you are able to access sheets only after publish that sheet.

So you can go and Share that sheet like is explained or if you have a lot of sheets then you can change code in our plugin in file wp-content/plugins/wpdatatables/source/class.wdttools.php around line 402

you will find this 

$csv_url = "https://docs.google.com/spreadsheets/d/{$spreadsheet_key}/export?format=csv&id={$spreadsheet_key}";

and you have to replace with this

$csv_url = "https://docs.google.com/spreadsheets/d/{$spreadsheet_key}/pub?hl=en_US&hl=en_US&single=true&output=csv";

We are working on solution for all cases to use old method and new one as well and we will try to be as soon as possible to release a new version with that.

Yes you can set to grab data over Service API but at the moment there is a quota limit. It's limited to 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user.

https://developers.google.com/sheets/api/limits

That quota can be increased, but that requires an additional charge in Google (increasing the quota is not free).

Thank you for understanding.

Best regards.

Hi Satwik,

It is released 3.7.1 version with fix for this issue.

Best regards.

Hi Satwik,

Yes that is enough for now. (Google allow that now- before 6 months ago it was forbidden, so users need to share it as well)

In next update we will implement new option Instant data update  from Google sheet with which you will not have cache issues(updated data from Google sheet will be instantly after refresh or page load on front).

Users still be able to use option like now and this new one with instant update which will be optional and this option will requires that sheet need to be shared. Everything will be covered with notices and popup modal instructions in plugin itself what user need to do to set this up and also with instructions in our docs.

Best regards.

Hi Shane,

Yes it is explain in one of previous tickets  Google Sheets API has a quota limit. It's limited to 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user.

https://developers.google.com/sheets/api/limits

That quota can be increased, but that requires an additional charge in Google (increasing the quota is not free). Another way would be to use the old method without the API and it is released new version with fix for not showing tables.

This issue with API limit is not related with latest update, because it is not change anything about that logic and limitation of using free Google Sheet API has always present.

Best regards