Batch Registration of AppSheet IPs to Cloud SQL Connection

When using Cloud SQL, we need to register the AppSheet server IP to the Connection.
There are 45 of them! :confounded:

Registering them by hand from the console is a lot of work, so let’s not do it…

With the following command, we can do the bulk registration from Cloud Shell.

> gcloud sql instances patch [INSTANCE_NAME] --authorized-networks=,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,