project-level-users-list.sh

#!/bin/bash
for project in  $(gcloud projects list --format="value(projectId)")
do
  echo "============================ Project:  $project ============================"
  mkdir $(pwd)/users/${project}
  for instance in $(gcloud compute instances list --project $project --filter="STATUS=RUNNING" --format="csv[no-heading](name,zone)")
   do
   	zone=(${instance//,/ })
   	read -p "You need ${zone[0]} ?" yn
	case $yn in
		[yY] | [yY][Ee][Ss] )
			echo "gcloud compute ssh ${zone[0]} --zone=${zone[1]} --project $project --command=\"sudo sed -n '/^\([^:]\+\):[^:]\+:[1-9][0-9]\{3\}/ { s/:.*//; p }' /etc/passwd\" >> \$(pwd)/users/${zone[0]}.xls"
			gcloud compute ssh ${zone[0]} --zone=${zone[1]} --project $project --command="sudo sed -n '/^\([^:]\+\):[^:]\+:[1-9][0-9]\{3\}/ { s/:.*//; p }' /etc/passwd" >> $(pwd)/users/$project/${zone[0]}.xls
		;;
		[nN] | [nN][Oo] ) ;;    
		* ) echo "Please answer yes or no.";;
	 esac	
   done
done