Title: Auto Update issue Last modified: November 18, 2020 --- # Auto Update issue * Resolved [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/) * I have various tables set to auto update from Google sheets – all of which have been working fine. * Suddenly however there are a load that are not pulling through the correct data and instead a load of code and mess. * The links are correct and the Google sheet is fine – any ideas? * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fauto-update-issue-3%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 15 replies - 1 through 15 (of 18 total) 1 [2](https://wordpress.org/support/topic/auto-update-issue-3/page/2/?output_format=md) [→](https://wordpress.org/support/topic/auto-update-issue-3/page/2/?output_format=md) * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13676440) * Further to this – I have tried to manually import the CSV and that doesnt work either * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13677125) * Hi, * thanks for your post, and sorry for the trouble. * If you are seeing a lot of “code and mess” imported, the links are not fully correct, unfortunately. * Please see [https://wordpress.org/support/topic/google-sheets-import-adds-extra-columns-and-rows/#post-12336102](https://wordpress.org/support/topic/google-sheets-import-adds-extra-columns-and-rows/#post-12336102) for more information on how the URL is supposed to look like. * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13677556) * Hi Tobias * That’s what I don’t understand – the link to the CSV file is the same as it has always been but overnight there were numerous ones that stopped working. I have used the CSV link to download a spreadsheet and manually uploaded it and it was fine, but as soon as the update ran using the same link, the spreadsheet went wrong again on the site. * I even disabled the auto update plugin and then set a few up again and the issue persists. * The example above for example was coming from [https://docs.google.com/spreadsheets/d/e/2PACX-1vRIXtBjdlLvIGnaKZMv-CtL75ErqAQM_w87Op_jn54qB3Thl0Vf3wRqyJWRNovDbuINMe0yRP2q9RMC/pub?output=csv](https://docs.google.com/spreadsheets/d/e/2PACX-1vRIXtBjdlLvIGnaKZMv-CtL75ErqAQM_w87Op_jn54qB3Thl0Vf3wRqyJWRNovDbuINMe0yRP2q9RMC/pub?output=csv) on the auto update * If I use this URL to try and import and replace the corrupted file, it won’t work – but if I put the URL into a browser and download the file, then upload it, it does. - This reply was modified 5 years, 5 months ago by [matts82](https://wordpress.org/support/users/matts82/). - This reply was modified 5 years, 5 months ago by [matts82](https://wordpress.org/support/users/matts82/). * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13678012) * Hi, * it looks like this URL will only return the CSV file to logged-in users, i.e. it’s not a public sharing link. To verify that, please try that URL in a “private”/” incognito” browsing tab: You will be asked to log in. The URL must however directly return the CSV file, without asking to log in. * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13678065) * Ok – have you got any idea why this has suddenly stopped working as like I said, the same URL has been used for way over 12 months without an issue? I’m unsure how I get the link without the requirement for someone to sign in – are you able to advise? * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13678077) * I have 280 spreadsheets linked to the site so as you can appreciate, am looking for the quickest and easiest way to get them all back online! * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13678202) * Hi, * wait, I just checked the link again, and it’s now working for me… It is directly returning a CSV file. Can you please try the manual import from that URL again? * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13678345) * I unpublished the file in Google sheets and then republished it but it gave me the same CSV link to use – I tried that and it worked * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13678369) * I also amended the privacy to people can view the file with a link rather than restricted which might also have helped. I’ll try it with the others in a while and see but hope that might have answered the issue. * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13678374) * Hi, * great! That’s good to hear! I can therefore only assume that something in the Google sharing settings must have changed… * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13678437) * It appears that way. Three that were ‘corrupted’ have been changed on Google to be visible to view rather than private and have updated without issue, so touch wood that has resolved it. Google must have changed something their end. * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13678536) * Hi, * yes, sure sounds like it :-/ * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13678579) * Thanks for your help – and also creating the one plug in that actually serves my needs when it comes to keeping my site online… * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13678594) * Hi, * no problem, you are very welcome! 🙂 Good to hear that this helped! * Best wishes, Tobias * P.S.: In case you haven’t, please [rate TablePress](https://wordpress.org/support/plugin/tablepress/reviews/#new-post) here in the plugin directory. Thanks! * [stockuper](https://wordpress.org/support/users/stockuper/) * (@stockuper) * [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/#post-13679233) * I came here with the same problem and you already solved it. Thank you! It remains“ a little” to open access to 500 Google files ))) - This reply was modified 5 years, 5 months ago by [stockuper](https://wordpress.org/support/users/stockuper/). Viewing 15 replies - 1 through 15 (of 18 total) 1 [2](https://wordpress.org/support/topic/auto-update-issue-3/page/2/?output_format=md) [→](https://wordpress.org/support/topic/auto-update-issue-3/page/2/?output_format=md) The topic ‘Auto Update issue’ is closed to new replies. * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944) * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/) * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq) * [Support Threads](https://wordpress.org/support/plugin/tablepress/) * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/) * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/) * 18 replies * 3 participants * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * Last activity: [5 years, 5 months ago](https://wordpress.org/support/topic/auto-update-issue-3/page/2/#post-13681635) * Status: resolved