5 ms·

Show HN: Tweetsheets – Twitter directly from within Google Docs

160 points by andreasklinger 14y ago

andreasklinger 14y ago
posting on behalf of my colleague jollife[1] who can't publish on HN because his account is "too young"? Is there any way around this? [1]: http://news.ycombinator.org/user?id=jollife http://news.ycombinator.org/user?id=jollife
- polshaw 14y ago
  ..seems odd, i've seen many 'green' (representing new?) users with articles on the front page? Looking at the user-page, i can only assume it means 'too few points', since they have had an account for over 9 months? If anyone can shed any light on this, please go ahead.
- ColinWright 14y ago
  Can you provide more details about this? I've seen many people post when they've got completely fresh, newly minted accounts. Perhaps things have changed recently, but I wonder if there's something going on other than what you think. A proper report would be helpful.
- tgrass 14y ago
  Using the same computer? Try clearing cookies.
  - jollife 14y ago
    my account is 270 days old, i've 5 points. it's unfortunately not due to a computer/browser session :-(
- dfc 14y ago
  The TLD in news.ycombinator.org sticks out. Did he try news.ycombinator.com?
subnet 14y ago
crazy :)
ConstantineXVI 14y ago
Apps Script seems to be capable of quite a bit more than the name suggests. Wouldn't expect it to have a full UI toolkit and designer, hosted memcache, or SQL access[0]. (In the docs, Google seems to dance around ever calling the language "JavaScript" but I can't find any reason it wouldn't be. Anyone know anything on that?) [0] https://developers.google.com/apps-script/defaultservices https://developers.google.com/apps-script/defaultservices PS: naturally most of the "core" Apps services are exposed as well
- codeka 14y ago
  On the overview page(1) they explicitly call it "a JavaScript cloud scripting language". As far as I know, there's no practical difference between Apps Script and JavaScript (except one runs on the server and one runs in the browser). (1): https://developers.google.com/apps-script/overview https://developers.google.com/apps-script/overview
jnazario 14y ago
hilarity, and thanks for showing me that apps script is worth looking at.
losethos 14y ago
God says... C:\Text\WALDEN.TXT ay & Co. have put animals to their best use, for they are all beasts of burden, in a sense, made to carry some portion of our thoughts. The mice which haunted my house were not the common ones, which are said to have been introduced into the country, but a wild native kind not found in the village. I sent one to a distinguished naturalist, and it interested him much. When I was building, one of these had its nest underneath the house, and before I had laid the second floor, and swept out the
darkstalker 14y ago
Didn't know that a google document could connect to internet services, very nice.
dotBen 14y ago
Here's another awesome Google Doc in this area: A Google Spreadsheet that will harvest all tweets containing a given search string. The code is interesting, and I had no idea Google Docs had the equivalent of CRON: http://mashe.hawksey.info/2012/01/twitter-archive-tagsv3/ http://mashe.hawksey.info/2012/01/twitter-archive-tagsv3/
vj44 14y ago
Or you can do the same right from MS Excel (in Python) using DataNitro: http://mit.edu/~victorj/www/blog/2012/08/06/Twitter-reader-in-Excel-with-Python-and-DataNitro/ http://mit.edu/~victorj/www/blog/2012/08/06/Twitter-reader-i...
sit12 14y ago
I dont get the "authorize" option in Run. It just says "running my function." Am I missing something?
- jollife 14y ago
  have you tried saving the code first? it looks like you're running "myfunction", because google spreadsheets don't know the copy/pasted functions ...
nollidge 14y ago
Are Apps scripts run in browser or on the server? Because this could be used as a Twitter proxy for anyone whose network filters for Twitter.com but not docs.google.com. Or, for that matter, data from any other blocked website... EDIT: wording
- jollife 14y ago
  it's directly run on the google servers.
nmcfarl 14y ago
We use a Google Spreadsheet as a buffer for our tweets at work, hacking the ’sheet to post would be an awesome addition - and not one I’d’ve ever thought of. This is a cool hack - and one that will make my co-workers lives a bit simpler.

160 points by andreasklinger 14y ago

posting on behalf of my colleague jollife[1] who can't publish on HN because his account is "too young"? Is there any way around this? [1]: http://news.ycombinator.org/user?id=jollife http://news.ycombinator.org/user?id=jollife

polshaw 14y ago
..seems odd, i've seen many 'green' (representing new?) users with articles on the front page? Looking at the user-page, i can only assume it means 'too few points', since they have had an account for over 9 months? If anyone can shed any light on this, please go ahead.
ColinWright 14y ago
Can you provide more details about this? I've seen many people post when they've got completely fresh, newly minted accounts. Perhaps things have changed recently, but I wonder if there's something going on other than what you think. A proper report would be helpful.
tgrass 14y ago
Using the same computer? Try clearing cookies.
- jollife 14y ago
  my account is 270 days old, i've 5 points. it's unfortunately not due to a computer/browser session :-(
dfc 14y ago
The TLD in news.ycombinator.org sticks out. Did he try news.ycombinator.com?

subnet 14y ago

crazy :)

ConstantineXVI 14y ago

Apps Script seems to be capable of quite a bit more than the name suggests. Wouldn't expect it to have a full UI toolkit and designer, hosted memcache, or SQL access[0]. (In the docs, Google seems to dance around ever calling the language "JavaScript" but I can't find any reason it wouldn't be. Anyone know anything on that?) [0] https://developers.google.com/apps-script/defaultservices https://developers.google.com/apps-script/defaultservices PS: naturally most of the "core" Apps services are exposed as well

codeka 14y ago
On the overview page(1) they explicitly call it "a JavaScript cloud scripting language". As far as I know, there's no practical difference between Apps Script and JavaScript (except one runs on the server and one runs in the browser). (1): https://developers.google.com/apps-script/overview https://developers.google.com/apps-script/overview

jnazario 14y ago

hilarity, and thanks for showing me that apps script is worth looking at.

losethos 14y ago

God says... C:\Text\WALDEN.TXT ay & Co. have put animals to their best use, for they are all beasts of burden, in a sense, made to carry some portion of our thoughts. The mice which haunted my house were not the common ones, which are said to have been introduced into the country, but a wild native kind not found in the village. I sent one to a distinguished naturalist, and it interested him much. When I was building, one of these had its nest underneath the house, and before I had laid the second floor, and swept out the

darkstalker 14y ago

Didn't know that a google document could connect to internet services, very nice.

dotBen 14y ago

Here's another awesome Google Doc in this area: A Google Spreadsheet that will harvest all tweets containing a given search string. The code is interesting, and I had no idea Google Docs had the equivalent of CRON: http://mashe.hawksey.info/2012/01/twitter-archive-tagsv3/ http://mashe.hawksey.info/2012/01/twitter-archive-tagsv3/

vj44 14y ago

Or you can do the same right from MS Excel (in Python) using DataNitro: http://mit.edu/~victorj/www/blog/2012/08/06/Twitter-reader-in-Excel-with-Python-and-DataNitro/ http://mit.edu/~victorj/www/blog/2012/08/06/Twitter-reader-i...

sit12 14y ago

I dont get the "authorize" option in Run. It just says "running my function." Am I missing something?

jollife 14y ago
have you tried saving the code first? it looks like you're running "myfunction", because google spreadsheets don't know the copy/pasted functions ...

nollidge 14y ago

Are Apps scripts run in browser or on the server? Because this could be used as a Twitter proxy for anyone whose network filters for Twitter.com but not docs.google.com. Or, for that matter, data from any other blocked website... EDIT: wording

jollife 14y ago
it's directly run on the google servers.

nmcfarl 14y ago

We use a Google Spreadsheet as a buffer for our tweets at work, hacking the ’sheet to post would be an awesome addition - and not one I’d’ve ever thought of. This is a cool hack - and one that will make my co-workers lives a bit simpler.