Respectfully, there is something different in your Google Sheet than in others; this is evidenced by the fact that your Sheet’s URL is different than the others I’ve seen before. Specifically, docs.google.com/spreadsheets/d/e/
has a e/
in there, and I don’t know what that means. If you look around, you’ll see no other Google Sheet URLs have this artifact.
So, either you have simply not set the settings you think you have, or there is something different about your Google Sheet or Google Account that makes your situation different.
I’ve never seen this e/
before, but the plugin is behaving as expected; it looks for the URL at https://docs.google.com/spreadsheets/d/e/2PACX-1vTART_VwhHUYsR22qVfoSsvQpSn6TC1QJxc-G3nvcU2f-7SI29E2iKLEwt08HlhNhI4vBra1SscOwEK/export?format=csv
which is exactly what it’s supposed to do. Google responds with a “No such file,” as you point out, which may mean Google simply doesn’t allow your Sheet to be accessed in the way the plugin needs, or it may mean Google has changed things around in such a way that this no longer works. I can’t find any notice of this on Google’s blogs, though, so I’m at a loss.
Further, the Google Docs Shortcode plugin does not actually read the data in your spreadsheet. That’s the point. As you undoubtedly know, it “works” by writing an <iframe>
into your page and loading the URL you give it in a new document. That’s fine, if that’s what you want. If it’s not, that plugin can hardly be said to be “working” in the way it seems like you mean.
Finally, on a personal note, in my country, today is a national holiday. You’re not paying me for my time and you’re not entitled to it, either. Yet here I am, looking into this issue you describe. I would appreciate it very much if you spoke to me with a bit more patience in the future. Thanks.