Google Sheets proof types
Note
Hyperproof connects to many third-party systems that frequently change, including the system interface. Contact your System Administrator or the third-party provider for assistance meeting the requirements to integrate with Hyperproof and collect the proof you need.
The Google Sheets Hypersync is a good option for users who store data in multiple systems, but don't have an easy way to import it into Hyperproof.
Users can create a Google Sheet containing the data and then import that sheet into Hyperproof. Hypersyncs automatically keep your proof up-to-date; any time you edit the sheet, the changes link back to Hyperproof. Additionally, this Hypersync ties directly into Hyperproof's automated control testing feature.
The account that creates the Hypersync needs access to the sheet, i.e. if you're using a service account, the service account needs permission to access the sheet.
Note
You only need to connect Hyperproof to the app once, and then you can create as many Hypersyncs as you need. Additionally, you can create multiple Hypersyncs for a single control or label.
Requirements
Permissions
The following permissions are required for using the Google Sheets Hypersync: userinfo.email and spreadsheets.readonly.
Formatting
Within the range specified, the first row of your sheet must contain headers (or keys) for Hyperproof to label all included columns correctly. Note that headers (or keys) cannot be duplicated.
File type
The file must be a Google Sheets file. If you upload an Excel (XLSX) file in Google Sheets, you must convert it to the Google Sheets format by selecting File > Save as Google Sheets. Use the resulting file when configuring the Hypersync.
Spreadsheet ID
Hyperproof requires a Spreadsheet ID when connecting to a Google Sheet. To find the Spreadsheet ID look at the URL for the sheet and copy the information immediately following /d/ or use the complete URL. For example, in the URL below, the Spreadsheet ID is shown in bold:
https://docs.google.com/spreadsheets/d/1e0D0bSATxuLbEz2Oa1sNKLZqh1C7UpezzkJOlzk2Mo0/edit?gid=0#gid=0
Note
If the file type or Spreadsheet ID is incorrect, Hyperproof generates an error similar to the following: Spreadsheet not found. Provide a valid spreadsheet URL or ID.
Importing a Google Sheet via a Hypersync
The sheet ID (URL) is needed to import the Google Sheet into Hyperproof. Additionally, Hyperproof determines the data types of the fields in Google Sheets based on the data in the first 50 rows.
From the Proof drop-down menu, select Google Sheet Data.
In the Spreadsheet ID field, enter the URL or ID of the sheet you want to connect.
From the Range Type drop-down menu, select a data export option:
Sheet - All data stored in the sheet.
If there is more than one sheet, you'll be asked to select the sheet you want to import.
Named range - Data based on a sheet formula.
Custom range - Data based on a sheet reference, e.g. A1:C5.