Last year I started working at OpenTable and quickly discovered that we get a lot of unsolicited sales emails. I’m guessing people just figure out our standard email format, then look up all employees on LinkedIn. If you work for a well-known company, you’ve probably seen these before. The subject is something like “Checking in… Continue reading How to mute an email address in Gmail
Category: Google Apps Script
First add-on published
My first Google sheets add-on is published! To be totally honest, I made it mainly to see what was involved. I really like the work that Andrew Stillman has been doing with New Visions for Public Schools, including Doctopus and formMule, and I wanted to see if I could do similar things for higher ed or international… Continue reading First add-on published
Cool things I’m thinking about
I’ve been away for a while because things have been pretty busy at Educents. We recently finished our seed round and we’ve been growing really quickly. It’s been an awesome experience being part of a successful startup that is focused on trying new things. As account manager, I’ve been talking to new partners every week and… Continue reading Cool things I’m thinking about
Tuesday Tip: Using Git with Google Apps Script
One of the biggest issues with Google Apps Script (GAS) is that it doesn’t have any real version control system. Last month I started using GitHub (through this course on Udacity) and was disappointed to discover that there is no way to directly integrate Git with GAS projects. If you’ve never used Git, it’s an… Continue reading Tuesday Tip: Using Git with Google Apps Script
Tuesday tip: Google add-ons
Earlier this year, Google unveiled add-ons. Previously, developers could use Google Apps Script (GAS) to create custom functions or tools, then publish them to script gallery. Other users could then read a short description if the script and install it in their own files. It worked fine, but it was clearly something Google hadn’t put… Continue reading Tuesday tip: Google add-ons
Tuesday tip: Spreadsheets and sheets in Google Apps Script
This week’s tip is a follow-up to last week’s post on working with ranges in Google Apps Script (GAS). Just like ranges, you need to be careful that you are working with the correct object if you’re dealing with sheets in GAS. If you’re used to Excel and VBA, GAS vocabulary is slightly different. In Excel, the… Continue reading Tuesday tip: Spreadsheets and sheets in Google Apps Script
Tuesday tip: Ranges as objects in Google Apps Script
Maybe this will be a regular thing. Next week will be my last at NYU, so I’ve had lots of opportunities to explain the things I do. As I do, I’m seeing colleagues that I’m training running into some of the same questions I’ve had in the past about Google Apps Script and the various… Continue reading Tuesday tip: Ranges as objects in Google Apps Script
Tuesday Tip? (Or, How Gmail is annoying)
Not sure if this will be a regular thing, so I don’t know if this qualifies as a Tuesday Tip, but it’s Tuesday, and I’ve been finding out things about Gmail lately. Specifically, at NYU I’ve made an email ticketing system using Google Apps Script and have discovered what is kind of an annoying quirk… Continue reading Tuesday Tip? (Or, How Gmail is annoying)
Sharing limited data without sharing the whole spreadsheet
Recently a friend asked me how he could share some data that he was working on with colleagues. The problem is that he can’t share the entire spreadsheet. My suggestion is to use Google Sheets and the ImportRange function to share limited ranges with another spreadsheet. What’s great about this method is that you can… Continue reading Sharing limited data without sharing the whole spreadsheet