Spreadsheet not found

[jziggas]

sheetdown https://docs.google.com/spreadsheets/d/14w0RjGvFE8MUyYzSz1cpaxqz5CxmBrikiySxMVmCCrc/pubhtml --save

yields

[Error: Spreadsheet not found. Please double check your spreadsheet key is correct.]

Check the link for yourself, it's published. Any ideas?

[jlord]

When I go to the URL in a browser it says it's not found. Did you also change the share settings to "anyone with link can view"?

[jziggas]

Hmm weird. Yes I made it public and double checked the links in an incognito window, everything showed up fine. Here is the other link https://docs.google.com/spreadsheets/d/14w0RjGvFE8MUyYzSz1cpaxqz5CxmBrikiySxMVmCCrc/edit?usp=sharing

Screenshot: http://cl.ly/image/2v0H2j3F3g33

[jlord]

That URL worked for me, though it returned the header strangely and I had to delete a couple of new lines.

[jziggas]

You did this?

sheetdown https://docs.google.com/spreadsheets/d/14w0RjGvFE8MUyYzSz1cpaxqz5CxmBrikiySxMVmCCrc/edit?usp=sharing --save

It's still giving me an error. Thanks for trying it out. I'm going to stop for now and try again tomorrow.

[jlord]

Yep. Double check you have the latest version maybe? Hrmmm.

I get the same error too.

Sorry for bothering, but how can we at least research into this issue? Are there any ways to diagnose it to get more information?

[jlord]

@TheMineMech It's hard for me to figure out since it is working for me and I can't replicate the error and therefore help debug. (I've just pulled the latest from the repo onto my machine and tried the link mentioned above and it is still working for me)

You could clone the repo and add some logs and try to trace the error you may learn more. Typically the two things that can cause errors are not publishing the spreadsheet and/or not setting the sharing to 'everyone with the link can view'. Google used to cause problems with new and old spreadsheets, but those should be resolved now. Do you know if you're using a new or old spreadsheet?

I published it, but still get the same error. I was using new spreadsheet.

Well, I commented out

    if (response.statusCode.toString() === "404") {
      return callback(new Error("HI Spreadsheet not found.\n"
        + "Please double check your spreadsheet key is correct."))
    }

in makeTable.js, and it (obviously) worked fine.
I want to help by providing logs or debug results, but I don't know how to do it. Any headups would be very appreciated.
By the way, script doesn't process links in spreadsheet. It could be a nice feature.

[devinreams]

This may be a red herring but I was having this issue with a spreadsheet that I "Imported" to Google Drive (instead of simply creating a new one).

So, I created a new spreadsheet, copy/pasted the data from the "imported" one, changed my sharing settings to "Anyone with the link can view" and 🎉 it worked.

[jlord]

👋 Hi @devinreams!!!

Hrmm that's really interesting! Off the top of my head I'm not sure why that would be, but it's good to know!

If anyone wants to dump some more URLs in here of spreadsheets that don't work for them that would be helpful for me to test and debug with ✨

I'll also work on finding some failing ones this week and look into the status codes, too.