A simple Powershell script for Windows, downloads a list of know ip-ranges from Microsoft Office 365 and Google and generates a whitelist to be used in OpenVPN.
Uses the Google ip-ranges webservice:
https://www.gstatic.com/ipranges/goog.json
and Office 365 IP Address and URL web service:
No guarantees, feel free to extend this script with your own additional desires ip-ranges.
Automate the world! #PowerShell