Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Google Spreadsheets and Python

twilio.com

Post reply on HN
Print view View original

141–143 of 143 posts

Re: Google Spreadsheets and Python

#141

Post by goblin89 »

Lightbody wrote: post #50

I love Google Sheets. It is so much more powerful than 99.9% of the users appreciate. Here is how I use it at my day job as head of PM at New Relic: - Fetch deals closed and lost hourly from Salesforce - Fetch for each of our 14k+ paid accounts usage metrics using our Insights product - Pull both items into a nice color-coded business dashboard that is near realtime - Send said dashboard out as a PDF to a bunch of st…

There’s also a newer thing called Google Data Studio, which creates neat visualizations directly from Sheets with even less effort.

It’s a no-brainer to feed all sorts of metrics (business or otherwise) from let’s say a Django app into Sheets, and with Data Studio decision makers can have all the freedom to combine them into complicated dashboards in accordance with current business landscape, pinging engineers only if new things need to be tracked.

Re: Google Spreadsheets and Python

#142

Post by victorhooi »

rebootthesystem wrote: post #139
victorhooi wrote: post #136

Earlier quoted context omitted.

I believe you're referring her to Adwords clickfraud - is that right? I don't work on that team, so can't comment on their policies (and even if I did, I probably can't comment publicly). However, my understanding is normally AdWords accounts are suspended for billing/fraud related reasons (e.g. you don't pay your bills) - e.g.: https://support.google.com/adwords/answer/2375414?hl=en-AU If you AdWords account does ge…

You are confusing your own products. AdSense. Not AdWords. The various forms Google makes available for appealing suspensions are pretty much useless. I urge you not to believe what I am saying here as well as not feeding within your own internal echo chamber. Use your own search product to search the 'net for the thousands of stories of various forms of algorithmic account suspensions, the damage they cause and how…

You ask for guarantees that an account will never be suspended, or that a service will never be discontinued.

I don't think that's even possible.

For one - abuse is a real thing.

Just ask Amazon about abuse and spam on their AWS platform. There is a reason that you can't just type in any credit card, and spin up 100 EC2 instances, or send 100,000 emails - depending on signals, Amazon seem to manually verify some accounts. But on top of that, they take proactive steps to suspend accounts acting in suspicious ways.

We do much the same.

It is a hard problem, and undoubtedly there are false positive and false negatives. That is regrettable - but I don't think allowing AWS or GCP to become a free haven for spammers or abusers is the answer.

You are correct that we need good procedures to deal with appeals of these things.

Regarding never deprecating a product - Google has started many products, and some of those have been shutdown. I know there's a lot of angst on HackerNews about Google Reader in particular - I myself used it a lot in fact. However, taking off my Google hat - of all companies, they are usually the best about letting you export your data, or migrate it away. When a product gets shutdown, you usually have 6 months, a year etc. to export your data. Even before I started there, they had Google Takeout which basically lets you export your data from any Google product in portable formats e.g. mbox, JSON files etc. Open standards are important to us - e.g. see our work on Kubernetes.

If there's a specific are you think we're failing on - please let me know, and I'll see if there's anything I am able to share, or if there's somebody I can link you up with.

Re: Google Spreadsheets and Python

#143

Post by alexjv89 »

gmisra wrote: post #38

I'm also a big fan of this approach, especially for sharing data responsibilities with non-technical colleagues. If you work in nodejs, the node-google-spreadsheet library is pretty good: https://www.npmjs.com/package/google-spreadsheet

thanks.. this is useful.. tried it out and perfectly matches my needs.
Post reply on HN