Connect VoiceQ Cloud to Google Sheets with Google Apps Script to pull live character data — lines, words, rates, pay and completion dates — straight into a spreadsheet, and refresh it automatically on a schedule. Updated for version 5.2.
What you'll need
- A Google account with access to Google Sheets
- A VoiceQ Cloud account and an active project
- Basic familiarity with Google Sheets — the script setup is copy-and-paste
The fastest path is the pre-built API template linked in the full user guide (button below), which skips the script setup entirely. The steps here cover setting up from a blank sheet at docs.google.com/spreadsheets/create.
Step 1 — Connect your project
- Open the VoiceQ Cloud project you want to connect.
- Copy the Project ID from the project URL — it's the long string of characters, e.g. '11e9f6a8-5fa8-fe32-a8bd-b71835b230d9'.
- Paste it into Cell A1 of your sheet.
- Back in the VoiceQ Cloud project, click Get Token (above the Characters section).
- Copy the generated token into Cell A2. It should include the 'Bearer' prefix.
Step 2 — Add the Apps Script
- In your sheet, go to Extensions > Apps Script.
- Name the script — we recommend 'VoiceQ Cloud API'.
- Delete the placeholder 'function myFunction( )' code.
- Paste in the Character Data Script from Appendix A of the user guide (download via the button below).
- Save (Cmd/Ctrl+S) and return to your sheet.
Step 3 — Run the import
- In Cell A4, enter: =ImportCharacters()
- The function pulls character data from your VoiceQ Cloud project into the sheet, with columns for name, actor, lines (50* and 65*), words, rate type, calculated pay, completion date and more.
Automate with triggers
Triggers re-run the import on a schedule so the sheet stays current without manual refreshes:
- In the Apps Script editor, open Triggers from the left sidebar.
- Click Add Trigger (bottom right).
- Choose the function to run and set the time-driven interval — this determines how often data is pulled from VoiceQ Cloud.
- Save. When prompted, sign in with your Google account, select Advanced > your project name, and click Allow to grant the script permission to edit the sheet.
Token expiry
Tokens expire after 48 hours for security. When yours expires, click Get Token in VoiceQ Cloud again and paste the new token into Cell A2. For a new project connection, update the Project ID in A1 as well — the script itself doesn't change.
Troubleshooting
The import returns an error or nothing at all
- Check Cell A1 contains only the Project ID and Cell A2 contains the full token including the 'Bearer' prefix — stray spaces are the usual culprit.
It worked before but now shows an error
- Your token has likely passed the 48-hour expiry — generate a fresh one and update Cell A2, then re-enter =ImportCharacters() in A4 to force a refresh.
The trigger isn't updating the sheet
- Reopen Apps Script > Triggers and confirm the trigger saved, and that you granted permissions (Advanced > project name > Allow) when prompted.
Still stuck? Download the full user guide below for screenshots of every step, or contact support and we'll help you get connected.