top of page
Google Sheets preparation steps
① Create a project in the Google Cloud Console
Google Cloud Console is a developer management interface provided by Google.
Here, we will configure the settings to manipulate the spreadsheet using the RIGDOCKS API.
*Please prepare your Google account in advance.1: Access the Google Cloud Console
2: Top menu "Select a project" → "New project"
3: Enter the project name and click "Create".
4: Select the project you created.
② Enable the Google Sheets API
1: Left menu "APIs & Services" → "Libraries"
4 : OK if "App added" is displayed
3. Select "Google Sheets API" → "Enable"
③ Setting up the OAuth consent screen
1: Left menu "APIs & Services" → "OAuth consent screen"
2: On the "Overview" page, click "Start".
3: Proceed by entering the following in "Project Configuration".
a: App name (e.g., RIGDOCKS) and user support email (your email address)
b: Select User Type "External"
c: Contact information (your email address)
d: Google API Services → Agree to the Policy
4. Enter the above information and click "Create".
④ Setting up test users
1: Open the "Target" page.
2: Test user's "Add users"
3. Enter the Google account address you want to use for the spreadsheet and click "Save".
⑤ Create an OAuth client
1: Open the "Client" page.
2: "Create a client"
3. Select "Desktop app" as the application type.
4: Enter a name → "Create"
5: "Download JSON" → Save the JSON file locally (Any location)
1: Launch REAPER
2: Click on Extensions > RIGDOCKS > GOLD > Spreadsheet > Load Credential
3: Select the JSON file downloaded from Google Cloud Console.
4. Your browser will launch and you will be prompted to log in.
5: Select your account
6: Click "Continue"
7: Click "Continue"
8. If it says "Loading successful," then it's complete.
9: Authenticated client IDs are also displayed within the Advanced tab.
After multiple client authentications are complete, you can switch between the clients you are using here.
By performing Load Credential again and authenticating with a different JSON file, you can save multiple clients.
*You can also switch by entering this ID as an argument to GSheet_Connect_UserAcount.
1 : Go to Display Information in Basic Information
2 : Press Add App Icon
3 : Select image
The image must be a rectangle with a side of 512px-2000px
Setting completed
① Create a project in the Google Cloud Console
Here, you will configure your account settings to manipulate your spreadsheet using the RIGDOCKS API.
*Google Cloud Console is a developer management interface provided by Google.
*Please prepare your Google account in advance.1: Access the Google Cloud Console
2: Top menu "Select a project" → "New project"
Google Cloud Console is a developer management interface provided by Google.
Here, we will configure the settings to manipulate the spreadsheet using the RIGDOCKS API.
*Please prepare your Google account in advance.
3: Enter the project name and click "Create".
4: Select the project you created.
② Enable the Google Sheets API
1: Left menu "APIs & Services" → "Libraries"
4 : OK if "App added" is displayed
3. Select "Google Sheets API" → "Enable"
③ Setting up the OAuth consent screen
1: Left menu "APIs & Services" → "OAuth consent screen"
2: On the "Overview" page, click "Start".
3: Proceed by entering the following in "Project Configuration".
1: App name (e.g., RIGDOCKS) and user support email (your email address)
a: App name (e.g., RIGDOCKS) and user support email (your email address)
b: Select User Type "External"
c: Contact information (your email address)
d: Google API Services → Agree to the Policy
a: App name (e.g., RIGDOCKS) and user support email (your email address)
b: Select User Type "External"
c: Contact information (your email address)
d: Google API Services → Agree to the Policy
a: App name (e.g., RIGDOCKS) and user support email (your email address)
b: Select User Type "External"
c: Contact information (your email address)
d: Google API Services → Agree to the Policy
4. Enter the above information and click "Create".
④ Setting up the test user (yourself)
1: Open the "Target" page.
2: Test user's "Add users"
3. Enter the address of your Google account that you will use for the spreadsheet and click "Save".
⑤ Create an OAuth client
1: Open the "Client" page.
2: "Create a client"
3. Select "Desktop app" as the application type.
4: Enter a name → "Create"
5. Download the JSON file → Place it in your Downloads folder (or any location of your choice) as you will need to read the file in the next step.
1: Launch REAPER
2: Click on Extensions > RIGDOCKS > GOLD > Spreadsheet > Load Credential
3: Select the JSON file downloaded from Google Cloud Console.
4. Your browser will launch and you will be prompted to log in.
5: Select your account
6: Click "Continue"
7: Click "Continue"
8. If it says "Loading successful," then it's complete.
9: Authenticated client IDs are also displayed within the Advanced tab.
After multiple client authentications are complete, you can switch between the clients you are using here.
By performing Load Credential again and authenticating with a different JSON file, you can save multiple clients.
*You can also switch by entering this ID as an argument to GSheet_Connect_UserAcount.
- We want to use it as a team.
Even when operating as a team, please enable the API from Google Cloud Console for each user and have them log in from REAPER. See the instructions in the tabs above for details.
・What are spreadsheet ID and sheet ID?
There are two ways to identify a spreadsheet:
You can obtain it from the sheet's URL.
① SpreadSheetID: The ID of the spreadsheet itself
②SheetID: The ID of the sheet created within the spreadsheet.
https://docs.google.com/spreadsheets/d/【SpreadSheetID】/edit?gid=#gid=【SheetID】Please pay attention to the arguments used for each API.
・What if I need to switch accounts?
Authenticating with different OAuth clients (see "Logging in from REAPER") will display multiple OAuth clients in the Extensions tab, allowing you to switch between them.
You can find your OAuth client ID in the "Clients" menu of the Google Cloud Console.
Alternatively, you can check the OAuth client ID in the folder name that opens when you click "Open Credentials Folder" in the Extensions tab.
・I want to obtain permission to edit the spreadsheet.
To use this API to manipulate spreadsheets, your Google account must have permission to edit the target sheet.
Open the Google Sheets and click "Share".
Enter the email address of the account to which you want to grant permissions.
Check the box for "Editor".
*API operations are not possible with the "Viewer" setting.
Pressing "Submit" will grant you the necessary permissions.
・I would like to know the details of each API.
For detailed specifications of each API, please refer to APIDOCK. Please check the information provided there.
bottom of page