I have a data table that is connected to a google sheet. It was working fine and then all of a sudden i am getting this error. "wpDataTables was unable to access data. Unauthorized access. Please make file accessible." Both on the front end and on the back end. I cannot even edit the table settings to point it to a local table. I am dead in the water and need some help. My google access has not changed. The table is published and shared.
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.
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.
I have a data table that is connected to a google sheet. It was working fine and then all of a sudden i am getting this error. "wpDataTables was unable to access data. Unauthorized access. Please make file accessible." Both on the front end and on the back end. I cannot even edit the table settings to point it to a local table. I am dead in the water and need some help. My google access has not changed. The table is published and shared.
Hello,
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.
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