Review a random Google Contact every day

I have all of my contacts loaded into Google Contacts but the problem is, I’m never convinced that they are up to date or even sure if I should still have the person’s contact details listed.

To address this I created the following script which will send me an email every day with a randomly selected contact.

I can then review the contact’s details, compare it with LinkedIn, Facebook and Twitter and then either update their contact details or send them an e-mail to catch up with them.

Continue reading Review a random Google Contact every day

I’m Back – And Faster !

Well it’s September now and this is my second post of the year!

It’s been a busy year but no excuses – I have neglected my blog. To make up for this I treated my blog to a new host. Gone are PlusNet and in are TSOHost.

I can’t recommend TSOHost highly enough. Within hours of me sending my backup to them they had migrated my blog and it was up and running and it’s MUCH faster! More importantly it’s back onto a supported software stack and it’s patched and up to date !

I have stacks of ideas for blog posts; specifically a series on using Tasker on android phones to send data to web forms , collating and analysing data in google spreadsheets then using web services to send data back to tasker to display a dashboard on your phone!

As an added bonus – previously some of my posts were password protected – these are now free and open!

Enjoy

Contacts – Keep In Touch or Update Details

One of my New Year resolutions was to keep in touch with more people.

I also need to clear out my contact list as there are lots of “old” and incomplete entries in my Google contacts list.

Ever the productivity geek I wanted to automate this. I ended up writing the following Google Apps Script:

Continue reading Contacts – Keep In Touch or Update Details

InBox Zero And Quantified Self

I’m a huge fan of keeping my inbox empty, but not very good and keeping it that way.

I’m becoming more interested in the “Quantified Self” concept i.e. you can only fix things that you can measure.

The obvious answer is to monitor what my GMail inbox looks like on a daily basis. Continue reading InBox Zero And Quantified Self

Social Media – How I Make It Work

Social Media – there are so many sites out there all wanting my input.
There are so many other web sites that produce content that want me to read their content.

You can see what my plumbing looks like here.

Continue reading Social Media – How I Make It Work

Google Spreadsheet & SQL Queries

Learning SQL
Creative Commons License photo credit: therefromhere
I am a big fan of Google Spreadsheets, they give you most of the features of a desktop “office” based spreadsheet but your data is stored online, no more need to carry your data on a USB stick.
I’m also a huge fan of databases, SQL is a fantastic tool for querying data.
Now you can combine the best of both worlds: store your data in a spreadsheet and then summarise the data using SQL.
Continue reading Google Spreadsheet & SQL Queries

Google Calendar Sync – Auto Run

A nice quick hint.

I kept forgetting to start Google Calendar Sync when I started Outlook. I don’t always start Outlook when I start my laptop and I’m not always online when I run Outlook so puting it in my Startup folder is not really an option.
My solution, a macro that runs when Outlook starts that gives me the option of running Google Calendar Sync if I feel it’s appropriate.

Private Sub Application_Startup()
Dim response As Integer
Dim RetVal
op
response = MsgBox(prompt:=”Do you want to run Google Calendar Sync?”, buttons:=vbYesNo)

If response = vbYes Then
RetVal = Shell(“C:\Program Files\Google\Google Calendar Sync\GoogleCalendarSync.exe”, vbMinimizedNoFocus)
End If

End Sub

NOTE: WordPress seems to “prettyfy” the quotes so when copying the code above it is better to delete and retype the quotation marks in your code editor of choice.

Google Reader – Send To GMail

I’m a huge fan of Google Reader.
They recently introduced a “Send To” feature to allow you to share items with other users.
The one that was not included by default was Send To GMail !

Try This:
https://mail.google.com/mail/?ui=2&view=cm&cmid=0&fs=1&tearoff=1&to=&su=${title}&body=${url}
Whoops, just noticed there is a big “EMail” button at the bottom of every article that does just this!

Last updated by at .