Muffinresearch Labs by Stuart Colville

FOWA Notes: How and Why We Built Google Docs and Spreadsheets - Jonathan Rochelle | Comments (2)

Posted in Events on 21st February 2007, 4:59 pm by Stuart

Step 1 any good product
Pick a killer cool name

Google…
…Docs…
…&…
…Spreadsheets

People said it sucks. But At least no-one will be confused.

Who Cares? It’s actually a start-up acquistion story

20052Web Technologies / XL2Web joins Google.

Mar 2006 - Upstartle / writely joins google

Jun 2006 Google spreadhsheets launched in labs
Aug 2006 Writely re-opens
Oct 06 Google docs launched.
Took it global

It actually fits well with our mission
Orgnaise my info
Make it accessible
with whomever I choose and nobody else

IOW
DIY content creation
Accepted/familiar interface.
Accessibility from anywhere.
Easy to use collaboration.
DIY community creation

It’s not on the web it is the web.

Key target features
Realtime editing
online storage
Publishing
APis

One overriding product goal:
Be easy to use.

General Architecture

Server-side calculation engine. lighten the load
Ajax client
Collaboration engine.
Storage Layer
infrastructure and shared services

Google infrastructurep provides cheap scale - just add water. The team focuses on integration and features.

Ajax Client
Well defined communication layer
Push calculation logic to the server side
Browser challenges - no safari or opera support
Perceived speed

Ajax is graeat,
nice browser based UI
No plugins
Multi-platform

Ajax stinks
300k pages
X browser issues

Decisions Decisions
Who is our initial user
What are the must-have V1 features?
Launched in June, updated based on feedback in July and August.
Collaboration features - rich conflict resolution or simple “trust me” collaboration

Integration Choices - which google products when?

Technical decisions
Storage services.. which fits best?
Stateful vs stateless
homing how to split the load.

Feedback from the users
Give us more specific features.

Give us improvements to current features
More sorting options etc.

Give us more integration with more Google and non-google services.

“.. but we’re not whining.. We love this product!”

Lessons learned (pt 1)
Get UI help and get it early
UI innovation can make a stellar success or failure

Front-end code is very dependent of the desired ui behaviours.

Users don’t like guessing what icons do.
PM’s don’t make good icons.

Lessons learned (pt 2)

Test new ideas with users early.
Nobody cared to “Pan” their spreadsheet like a map.

Use Test harnesses, Automation and benchmarks - early
Client and server side
Key for ajax experimentation

Speed is critical
Performance improvements can Always be made.
Get someone important to say it’s too slow
Compromise, kill the cool but un-used features…

Lessons learned (pt 3)

The needs of many outweigh the needs of the few
Even if that “one” is paying the bills
Get user feedback and use it as a key input to feature plans

Sometimes insight does NOT come from the user
Our biggest was realtime collaboration. - This was a critical change to the proposition.

User data is sacred
Don’t ever give users a reason not to trust your product. Even internal users.
Treat data like it’s your bank account details.

Lessons learned (pt 4)

Provide a very specific value that users can describe

If users are saying they need somewher to use this product
is not as good as
users saying that your product will improve productivity 80%

Focus on features which align with your product’s value.
for example collaboration features are critical.
It’s not about which features most people want or which features will get us more users.

Talk to users
Gather plenty from early users - if they represent your target.

Final lesson learned
The team is the most important thing.
have partners
Pick the right partners
Complimentary skills
I’m not a good administrator so I picked a partner that was a great admin
Same with engineering.

Build a great Team
Don’t compromise

Don’t hire for everything. Buy services

Docs and spreadsheets http://docs.google.com
Google APIS http://code.google.com
Spreadsheets API: http://code.google.com/apis/spreadsheets/overview.html

Post Tools

Comments: Add yours

1. On May 22nd, 2007 at 12:54 am q q said:

Hi, I was searching for a place to suggest this to Google. I am a iGoogle user and I love it. I use Google Notebook and Google Docs for quite some time already as well. But recently I came across Zoho.com. I have to say they have a more complete set of web2.0 office suit and very feature rich compare to what Google Docs have now.

I would suggest that Google buys Zoho to enhance the currently limited Google Docs… Thanks. Just my personal view:)

2. On April 23rd, 2008 at 9:58 am How they built Google Docs? at Entrepreneur Geek said:

[...] Stuart Colville’s notes from the same talk [...]







XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>



Standalone mac battery charger|(0)

Got a spare mac battery? I’ve often wondered why up until now no-one’s produced a standalone charger so that you can charge batteries without having to plug them into the mac. Fortunately Fastmac.com have produced a standalone charger that allows you to do just that. and it’s compatible with iBooks, Powerbooks, macbooks and Macbook Pros. It’s also 110/200v. Exactly what I was looking for!

Django Admin Ominigraffle Stencil|(0)

Colleague Alex Lee has created a nice stencil for omingraffle with the Django Admin UI components, perfect for wireframing customised admin screens. For more details and to download the stencil see Alex’s Blog csensedesign.co.uk

Photos on Flickr

© Copyright 2004-08 Stuart Colville, all rights reserved. May contain traces of Muffin. Powered by WordPress. Hosting by 1&1 This page was baked in 0.740s.