This post was originally published at Working with Google Sheets and Apps Script

It’s easy to start working with a spreadsheet, but it also takes time to master your skills to use all the powerful features it provides. 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.

In this article, I’m going to focus on extending Google Spreadsheets with a Google Apps Script that validates European Union VAT IDs via API calls.

Continue reading here – 

This post was originally published at Working with Google Sheets and Apps Script