---
title: Writing a Bash Script for GCP to Fetch Data | GSuite Solved
description: Enhance GCP project data retrieval with a robust Bash script. Extract crucial details like project number, folder path, and cost center effortlessly.
---

[Articles | C2C](https://www.c2cglobal.com/articles)

# [Writing a Bash Script for GCP to Fetch Data | GSuite Solved](https://www.c2cglobal.com/articles/bash-script-for-gcp-to-fetch-data-2115)

 Written by [Vikash Vikal](https://www.c2cglobal.com/articles/author/vikash-vikal) | Nov 23, 2021 6:00:00 AM

script to fetch the GCP project details as mention below.

projectid, name, projectnumber, date&time, folderpath, projectowner, folderpath, costcentre, label.

I have written belwo script and it is working for- projectid, name, projectnumber, date&time.

#!/bin/bash

> project\_data.csv

gcloud projects list --format="value(project\_id, name, project\_number, project\_owner, tag, createTime.date(tz=LOCAL))" >whole\_project\_details.txt

echo project\_id, project\_name, project\_number, project\_owner, project\_tag, project\_time >project\_data.csv

while read project\_details

do

project\_id=\`echo $project\_details | awk '{print $1}'\`

project\_name=\`echo  $project\_details | awk '{print $2}'\`

project\_number=\`echo $project\_details | awk '{print $3}'\`

project\_time=\`echo $project\_details | awk '{print $4}'\`

project\_owner=\`echo $project\_details | awk '{print $5}'\`

project\_tag=\`echo $project\_details | awk '{print $6}'\`

echo $project\_id, $project\_name, $project\_number, $project\_owner, $project\_tag, $project\_time  >> project\_data.csv

done < whole\_project\_details.txt

 

But not able to fetch date of - owner, folderpath, label, costcentre.

 

please help me. Thank you in advance.

 

Best Answer from: sathyaram\_s 

 

From the documentation : 

 

> To refer to a list of fields you can sort, filter, and format by for each resource, you can run a list command with the format set to `text` or `json`. For example, $ [gcloud compute instances list](https://cloud.google.com/sdk/gcloud/reference/compute/instances/list) --limit=1 --format=text.

 

In your case, try gcloud projects list --format=text to confirm all the information you are after is available for the project resource. 

[View full post](https://www.c2cglobal.com/articles/bash-script-for-gcp-to-fetch-data-2115)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Vikash Vikal"
  },
  "dateModified" : "2024-03-29T14:08:56.081Z",
  "datePublished" : "2021-11-23T06:00:00Z",
  "headline" : "Bash Script for GCP to fetch data",
  "image" : {
    "@type" : "ImageObject",
    "height" : 700,
    "url" : "https://www.c2cglobal.com/hubfs/Imported_Blog_Media/General%20Article%20Graphic-Mar-21-2024-09-11-30-9884-PM-Mar-26-2024-08-41-44-8399-PM.jpg",
    "width" : 2000
  },
  "mainEntityOfPage" : "https://www.c2cglobal.com/articles/bash-script-for-gcp-to-fetch-data-2115",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "C2C Articles"
  }
}
```