Add-ons for Google Docs and Sheets

Google has snuck out some rather cool new functionality to its cloud based productivity suite Google Drive.

Called add-ons, you can now use them to add extra functionality to your Google Docs and Spreadsheets experience.

Here’s a video explaining it all:

[youtube http://www.youtube.com/watch?v=lZqX6ocwHWU]

So what are these add-ons and what do they do?

Lucky for us that Lifehacker has produced a list of the best ones. They include:

  • HelloFax, which lets you fax a Google Doc without leaving the app
  • Mapping sheets lets you take a spreadsheet full of address information and put it all on a Google Map
  • UberConference – lets you set up and run a conference call from within your Google Doc. Great for collaborating across distances
  • Track Changes – gives you reviewing tools a bit more like those you are used to in Word

These are just some of those currently available – it will be interesting to see what will come in time as developers get to work.

Five for Friday – 14 March 2014

linksFive for Friday is WorkSmart’s weekly roundup of interesting stuff from the week’s reading.

  1. About change, defaults and disruption – “large organisations are racing against start-ups to stay relevant”. Great stuff from Anne McCrossan
  2. Creating a minimum viable product using WordPress – Chris Lema on using WordPress to throw together prototype services
  3. 5 More Unexpected Ways to Work Smarter, Not Harder – useful ideas. Thanks to Dan Slee for the link.
  4. Is it time to quit your job and launch that new start up? – nice video from Bethnal Green Ventures via the Nominet Trust
  5. Forrester argues piecemeal digital transformation won’t work – interesting research. Lovely quote: “Dabbling with digital isn’t the route to success”.
Did you know that WorkSmart has a Pinterest board where loads of cool stuff is shared?

Tame your Twitter stream

tame-itNot sure how I had never come across this before, but Tame is super useful!

You set up an account as with all these services, and then connect to your Twitter account. Tame then goes away and comes back with a dashboard style view, in three columns.

The columns display the most popular links being shared by the people you follow, the most popular hashtags being used, and the most popular accounts being mentioned.

It’s a simple idea, but for those moments when you don’t have time for much more than a quick glance at Twitter, it gives you a fast summary of what’s popular in your stream – which might be all you need.

Here’s a video to show how it works:

WIN! ‘The Myth of Innovation’ by Scott Berkun

photoThe Myth of Innovation by Scott Berkun is a great read on the topic of technology and innovation. It’s little Ruth’s favourite bedtime read!

From the blurb:

This updated paperback edition of the classic bestseller, takes you on a hilarious, fast-paced ride through the history of ideas. You’ll learn to transcend the false stories that deceive many business experts, scientists, and much of pop culture, with history based lessons on how to invent, create and deliver on your own ideas. You’ll have fun while you learn:

  • Where ideas come from
  • The true history of history
  • Why most people don’t like ideas
  • How great managers make ideas thrive
  • The importance of problem finding
  • The simple plan (new for paperback)

Since its initial publication, this classic bestseller has been discussed on NPR, MSNBC, CNBC, and at Yale University, MIT, Carnegie Mellon University, Microsoft, Apple, Intel, Google, Amazon.com, and other major media, corporations, and universities. It has changed the way thousands of leaders and creators understand the world.

Find out more about it on the book’s Amazon page.

I’ve a copy of the new paperback version of the book to give away. All you have to do is sign up to become a member of WorkSmart – which is free – and on Friday 21st March I will draw someone at random to send the book to.

Don’t worry if you have already signed up, as all members will be involved in the draw.

Capsule – the acceptable and useful face of CRM

capsulecrm‘CRM’ or customer relationship management is one of those IT phrases that can put the fear of God into people, and with good reason.

There aren’t many people who have managed to avoid the organisational carnage that attempts to deploy CRM can cause. Careers have been left in ruins, consultants missing in action, businesses killed along the way.

But it really doesn’t have to be that way! In fact, using a small scale, lightweight CRM have been incredibly helpful in getting all manner of projects done.

My favourite is CapsuleCRM. It enables you to very simply keep contact records and assign various bits of information to them. It also helps you keep a database of the emails you send them, and helps you to organise your workload by attaching tasks to people.

You can also create cases, where tasks, people, notes and files can all be held together in one place. These can be used as a case management system relating to an organisation or person you are working with, or can even be used as a rudimentary but effective internal project management tool.

Finally, there is a free app that you can use on your smartphone so your contacts, notes and tasks are never far away.

Of course this is a CRM so there are some sales pipeline features in there as well. They may not be of use to you. But that’s ok – either don’t use them at all, or think up some other way that those features might be helpful to you.

With pretty much any project where you need to keep a track of people and your interactions with them, having a lightweight database like CapsuleCRM around can be super helpful. CapsuleCRM has a free tier, so you don’t even need to pay for it, or it’s just £8 per month per user if you want to unlock extra storage and so on.

Load more posts!