Hi Arun,
Thank you for your post. Could you please provide more details about your steps?
In case you used this manual https://subject7.zendesk.com/hc/en-us/articles/360042451714-Using-Subject7-API-to-create-a-custom-report-in-Google-Sheets
we would like to know what options did you have after clicking on the blue button "Enable the Google Sheets API".
If you had a select box with different options, for example, Web Browser, Android, Desktop app, etc. which one you selected out of them?
Regards,
Subject7 Team