Thursday, February 23, 2012 team member becomes Google Apps Certified Sales Specialist

As part of the launch of the new tier of Google Apps PREMIER Resellers effective Feb. 14th, 2012, myself, Blair Collins, has received the Google Apps Certified Sales Specialist Certification.  We were part of the beta exam process so we're among the first in the world to receive the certification.

Details on the requirements can be found at: is pleased to be able to further differentiate ourselves in the Google Apps Marketplace with two Google Apps Certified Deployment Specialists, a Google Apps Certified Sales Specialist, and our Google Apps PREMIER SMB Reseller status.  Very few organizations in the world have achieved this level of recognition.

Deploying Google Apps is what we love to do!

Is your current provider Google Apps certified?

Friday, February 17, 2012

Custom reports for Freshbooks, Xero, and Norada Solve360

We've been building custom reports for Norada Solve360 CRM in Google Spreadsheets for a while and realized that since Freshbooks has a published open API we could do the same for Freshbooks customers.

In our case we wanted to know billings/revenue by employee.  The default Freshbooks report lumps the full invoice amount under who created the invoice not who generated the billable time entry.

Our custom report directly grabs the invoice line items via the Freshbooks API so updating the report with the latest data is as simple as clicking the menu option "Refresh Invoices".

Freshbooks Billings by Staff/Employee

Since it is programmed in Google Apps Script inside Google Spreadsheets sharing the report is a snap and you can use the invoice line item data to populate pivot table reports.  Pivot Tables in Google Spreadsheets allow you to slice the data any way you choose for billings by week, by task, by rate, etc.

All the Javascript like code runs on the Google infrastructure so there is zero software to install or manage and zero recurring costs.

Contact us at if you'd like to purchase your own copy of this report or have us build a different report specific to your needs for Freshbooks, Xero, or Norada Solve360.

Tuesday, February 14, 2012 Becomes a Google Apps Premier SMB Reseller announced today that it has become a Premier SMB Reseller of the Google Apps™ suite of communication and collaboration tools. This new designation from Google enables customers to more easily assess a reseller’s expertise advising on and deploying Google products. has moved from an Authorized to a Premier Reseller based on their expertise and success in helping customers deploy and use Google Apps. was launched in 2009 to help small and medium businesses (SMB's) leverage Google Apps for an enterprise class email, calendar, and document collaboration solution that's easy on the wallet, simple to use, and allows you to be productive from anywhere, with anyone. Our solution offering has grown to include Google Apps integrated products such as Norada Solve360 CRM/project management, Freshbooks billing, Xero accounting, plus custom programming on Google App Engine and Google Apps Script.

Google Apps brings simple, powerful communication and collaboration tools to organizations of any size – all hosted by Google to streamline setup, minimize maintenance, and reduce IT costs. With Gmail (including Google email security, powered by Postini), Google Calendar, and integrated IM, users can stay connected and work together with ease. And, using Google Docs and Google Sites, which include word processing, spreadsheet, presentation and website creation tools, they can share files and collaborate in real-time, keeping versions organized and available wherever and whenever users work.

The Google Apps Reseller program includes companies globally that sell, service and customize Google Apps for Business for their customers. As a part of the Apps Reseller program, receives training, support and deployment tools from Google, as well as access to APIs for integrating Google Apps into their customers' business operations. To learn more about becoming a Premier Reseller, including eligibility criteria and benefits, please visit the Google Reseller Program website: