Live data from Hacker News

Google Docs gets an API for task automation

techcrunch.com

191–199 of 199 posts

Re: Google Docs gets an API for task automation

#191

Earlier quoted context omitted.

> Ideally the IT department would take a step back, assess what the users (you the stakeholder) needs are, and provide the solutions. This approach was taken with Lotus Notes. The ivory tower decided who could create and control a database. All it does is throw up bureaucratic barriers people will work around. How much of your company is dependent on bespoke Excel databases? What better tools can you empower the empl…

@cosmie provides a good model for IT organization to quickly bring supportable solutions. The principles behind Agile is to reach across these barriers / towers. These Experts are the product owners / users, the developers, and also includes UX designers, operations team, security team, and capacity team. This is ideal but realistically challenging to pull off. A given Firm should also be providing a way for Shadow I…

It's deeply flattering that you read to the end of my rambling comment, let alone referenced it! :)

I happened to be exposed to that model at one of my first professional jobs, and it was such an incredibly effective and seemingly obvious organizational structure that I presumed it was normal. Every job I've had since then has just deepened my appreciation for the brilliance and skill of whatever executive team pulled that off, as I've realized just how rare it is.

Fascinatingly enough, the organizational structure of that giant, traditional company bore a striking resemblance to how a software architect would approach designing a modern SOA on a cloud platform. And when the same principles of an SOA were applied to the design of the organization itself, the same communication structures, advantages, and trade offs emerged.

Which makes sense. Organizations and software are incredibly similar systems, and the parallels between the two allow for pretty seamless transfer of principles, best practices, pitfalls, mental frameworks, optimization opportunities, and reference architectures between organizational design and software design. Which is probably one of the hidden strengths of tech founders and the companies they create, since they'll implicitly infuse their experience at software design into the way they design all aspects of their company, even if they don't recognize they're doing it. Which is a competitive advantage over traditional business leaders that likely only have exposure to standard organizational design practices/teachings.

Re: Google Docs gets an API for task automation

#192
post #189
post #143

Earlier quoted context omitted.

> this makes entering dates or modifying formulas in excel online near impossible. It would be so much easier, if the us finally stopped using this middle-endian date format. It's logically flawed and too prone for misinterpretation. Further the US is the only country in the world to insist on using it. yyyy-mm-dd or dd-mm-yyyy are both fine (I actually prefer the first, though my country uses the latter) and logical…

the dates issue is actually a little more confusing than you'd think because when entering the date online you need to enter it as dd/mm/yyyy but it will display as mm.dd.yyyy (did you catch that, they change the separator too). Re: formulas, they are all in german which means that unless I know the german equivalent word that microsoft chose, I can't make any modifications or even really write new formulas.

Actually Excel is smart here. It knows that Germany uses dots, but slashes are usually an indicator for the US. So you enter mm/dd/yyyy and it comes out as dd.mm.yyyy. (you see, you entered it flipped in your described experience). The easiest way for me is to enter it yyyy-mm-dd in a date formatted column and it will always catch the correct date.

I feel the pain with the function names. I know some in German and some in English, because I just switched to the native language at some point. But the translations are easily findable in the web [1] and there is even a built in function translator tool [2].

[1] https://www.excel-function-translation.com/index.php?page=en...

[2] https://support.office.com/en-us/article/excel-functions-tra...

Re: Google Docs gets an API for task automation

#193
post #135

Earlier quoted context omitted.

The comp I work for has half bought into the O365 thing. Most of us are on the semi-annual channel for desktop clients, a lucky few are on monthly no rhyme or reason. And bec HQ is in EU they've decided to localize all web stuff to german. this makes entering dates or modifying formulas in excel online near impossible. Also for some reason they've chosen to keep flow and teams off by default, I can activate the free…

Impossible? You mean efficient.

The reality of the German efficiency myth is actually just lots and lots of bureaucracy. something you'd never truly appreciate until you try living there (as a foreigner no less) for more than a few months... (my cousin explained it to me with what they call it. Papierkreig. Literally "Paper war")

Re: Google Docs gets an API for task automation

#195

It terrifies me how entrenched the Google suite is becoming, and more 'open' APIs will surely further that position. It's the default for most community / cross org collaboration and note-taking in my line of work. A huge amount of stuff gets done in Google docs. And then Google ban your account for some random reason and you're suddenly barred from participating, your voice can no longer be heard, and who knows what…

A business running GSuite getting banned would indeed be a disaster, but has this ever happened? For personal accounts, what happens if you create another account? It's also a big disruption, but "your voice can no longer be heard" seems exaggerated?

If you get banned for something by Google, and create another account, they just ban you again - Look at the state of the google play store

Re: Google Docs gets an API for task automation

#196
post #71
post #61

Great. Can we automate changing every single goddamn spreadsheet to not be in US date format? And while we're in there, how about adding a locale for New Zealand?

I suspect you have tried this, but if not, - visit https://myaccount.google.com/language - click on (re-choose) English - click on New Zealand as the 'sub-language' should set your locale across the board, rather than doing it on a per-sheet basis. If it doesn't work, as a Canadian, I empathize with your troubles and apologize.

Wow, that seems to have got closer, thank you. Spreadsheets are now created with Australian locale, although they have now lost their default timezone completely.

I'm interested whether this change will affect other Google products, in particular whether it messes up the operation of Google Assistant on my phone (possibly that can be overridden).

Cheers!

Re: Google Docs gets an API for task automation

#197
post #18

I do a lot of Office automation. It's nice to know that similar can now be done with Google Docs.

I found there to be a lot of demand in document automation especially in the real estate world. What's your experience been like, just wondering?

I've done it on and off for about 15 years. I've done some in the real estate world as well. My experience in a nutshell:

* You have to use server-side automation - which is unsupported, and probably even violates Microsoft's terms of use.

* It's tricky. I use a serialized message queue to generate documents.

* Microsoft was dang stupid to not support automation. Such lost opportunity. I doubt that Google's supporting automation is going to change Microsoft.

Re: Google Docs gets an API for task automation

#198
post #115

They will have a lot of catchup to do to get where Office is now. I'm frankly amazed by how good Microsoft Flow has been. So many dumb business processes rely on an Excel doc somewhere, or a stupid manual email somewhere else. But with Flow I've seen just a single smarty-pants able to fully streamline an entire department one rule at a time. They don't need to get permission to bring in a new logo - it's part of Offi…

Microsoft Flow is a really powerful - in terms of advanced capabilities it offers. If you're bought into the Office 365 ecosystem - the add-ins to Teams, Excel and SharePoint are really nifty. You can even run a "flow" over row data in Excel. I personally use this to file and track bugs - saves so much time for me. It also has capabilities that allows you to connect to any REST API - look up Custom Connectors. Finall…

Is flow different than logic apps?

Re: Google Docs gets an API for task automation

#199

I wished they would spend time on fixing bugs, Google docs has so many subtle bugs it is a very annoying product to use. Of course you could argue that you could do both new features and fix bugs but with budgets (even for Google) finite and new features not as critical as fixing existing issues I would love for the priority to be given to bug fixes. Pet peeve: it is impossible to do a wysiwyg document in Google docs…

Another hugely annoying bug that I cannot get over is that it doesn't respect umlauts such as in German typed via US keyboard even when using the Apple way of doing it by holding the key and selecting. Maddening.

It must have been 2 years since I last tried Docs but at that time Japanese input was utterly broken. Both in Safari and Chrome (and in different ways in each browser)
Post reply on HN