Open Google Cloud Console Dashboard. Go to Select Project > New Project. Create a new Project.
Select the newly created project. Go to Library, search for Sheets/Drive and select Enable.
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.
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.
Copy the id of the Google Sheet from the url in the browser. This id will be used for the input of Action.
Copy the name of the spreadsheet tab. This id will be used for the input of Action.
Updated 3 months ago