Skip to main content

Set up Google Service

Set up Google Service Account#

Go to Google Console and sign in to your Google account. Once signed in, you'll see a list of existing projects (if there are any) or you can click Create Project to create a new one.

img

On the New Project page, enter a name for your project, select an organization and then click Create.

img

Enable the Sheet's API#

Make sure your project is still selected as the current project. From the navigation menu, select Library under APIs & Services option.

img

Search for Google Sheets and click the API tile.

img

Click Enable.

img

Enable the Drive's API#

Do the same thing to enable the Google Drive API. Search for Google Drive and click the API tile.

img

Click Enable.

img

Download Service Account Credentials#

Now we will create credentials that we will download as a JSON file and later add to the Google sheets node to configure it. To create credentials, from the navigation menu, select Credentials under APIs and Services.

img

On the Credentials page, click Create Credentials and select the Service Account option.

img

Set the Service account dropdown to New Service Account and click Create.

img

Select the Role for your Service Account.

img

Click Done to create credentials. Select Service Account from the list.

img

Save Service Account Email#

Select Details tab and copy the email address.

img

This information will be used to Share Sheet With Email.

Save Credential File#

Select Keys tab and click on Add Key

img

Select JSON key type and click on Create

img

A key file of josn type will be download to your system.

img

Now open the downloaded JSON file and copy all information from the file. This information will be used to Set up Google Sheet Connector.