First, create a new Zap. Select BigQuery - Query Job Completed as the event.
Choose your relevant query which pulls your candidates data
To do a bulk sync of your query data with Great Question the Sync Candidates action is used. This is a singe action which takes multiple rows of candidates.
Select Great Question - Sync Candidates action.
To configure this action, map each row of data to the relevant custom attribute configure on Great Question. Note: email is used as the unique id. If an existing candidate exists in Great Question with the same email, their record will be updated.
Once your Zap is tested and configured publish your Zap. In order for your data to continually update you will need to set up your BigQuery query to run daily/weekly.
Here are some features for this integration that we are considering. Please contact [email protected] to request these or if you have a more complex use case.