Dream Home Office Setup

New Office

How it began

Growing up, I vividly remember sitting in my dad’s home office after school, waiting for him to get home from work.

The office had a tall ceiling and a single window at the back that opened into a tiny access courtyard between our house and the neighbor’s house (it was a semi-detached Victorian).

My dad sat behind a heavy wooden desk, with a big, boxy desktop computer sitting atop. On one wall was a bookshelf, full of computer books and boxes of floppy disks for illustrious programs like Microsoft Windows, Lotus 1-2-3, Borland Quattro Pro, and many others I’ve forgotten.

I would pull the thickest manual off the shelf and ask dad to explain it to me the minute he got home from work. I’m sure it’s just what he wanted to do at the end of a long work day. Sorry (but not sorry) dad!

I’ve wanted my own work space, reflecting my personality and overflowing with books, ever since.

Working From Home

I’ve worked for myself for 5 years now, so I’m used to working from home.

For the first couple of years, I worked from a small desk in the living room and then the basement of where I lived at the time.

When my wife and I moved to Florida in 2017, I rented a 1-person office in downtown St. Petersburg. My youngest son was only a few months old so I needed a quiet space to record videos. (I launched my first online course in 2017.)

I customized that rental office to make it my own. The first investment was a Fully Jarvis standing desk, which I still use and love today.

Last year, we moved to Harpers Ferry, WV, and it was a chance to set up a new office. The only change was the better scenery out my window and a couple of pieces of artwork on the walls.

This year, 2020, we moved out of the rental house and into our own home, so it was finally time to build the dream office. This is iteration three of my home office.

An Investment In You And Your Business

I’ve come to realize that the environment in which you do your work is important.

To do my best work I need to clear my mind out first. If there’s clutter everywhere, which is most days since I have young kids, then my mind is using energy to think about it. In my head, I’m doing a virtual Maire Kondo where I sweep it all away and out of sight.

My office is one space I have control over though. I can set it up to be clean and minimal.

Today, I’m much more sure of who I am and what I do than at any previous stage in life. And that translates into being able to create a workspace that facilitates the work I do now.

Global HQ for Collins Analytics LLC

My 2014 MacBook Pro is 6 years old and showing its age.

I don’t do a lot of heavy-duty computing, but I do work with large video files. And of course, I have a lot of Chrome tabs open at any given time.

The time from deciding I needed a new computer to actually purchasing one was about 12 months!

I spent a LOT of time researching options and looking at other’s setups.

But it wasn’t until I saw this Mac Mini and Ultra widescreen setup that I found what I was looking for. This was the perfect setup for me.

Here’s my current home office setup:

New Office

I’m using the new  Apple Mac Mini with the M1 chip, powering 2 monitors: an ultrawide Dell U3419W (supported by a Fully Jarvis monitor arm) and an Acer R240HY.

The microphone is a Blue Yeti on a Blue Compass arm, and the light is an Elgato Key light.

Everything sits on Fully’s Jarvis standing desk, which I’ve had for years and love.

Apple Mac Mini

So far, it’s a fantastic combination! Super fast, quiet and tons of real estate.

That’s a Lego Saturn V rocket on the window ledge, one of the greatest Lego models of all time.

Lego Saturn V rocket

Office door decal

How To Become A Freelance Google Sheets Developer

You’ve decided you want to be a freelance Google Sheets developer. Great!

But how do you get started?

I get asked this question a lot, so I’ve compiled my email answers into this blog post.

But first, let me share my story, so you hear it from the horse’s mouth:

My Journey As A Freelance Google Sheets Developer

I quit my corporate accounting job in late 2014. I was unhappy because I felt like I was living someone else’s life. Deep down, I knew I wanted to do something technical and creative.

After leaving corporate accounting, I spent six months learning to code and looking for tech roles.

Following the advice for job hunters at the time, I created a blog (this website) and began writing about about lots of different technical topics including coding, data and Google Sheets. Without planning it, I was learning in public.

The first post was about how to build a dashboard in Google Sheets. It was by far the most popular post for search traffic that first year.

And it led to my first client, which was fortunate because I wasn’t getting anywhere applying for tech roles. (And I really mean that, I applied for a bunch of web developer roles and data analyst roles and was yet to get past the first interview. Things worked out in the end though.)

First Client

My first client was a small real estate company using Forms and Sheets to collect data from their sales agents. They’d seen the dashboard tutorial on my website and asked me to create something similar for them.

I charged them $400 and the project took around 10 hours. (Actually, it could well have been 20 hours because I didn’t track my time when I first started.)

Although the dashboard was basic, it delivered huge value to the client.

Cultivating Inbound Leads

I kept publishing content about Google Sheets and Apps Script. The website picked up more search traffic through 2015 and each subsequent year since.

I realize I was lucky with my timing since Google Sheets growth was exploding and there weren’t many resources online.

The search traffic brought more inbound leads: people contacting me for help with their projects.

Once you have a reliable source of leads coming into your business, you can focus on being more efficient and expanding beyond the feast to famine freelance cycle.

After a few years of freelancing, I stopped trading time for money (which we discuss below) and eventually moved to creating online courses and teaching online (but that’s a story for another day).

Freelance Google Sheets Developer
Yeah, this is a 100% truthful representation of the freelancer life ?

Your journey won’t look like mine, but there are universal actions you can take to get there quicker than I did. So, turning our attention back to you, here are some actionable steps you can take today to start your freelancer journey:

Freelance Google Sheets Developer Playbook

This short guide is broken into a few sections dealing with different aspects of freelancing.

The most important lesson to takeaway is that you need to spend as much, if not more, time on sales as on the hard, technical skills.

With that in mind, let’s begin with the most important thing you can do for your freelance career: get clients!

1. How To Get Clients As A Freelance Google Sheets Developer

This is the most important thing you do.

Not your Google Sheets skills. Not your business skills. Not time management. No, the most important thing is getting clients. (And then making them happy of course.)

This will determine whether or not you succeed, so focus heavily on this from day one.

Specifically, here are some ideas to get your first clients:

  • Email all your friends/family/contacts to tell them you’re doing this and ask for work referrals.
  • Offer to do pro-bono (free) spreadsheet work for small orgs/non-profits to gain some experience and testimonials.
  • Look for freelance spreadsheet work on sites like Upwork and Fiverr. Choose one and build a portfolio/reputation there.
  • Look for Google Sheet jobs on job sites like Indeed (hard to find ones where this is the main skill required though).
  • Keep your eyes on “spreadsheet” companies that build solutions on top of Google Sheets (e.g. this list on Product Hunt). They occasionally hire part-time and full-time spreadsheet developers.
  • Create a (simple) website and share your work/ideas/knowledge. This will help you figure out what you want to do and demonstrate you can do it.
  • Add a “Hire Me” page with details of your work and testimonials. Make it easy for someone to contact you through a form.
  • Create a white-paper or short ebook that’s helpful in your industry and share it with your network. Ask them to share with their networks. You’d be amazed at how shareable a high-value asset like an ebook can be. Creating content is a high leverage activity (i.e. the reward > the effort, at least over the long run).

Spreadsheet tea mug

2. Fees: What To Charge As A Freelance Google Sheets Developer?

“What should I charge?” is probably the second most frequently asked question (after “how do I get clients?”).

The answers and advice are across the board:

“Do it for free to get exposure.” (But how will you pay the bills?)

“Charge what you’re worth.” (Super helpful when you’re starting out!)

“Whatever number you have in your head, double it.” (Ok, that’s not bad advice as most freelancers undercharge).

Consider Both Sides

Most of us, especially when we’re new to this game, think about fees based on what it takes to complete the project, i.e. how many hours it will take.

Maybe it’ll take me 15 hours, which, at $100 / hour, is $1,500. Bingo! Invoice for $1,500.

That’s fine, but it’s only one way to think about it.

The other way is to think, “what’s the value of this to the client?”

Suppose they’ve asked you to automate their reporting pipeline and they’ll save 3 hours a week. Now that analyst’s time can be repurposed to do more meaningful work.

From the client’s perspective, this is hugely valuable.

They’d probably happily pay multiples of $1,500 for that solution.

So you have to think about both angles: your side, in terms of how much time it’ll take you to do the project, and then from the client’s side, and what’s the value there.

Hourly Pricing

The rate is dependent on many factors: your experience, the niche you’re working in, the market you operate in etc.

Just remember, you’re competing with people who answer questions for free in forums and folks who charge $5/hr on Upwork.

It’s hard to compete on price and you can’t work for $5/hr if you’re living in the U.S.

Assuming equal spreadsheet skills, you can differentiate yourself by being super reliable, a pleasure to work with, a great communicator, knowledgeable about the client’s industry, etc.

And then you can consider consulting rates for Google Sheets work in the range of $50/hr – $150/hr.

Project Pricing

As you improve your systems and grow your business, you’ll become more efficient at solving problems (for example, you have templates for contracts, NDAs, etc. or a gallery of solutions that you can partially re-use).

It makes sense to ditch hourly rates and move to project rates. This way, your efficiency is rewarded. If you do project pricing though, you have to define the scope of work carefully and precisely, to avoid scope creep.

For example, rather than say “Includes planning calls” in your scope, say “includes two 30-minute planning calls” so you set expectations with the client. They won’t ask for more and neither party will expect anything different.

Most Google Sheets development projects will be one-off, but you may get lucky and land a client on a monthly retainer basis, where you’re paid to keep their Google Sheets humming along each month.

Think about the “both sides” idea discussed above. Work out the hours you think it’ll take and use that as your lower pricing bound. Then think about the value to the client and come up with an upper bound. Pitch the client with your bid somewhere between these two bounds.

Pricing Strategy Tips

  • You might start with a few small free projects to generate leads and portfolio pieces.
  • Then start charging an hourly rate on the lower end, say $40/hour.
  • Raise your rates every 6 months or so early on, until you find the optimum level that keeps you busy and maximises your earnings.
  • Once you have some experience under your belt, try project pricing so your efficiency is rewarded.
  • Push yourself to pitch higher than you’re comfortable with. If the client rejects your offer you can always go back with a lower offer.
  • When you propose your opening bid, price it high enough that you have wiggle room. The client may counter with their offer and if you’ve priced low to begin with, you won’t have room to go down.

3. How To Be A Good Freelance Google Sheets Developer

Once you’ve got your first client, you want to make them happy. Happy clients return for more work and refer you to their network.

Follow these few simple steps and you’ll be way ahead of your competition:

  • Always be polite and courteous in your communications. If you feel like emotion is clouding your decision, walk away from the email or say “I’ll get back to you” and sleep on it. Inevitably, when the fog lifts, you can see the correct decision.
  • Always be professional and do what you say you’re going to do.
  • Stick to deadlines and be on time with your submissions. (If you can’t hit a deadline, let the client know as soon as possible and they’ll generally be understanding.)
  • Be honest with your clients, e.g. if you need more time, it’s going to cost more.
  • Have a bias towards over-communicating rather than under-communicating. Clients appreciate being kept in the loop.
  • Have a bias towards action and don’t expect to get everything right first time.

Remember, you’re serving the client, not the other way around. Focus on delivering value to the client, not treating them like an ATM.

4. Implement Systems To Increase Efficiency

Set up systems as soon as you can. It’ll be hugely beneficial for you.

Pre Engagement Phase

The pre-client phase is one area where it’s easy to lose a lot of time. (I’m speaking from experience.) It’s a great area to implement systems to save yourself time and headaches. For example, consider:

  • Using a service like Calendly to schedule calls, rather than back and forth emails.
  • Creating a standard work template and pricing structure so you can easily see whether clients are a good fit.
  • Setting a minimum project price and let potential clients know relatively early in the process, so you don’t waste time with people who won’t pay you.
  • Set up a robust Customer Relationship Management (CRM) workflow (doesn’t have to be an expensive tool, a Google Sheet also works). Whenever clients dry up, you can email former clients to see if they need help.

During the Project

  • Use a time tracking system (e.g. Toggl) to track your time. This will be super helpful for costing out future projects as well as the current one.
  • Batch your time so you avoid too much context switching. For example, schedule all calls on Tuesday afternoons. Open and reply to emails twice a day in 30-minute blocks, then keep your email shut in between (not always possible).

After the Project

Create a standard post-engagement workflow. You have the opportunity to leave the client feeling happy and help your future business prospects.

  • Check the client is happy and whether there’s anything else you can do for them.
  • Systemize your payment process to make sure you get paid in a timely fashion. I use Harvest App to create and send invoices.
  • Ask for testimonials. Use a Google Form so they’re all together in a Google Sheet and you can access them anytime.

5. Niche Down By Industry

Focussing on a specific industry has many benefits:

  • You develop industry knowledge, which improves the quality of your work product.
  • You develop a reputation as an expert in the field, the “go-to” person for this type of work.
  • You develop a network and get referrals.
  • You can more easily systemize your business e.g. client onboarding.
  • You can even productize your work e.g. create a Google Sheets template for that industry. This is great for lead generation and could potentially be a revenue generator.

Don’t stress too much about a niche to focus on when you’re just getting started though, unless you have prior experience that gives you a clear advantage.

Otherwise, see what type of work you like doing and what’s popular with your clients. I did Excel, SQL and Tableau consulting and training, as well as Google Sheets work, for the first 2 years, before really doubling down on just Google products. And I worked across all industries to begin with.

Many small businesses, nonprofits and mom-and-pop stores could use help with their data, which in all likelihood exists in spreadsheets!

6. Scale

Finding clients and doing high quality work will always be the two most important aspects of your business.

As you scale, you grow from the feast-to-famine freelancer model to a more predictable monthly take-home as a small business.

You’ll need to systemize more parts of the business so you can focus less of your time on repeatable tasks (like invoicing) and more time on high-value, unique tasks like finding new clients and hiring staff members.

Freelancer To Business Journey

Freelance Google Sheets developer → sole-member business → sole-member business with an assistant → sole-member business with contractors → agency business model with full-time people

At some point you need to decide if you want to do the work or run the business. You can’t do both.

I love my work, so I’ve deliberately kept myself as a single-member LLC with one assistant, so I can keep doing the work.

But it’s an equally valid path to hire contractors, and eventually employees, who carry out the actual spreadsheet work, whilst you run and scale the business.

Some ideas to think about:

  • Find other contractors with complimentary skills so you can refer work to each other, or collaborate together on projects.
  • Outsource non-core tasks. For example, hire a bookkeeper to do your accounting for you.
  • Get rid of clients that are hard work (because they pay low rates, haggle over everything, don’t respond to you etc.). Marie Kondo your client list! Does this client bring me joy? If not, let them go!
  • Culture also becomes a critical part of your success as you start to hire people.

It’s simple in theory but hard to execute: hire great people, give them a compelling vision for the business and get out of their way so they can do great work.

Resources

Check out Andy Conlin’s How To Be A Freelance Google Sheets Developer talk from SheetsCon 2020.

This is a useful article from the Excel consulting world from the perspective of the client hiring a freelancer.

Here’s an excellent post breaking down the financial realities of freelancing in the U.S.: Making $100k As An Employee Versus Being Self-Employed

Good luck!

Ben Collins, December 2020

P.S. Share your own freelance journeys and tips in the comments below! Everyone has a unique journey and value to add.

In Pursuit Of A Dream

As I’ve grown, my values have changed and evolved.

Things that mattered to me in my twenties and early thirties don’t matter so much now.

As each year passes, what matters to me becomes clearer. A simple life, with a focus around family, regular outdoor exercise, and a good work routine is what I’m looking for.

(Honestly, I think this guy had it figured out 😉 )

For the past few years, my wife and I have nurtured a shared dream of moving our family to a small mountain town.
Continue reading In Pursuit Of A Dream

Recap From Google Cloud Next ’19 Conference

I’ve recently returned from a fantastic week in San Francisco at Google’s Cloud Next ’19 conference, which is their annual Cloud conference for developers and vendors. It’s a huge event, with some 30,000+ attendees and 500 sessions.

Google made a 122 announcements, including some exciting developments relating to Google Sheets.

Here are the talks from the Google Cloud Next 19 conference that related to Google Sheets:

1. 30 Ways Google Sheets Can Help Your Company Uncover and Share Data Insights

If you only watch one session from next and you’re a Google Sheets user, then I’d recommend this one. It’s really well presented look at the capabilities of Google Sheets in the context of working with data and the Sheets team give plenty of sneak peeks into where the tool is going.

Here are the new features we can expect to see in the future:

Images in cells: allows you to add images anchored inside a cell, not just free-floating, and without needing to use the IMAGE function

Trim Whitespace: natively remove whitespace around data in cells, instead of having to use formulas

Remove Duplicates: natively remove duplicates in Google Sheets without needing to use an add-on or manual formula methods

Slicers: slicers are controls to add filters to pivot tables and charts

Reports & Themes: features to make dashboard reports easier in Sheets

OnPrem data connectors: data connectors to other SQL databases to easily access data from Sheets

Connected sheets: Connected Sheets connect Sheets to BigQuery and use Sheets functionality, like pivot tables, formulas and charts, with millions or even billions of rows of data inside BigQuery. The presenters showed an incredible demonstration of running a pivot table on 128 million rows of data!

View and edit history of individual cells: see how cells have changed over time

Embedding Sheets in Docs and Slides

MS Office Editing: work on Office files straight from G Suite without having to convert file types

Legacy keyboard shortcuts

2. How to Grow a Spreadsheet into an Application

Most of us use spreadsheets beyond simple data tasks. We build to-do lists, address books, scheduling apps, bug trackers, etc. Eventually, however, there comes a time when you need something more robust than a standalone Google Sheet, and this talk explores that journey, from single Google Sheet to full-blown application.

3. How to Simplify Business Processes with G Suite

4. Google Docs: Taking Collaboration Beyond Real Time

5. Open Doors to ML: How AAA Leverages BQML and Google Sheets to Predict Call Volume

An interesting session looking at how AAA uses BigQuery and Machine Learning to create predictive models that everyone can access through the Google Sheets interface. It was fascinating to see how Google Sheets has been positioned as the final step of the big data/machine learning pipelines.

6. Bring Your Favorite Enterprise Apps to G Suite with the New G Suite Add-ons

For Add-On developers, there was a big announcement about the new G Suite Add-Ons, which should make developers lives easier:

The full library of sessions from Google Next 19 can be found over on the Google Cloud Platform and the G Suite channels.

See you at Google Next 20 perhaps?

Google Next 19 Conference – Live Blog

Conference Recap

Check out the best Google Sheets and G Suite videos here: Google Sheets Sessions From Cloud Next ’19 Conference


Friday, April 12th (Post-conference)

The conference may be over but I have a little time left in San Francisco. Today I had the opportunity to visit the Googleplex in Mountain View and record a video with the Data Studio team 🙂

Google logo

In the studio with the Data Studio team
In the studio with the Data Studio team
Android Robot!
Android Robot!

Thursday, April 11th (Day 3)

Day 3 at Next ‘19 recap from Google: A look back at an amazing week

1.35 PM – Growing a spreadsheet into an application

Spreadsheet applications

Really interesting talk about the life cycle of a spreadsheet, and how it grows into an application, and how you can move beyond the spreadsheet to a more robust, scalable solution.

Spreadsheet applications
Use cases when spreadsheets make good applications…
Spreadsheet applications
…and times when they don’t make good applications!

11 AM – Data Studio meetup

A bunch of Data Studio enthusiasts and Googlers got together to discuss the product and the roadmap. Great to get some insight into where it’s going. They’re certainly investing heavily in Data Studio!

9 AM – Simplify Business Processes with G Suite session

Simplify Business with G Suite

Some really interesting use-cases of businesses adopting G Suite, and how it’s simplifying and streamlining their processes.

The BigQuery to Google Sheets connector is getting a lot of love! ?

Google Sheets BigQuery connector
Google Sheets BigQuery connector

The team also shared some innovative and wide-ranging examples of App Maker apps. For example, here’s an App Maker app that can recognize text in a photo and transfer that into a Google Doc for you!

Google App Maker

It’s the final day of Google Next 19!

Video replay of yesterday’s Sheets session!

The video replay of yesterday’s Google Sheets session is now on YouTube. This is highly recommended if you have 45 minutes. In it, the Product Managers from Google share the Google Sheets roadmap:


Wednesday, April 10th (Day 2)

Day 2 recap on the Google Cloud Blog

4.40 PM – Developer Keynote LIVE

Watch live here

3.30 PM – Data Studio

Serverless reporting with GCP and Data Studio
Serverless reporting with GCP and Data Studio

Lots of updates from the Data Studio team and a great demonstration of how quick the tool is to analyze a hundred million rows of data, when using the new BigQuery BI Engine between BigQuery and Data Studio.

The other big updates included a sophisticated chart drill-down and cross-filtering features and more insight into the scheduled distribution of reports.

Scheduled Data Studio report
Scheduled Data Studio report

It’s very clear that Google are investing heavily in this tool!

2.10 PM – BQML and Google Sheets

BigQuery ML and Google Sheets

This was a really interesting session on how AAA utilize BigQuery and the new BigQuery ML (Machine Learning) tool to predict volume at call centers. They use the BigQuery connector to bring the analytical capabilities into Sheets, to open access to the model to many more people across the organization.

BigQuery Connector into Google Sheets

Fascinating stuff!

12.30 PM – Google Sheets Session

Wow! So many big features in the pipeline:

Google Sheets announcements
Google Sheets announcements

How we work with data in Google Sheets is changing. Some of the biggest announcements were (some available in beta today, some coming in the future):

  • Connected Sheets for BigQuery (see Product Keynote below)
  • On Prem data connectors – Oracle, MySQL, Postgres databases direct into Sheets
  • Native remove duplicates feature
  • Slicers
  • Reports!Easily create beautiful reports, including Themes feature
  • See and Edit history of a cell
  • Embedding Sheets into Docs/Slides
  • And more…!
Google Sheets Reports feature
Google Sheets Reports feature
Google Next Keynote Day 2
Analyzing millions of rows of BigQuery data directly in Google Sheets formula! ?

More to come…

9 AM – Product Keynote

Good to see G Suite get a lot of stage time!

Google Next Keynote Day 2

Google Next Keynote Day 2
BigQuery + Google Sheets! This is exciting!

Probably the most exciting feature for Sheets users is a new feature in #GoogleSheets, called Connected Sheets, which lets you collaborate on up to 10 billion rows of BigQuery data right from within Sheets (without needing SQL!) –> more details and apply for beta access now

Other big announcements included:

  • G Suite integration with Google Assistant (beta)
  • G Suite Add-ons (beta coming soon)
  • Office editing in Docs, Slides and Sheets (generally available)

For a full run-down of all the new features and products coming to G Suite: check it out here on the G Suite blog

Watch it live here –> Next on Air


Tuesday, April 9th (Day 1)

Day 1 Recap

Day 1 was all about enterprise, enterprise, enterprise. Google Cloud CEO, Thomas Kurian, announced a new product, Anthos, available for managing multi-cloud solutions.

For me personally, this enterprise stuff is really interesting but not directly relevant. The highlight of the day was meeting a bunch of great folks and sharing ideas, beginning by serendipitously sitting next to a data scientist from MailChimp for the opening keynote.

Some links from day 1:

Google Cloud Next ‘19: Welcome to the future of digital transformation

Day 1 at Next ‘19: Hybrid cloud, full-stack serverless, open-source partnerships, and more (the official recap)

Tomorrow, the focus is more on product and developers!

There are sessions focused on Sheets (new announcements hopefully!), combining BigQuery with Sheets and finally, Data Studio. So I should have a lot more substantive updates to share here on the blog tomorrow 🙂

4PM – Checking out the Vendor Hall

Google Next 19 Vendor hall

The scale of this conference is pretty overwhelming!

Google Next 19 Vendor hall

1 PM – 3.30 PM – G Suite Product Feedback session

One of the benefits of becoming a Google Developer Expert is that I get to meet some of the Google Project Managers and give product feedback directly.

This afternoon we had a big round table with most of the G Suite and Apps Script GDEs and the respective Product Managers and Developer Relations team from Google.

It was a lively discussion and great to see Google listening to all our feedback. There’s lots of exciting stuff in the pipeline, some of which will be announced at Next, some later this year.

Unfortunately I can’t share any specifics now, but I’ll certainly share anything that gets announced at the sessions tomorrow!

11 AM – The Non-Engineer Guide to BigQuery

Google Next 19 BigQuery session

Interesting presentation, although totally different to what I expected.

I was expecting more of an introduction to using BigQuery and how to approach it for product managers, analysts, managers etc. (i.e. non-engineers).

Instead it was an demonstration of a super cool tool Viant have built on top of BigQuery to democratize access to data across their organization. Their tool – potens.io – allows you to build workflows to query data in BigQuery including business logic, API integration and script outputs (like emails if certain results are obtained). Interesting stuff for sure!

Google BigQuery Potens
Example workflow built using Potens.io to review ad assets and run them through Cloud Vision API to flag inappropriate content, all atop BigQuery

I look forward to diving into BigQuery (someday soon!) and start creating content here.

Google Next 19 BigQuery session

9 AM – Keynote

I managed to get into the hall for the keynote this year. The sheer number of people filing in and out of the Moscone center was still overwhelming.

Sundar Pichai (CEO of Google) kicked things off before new Cloud CEO, Thomas Kurian, took over and laid out his vision for Google Cloud.

Unsurprisingly, and understandably given Google’s position in the cloud race behind Amazon and Microsoft, the focus was entirely on Enterprise solutions and multi-cloud solutions. Not much mention of G Suite…yet.

Google Next 19 Keynote
It’s a rock concert for geeks! ?

Monday, April 8th (T – 1 Day)

6.30 PM – Next ’19 Community Dinner

Tonight Google hosted a community dinner for the Google Developer Experts in their offices downtown.

It was great to catch up with fellow Apps Script and G Suite GDEs and hear what everyone’s up to.

Google Next 19 Community Dinner

Everyone is using the CLASP, the Command Line Apps Script interface, with their code editors of choice. This allows for a much improved development environment over the native Apps Script one. And we’re all waiting to see if there’s any vision on the Apps Script roadmap and a timeline when the new runtime engine will come in (which will make scripts run a lot faster).

1 PM

Lunch in Chinatown with David Siegel, CEO and co-founder of Glide Apps. Glide Apps lets you turn your Google Sheets into mobile apps, with no coding required.

Lunch in San Francisco

The Next conference starts in earnest for me tomorrow (it’s the community summit today).

12.30 PM:

Some early G Suite stats being shared at the community events today (I’m not there, so reporting this from Twitter):

  • 1.5B+ App Users
  • 90M+ students with an Edu license
  • 5M+ paying G Suite Businesses (up 1M from last year)

If you’re unable to attend Next, the Keynote sessions are available to watch live online here: https://cloud.withgoogle.com/next/sf/

9 AM:

Registration day! If you’re attending and you have a chance to collect your badge today then I highly recommend. Tomorrow the lines will be pretty long…

I’ve got my badge!

Google Next 19 Badge

Google Next 19 Conference
Digging the conference graphics on the side of the Moscone Center

The billboards all around the SOMA district of San Francisco are plastered with the conference ads. It’s crazy how big this event is. I’ve heard there’ll north of thirty thousand attendees. Wow!


Sunday, April 7th (T – 2 Days)

The Google Next 19 conference is almost here!

I arrived in San Francisco this morning after an early flight. It’s been a beautiful day so I caught up with a buddy and we did a great walk around the city parks. This, the view from near the top of Buena Vista park:

Golden Gate Bridge from Buena Vista park
Golden Gate Bridge from Buena Vista park

I’m really excited to catch up with friends, meet awesome new folks and hear all about the Google product road maps this week!

This is what the Google Sheets team announced last year:

  • 5 million cells ✔️ We got that earlier this year!
  • Slicers ? Not yet! They’re still in the works but I’m sure there’ll be an update this week!
  • Better Charts ✔️ We got some nice upgrades like editing individual data points.
  • Pivot Table Upgrades ✔️
  • Big Query Data Integration ✔️ Available to G Suite Business, Enterprise and Education users
  • There were a bunch of other upgrades and new features announced!

I’ll be sure to share the announcements from this year’s Google Sheets session here in this blog!


Friday, April 5 (T – 4 Days)

Google Next 19

Google Next 19, the big annual conference from Google Cloud and G Suite, is just around the corner. It starts on Tuesday 9th April, although there are things happening on Sunday and Monday beforehand.

I have my ticket and I’m flying to San Francisco on Sunday. I’m really excited!

Last year was my first time at Next, and it was an eye-opening experience. With over 20,000 attendees and hundreds of talks, it was inspiring and overwhelming in equal measure. It was great to hear first-hand from the Google Sheets team on the roadmap, and I’m looking forward to new updates this year.

This year, with experience from last year fresh in my mind, I’ve scheduled meetings ahead of time, been a little less ambitious with my schedule and packed a portable battery charger!

My plan is to update this post daily with news and announcements from Next 19.

I’ll also be posting lots of updates to Twitter, under the #GoogleNext19 hashtag.