Google Drive
1. Create New Project
Open Google Cloud Console Dashboard. Go to Select Project > New Project. Create a new Project.
![Screenshot 2020-09-10 at 16.03.17.png 1600](https://files.readme.io/e03ae59-Screenshot_2020-09-10_at_16.03.17.png)
2. Enable Required API
Select the newly created project. Go to Library, search for Sheets/Drive and select Enable.
![Screenshot 2020-09-10 at 16.08.02.png 1600](https://files.readme.io/2f1d1ab-Screenshot_2020-09-10_at_16.08.02.png)
![Screenshot 2020-09-10 at 16.11.55.png 1600](https://files.readme.io/547472a-Screenshot_2020-09-10_at_16.11.55.png)
3. Create New Service Account
Using the Navigation Menu go to IAM & Admin > Service Accounts. Go to + Create New Service Account, and after entering the name go to Create. Using the Select a Role navigate to Project > Viewer or Editor, when selected go to Continue, and go to Done on the next page.
![Screenshot 2020-09-10 at 16.14.14.png 1600](https://files.readme.io/cfc998e-Screenshot_2020-09-10_at_16.14.14.png)
![Screenshot 2020-09-10 at 16.15.20.png 1600](https://files.readme.io/37b1c59-Screenshot_2020-09-10_at_16.15.20.png)
![Screenshot 2021-05-25 at 12.44.58.png 2754](https://files.readme.io/f5453f7-Screenshot_2021-05-25_at_12.44.58.png)
4. Get Credentials
Select the newly created Service Account in the Service Accounts list, and go to Add Key > Create New Key > JSON and go to Create, a json file will download which contains the service account credentials. Copy the contents of this file and paste it in the Credentials input of the action.
![Screenshot 2021-05-25 at 12.46.31.png 2708](https://files.readme.io/7f11df0-Screenshot_2021-05-25_at_12.46.31.png)
![Screenshot 2021-05-25 at 12.48.54.png 2758](https://files.readme.io/153ac65-Screenshot_2021-05-25_at_12.48.54.png)
5. Copy Sheet ID
Copy the id of the Google Sheet from the url in the browser. This id will be used for the input of Action.
![Screenshot 2020-09-10 at 16.21.54.png 1600](https://files.readme.io/54c91e9-Screenshot_2020-09-10_at_16.21.54.png)
6. Copy Sheet tab
Copy the name of the spreadsheet tab. This id will be used for the input of Action.
![Screenshot 2021-05-25 at 12.52.00.png 992](https://files.readme.io/5cb6ee2-Screenshot_2021-05-25_at_12.52.00.png)
Updated 8 months ago