Connecting data source to ConectoHub
In ConectoHub you can connect your third party data sources such as Google Sheets, Excel, Airtable etc. to your KR metrics.
ConectoHub takes last updates from your data source and update metrics automatically for you.
1. Open Key Result detail page and select data source you want to connect
2. Follow the steps
3. Connect your data source account
4. Select spreadsheet and worksheet you want to connect
5. Define triggers
6. Connect your ConectoHub account
7. Select the Key Result you want to update via data source
8. Map data between spreadsheet and Key Result
9. Select check-in type: ("Update" to send current value from your data source or select "Sum" to add to the previous Check-in value)
10. Send the test data
11. The test data sent successfully.
12. In the last step "Turn on Zap" and it's done!
Now your data source such as google or excel sheet will update your Key Result automatically. Take a coffee and let ConectoHub do the rest.