Hi Phillip,

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.

Thank you for understanding.

Best regards.

Hi Phillip,

It is released fix for this issue and will be available in version 3.7.1 when Envato approve update. 

Sorry for inconvenience,

Best regards..