Just wanted to post that I have finally figured it out, but needed to make a helper app for it that reads the gmail api. I tried through the javascript version but it was really giving me a fit with logging in I had to click the allow etc etc etc everytime I did it. I started to use the .net version and wrote an app using copied code from the web and it started to work. So what I have it doing is any emails from the 2FA email address get moved to a certain folder in gmail, so they are easy to find. Then the helper app reads the latest email from the folder and parses out the code and then hands it back to VBA (still ironing out that part but is trivial compared to getting this working up to this point. So soon I should have 2FA working for some of my automations and eventually should be able to create passwords too that require the 2FA to work. Can share the code with anyone after I get it completed for the helper app. Have a good day.