Several tables on our website have started showing this error message on page load:
"Error: wpDataTables was unable to access data. Unauthorized access. Please make file accessible."
These tables are supposed to pull data from Google Sheets, this was working properly yesterday, and I don't believe anything was changed. Some of the other tables on the website are configured the same way, and are still working properly.
Google has recently updated its security policies, affecting how Google Spreadsheets connect to third-party applications.
As a result, existing spreadsheets created before this change will continue to work without issues. However, newly created Google Sheets will encounter connection errors due to these updated security protocols.
For the newly created Google Sheets with wpDataTables, you’ll need to connect your Google API service account in the plugin settings/Google Spreadsheet API settings.
You can find detailed instructions on setting up a Google API service account here.
If you need to use private sheets, refer to this guide.
Once your Google API service account is added to our plugin, you won’t need to repeat this step, and all Google Sheets functionalities will work as before.
Several tables on our website have started showing this error message on page load:
"Error: wpDataTables was unable to access data. Unauthorized access. Please make file accessible."
These tables are supposed to pull data from Google Sheets, this was working properly yesterday, and I don't believe anything was changed. Some of the other tables on the website are configured the same way, and are still working properly.
Hello,
Apologies for all the waiting time.
Thank you for your patience.
Google has recently updated its security policies, affecting how Google Spreadsheets connect to third-party applications.
As a result, existing spreadsheets created before this change will continue to work without issues. However, newly created Google Sheets will encounter connection errors due to these updated security protocols.
For the newly created Google Sheets with wpDataTables, you’ll need to connect your Google API service account in the plugin settings/Google Spreadsheet API settings.
You can find detailed instructions on setting up a Google API service account here.
Once your Google API service account is added to our plugin, you won’t need to repeat this step, and all Google Sheets functionalities will work as before.
Let me know if you need further assistance!
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables