Working with Google Sheets and Apps Script

CRANK

When you start feeling comfortable with formulas, functions, pivot tables, etc., there is still one more level which allows you to achieve even more—custom extensions. I’m going to focus on extending Google Spreadsheets with a Google Apps Script that validates European Union VAT IDs via API calls.