Since I've covered these techniques a few times in other posts in this section, I'll get straight to the code, which is of course on GitHub (you'll need the classes there as well as this code)
A couple of notable points on what's going on
Here's one that took me a while to discover
See it ?
You can get the VBA test code and class from gitHub. It's been put there automatically - you can use Getting started with VbaGit to pull it into your workbook or just download it. Remember to look at the dependency file for the Excel references required.
The Apps Script is also on github, and was put there automatically as described in Getting your apps scripts to Github
I also have a blogpost on this topic here - Making going Google easier by running Apps Script from VBA
Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, All formats are available from O'Reilly, Amazon and all good bookshops. You can also read a preview on O'Reilly