Data
Connect Mindful with Google Sheets
The Data section of the Connections page contains integrations with Google Sheets. These connections export a snapshot of pending callbacks to a spreadsheet, or import changes to scheduled callback timeslots.
View pending callbacks via Google Sheets
This connection provides a list of pending callbacks segmented into 15-minute timeslots. The timeslots represent the times that callbacks were originally estimated to be launched. Callbacks are added to the list when registered, and finalized calls are removed once per day.
Follow the instructions below to enable this connection:
Click Enable on the "Post Call Survey" tile.
Enter a Client ID and Secret from a Mindful API Application Client (this step may be skipped if you have enabled other connections).
When prompted, click Sign In to authenticate to Google Sheets.
This will open the Google authentication process in a separate window. Create or log in to the Google account that will contain your spreadsheets.
When prompted, configure the spreadsheet ID and sheet name from the Google spreadsheet for each variable.
Important: Enter the same values in all three sections.The spreadsheet ID can be found in the URL of the spreadsheet, and the sheet name can be found on the sheet's tab.
After Installation, a Mindful team member will need to provide webhook URLs for a callback registration webhook and a separate callback finalization webhook.
Errors
If there are errors at any point in processing, two retry attempts will be made after a progressively increasing delay.
Update maximum scheduled callbacks per interval via Google Sheets
The Call Target Timeslots connection runs once per day to update the maximum scheduled callbacks for all time slots for as many Call Targets as you would like, with different configuration for each Call Target. You can use this connection to change time slot configuration on a daily basis.
Follow the instructions below to enable this connection:
Before configuring the connection, create a metadata item for each Call Target you would like to update:
Name — Enter timeslot_spreadsheet.
Present Metadata to — Deselect both Agent and Customer.
Type — Select "SIP Header".
Default Value > Both Legs — Enter a Google spreadsheet ID, which can be found in the URL of the spreadsheet.
On the Connections page, click Enable on the "Call Target Timeslots" tile.
Enter a Client ID and Secret from a Mindful API Application Client (this step may be skipped if you have enabled other connections).
When prompted, click Sign In to authenticate to Google Sheets.
This will open the Google authentication process in a separate window. Create or log in to the Google account that will contain your spreadsheets.
When prompted, configure the API Key, Client ID, and API Host URL in the fields provided.
API Key and Client ID — Contact the Mindful team to obtain the credentials for your organization.
API Host — Enter api-callback.getmindful.com.
When you're finished configuring all required variables, click Create.
To configure the spreadsheet, first export the Maximum Callbacks Allowed per Schedule Interval as a CSV file, then copy and paste the contents into the Google Sheet specified in the Call Target metadata item configured earlier.
This will ensure that all rows are included and labeled properly. To learn how to export your time slots, see Scheduled callback.
Add a new tab to the spreadsheet for each day of the week (Sunday to Saturday).
The daily configuration update will be based on the tab for the current day of the week.
Update only Column E (maxScheduled) with new values, as needed, in each tab.
At the scheduled processing time, the configuration for the current day of the week will be applied to the Call Target.
When you are ready to upload a spreadsheet, click Start on the appropriate tile.
Errors
If there are errors at any point in processing the upload, two retry attempts will be made after a progressive delay.
Export Call Target configuration
The Configuration Export connection exports core properties of all Call Targets in your organization to a Google spreadsheet, allowing you to review and compare your Call Targets without sending API requests or browsing the user interface.
Exported properties
The following table maps the names of the exported properties to their associated fields in the Mindful user interface. To learn more about these fields and their locations, see Call Targets page.
| Exported property | UI property name |
|---|---|
| id | N/A - The Call Target ID is not displayed in the UI but is available via API. |
| name | Name |
| enableCallbackRegistration | Register Callbacks |
| enableCallbackProcessing | Process Callbacks |
| firstPartyCalled | First Party Called |
| announceAni | Announce ANI |
| offerAsapCallback | Offer ASAP Callback |
| offerChooseHold | Offer Choose Hold |
| offerScheduledCallbackVoice | Offer Scheduled Callback (Voice) |
| offerScheduledCallbackWidget | Offer Scheduled Callback (Widget/API) |
| messaging.offerMessageIntercept | Offer Message Intercept |
| offerNextDayCallback | Offer Next Business Day Callbacks |
| enableCallbackDoubleCheck | Enable Callback Double Check |
| callbackDoubleCheckScope | Callback Double Check Scope |
| enableVoiceScheduledCallbackAfterHours | Offer Scheduled Callback Outside of Hours (Voice) |
| announceEcbtBeforeOffer | Announce ECBT during Offer |
| announceEcbtAfterRegistration | Announce ECBT during Confirmation |
| minCallbackDelay | Minimum Callback Delay |
| maxQueuedCalls | Max Queue Depth |
| maxActiveCalls | Max Active Calls |
| callbackCallerId | Caller ID (CID) |
| chooseHoldAgentDestination | Choose Hold Number |
| callbackAgentDestination | Callback Number |
| dynamicDnisMappingEnabled | Use Dynamic DNIS Mapping |
| phoneNumbers | N/A - A comma separated list of all phone numbers assigned to the Call Target |
Install the connection
Follow the instructions below to enable this connection:
Click Enable on the "Configuration Export" tile.
Enter a Client ID and Secret from a Mindful API Application Client (this step may be skipped if you have enabled other connections).
When prompted, click Sign In to authenticate to Google Sheets.
This will open the Google authentication process in a separate window. Create or log in to the Google account that will contain your spreadsheets.
When prompted, configure the spreadsheet ID and sheet name from the Google spreadsheet you would like to contain the export.
The connection will export the Call Target configuration to the specified sheet.
The spreadsheet ID can be found in the URL of the spreadsheet, and the sheet name can be found on the sheet's tab.
When you are finished configuring all required variables, click Create.
When you are ready to upload a spreadsheet, click Start on the appropriate tile.
You should see the results posted in the specified sheet. When finished, the integration will pause automatically after a few minutes.
To export the configuration again in the future, click Start again.
Errors
If there are errors at any point in processing, two retry attempts will be made after a progressive delay.
