Google Sheet Credentials

📌 prerequisites a google cloud project access to google cloud console a google sheet that you want to access 1\ enable google sheets api go to google cloud console → enable apis & services search for google sheets api click enable 2\ create a service account in google cloud console , go to iam & admin → service accounts click create service account enter a name (e g , sheets access service) assign editor role (or more restrictive role if only read access is needed) click done 3\ generate and download credentials select your new service account go to the keys tab click add key click create new key choose json format and click create a json file will be downloaded → this is your credentials file example file name sheets service account json ⚠️ keep this file secure — it contains private keys 4\ share your google sheet with the service account open the google sheet you want to access click share add the service account email address (found inside your json file, e g , sheets access service\@your project iam gserviceaccount com) add the service account email address and click send give it editor or viewer access