search

benborgers / opensheet

💾 An API to get a Google Sheet as JSON, no authentication required.
https://opensheet.elk.sh
MIT License
632 stars 121 forks source link

Bug: Unable to parse range #18

Closed MarketingPip closed 2 years ago

MarketingPip commented 2 years ago

Facing issues when grabbing data when using other sheet's besides the test sheet.

Unable to parse range.

benborgers commented 2 years ago

Strange! Could you paste a URL where you're getting this error?

MarketingPip commented 2 years ago

More than happy too! Thank you too for the fast reply - maybe too if lucky I can pick your brain with something non related to this repo. (if willing obviously - let me know & I will add you to separate repo to ask ie; JS help related)

Spreadsheet to try

benborgers commented 2 years ago

Sure! Wanna send me an email about the other thing? benborgers@hey.com

It looks like the spreadsheet isn't shared -- could you by chance open up link sharing?

MarketingPip commented 2 years ago

You are the best! Thank you! You can expect a email NOW!

Here is the updated spreadsheet link (was public before - don't know what happened lol)

& to make your life easier here is the opensheet URL with error.

benborgers commented 2 years ago

Ah! The last part of the URL should be the name of the tab, which in your case is “Form Responses 1”. Here’s the correct URL to use: https://opensheet.elk.sh/1GpUteMOS41K7c3pj7b77xF4F-7PTKZyfPK4FVQr8SVc/Form+Responses+1

Sorry about that! The error message is a bit cryptic.

MarketingPip commented 2 years ago

Thank you! I'd add this to documentation obviously for other users (assuming you're on it already😉)

And no sorry needed at all! Thank you again!