Google Service Account
This is the second step in configuring True Sheets, this guide assumes you have already completed step one.
Last updated
Was this helpful?
This is the second step in configuring True Sheets, this guide assumes you have already completed step one.
Last updated
Was this helpful?
In the section, you'll learn how to create a google service account to connect to the google sheets API and overall connect your spreadsheet to your True Sheets product. This section is best complete on a PC/Laptop, we recommend that you use either one of them.
Head to the and login with your google account, if this is your first time using the google cloud console you may be prompted to complete other tasks before continuing. Select the create a project dropdown menu and press new project.
Enter any project name, and any project ID (This is only used to identify your account on googles end). Wait for your project to be created and then select it from the same select menu on the navbar, once inside the project you can begin enabling the API.
Use the navigation menu to open the APIs and Services tab, then select Enabled APIs and services.
Near the top of the page, select the Enable APIs and Services button and search for Google Sheets API.
Select the first result and press enable, this will allow you to now connect to the Google Sheets API and use True Sheets for this project.
Now that the API is enabled, you can create authentication credentials in the form of a service account. Select the Credentials tab on the page you have been redirect to.
Near the bottom of the page, you will see an option for service accounts. Select the option on the far right to Manage service accounts, here is where you can create a service account.
For the account configuration you can enter any name and ID and select the role Owner under permissions, then press done.
The next step is to create a JSON access key file for the newly created service account, to do this first select the email of the account you just created and navigate to the keys tab on the top navigation bar. In the tab press the add key button and select create new key, ensuring the key type is JSON, the press create.
A JSON file will be downloaded to your device, this file contains your access credentials to the service account so make sure to keep it safe. This file is to be uploaded to the root of your Products file, with the index.js and config.js files. You must then rename it to credentials.json, the end result should show your files like the following.
Just like any google account, the service account will need access to your spreadsheet. This is done by heading over to your spreadsheet, pressing the share button and then entering your service account email into the box. For permissions, provide them with editor and then press Done. That's it, you have now configured the google sheets and google service account for True Sheets. You can now continue in the documentation to ensure you configure the rest of the settings correctly.
