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 Callback scheduling settings.
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're 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.
