Import RESTRICTED data from Google Sheets in Excel Part 1/2

See various methods to import data from Google Sheets here: excelmacrofun.blogspot.com/20...
In this video we see a method to import RESTRICTED data from Google Sheets in Excel using VBA macros. The method consists of creating our own Google script API and then sending a HTTP request from Excel to get the data. In the next video we will see how to read the response to write the data to a range in Excel.
Find many other macro examples and Excel VBA learning materials (including the Excel VBA Guide for Beginners and Excel VBA Objects Guide for Intermediate) in the blog spot: excelmacroclass.blogspot.com
And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (excelmacrofun.blogspot.com/)
Excel Macro Business (excelmacrobusiness.blogspot.com/)
Excel Macro Sports (excelmacrosports.blogspot.com/)

[@TheSardOz]

Great content as always Vic!

[@blakeM193]

This playlist is amazing, thank you! Any chance you could do a video expanding more on how to do the "2nd level authentication" with a token and encoding?

[@ExcelMacroMania]

Thanks! And yes, I will definitely do it but I don't be able to work on it until after the summer.

[@abdullahquhtani4247]

Great 👍🏼. I hope you consider explaining how to send mor than one parameter and how to responses with customized message to verify parameters (length or data type i.e Int. Or string) and if no data were found.
Thank you 🙏🏻

[@ExcelMacroMania]

I will have to make another video for that. The Part 2 video will just explain how to read the JSON response (and also how to return HTML instead) and write contents to the worksheet.

[@abdullahquhtani4247]

@@ExcelMacroMania Great 👍🏼

[@chasee2446]

"Promo sm"